[不定项选择题]choose one. 

You take regular backups of one of your production databases by using RMAN with a recovery catalog. 

You have added two new tablespaces to this database which must be included in future backups.

Which process occurs which allows the new backups to contain the new datafiles?

A.

The target database control file is synchronized from the recovery catalog with

A partial resync at the next backup.

B.

The recovery catalog is synchronized from the target database control file with

A full resync at the next backup.

C.

The target database control file is synchronized from the recovery catalog with

A full resync at the next backup.

D.

The recovery catalog is synchronized from the target database control file with

A partial resync at the next backup.

[不定项选择题]choose two You take your database backups by using the RMAN

Media management interface (MMI).

Which two are true about the use of

The RMAN MMI?

A.

You can use it to create proxy copies for database files.

B.

You can use it to create proxy copies for entire file systems.

C.

You can use it to create image copies for entire file systems.

D.

You can use it to create image copies for database files.

E. You can use it to create backup sets for database files.

[不定项选择题]Choose the best answer. You want to transport the UNIVERSITY

Tablespace from one database to another. The UNIVERSITY tablespace is

Currently open read/write. The source and destination platforms have the

Same endian Examine this list of steps:. 

1. Make the UNIVERSITY tablespace read-only on the source 

2. Export the UNIVERSITY tablespace metadata using EXPDP. 

3. Create a cross-platform backup set from the UNIVERSITY

Source system, using an RMAN command that includes the DATAPUMP clause. 

4. Copy the cross-platform backup sets to the destination system. 

5. Copy the Data Pump dump set from the source to the destination system. 

6. Restore the cross-platform backup set on the destination system using an

RMAN command that includes the DATAPUMP clause. 

7. Import the UNIVERSITY tablespace metadata using IMPDP. 

8. Make the UNIVERSITY Tablespace read/write on the destination system. 

Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY Tablespace?

A.

3,4,6

B.

2,3,4,5,6,7

C.

1,3,4,6,8

D.

1,2,3,4,5,6,7,8

[不定项选择题]Choose two .You upgrade your database from pre-12c to a multitenant

Container database (CDB) that contains pluggable databases (PDBs).

Examine the query and its output:

SQL> SELECT * FROM v$PWFILE_users;

USERNAME

SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID

---------------------------------------------------------------------

---

SYS

TRUE TRUE

FALSE

FALSE

FALSE

FALSE

0

Which two tasks must you perform to add users with the SYSBACKUP,

SYSDG, and SYSKM prileges to the password file?

A.) Re-create or migrate the password file to the Oracle Database 12c format
B.) Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
C.) Copy the password file from a sample file in the DBS dierectory
D.) Assign appropriate operating system groups to SYSBACKUP, SYSDG, and
SYSKM.

[不定项选择题]Choose the best answer.

How do you configure a CDB for local undo mode?

A.

Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO

Tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then

Restart the CDB

Instance.

B.

Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER

DATABASE LOCAL UNDO ON, and then restart the CDB instance.

C.

Open the CDB instance in upgrade mode. In each PDB, execute ALTER

DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the

CDB instance.

D.

Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER

DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and

Then restart the CDB instance.

E. Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE
LOCAL UNDO ON, and then change the CDB to read/write mode.

[不定项选择题]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. You issued this command: RMAN> BACKUP RECOVERY

AREA FORCE; Which three are true?

A.

All files in any previous FRA that have not yet been backed up, are backed up.

B.

All files in the current fast recovery area (FRA) that have not yet been backed

Up, are backed up. 

C.

All files in the current FRA that have been backed up

Already, are backed up.

D.

All Oracle recovery files normally written to the FRA and which have been

Backed up already to the current FRA, are backed up.

E.

All files in any previous FRA that have been backed up already, are backed up.

F.

All Oracle recovery files normally written to the FRA and which have not yet

Been backed, are backed up.

G. All Oracle recovery files normally written to the FRA and which have been
Backed up already to in any previous FRA, are backed up.

[不定项选择题]Choose two. You plan to perform cross-platform PDB transport using

XTTS. Which two are true?

A.

Automatic conversion of endianess occurs.

B.

The source and target platforms must have the same endianess.

C.

The source PDB can be in MOUNT or OPEN state.

D.

The source PDB must not be an application root.

E.

The source PDB must be in MOUNT state.

F.

A backup of the PDB must exist, taken using the BACKUP command with the to PLATFORM clause.

[不定项选择题]Choose three. You must migrate a non-CDB Oracle 11g Database to a

CDB without first performing an upgrade to the non-CDB.

User-defined objects are stored in several tablespaces in the non-CDB.

Which three methods can you use?

A.

Data Pump full database export and import

B.

cloning the non-CDB as a PDB

C.

replication using GoldenGate

D.

Data Pump transportable tablespaces

E. Data Pump full transportable database
F. the DBMS_PDB package

[不定项选择题]Choose two.

You are managing this configuration:

1CDB1 is a container database.

2 PDB1 and PDB2 are two pluggable databases in CDB1.

3 USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2 .

CDB1 user SYS executes these commands after connecting successfully to

PDB2:

