Free 1z0-062: Oracle Database 12c Installation and Administration Exam Questions and Answers

Last updated: August 30, 2026

Provider

Oracle

Questions in our bank

1000+

Free to read

First 10, with answers

Official page

Official Exam website

Our test mode duration & pass mark

130 mins · 70%

Verified answers

Reviewed weekly

Recommended: Switch to Test Mode to start a practice test that simulates the real exam experience.

1. Question #1

   In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the following command from the root container: SQL > REVOKE create table FROM C # # A_ADMIN; What is the result?

   • A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
   • B. It fails and reports an error because the CONTAINER=ALL clause is not used.
   • C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
   • D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
   Reveal Answer

2. Question #2

   Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?

   • A. shutting down the database instance that is being upgraded
   • B. executing the catctl.pl script to run the upgrade processes in parallel
   • C. running the Pre-Upgrade Information Tool
   • D. copying the listener.ora file to the new ORACLE_HOME
   Reveal Answer

3. Question #3

   Your database is open and the listener LISTENER is up. You issue the command: LSNRCTL> RELOAD What is the effect of RELOAD on sessions that were originally established by LISTENER?

   • A. Only sessions based on static listener registrations are disconnected.
   • B. Existing connections are not disconnected; however, they cannot perform any operations until the listener completes the re-registration of the database instance
   • C. The sessions are not affected and continue to function normally.
   • D. All the sessions are terminated and active transactions are rolled bac
   Reveal Answer

4. Question #4

   Examine the parameters for your database instance: You execute the following command: SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; Which statement is true in this scenario?

   • A. Undo data is written to flashback logs after 1200 seconds.
   • B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undotablespace.
   • C. You can perform a Flashback Database operation only within the duration seconds.
   • D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.
   Reveal Answer

5. Question #5

   Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

   • A. By default, EM express is available for a database after database creation.
   • B. You can use EM express to manage multiple databases running on the same server.
   • C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
   • D. You cannot start up or shut down a database Instance by using EM express.
   Reveal Answer

6. Question #6

   Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container. The steps to recover the tablespace are as follows: 1. Mount the CDB. 2. Close all the PDBs. 3. Open the database. 4. Apply the archive redo logs. 5. Restore the data file. 6. Take the SYSAUX tablespace offline. 7. Place the SYSAUX tablespace online. 8. Open all the PDBs with RESETLOGS. 9. Open the database with RESETLOGS. 10. Execute the command SHUTDOWN ABORT. Which option identifies the correct sequence to recover the SYSAUX tablespace?

   • A. 6, 5, 4, 7
   • B. 10, 1, 2, 5, 8
   • C. 10, 1, 2, 5, 4, 9, 8
   • D. 10, 1, 5, 8, 10
   Reveal Answer

7. Question #7

   You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceeded during execution of a data manipulation language (DML) statement, the operation should abort and return an error. However, queries should still be allowed, even if users have exceeded the undo space limitation. How would you achieve this?

   • A. Specify the maximum amount of quota a user can be allocated in the undo tablespace.
   • B. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions.
   • C. Implement a profile for these users.
   • D. Implement a Database Resource Manager pla
   Reveal Answer

8. Question #8

   You executed the following command to create a password file in the database server: $ orapwd file = orapworcl entries = 5 ignorecase=N Which statement describes the purpose of the above password file?

   • A. It records usernames and passwords of users when granted the DBA role
   • B. It contains usernames and passwords of users for whom auditing is enabled
   • C. It is used by Oracle to authenticate users for remote database administrator
   • D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups
   Reveal Answer

9. Question #9

   A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: There is enough free space in the disk group for mirroring to be done. What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

   • A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
   • B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
   • C. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
   • D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the
   Reveal Answer

10. Question #10

    Examine the following steps: ADBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY. SIDNEY grants the CREATE TABLE system privilege to the HR user. Which statement is true?

    • A. SIDNEY can revoke the CREATE TABLE system privilege only from HR, to whom he granted it.
    • B. HR can grant the CREATE TABLE system privilege to other users.
    • C. Neither SIDNEY nor HR can create new tables if the DBA revokes the CREATE TABLE privilege from SIDNEY.
    • D. HR still retains the CREATE TABLE system privilege if the DBA revokes the CREATE TABLE privilege from SIDNEY.
    Reveal Answer