Oracle Database 12c: Advanced Administration - 1z1-063 Exam Practice Test
You are administering a multitenant container database (CDB) CDB1 that has multiple pluggable databases (PDBs). As the SYS user on CDB$ROOT, you execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL;
SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##ADMIN user that is created in all PDBs? (Choose two.)
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL;
SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##ADMIN user that is created in all PDBs? (Choose two.)
Correct Answer: B,E
Vote an answer
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?
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?
Correct Answer: E
Vote an answer
Examine these Data Pump commands to export and import objects from and to the same database.
The dba has not yet created users hr1 and oe1.
$expdp system/manager
schemas = hr.oe
directory = EXP_DIR
dumpfile = export.dat
include = table
$ impdpsysten/manager
schemas = hr1,oe1
directory = EXP_DIR
dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?
The dba has not yet created users hr1 and oe1.
$expdp system/manager
schemas = hr.oe
directory = EXP_DIR
dumpfile = export.dat
include = table
$ impdpsysten/manager
schemas = hr1,oe1
directory = EXP_DIR
dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?
Correct Answer: A
Vote an answer
As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?
Which step should you perform next to start the upgrade of the database?
Correct Answer: D
Vote an answer
Which three types of failures are detected by the Data Recovery Advisor (DRA)? (Choose three.)
Correct Answer: A,B,E
Vote an answer
You want RMAN to make duplicate copies of data files when using the BACKUP command.
What must you set using the RMAN CONFIGURE command to achieve this?
What must you set using the RMAN CONFIGURE command to achieve this?
Correct Answer: B
Vote an answer
You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded.
Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?
Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?
Correct Answer: A
Vote an answer
The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction.
Which type of lock would this scenario lead to?
Which type of lock would this scenario lead to?
Correct Answer: C
Vote an answer
Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):
1. Start the RMAN client by using the RMAN TARGET / command.
2. Start the RMAN client by using the OSB user.
3. RMAN creates the backup pieces.
4. Run the RMAN BACKUP command with the SBT channels.
5. OSB creates a backup job and assigns a unique identifier.
6. OSB creates a backup job request through the OSB SBT library.
7. OSB stores metadata about RMAN backup pieces in the OSB catalog.
8. OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.
1. Start the RMAN client by using the RMAN TARGET / command.
2. Start the RMAN client by using the OSB user.
3. RMAN creates the backup pieces.
4. Run the RMAN BACKUP command with the SBT channels.
5. OSB creates a backup job and assigns a unique identifier.
6. OSB creates a backup job request through the OSB SBT library.
7. OSB stores metadata about RMAN backup pieces in the OSB catalog.
8. OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.
Correct Answer: D
Vote an answer
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?
Correct Answer: A
Vote an answer