1Z0-063 Real Exam Questions and Verified Answers

Question 1 Multiple choice

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

A
The ADR base is shared across multiple instances.
B
The ADR base keeps all diagnostic information in binary format.
C
The ADR can be used to store statspack snapshots to diagnose database performance issues.
D
The ADR can be used for problem diagnosis even when the database instance is down.
E
The ADR is used to store Automatic Workload Repository (AWR) snapshots.

Show answer and explanation

Correct answers: A, D

Question 2 Multiple choice

Examine this command:

SQL> CREATE DATABASE cdb1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbs1
ENABLE PLUGGABLE DATABASE
SEED

SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M;

Which two requirements must be met to ensure that CDB1 is created? (Choose two.)

A
The ENABLE_PLUGGABLE_DATABASE parameter must be set to TRUE.
B
The PDB_FILE_NAME_CONVERT parameter must be configured.
C
The FILE_NAME_CONVERT clause must be added to the command.
D
The USER_DATA TABLESPACE clause must be added to the command.
E
The DB_CREATE_FILE_DEST parameter must be configured.

Show answer and explanation

Correct answers: A, C

Question 3 Single choice

One of your multitenant container databases (CDB) contains two pluggable databases (PDBs) called PDB1 and PDB2.

You connect to PDB2 as a common user with DBA privileges.

The STATISTICS_LEVEL parameter is PDB modifiable.

As the user SYS, you execute this command successfully on PDB2:
SQL> ALTER SET STATISTICS_LEVEL=ALL SID='*' SCOPE=BOTH;

Which two statements are true about the result of this command?

A
The data dictionary in PDB2 is updated.
B
The STATISTICS_LEVEL parameter is set to ALL in memory only for PDB2.
C
The SPFILE is updated.
D
The data dictionary in CDB$ROOT is updated.
E
The STATISTICS_LEVEL parameter is set to ALL in memory for both PDBs.

Show answer and explanation

Correct answer: B

Question 4 Multiple choice

For which three pieces of information can you use the RMAN list command? (Choose three.)

A
stored scripts in the recovery catalog
B
available archived redo log files
C
backup sets and image copies that are obsolete
D
backups of tablespaces
E
backups that are marked obsolete according to the current retention policy

Show answer and explanation

Correct answers: A, B, D

Explanation

References:
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup007.htm
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585TheprimarypurposeoftheLISTcommandistolistbackupandcopies.Forexample,youcanlist:?Backupsandproxycopiesofadatabase,tablespace,datafile,archivedredolog,orcontrolfile?Backupsthathaveexpired?Backupsrestrictedbytime,pathname,devicetype,tag,orrecoverability?Archivedredologfilesanddiskcopies

Question 5 Multiple choice

Which three RMAN persistent settings can be set explicitly? (Choose three.)

A
archivelog deletion policy
B
SPFILE backup duplexing
C
image copy duplexing
D
archivelog backup duplexing
E
redo log backup duplexing
F
controlfile autobackup formats

Show answer and explanation

Correct answers: A, C, F

Question 6 Multiple choice

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;

Which two statements are true? (Choose two.)

A
An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
B
An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
C
The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
D
The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
E
A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.

Show answer and explanation

Correct answers: C, E

Question 7 Multiple choice

Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? (Choose two.)

A
The MTTR advisor is enabled only if the value is greater than the default value.
B
Automatic checkpoint tuning is enabled.
C
The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.
D
The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGET parameter.

Show answer and explanation

Correct answers: A, C

Explanation

The FAST_START_MTTR_TARGET initialization parameter lets you specify in seconds the expected
"mean time to recover" (MTTR), which is the expected amount of time Oracle takes to perform crash or instance recovery for a single instance.
To enable MTTR advisory, set the initialization parameter FAST_START_MTTR_TARGET to a nonzero value. If FAST_START_MTTR_TARGET is not specified, then MTTR advisory will be OFF.
When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL.
Note: The default value is 0. Range of values is 0 to 3600 seconds.

References:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams079.htm#REFRN10058
https://docs.oracle.com/cd/A97630_01/server.920/a96533/instreco.htm

Question 8 Single choice

View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors:

SQL> startup
ORA-00824:cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information

Why did the instance fail to start?

A
because pga_aggregate_target is not set
B
because statistics_level is set to basic
C
because memory_target and memory_max_target cannot be equal
D
because sga_target and memory_target are both set

Show answer and explanation

Correct answer: B

Question 9 Multiple choice

Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

A
RMAN preauthorization on the host
B
OSB encryption for data in transport and on tape
C
matching the OS user identity of the Oracle instance associated with the database username
D
assigned to a class with rights to back up or restore Oracle database
E
scheduling of the RMAN backup to occur automatically at user-defined intervals
F
assigned to a class with rights to browse all directories and catalogs

Show answer and explanation

Correct answers: A, D, F

Explanation

A: Performing Oracle database backups using RMAN requires RMAN user preauthorization within OSB

D: The preauthorized Oracle Secure Backup user must also be assigned to an Oracle Secure Backup class possessing the following rights: access Oracle backups (set to owner, class, or all) perform Oracle backups and restores

F: The preauthorized Oracle Secure Backup user must be mapped to operating system privileges to access the files to be backed up or restored. the preauthorized Oracle Secure Backup user can perform RMAN operations only on the host where it has access to files.

References:
https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm#OBADM199

Question 10 Single choice

A database instance uses an SPFILE. Examine the parameter:

You plan to multiplex the control file to a new location, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.

Examine the possible steps that are in random order:

1. Shut down the database instance.
2.Issue ALTER SYSTEM SET CONTROL_FILES= `/u01/app/oracle/oradata/cdb1/disk1/control01.ctl,/u01/
app/oracle/oradata/cdb1/disk2/control02.ctl, /u01/app/oracle/oradata/cdb1/disk3/ control03.ctl'
SCOPE=SPFILE;.
3. Issue ALTER SYSTEM SET CONTROL_FILES=
`/u01/app/oracle/oradata/cdb1/disk1/control01.ctl,/u01/app/oracle/oradata/cdb1/disk2/control02.ctl, /u01/
app/oracle/oradata/cdb1/disk3/control03.ctl';.
4. Copy the control file from the existing location to `/u01/app/oracle/oradata/cdb1/disk3/control03.ctl'.
5. Mount the database.
6. Open the database.

Identify the required steps in the correct order to accomplish the task.

A
3, 4
B
2, 6
C
3, 1, 4, 6
D
1, 5, 2, 4, 6
E
2, 1, 4, 6

Show answer and explanation

Correct answer: E