1Z0-063 Online Practice Questions and Answers

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?

A. It lists failures only for the CDB root database.

B. It lists failures for a PDB only when RMAN is connected to a recovery catalog.

C. It lists failures for the CDB and all the PDBs in this CDB.

D. It lists failures only if RMAN is connected to a PDB.

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?

A. Exclusive table-level lock on the EMPLOYEES table

B. Row-exclusive lock on the row being updated

C. Null lock on the EMPLOYEES table

D. Null lock on the row being updated

Examine the RMAN commands:

RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";

RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M;

Which statement is true about the DUPLICATE command?

A. It fails because there is no connection to a recovery catalog.

B. It succeeds only if the target database is in MOUNT state.

C. It succeeds and creates multisection backup sets that are used for active database duplication.

D. It fails because no parallel channels are allocated for the auxiliary database.

Which three statements are true about using RMAN without a recovery catalog? (Choose three.)

A. No archive log deletion policies will be possible.

B. The REPORT SCHEMA command will report only the current database schema.

C. CONTROL_FILE_RECORD_KEEP_TIME may need to be increased.

D. The RMAN backup retention can only be configured to use a redundancy based policy.

E. Database duplication will require a connection to the target.

F. CONTROL_FILE_RECORD_KEEP_TIME may need to be decreased.

In a database supporting an OLTP workload, tables are frequently updated on both key and non-key columns.

Reports are also generated by joining multiple tables.

Which table organization or type would provide the best performance for this hybrid workload?

A. heap table with a primary key index

B. external table

C. hash clustered table

D. global temporary table

E. index clustered table

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.)

A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

B. Setting the target tablespace to read-only after the segments are moved

C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used

D. Taking the target tablespace offline after the segments are moved

E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

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

A. The backup must be performed in mount state.

B. The tablespace must be taken offline.

C. All files must be backed up as backup sets.

D. The database must be backed up as an image copy.

Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.

What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

A. SQL Performance Analyzer

B. SQL Access Advisor

C. SQL Tuning Advisor

D. Automatic Workload Repository (AWR) report

E. Automatic Database Diagnostic Monitor (ADDM)

Users report this error message when inserting rows into the orders table: ERROR at line1:

ORA-01654f:unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES

You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.

Which two must you do to fix this problem without affecting currently executing queries? (Choose two.)

A. drop and re-create the index

B. coalesce the order.ind index

C. coalesce the indexes tablespace

D. perform an on line table rebuild using dbms_redefinition

E. rebuild the index online moving it to another tablespace that has enough free space for the index

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 D3ID for the database.

Identify the required steps in the correct order.

A. 1, 8, 3, 2, 4, 5, 7, 6

B. 8, 1, 3, 2, 4, 5, 7, 6

C. 1, 3, 2, 4, 8, 5, 6, 7

D. 8, 3, 2, 4, 5, 7, 6

E. 8, 1, 3, 2, 4, 5, 6