SQL> ALTER SESSION SET CONTAINER=pdb1;

Session altered.

SQL> INSERT INTO user1.emp VALUES (100, 'Alan' ,1) ;

1 row created.

SQL> INSERT INTO user1.emp VALUES (101, 'Ben' ,1) ;

1 row created.

SQL> ALTER SESSION SET CONTAINER=pdb2;

Session altered.

SQL> INSERT INTO user2.dept VALUES(1, 'IT');

Which two are true? (Choose two.)

A. The inserts on USER1.EMP remain uncommitted when the session connected
To PDB2.
B. The inserts on USER1.EMP were committed when the session inserted a row
Into USER2. DEPT.
C. The insert on USER2.DEPT fails because of the active transaction in the parent
Container.
D. The insert on USER2.DEPT is a recursive autonomous transaction by the child
Session and is
Committed.
E. The inserts on USER1.EMP were rolled back when the session connected to
PDB2.
F. The insert on USER2.DEPT is uncommitted.
G. The inserts on USER1.EMP were committed when the session connected to
PDB2.

[不定项选择题]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.

[不定项选择题]You must transport the UNIVERSITY tablespace from one database to

Another.

The UNIVERSITY tablespace is currently open read/write.

The source and destination platforms have different endian formats.

Examine this list of actions:

1-Make the UNIVERSITY tablespace read-only on the source system.

2-Export the UNIVERSITY tablespace metadata using EXPDP.

3-Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the source system.

4-Copy the UNIVERSITY tablespace data files to the destination system.

5-Copy the Data Pump dump set to the destination system.

6-Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.

7-Import the UNIVERSITY tablespace metadata using IMPDP.

8-Make the UNIVERSITY tablespace read/write on the destination system.

Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

A.

1, 2, 4, 5, 7, 8

B.

1, 2, 4, 6, 7, 8

C.

1, 2, 3, 4, 5, 7, 8

D.

1, 2, 3, 4, 5, 6, 7, 8

E. 2, 4, 5, 6, 7

[不定项选择题]You are administering a multitenant container database (COB) that

Contains two pluggable databases (PDBs), pdb1 and pdb2. You are

Connected to pdb2 as a common user with DBA privileges. The

Statistics_level parameter is PDB modifiable.

As the user sys, execute the following command on pdb2:

SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;

Which statement is true about the result of this command?

A.

The statistics_level parameter is set to all when any of the PDBs is reopened.

B.

The statistics_level parameter is set to all only for PDB2 when it is reopened.

C.

The statistics_level parameter is set to all when the root database is restarted.

D.

The statement is ignored because there is no SPFILE for a PDB.

[不定项选择题]You notice performance degradation in your production Oracle 12c

Database. You want to know what caused this performance difference.

Which method or feature should you use?

A.

Database Replay

B.

Automatic Database Diagnostic Monitor (ADDM) Compare Period report

C.

Active Session History (ASH) report

D.

SQL Performance Analyzer

[不定项选择题]choose one
You enable Flashback Data Archive for a table for which you
Want to track and save all transactions for four years. After some time, the
Requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;
What is the outcome?
A. All historical data older than two years, if any, is purged from the flashback
Archive FDA1.
B. An error is returned because the retention period cannot be reduced.
C. All the flashback data archives are purged and the subsequently created
Flashback archives are maintained for two years.
D. All historical data older than two years, if any, is archived to flashback logs and
The flashback archive is set to new retention time.

[不定项选择题]You plan to install Oracle Grid Infrastructure for a Standalone Server

And Oracle Database for the first time on a server.

Examine this command and its outcome:

Which two are true? (Choose two.)

A.

oracle will be an owner of the Oracle Inventory.

B.

oracle must be the owner of every Oracle Database installation.

C.

oracle can own an Oracle Database installation but not an Oracle Grid

Infrastructure installation.

D.

oracle will be granted the SYSASM privilege when installing the Oracle

Database software.

E. The user account, oracle, and group, oinstall, can be used for all Oracle
Software installations.

[不定项选择题]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 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 two Examine the command to duplicate a database:

RMAN> DUPLICATE TARGET DATABASE

TO cdb

PLUGGABLE DATABASE pdbl,pdb5;

Which two statements are true about the DUPLICATE command?

A. The root and the seed database in the container database (CDB) are also
Duplicated.
B. A backup of PDB1 and PDB5 must exist before executing the command.
C. The SPFILE is copied along with the data files of the pluggable databases
(PDBs).
D. An auxiliary instance must be started with the initialization parameter
ENABLE_PLUGGABLE_DATABASE set to TRUE.
E. The DUPLICATE command first creates a backup, and then duplicates the PDBs
By using the backup.

[不定项选择题]You notice that the performance of your production 24x7 Oracle 12c

Database has significantly degraded. Sometimes, you are not able to connect

To the database instance because it hangs.

How can you detect the cause of the degraded performance?

A.

by performing emergency monitoring using Real-Time Automatic Database

Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

B.

by running ADDM to fetch information from the latest Automatic Workload

Repository (AWR) snapshots

C.

by using Active Session History (ASH) data and performing hang analysis

D.

by running ADDM in diagnostic mode