1Z0-063 Online Practice Questions and Answers

Which three statements are true about the database instance startup after an instance failure? (Choose three.)

A. The RECO process recovers the uncommitted transactions at the next instance startup.

B. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.

C. Uncommitted changes are rolled back to ensure transactional consistency.

D. The SMON process coordinates the database recovery.

E. Media recovery is required to complete the database recovery.

F. Changes committed before the failure, which were not written to the data files, are re-applied.

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.

Which two best methods for recovering the truncated table data? (Choose two.)

A. Table Point-in-Time Recovery

B. Database Point-in-Time Recovery

C. Tablespace Point-in-Time Recovery

D. Flashback Database

E. Flashback Transaction Backout

Which two operations are NOT performed by the DUPLICATE command in RMAN while duplicating a database that is open? (Choose two.)

A. creating a control file for the duplicate database

B. restoring target data files to the duplicate database

C. performing complete recovery by using all available backups

D. generating a new, unique database identifier (DBID) for the duplicate database

E. copying online redo log files from the target database to the duplicate database

Which four are true about Consolidated Database Replay? (Choose four.)

A. The workload capture and replay servers must run the same operating system (OS).

B. Multiple workload captures from multiple databases can be replayed simultaneously.

C. A subset of the captured workload can be replayed.

D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.

E. Multiple replay schedules can be defined for a consolidated replay.

F. A single replay schedule can be defined for a consolidated replay.

G. A superset of the captured workload can be replayed.

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. 1, 3, 5, 4, 2, and 7

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

C. 2, 4, 5, 3 and 7

D. 1, 4, 5, 2 and 6

E. 3, 5, 4, 2, and 7

Which two components are contained only in CDB$ROOT? (Choose two.)

A. the unified audit trail

B. database links between PDBs in the CDB

C. PDB service names

D. resource manager plans for each PDB in the CDB

E. the default TEMP tablespace for the entire CDB

A database instance uses an SPFILE. Examine the parameter: You plan to multiplex the control file to a new location, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.

Examine the possible steps that are in random order:

1. Shut down the database instance.

2.Issue ALTER SYSTEM SET CONTROL_FILES= `/u01/app/oracle/oradata/cdb1/disk1/control01.ctl,/u01/

app/oracle/oradata/cdb1/disk2/control02.ctl, /u01/app/oracle/oradata/cdb1/disk3/ control03.ctl'

SCOPE=SPFILE;.

3.

Issue ALTER SYSTEM SET CONTROL_FILES=

`/u01/app/oracle/oradata/cdb1/disk1/control01.ctl,/u01/app/oracle/oradata/cdb1/disk2/control02.ctl, /u01/

app/oracle/oradata/cdb1/disk3/control03.ctl';.

4.

Copy the control file from the existing location to `/u01/app/oracle/oradata/cdb1/disk3/control03.ctl'.

5.

Mount the database.

6.

Open the database.

Identify the required steps in the correct order to accomplish the task.

A. 3, 4

B. 2, 6

C. 3, 1, 4, 6

D. 1, 5, 2, 4, 6

E. 2, 1, 4, 6

Which three are true about RMAN duplexed backup sets or image copies? (Choose three.)

A. A backup set may be duplexed with both copies written to disk.

B. An image copy on sbt can be copied to disk.

C. A backup set may be duplexed with both copies written to sbt.

D. An image copy on disk can be copied to sbt.

E. An image copy on disk can be copied to disk.

F. A backup set may be duplexed so that one copy is written to sbt and the other to disk.

You are administering a multitenant container database (CDB) cdb1.

Examine the command and its output:

SQL>show parameterfile

NAME TYPE VALUE

db_create_file_dest string

db_file_name_convert string db_files integer 200 You verify that sufficient disk space is available and that no file currently exists in the `/u0l/app/oracle/

oradata/cdb1/salesdb' location.

You plan to create a new pluggable database (PDB) by using the command:

SQL>CREATEPLUGGABLEDATABASESALESPDB

ADMINUSER salesadm IDENTIFIED BY password;

ROLES=(dba)

DEFAULTTABLESPACE sales

DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01.dbf'SIZE 250M AUTOEXTEND ON

FILE_NAME_CONVERT=(`/u01/app/oracle/oradata/cdb1/pdbseed/',

'/u01/app/oracle/oradata/cdb1/salesdb/')

STORAGE(MAXSIZE2G)

PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';

Which statement is true?

A. SALESPDB is created and is in mount state.

B. PDB creation fails because the db_file_name_convert parameter is not set in the CDB.

C. SALESPDB is created and is in read/write mode.

D. PDB creation fails because a default temporary tablespace is not defined for SALESPDB.

Evaluate these statements:

CREATE TABLE purchase_orders

(po_idNUMBER(4),

po_dateTIMESTAMP,

supplier_idNUM8ER(6),

po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id))

PARTITION BY RANGE(po_date)

(PARTITIONQ1 VALUES LESS THAN (TO_DATE('01-apr-2007','dd-mm-yyyy')),

PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mm-yyyy')),

PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct- 2007','dd-mm-yyyy')),

PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-mm-yyyy')));

CREATE TABLE purchase_order_items

(po_idNUM3ER(4)NOT NULL,

product_idNUMBER(6)NOT NULL,

unit_price NUMBER(8,2),

quantity NUMBER(8),

CONSTRAINT po_items_f k

FOREIGN KEY(po_id)REFERENCES purchase_orders(po_id))

PARTITION BY REFERENCE(po_items_fk);

Which two statements are true? (Choose two.)

A. Partitions of purchase_order_items are assigned unique names based on a sequence.

B. The purchase_orders and purchase_order_items tables are created with four partition each.

C. purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.

D. The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.

E. Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint.