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

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?

A.

AWR snapshots can be created in CDB$ROOT.

B.

ADDM can run in a nonroot container.

C.

AWR reports can be generated while connected to any container.

D.

All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

E.

AWR snapshots can be created in a PDB.

F.

No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

A.

It analyzes a period of time corresponding to the 12 hours of activity.

B.

It runs automatically after each AWR snapshot.

C.

A DBA can run it manually.

D.

Results are written to the alert log.

E.

It analyzes a period of time corresponding to the last day of activity.

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

A.

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

B.

A failure can be closed only when it has been repaired.

C.

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

D.

The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.

E.

Data Recovery Advisor can proactively check for failures.

Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

A.

By default, the transported database will use Oracle Managed Files (OMF)

B.

Data files can be converted on the destination system.

C.

Data files can be converted on the source system.

D.

A new DBID is automatically created for the transported database.

E.

Databases can be transported between systems with different endian formats.

F.

The password file is automatically converted by RMAN.

Choose three. Which three actions will add a resource to an Oracle Restart configuration?

A.

creating a disk group using the CREATE DISKGROUP SQL statement

B.

creating a database service using DBMS_SERVICE.CREATE_SERVICE

C.

creating a database service using Oracle Database Configuration Assistant (DBCA)

D.

creating a database using the CREATE DATABASE SQL statement

E.

creating an Oracle Database service by modifying the SERVICE_NAMES parameter

F.

creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)

choose one You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

A.

Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.

B.

Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

C.

Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

D.

Create the database by using the CREATE DATABASE . . . command and manually import data by using Data Pump.

Choose three. Which three are true about recovering tables using RMAN?

A.

RMAN can recover tables owned by the SYSTEM user.

B.

RMAN can recover tables owned by the SYS user.

C.

RMAN can recover tables in the SYSTEM tablespace.

D.

RMAN always uses an auxiliary instance.

E.

RMAN can recover a table after a DDL operation has altered the table structure.

F.

RMAN can recover tables in the SYSAUX tablespace.

G.

RMAN can recover tables in a standby database.

choose two Which two are benefits of unified auditing in full mode?

A.

All audit data is written to both the traditional locations and to the unified location.

B.

The audit trail is in a single format.

C.

Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location.

D.

The audit trail is read-only.

E.

The audit trail uses less space.

Choose two. Which two are true about backup encryption?

A.

The Transparent Data Encryption (TDE) keystore is backed up using RMAN.

B.

Vendor-specific media management software can be used for making encrypted RMAN backups to media.

C.

The BACKUP BACKUPSET command can encrypt and decrypt backup sets.

D.

Image copies can be encrypted.

E.

Keystore-based encryption is the default mode for RMAN backup encryption.

F.

Backup encryption can be enabled selectively for specific tablespaces.

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

A.

Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.

B.

A connection to an auxiliary instance is always required.

C.

A subset of the target database can be duplicated.

D.

A new DBID is always created for the duplicated database.

E.

A connection to the recovery catalog instance is always required.

F.

A backup of the target database is always required.

G.

Duplication can be done by having the target database instance push copies to the auxiliary database instance.