Oracle 1Z0-083 Quiz 20 Topic 4 Questions 96-100

Question: 1

Which three are true about Database Point-in-Time Recovery?

AThe target point for the recovery must be specified as a time or System Change Number (SCN).

BThe database must be open resetlogs after Database Point-in-Time Recovery.

CThe database must be in archivelog mode.

DDatabase Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)

EThe database must be in mount state when performing Database Point-in-Time Recovery.

FThe database must have flashback database on to perform Database Point-in-Time Recovery.

Show Answer

Question: 2

A database is configured in archivelog mode.

Full RMAN backups are taken daily and no backup to trace has been taken of the control file.

A media failure has occurred.

In which two scenarios is complete recovery possible?

Aafter losing an archived log from before the most recent backup

Bafter losing all copies of the control file

Cwhen any archived log from, before, or after the most recent backup is corrupt

Dafter losing an archived log from after the most recent backup

Eafter losing the system tablespace

Show Answer

Question: 3

Which two are true about instance recovery?

AIt is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

BIt is performed by the Recovery Writer (rvwr) background process.

CIt is performed automatically while the database remains in mount state. Then the database is opened.

DSetting fast_start_mttr_target to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.

EIt is not possible if an archived log is missing.

FSetting fast_start_mttr_target to a higher value reduces instance recovery time by causing the log writer to write more frequently, thereby reducing the number of I/Os needed during instance recovery.

Show Answer

Question: 4

Examine this configuration:

1. CDB1 is a container database.

2. PDB1 and PDB2 are pluggable databases in CDB1.

You execute these commands successfully:

q4_1Z0-083

Which two are true?

ARedo logs are opened.

BPDB$SEED is in read only state.

CPDB1 and PDB2 are in read only state.

DPDB1 and PDB2 are in mount state.

ECDB$ROOT is in mount state.

Show Answer

Question: 5

For which two requirements can you use the user_tablespaces clause with the create pluggable database command?

Ato specify a default tablespace in a PDB cloned from another PDB in the same CDB

Bto specify the list of user tablespaces to include when moving a non-CDB to a PDB

Cto include specific user tablespaces only when relocating a PDB

Dto exclude all tablespaces except system, sysaux, and temp when plugging in a PDB

Eto exclude a temp tablespace when plugging in a PDB

Fto specify the list of tablespaces to include when creating a PDB from the CDB seed

Show Answer

Oracle 1Z0-083 Quiz:20 Topic:4 Questions:96-100