Oracle Database 12c: Advanced Administration (1z0-063) Free Practice Test

Question 1

Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

A. You can compress data but not metadata during export.

B. You cannot export data from a remote database.

C. You can overwrite existing dump files during export.

D. You can rename tables during import.

Correct Answer: C,D

Question 2

You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user:
SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO c##scott;
Which statement is true about the C##SCOTT user?

A. It is created in all the PDBs with the CREATE SESSION privilege.

B. It is created only in CDB$ROOT and has the CREATE SESSION privilege.

C. It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.

D. It is created and has the CREATE SESSION privilege only in a PDB that is open.

Correct Answer: C

Question 3

You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used? (Choose two.)

A. Enterprise Manager Database Express

B. Oracle Secure Backup

C. RMAN Media Management Library

D. RMAN recovery catalog

E. Enterprise Manager Cloud Control

Correct Answer: D,E

Question 4

You are required to migrate your 11.2.0.3 database to an Oracle 12c database.
Examine the list of steps that might be used to accomplish this task:
1. Place all user-defined tablespaces in read-only mode on the source database.
2. Use the RMAN convert command to convert data files to the target platform's endian format, if required.
3. Perform a full transportable export on the source database with the parameters VERSION=12, TRANSPORTABLE=ALWAYS, and FULL=Y.
4. Transport the data files for all the user-defined tablespaces.
5. Transport the export dump file to the target database.
6. Perform an import on the target database by using the FULL, NETWORK_LINK, and TRANSPORT_DATAFILES parameters.
7. Perform an import on the target database by using the full and TRANSPORT_DATAFILES parameters.
Identify the minimum required steps in the correct order.

A. 1, 4, 5, 2 and 6

B. 1, 2, 4, 6, 5, 3 and 7

C. 1, 3, 5, 4, 2, and 7

D. 2, 4, 5, 3 and 7

E. 3, 5, 4, 2, and 7

Correct Answer: C

Question 5

Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2, both of which are open. RMAN is connected to the target pluggable database PDB2_1.
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?

A. Only the data files belonging to pdb2_1 are backed up.

B. All data files belonging to PDB2_1 are backed up and all archive log files are deleted.

C. This command gives an error because archive log files can be backed up only when RMAN is connected to the root container database.

D. All data files belonging to PDB2_1 are backed up along with the archive log files.

Correct Answer: D

Question 6

Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

A. Oracle Recovery Manager (RMAN)

B. Oracle Real Application Security

C. Oracle Data Pump

D. Oracle Label Security

E. Oracle Database Vault

Correct Answer: A

Question 7

In a database supporting an OLTP workload, tables are frequently updated on both key and non-key columns.
Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?

A. global temporary table

B. hash clustered table

C. external table

D. index clustered table

E. heap table with a primary key index

Correct Answer: D

Question 8

RMAN is connected to a target database instance and an auxiliary instance. You execute the command:

What is the outcome?

A. RMAN uses the push method to transfer backup sets.

B. RMAN uses the pull method to restore files using image copies.

C. RMAN uses the push method to transfer image copies.

D. RMAN uses the pull method to restore files using backup sets.

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 9

Your database is running in archivelog mode. Examine the parameters for your database instance:
LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY'
LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch'
LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch'
LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch'
LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?

A. The database instance is shutdown immediately.

B. The database instance hangs and the redo log files are not overwritten.

C. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.

D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

Correct Answer: D

Question 10

Examine the command and its output:
SQL> DROP TABLE EMPLOYEE;
SQL> SELECT object_name AS recycle_name, original_name, type
FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE
binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE
You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP; Which two statements are true? (Choose two.)

A. It flashes back the employee table and all the constraints associated with the table.

B. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.

C. It automatically flashes back any triggers defined on the table.

D. It automatically flashes back all the indexes on the employees table.

E. It flashes back only the structure of the table and not the data.

Correct Answer: A,C

Welcome to TestSimulate

Oracle Database 12c: Advanced Administration (1z0-063) Free Practice Test