1Z0-053 Online Practice Questions and Answers

Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)

A. It repairs blocks that have read disk I/O errors.

B. It checks whether the alias metadata directory and the file directory are linked correctly.

C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.

D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.

Evaluate the following statements:

CREATE TABLE purchase_orders (

po_id NUMBER(4),

po_date TIMESTAMP,

supplier_id NUMBER(6),

po_total NUMBER(8,2),

CONSTRAINT order_pk PRIMARY KEY(po_id))

PARTITION BY RANGE(po_date) (

PARTITION Q1 VALUES LESS THAN (TO_DATE('1-apr-2007','d-mon-yyyy'), PARTITION Q2 VALUES

LESS THAN (TO_DATE('1-jul-2007','d-mon-yyyy'), PARTITION Q3 VALUES LESS THAN (TO_DATE('1oct-2007','d-mon-yyyy'), PARTITION Q4 VALUES LESS THAN (TO_DATE('1-jan-2008','d-mon-yyyy'));

CREATE TABLE purchase_order_items (

po_id NUMBER(4) NOT NULL,

product_id NUMBER(6) NOT NULL,

unit_price NUMBER(8,2),

quantity NUMBER(8),

CONSTRAINT po_items_fk FOREIGN KEY (po_id)

REFERENCES purchase_orders(po_id))

PARTITION BY REFERENCE(po_items_fk);

What are the two consequences of the above statements? (Choose two.)

A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.

B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.

C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.

D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.

E. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

The SQL Tuning Advisor configuration has default settings in your database instance.

Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?

A. statistics recommendations

B. SQL Profile recommendations

C. Index-related recommendations

D. restructuring of SQL recommendations

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).

Which two are the prerequisites to perform this operation? (Choose two)

A. You must configure block change tracking file

B. You must have first level 1 backups for RMAN to restore blocks

C. You must ensure that the SALES database is mounted or open

D. You must have full or level 0 backups for RMAN to restore blocks

E. You must take the tools01.dbf data file offline before you start a block media recovery

Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)

A. Database must be running in archivelog mode.

B. Automatic undo management must be enabled.

C. Undo retention guarantee must be enabled.

D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

In order to perform Flashback Transaction Query operations, which of these steps are required? (Choose all that apply.)

A. Ensure that database is running with version 10.1 compatibility.

B. Enable Flashback Logging.

C. Enable Supplemental Logging.

D. Ensure that the database is running with version 10.0 compatibility.

E. Ensure that the database is in ARCHIVELOG mode

What are the two different types of database duplication? (Choose two.)

A. Active

B. Passive

C. Online

D. Backup-based

E. Failure driven

You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?

a.

Shut down the database.

b.

Restore a control-file copy from backup media.

c.

Use the create control file command to create a new control file.

d.

Copy the backup control file into place.

e.

Create a new copy of the control file from one of the surviving control files.

f.

Recover the database using the recover database using BACKUP CONTROLFILE command.

g.

Start up the database.

A.

a, b, f, g

B.

c, f, g

C.

a, d, f, g

D.

a, f, g

E.

a, e, g

Which command is used to configure RMAN to perform a compressed backup for every backup executed?

A. BACKUP AS COMPRESSED BACKUPSET DATABASE

B. BACKUP AS COMPRESSED COPY OF DATABASE

C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET

D. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS

E. BACKUP DATABASE COMPRESS

If a backup is expired, which of the following is true?

A. It can never be used for a restore/recover operation.

B. Oracle will remove the backup set pieces from the flash recovery area.

C. The backup has been used at least once to restore and recover the database.

D. The backup is no longer valid because of a resetlogs operation.

E. The physical backup set pieces are missing from the media.