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

Oracle 1z0-083 - Oracle Database Administration II

Oracle 1z0-083 Premium Access     Download Demo    
Page: 5 / 9
Total 286 questions

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

A.

Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

B.

Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

D.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

E.

Re-createthepasswordfileintheOracleDatabase12cformat. Correct

.Examine the RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?

A.

The password for the encryption must be set up.

B.

Oracle wallet for the encryption must be set up.

C.

All the tablespaces in the database must be encrypted

D.

Oracle Database Vault must be enabled.

Choose three. PDB1 and PDB2 are pluggable databases in CDB1. Examine these commands: $ export ORACLE_SID=CDB1 $ sqlplus / as sysdba SQL> STARTUP ....... Database opened. SQL> SHOW PDBS CON_ID CON_NAME --------------------------------------------------------------------OPEN MODE READ ONLY NO MOUNTED MOUNTED SQL> ALTER PLUGGABLE Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 SAVE STATE; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 CLOSE; Pluggable database altered. SQL> ALTER PLUGGABLE A DATABASE pdb2 OPEN; Pluggable database altered. CDB1 is then restarted. Which three are true?

A.

PDB2 will be opened READ WRITE.

B.

PDB1 will be opened READ WRITE.

C.

PDB1 will be MOUNTED.

D.

PDB$SEED will be opened READ ONLY.

E.

PDB$SEED will be MOUNTED

F.

PDB2 will be MOUNTED.

Choose three. Which three are true about corrupted data blocks and their recovery in an Oracle Database?

A.

If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.

B.

DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption.

C.

A media corrupt block is one where the block is not formatted correctly.

D.

The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.

E.

If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt.

F.

DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.

choose one .Examine the 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 statement is true about the DUPLICATE command?

A.

It succeeds and creates multisection backup sets that are used for active database duplication.

B.

It fails because there is no connection to a recovery catalog.

C.

It succeeds only if the target database is in MOUNT state.

D.

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

Examine this configuration: 1. The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA. 2. ORCL uses disk group +FRA for the Fast Recovery Area. 3. LISTENER is the listener for ORCL. 4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart. 5. All components are currently shut down. You execute this command:

What is the outcome?

A.

The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.

B.

Only the ORCL database instance is started.

C.

Only the ORCL database and the ASM instances are started.

D.

Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.

E.

Only the ORCL database instance and the +DATA and +FRA disk groups are started.

choose three Which three RMAN persistent settings can be set explicitly?

A.

SPFILE backup duplexing

B.

control file auto backup formats

C.

archive log deletion policy

D.

image copy duplexing

E.

redo log backup duplexing

F.

archive log backup duplexing

Choose three. Which three are true about upgrading an application in an application container?

A.

An application root clone gets created automatically.

B.

The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED.

C.

After an application upgrade, the application container's PDBs remain synchronized with the existing application root.

D.

The upgrade must be performed when connected to CDB$ROOT.

E.

An application name and version number must be specified to upgrade the application.

F.

After an application upgrade, the application container's PDBs are automatically synchronized with the application root clone.

Choose three. Which three are true about the tools for diagnosing Oracle Database failure situations?

A.

RMAN can always repair corrupt blocks.

B.

Flashback commands help with repairing physical errors.

C.

The ADR can store metadata in an Oracle Database repository.

D.

The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.

E.

The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.

F.

The Data Recovery Advisor uses the ADR.

A database is configured in ARCHIVE LOG mode. Full RMAN backups are taken 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? (Choose two.)

A.

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

B.

after losing all copies of the control file

C.

after losing an archived log from after the most recent backup

D.

after losing an archived log from before the most recent backup

E.

after losing the SYSTEM tablespace