Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

examout.co

A database is configured in ARCHIVE LOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required? (Choose two.)

A.

after losing a SYSAUX tablespace data file

B.

after losing all members of an INACTIVE online redo log group

C.

after losing all members of the CURRENT online redo log group

D.

after losing all copies of the control file

E.

after losing an UNDO tablespace that is in use

choose two Examine these 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 two statements are true about the DUPLICATE command?

A.

It succeeds.

B.

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

C.

It fails because connection to the AUXILIARY instance must be as SYSDBA.

D.

Itsucceeds only if the target database is greater than 400M.

E.

No catalogued backup of the TARGET is used to duplicate the database.

Choose two. You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI). There is no existing Oracle installation on the server. Which two are prerequisites?

A.

an operating system user to own this installation

B.

the Oracle Inventory group oinstall

C.

an operating system account called grid

D.

a group called dba

E.

the installation of Oracle ASMLIB

Choose three. Which three are true about block media recovery?

A.

To use it, Flashback Database must be enabled.

B.

A block being recovered is not accessible.

C.

It cannot repair logical corruption.

D.

It can be performed on noncorrupt blocks.

E.

The target database for which one or more blocks are to be recovered must be in the OPEN state.

F.

The data file containing the block being recovered remains online.

Which three statements are true about Flashback Database?

A.

Flashback logs are written sequentially, and are archived.

B.

Flashback Database uses a restored control file to recover a database.

C.

The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

D.

Flashback Database can recover a database to the state that it was in before a reset logs operation.

E.

Flashback Database can recover a data file that was dropped during the span of time of the flashback.

F.

Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

choose three Which three are true about unified auditing in full mode?

A.

The unified audit trail is written to a read-only table.

B.

The unified audit trail is written to a read-only external file.

C.

Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

D.

Audit records are created for SYS.

E.

Audit records are created for non-sys users.

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2.

COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT. You execute these commands: S sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; Which is true?

A.

It will return an error because creation of a local role is not allowed in CDB$ROOT.

B.

ROLE1 will be created only in CDB$ROOT.

C.

It will return an error because common roles must start with C##.

D.

ROLE1 will be created only in CDB$ROOT and APP1_ROOT.

E.

ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.

Choose two. Which two are true about the Optimizer Statistics Advisor?

A.

It always analyzes all schemas in the database.

B.

It can recommend changes to improve the statistics gathering process.

C.

It can be run only manually.

D.

It runs automatically every night by default. E) It can be run only automatically.

Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle container database from an older release. 2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1. A priority list UpgrdList has these entries: 1, pdb2 2, pdb1, pdb3 You execute this command: $ /u01/app/oracle/product/18.1.0/ db_1/rdbms/admin/dbupgrade -L UpgrdList In which order will the upgrade occur?

A.

CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4

B.

CDB$ROOT, PDB2, PDB1, and PDB3

C.

CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3

D.

CDB$ROOT, PDB1, PDB2, PDB3, and PDB4

E.

CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4

Choose two. Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?

A.

Data Recovery Advisor can proactively check for failures.

B.

Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

C.

ata Recovery Advisor can be used if a database is in the NOMOUNT state.

D.

A failure can be closed only if the database is in MOUNT state.

E.

Data Recovery Advisor can be used if a database is closed.