Oracle 1Z0-083 Quiz 21 Topic 6 Questions 101-105

Question: 1

Which three are true about requirements for various flashback operations?

Aflashback version query requires undo to retrieve all versions of a row that existed between two points in time.

Bflashback drop requires that the recyclebin parameter be set to on.

Cflashback data archive requires undo to store all versions of all rows of a table being tracked.

Dflashback transaction query requires undo to retrieve all versions of a row that existed between two points in time.

Eflashback drop requires undo to retrieve all versions of a row that existed between two points in time.

Fflashback version query requires that the recyclebin parameter be set to on.

Show Answer

Question: 2

Which two are true about automatic block repair?

AReal-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.

BIt is not possible for media corrupt blocks.

CAutomatic block repair can repair blocks with no standby database if db_block_checking = TRUE.

DReal-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

EReal-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.

Show Answer

Question: 3

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment?

Athe configuration of storage arrays

Bthe physical data model

Cdefining primary keys for all tables to speed up all queries

Ddefining foreign keys for all tables to speed up joins

Eusing check constraints to speed up updates

Show Answer

Question: 4

You issued this command:

RMAN> BACKUP RECOVERY FILES;

Which two are true?

AAll non-Oracle files in the current FRAthat have not been backed up already, are backed up.

BAll Oracle recovery files in the current fast recovery area (FRA) are backed up.

CAll Oracle recovery files in the current FRA that have not been backed up already, are backed up.

DAll Oracle recovery files not in the current FRA that have not been backed up already, are backed up.

EThese backups can be written to disk or SBT.

Show Answer

Question: 5

Examine this command:

$ rhpctl move database -sourcehorae Oracle_horne_path -destinationhome Oracle_home_path

For which two purposes can you use this command?

Ato switch to a patched Oracle Database home

Bto switch the Oracle Database home when using a centralized Rapid Home Provisioning server

Cto switch back to the previous Oracle home as part of a rollback operation

Dto switch an existing Oracle Database home to a newer release of Oracle software on the same server

Eto switch to a read-only Oracle home

Show Answer

Oracle 1Z0-083 Quiz:21 Topic:6 Questions:101-105