BEST Verified Oracle 1z0-078 Exam Questions (2024)
The Best Practice Test Preparation for the 1z0-078 Certification Exam
Oracle 1z0-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
NEW QUESTION # 14
Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 19c RAC? (Choose two.)
- A. A CR image may get served from one instance to another to satisfy a read request.
- B. An xcur block image may exist for a specific database block in only one instance.
- C. An xcur image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.
- D. A Pi block image may exist for a specific database block in only one instance.
- E. An xcur image is not shipped to another instance until commits occur for updated rows on the block.
Answer: A,B
NEW QUESTION # 15
Which three statements are true about fully qualified file names in ASM? (Choose three.)
- A. They are the only valid form that can be used for single file creation of a control file.
- B. An alias may be created for an existing file by referring to the fully qualified file name.
- C. They are system Generated at the time of ASM file creation.
- D. They can be created only if OMF is enabled.
- E. They can be used to reference existing ASM files.
Answer: C,E
NEW QUESTION # 16
You want to create a tablespace, SALES, with these requirements:
1. Its data file has an alias name sales.dbf.
2. Its data file is stored in the directory CURRENT_YR in the disk group DATA.
Examine this command:
SQL> CREATE TABLESPACE sales;
Which two tasks must you perform to meet these requirements? (Choose two.)
- A. Create the current yr directory in the +data disk group.
- B. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.
- C. Add the autoextend on clause to the command.
- D. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.
- E. Create the current yr directory in the root directory (+).
Answer: A,B
NEW QUESTION # 17
Examine these descriptions of ASM instance shutdown behavior:
1) The ASM instance shuts down immediately without an orderly dismount of disk groups.
2) Active SQL statements are allowed to complete before an orderly dismount of all disk groups occurs and then the ASM instance shuts down without waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
3) Active SQL statements are allowed to complete before an orderly dismount of all of disk groups occurs and then the ASM instance shuts down after waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
Which two lists are correct matches for these descriptions? (Choose two.)
- A. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT
- B. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE
- C. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
- D. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
- E. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
Answer: A,B
NEW QUESTION # 18
Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)
- A. Mutexes
- B. Latches
- C. Database block buffers
- D. Enqueues
- E. Cursors
- F. Redo log buffers
Answer: A,B,D
NEW QUESTION # 19
Which two statements are true about initialization parameters for Clustered ASM instances? (Choose two.)
- A. The maximum value of ASM_POWER_LIMIT is 1024.
- B. The default value of INSTANCE_TYPE is ASM.
- C. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.
- D. The ASM_DISKGOUPS parameter is optional.
- E. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.
Answer: B,D
NEW QUESTION # 20
Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 19.0
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)
- A. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.
- B. Transactions on database objects stored in tablespaces in the dgrpi disk group fail.
- C. New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-
- D. The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.
Answer: A,C
NEW QUESTION # 21
Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)
- A. An ADVM volume is individually named and can contain only one file system.
- B. Only one ADVM volume can be created in an ASM disk group.
- C. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
- D. To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.
- E. File systems contained in ADVM volumes may only contain database files.
Answer: A,C
NEW QUESTION # 22
Examine this command:
Which two statements are required for this command to succeed? (Choose two.)
- A. Existing data files in TBS1 must also use the same template.
- B. newtemplate must be defined for the +DATA disk group.
- C. User-defined subdirectories ORCL and USERS must already exist.
- D. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
- E. The +DATA disk group should not be part of Flex ASM.
Answer: B,C
NEW QUESTION # 23
Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)
- A. It can diagnose latency problems in the Cluster Interconnect.
- B. It can analyze performance using data captured on all instances.
- C. It can diagnose skew in response time.
- D. It runs automatically in Instance ADDM mode after each AWR snapshot is created.
- E. It can only analyze performance on the instance running the ADDM job.
- F. It can analyze performance over any given time period.
Answer: B,C,F
NEW QUESTION # 24
Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)
- A. The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.
- B. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
- C. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.
- D. The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.
- E. The upgrade must be done out-of-place.
- F. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.
- G. The upgrade must be done in-place.
Answer: B,C,D,F
NEW QUESTION # 25
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
- A. An ACFS snapshot can be ACFS encrypted.
- B. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
- C. acfsucil encr on can be used to specify the encryption key length for a directory or file.
- D. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.
- E. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
Answer: A,C,D
NEW QUESTION # 26
Which two statements are true about High Availability NFS (HANFS)? (Choose two.)
- A. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS
- B. HANFS provides high availability in case of an NFS client failure.
- C. HANFS does not depend on NFS services provided by the underlying operating system.
- D. HANFS' performance depends on the characteristics of the underlying ASM disks.
- E. HANFS provides high availability in case of cluster node failure.
Answer: D,E
NEW QUESTION # 27
Examine this sequence of commands:
The cluster consists of nodes HOST01, HOST02, HOST03 and HOST04, and the clusterware is running on all four nodes.
Which three statements are true about the result of the root user running these commands on HOST01? (Choose three.)
- A. The Oracle Clusterware stack is started on all nodes except host01.
- B. The Oracle Clusterware stack is prevented from being automatically started on host01.
- C. The Oracle Clusterware stack is stopped on all nodes except host01.
- D. The Oracle Clusterware stack is started on all nodes.
- E. The Oracle Clusterware stack is prevented from being automatically started on all nodes.
- F. The Oracle Clusterware stack is stopped on all nodes.
Answer: B,D,F
NEW QUESTION # 28
Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)
- A. crsctl disable crs
- B. crsctl stop crs
- C. crsctl stop cluster
- D. crsctl config crs
Answer: A,B
NEW QUESTION # 29
Which two statements are true regarding the default service that is automatically created upon PDB creation in a RAC database environment? (Choose two.)
- A. It is uniformly available on all instances for administrator-managed databases.
- B. It is not automatically registered in the OCR.
- C. It cannot be used to automate the opening of the PDB by the Clusterware.
- D. It is automatically registered in the OCR.
- E. It is created and started on only one instance when using policy-managed database configuration.
Answer: D
NEW QUESTION # 30
Which statement is true about Oracle Database 19c SGA Management?
- A. Oracle RAC Resource Management only allows assignment of the SGA during database startup.
- B. Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.
- C. Oracle RAC Resource Management only allows assignment of the SGA during instance startup.
- D. Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.
Answer: B
NEW QUESTION # 31
......
1z0-078 Exam Dumps, Practice Test Questions BUNDLE PACK: https://www.braindumpspass.com/Oracle/1z0-078-practice-exam-dumps.html
Oracle Database Certification 1z0-078 Sample Questions Reliable: https://drive.google.com/open?id=1lBgttx001TUJzdY0nMyRHcnnBTxBS9DO
