1z0-063 Oracle Database 12c: Advanced Administration Questions and Answers

Your database supports an OLTP workload. Examine the output of the query:

To ensure faster instance recovery, you set the FAST_START_MTTR_TARGET initialization parameter to 30.

What is the effect of this setting on the database?

The following parameters are set for your Oracle 12c database instance:

OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE

You want to manage the SQL plan evolution task manually. Examine the following steps:

1. Set the evolve task parameters.

2. Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.

3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.

4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.

5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.

Identify the correct sequence of steps.

Examine this parameter in a database's PFILE:

DB_CREATE_FILE_DEST = '/u01/app/oracle/oradata/'

You execute this command:

Which three are true after successful database creation? (Choose three.)

You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:

Which two statements are true? (Choose two.)

Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:

1. Make the tablespace read-only at the source database.

2. Export metadata from the source database.

3. Import metadata into the target database.

4. Transfer the dump file and data files to the target machine.

5. Convert data files by using Recovery Manager (RMAN).

6. Make the tablespace read-write at the target database.

Identify the required steps in the correct order.

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?

You want to create a guaranteed restore point for your databases by executing the command:

SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;

Identify two prerequisites for the successful execution of this command. (Choose two.)

Which two statements are true about RMAN duplexed backups? (Choose two.)

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?

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).

Examine the steps required to perform the migration:

1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.

2. Place all tablespaces in read-only mode on the source database.

3. Upgrade the source database to Oracle Database 12c.

4. Copy the dump file and data files to the desired location in the target database.

5. Create a new PDB in the target CDB.

6. Synchronize the PDB on the target CDB.

7. Use Data Pump import on the new PDB by using the full transportable import options.

Identify the required steps in the correct order.

Which four actions are possible during an Online Datafile Move operation? (Choose four.)

Which two result in an inconsistent backup? (Choose two.)

You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.

Which two statements are true? (Choose two.)

One of your databases supports a data warehousing workload and is in NOARCHIVELOG mode. You perform RMAN level 0 backup on Sundays and level 1 incremental backups on other days.

One data file is corrupt and the current online redo log is missing due to media failure.

Which four actions must you take for recovery? (Choose four.)

Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:

1. Create media families for data files and archived redo log files.

2. Configure database backup storage selectors or RMAN media management parameters.

3. Create an OSB user preauthorized for RMAN operations.

4. Configure RMAN Access to the OSB SBT.

5. Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0.

Identify the steps in the correct order.

For which three pieces of information can you use the RMAN LIST command? (Choose three.)

One of your multitenant container databases (CDB) contains multiple pluggable databases (PDBs). You connect to CDB$ROOT as SYS and execute these commands successfully:

SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123;

SQL> CREATE ROLE C##CONNECT;

SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;

SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;

Which three are true? (Choose three.)

You want to duplicate one of your databases when connected to the target database and to the recovery catalog.

Which three are true about this type of database duplication? (Choose three.)

You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following:

i. Long-running queries are not affected.

ii. No extra space is used.

iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process.

iv. Unused space is reclaimed both above and below the high water mark.

Which alter TABLE option would you recommend?

Your multitenant container database (CDB) CDB1, has no startup triggers and contains multiple pluggable databases (PDBs).

It was started up by using the command which executed successfully with no errors:

SQL> STARTUP MOUNT

Which two statements are true? (Choose two.)

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? (Choose two.)

Which two are benefits of unified auditing in full mode? (Choose two.)

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.

Which method or feature should you use?

Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.

Examine the steps to recover this table from an RMAN backup:

1. Determine which backup contains the table that needs to be recovered.

2. Issue the RECOVER TABLE RMAN command with an auxiliary destination defined and the point in time specified.

3. Import the Data Pump export dump file into the auxiliary instance.

4. Create a Data Pump export dump file that contains the recovered table on a target database.

Identify the required steps in the correct order.

After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:

SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE

-------------------------

0

SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)

PL/SQL procedure successfully completed.

SQL> select number_value from redaction_values_for_type_full;

NUMBER VALUE

------------------------

-1

After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.

What must you do to activate the new default value for numeric full redaction?

You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.

Examine the steps required to recover the database:

1. Restore an autobackup of the server parameter file.

2. Restore the control file.

3. Start up the database instance in NOMOUNT state.

4. Mount the database.

5. Restore the data files.

6. Open the database with the RESETLOGS option.

7. Recover the data files.

8. Set DBID for the database.

Identify the required steps in the correct order.

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.

Examine the command:

RMAN> LIST FAILURE;

Which statement is true about this command?

You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode and contains pluggable databases (PDBs), PDB_1 and PDB_2.

While opening PDB_1, you get an error:

SQL> alter pluggable database pdb_1 open;

ORA-01157: cannot identify/lock data file 11 - see DBWR trace file

ORA-01110: data file 11: '/u01/app/oracle/oradata/cdb1/pdb_1/example01.dbf'

To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:

RMAN> REPAIR FAILURE;

Which statement describes the consequence of the command?

RMAN is connected to the target database PROD1 and an auxiliary instance in NOMOUNT state. Examine the command to create a duplicate database:

Which two statements are true about the execution of the DUPLICATE command? (Choose two.)

You plan to upgrade a production database running in NOARCHIVELOG mode that has no Fast Recovery Area configured.

The upgrade must be reversable within as quickly as possible with the smallest overhead.

Which three steps must you perform before you start the upgrade? (Choose three.)

On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:

S>sqlldrhr/hr@pdb table=employees

Which two statements are true about the command? (Choose two.)

Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler? (Choose three.)

A database is running in ARCHIVELOG mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.

What type of backup do you recommend to improve the performance of the backup?

You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

Which two are true about Oracle Secure Backup (OSB)? (Choose two.)

Which three statements are true about automated maintenance tasks? (Choose three.)

Which parameter must be set to which value to implement automatic PGA memory management?

In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.

Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement? (Choose two.)