Free Oracle 1z0-063 Exam Dumps Questions & Answers

Which three statements are true about persistent lightweight jobs? (Choose three.)

• A.They may be created as fully self-contained jobs.
• B.They generate large amounts of metadata.
• C.They must reference an existing Scheduler Program.
• D.A user cannot set privileges on them.
• E.They are useful when users need to create a large number of jobs quickly.

Which two are true about RMAN image copies? (Choose two.)

• A.They can be used as a level 0 incremental backup.
• B.They are the only backup option available for database in NOARCHIVELOG mode.
• C.They can be encrypted using Transparent Data Encryption (TDE).
• D.The can only be written to disk.

You want to create a duplicate database DUP_DB from your production database PROD on the same host.
The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:

What is a prerequisite for the successful execution of this command?

• A.The target database must be in MOUNT state.
• B.RMAN must be connected to the target database instance and the auxiliary instance.
• C.Flashback must be enabled for the PROD database.
• D.A most recent backup set of the PROD database must exist.

Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs).
In PDB HR_PDB, common user C##ADMIN and local user B_ADMIN have only the CONNECT privilege.
You create a common role C##ROLE1 with the CREATE ANY TABLE and SELECT ANY TABLE privileges.
You then execute the commands:
SQL> GRANT c##role1 TO c##admin CONTAINER=ALL>;
SQL> CONN sys/oracle@HR_PDB as sysdba
SQL> GRANT c##role1 TO b_admin CONTAINER=CURRENT;
Which three statements are true? (Choose three.)

• A.C##ADMIN can create and select any table in HR_PDB.
• B.C##ADMIN can create and select any table, and grant the C##ROLE1 role to users only in the root container.
• C.B_ADMIN can create and select any table only in HR_PDB.
• D.A local role can be granted to c##role1 in a PDB
• E.Role c##role1 will always have the same privileges in each PDB.
• F.B_ADMIN can create and select any table in both the root container and HR_PDB.

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.2, 4, 5, 3 and 7
• B.1, 3, 5, 4, 2, and 7
• C.1, 2, 4, 6, 5, 3 and 7
• D.3, 5, 4, 2, and 7
• E.1, 4, 5, 2 and 6