Free Oracle 1z0-063 Exam Dumps Questions & Answers

Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

• A.  The password for the encryption must be set up.
• B.  Oracle wallet for the encryption must be set up.
• C.  All the tablespaces in the database must be encrypted.
• D.  Oracle Database Vault must be enabled.

You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs).
You execute the command to start up the CDB:
SQL> STARTUP
Which statement is true?

• A.  CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode.
• B.  CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode.
• C.  CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode.
• D.  CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state.
• E.  CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode.

You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true? (Choose two.)

• A.  Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
• B.  A resumable statement can be suspended and resumed only once during execution.
• C.  Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
• D.  Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
• E.  A suspended statement will report an error if no corrective action has taken place during a timeout period.

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

You wish to create jobs to satisfy these requirements:
1. Automatically bulk load data from a flat file.
2. Rebuild indexes on the SALES table after completion of the bulk load.
How would you create these jobs?

• A.  Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.
• B.  Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
• C.  Create both jobs using application raised events.
• D.  Create both jobs by using Scheduler raised events.