oracle 1z0-063 practice test

Question 1

You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the
temp01.dbf temp file belonging to the TEMP tablespace is corrupted. Identify two methods to recover the temp file with the
least disruption to database availability. (Choose two.)

• A. Drop the TEMP tablespace, and then re-create it with new temp files.
• B. Restart the database instance to create the temp file automatically.
• C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.
• D. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is corrupted.

Answer:

B C

Explanation:
Temp files are a special class of data files that are associated only with temporary tablespaces.
B: After restore and recovery of a whole database, when the database is open, missing temporary tablespaces that were
recorded in the control file are re-created with their previous creation size, AUTOEXTEND, and MAXSIZE attributes. Only
temporary tablespaces that are missing are re-created. If a temp file exists at the location recorded in the RMAN repository
but has an invalid header, then RMAN does not re-create the temp file.
If the temp files were created as Oracle-managed files, then they are re-created in the current DB_CREATE_FILE_DEST
location. Otherwise, they are re-created at their previous locations.
C: If a data file becomes missing or corrupted. You must take it offline before you can open the database.
References: https://docs.oracle.com/database/121/ADMIN/dfiles.htm
https://docs.oracle.com/database/121/BRADV/rcmcomre.htm

Question 2

Identify two scenarios in which the RMAN crosscheck command can be used. (Choose two.)

• A. when checking for backups that are not required as per the retention policy
• B. when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes
• C. when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible
• D. when synchronizing backups, which were not performed by using RMAN, with the RMAN repository
• E. when listing backups that are required for recovery operations

Answer:

B E

Question 3

Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a
given transaction or for transactions in a given time interval. Which three are prerequisites to fulfill this requirement? (Choose
three.)

• A. Minimal supplemental logging must be enabled.
• B. The database must be running in archivelog mode.
• C. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.
• D. The flashback any table privilege must be granted to the user.
• E. The select any transaction privilege must be granted to the user.
• F. The recycle bin parameter must be set to on.

Answer:

A B E

Question 4

Which two components are contained only in CDB$ROOT? (Choose two.)

• A. the unified audit trail
• B. database links between PDBs in the CDB
• C. PDB service names
• D. resource manager plans for each PDB in the CDB
• E. the default TEMP tablespace for the entire CDB

Answer:

C E

Explanation:
Reference https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89268

Question 5

You take regular backups of one of your production databases by using RMAN with a recovery catalog.
You have added two new tablespaces to this database which must be included in future backups.
Which process occurs which allows the new backups to contain the new datafiles?

• A. The target database control file is synchronized from the recovery catalog with a full resync at the next backup.
• B. The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.
• C. The recovery catalog is synchronized from the target database control file with a full resync at the next backup.
• D. The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

Answer:

A

Question 6

You set the following parameters in the parameter file and restart the database instance:
NEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true? (Choose two.)

• A. The memory_max_target parameter is automatically set to 500 MB.
• B. The pga_aggregate_target and sga_target parameters are automatically set to zero.
• C. The value of the memory_max_target parameter remains zero for the database instance.
• D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.
• E. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

Answer:

A D

Question 7

In an Oracle 12c database, you attempt to load data into the HR.EMPLOYEES table in a pluggable database (PDB):
$> sqlldr hr/[email protected] table=employees
Which three are true? (Choose three.)

• A. It creates the HR.EMPLOYEES table in the PDB and loads data into it if the table does not exist in the PDB to which HR connects.
• B. It succeeds if HR is a local user in the PDB to which HR connects.
• C. It loads data into HR.EMPLOYEES if the table exists in the PDB to which HR connects.
• D. It succeeds if HR is a common user.
• E. It loads data into HR.EMPLOYEES if the table exists in CDB$ROOT.

Answer:

A B C

Question 8

Examine the following set of RMAN commands:

Which statement is true about the RMAN run block execution?

• A. The script is executed and both DC1 and CH1 channels are used for script execution.
• B. The execution of the script fails because multiple channels cannot exist simultaneously.
• C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.
• D. The new channel, CH1, is ignored because a channel has been configured already.

Answer:

C

Question 9

Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP(2013-02-04 09:30:00, YYYY-MM-DD HH:MI:SS);
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP(2013-02-04 09:30:00, YYYY-MM-DD HH:MI:SS);
5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;
6. ALTER TABLE customers FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?

• A. 1, 2, 5
• B. 1, 3, 6
• C. 2, 3, 5, 6
• D. 3, 4, 5

Answer:

A

Question 10

One of your databases is in ARCHIVELOG mode and take nightly RMAN backups.
The USERS and IDX tablespaces are missing due to storage array errors.
Which four actions would recover the tablespaces and their contents while the database remains open? (Choose four.)

• A. Bring both tablespaces ONLINE.
• B. Recover both tablespaces.
• C. Take both tablespaces OFFLINE NORMAL.
• D. Take both tablespaces OFFLINE IMMEDIATE.
• E. Restore both tablespaces from the most recent backup.
• F. Bring both tablespaces ONLINE and rebuild all the instances in the IDX tablespace.

Answer:

A B D E