[不定项选择题]Choose two. Your database is in ARCHIVELOG mode and you plan to

Use Flashback Database. Which two features or parameters manage space

Availability in the fast recovery area?

A. the backup retention policy
B. the backup optimization policy
C. the DB_CREATE_ONLINE_LOG_DEST_n parameter setting
D. the archived log deletion policy
E. the DB_RECOVERY_FILE_DEST parameter setting
F. using guaranteed UNDO retention

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

Your container database, CDB1, is in local undo mode.

You successfully execute this command while connected to CDB1:

CREATE PLUGGABLE DATABASE pdb1

ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT)

CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ;

Which three are true about PDB1?

A. It has the same common users defined as does CDB1.
B. It has only local roles.
C. It has the same number of roles as CDB1.
D. Service PDB1 is created for remote logins to PDB1.
E. It is in mount state after creation.
F. It has no local users.

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

[不定项选择题]Choose three. Which three capabilities require the use of the RMAN

Recovery catalog?

A. using RMAN stored scripts
B. creating encrypted backups
C. creating customized reports about a single database's backups
D. using the REPORT SCHEMA command to list a database's data files and
Tablespaces at times in the past
E. using the KEEP FOREVER clause with the BACKUP command
F. using the REPORT SCHEMA command to list a database's current data files and
Tablespaces

[不定项选择题]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 three. Which three resources are always shared among

CDB$ROOT and pluggable databases (PDBs)?

A.

the data dictionary in CDB$ROOT

B.

the log writer process (LGWR)

C.

SYSAUX tablespaces

D.

temporary tablespaces

E. the Process Monitor Process (PMON)
F. undo tablespaces

[不定项选择题]Choose the best answer. Examine this output of an export from the

Current release of an Oracle multitenant database:

$ sqlplus system/oracle .

SQL> col name for a10

SQL> select name, open_mode from v$pdbs;

NAME

OPEN_MODE

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

PDB$SEED

READ ONLY

PDB1

READ WRITE

PDB2

MOUNTED

SQL> exit

Next you execute:

$ expdp system/oracle full=y

What is the outcome?

A.

It fails because Data Pump cannot be used while connected to the root

Container.

B.

It creates a full export of the root container and PDB1.

C.

It creates a full export of the root container and all PDBs.

D.

It creates a full export of the root container and all open PDBs.

E. It creates a full export of only the root container.

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

Examine this configuration:

1CDB1 is a container database.

2 APP_ROOT is an application root in CDB1.

3APP_PDB1 is an application PDB in APP_ROOT.

4FLASHBACK DATABASE is ON.

You execute these commands:

$ sqlplus sys/orac1e_4U@localhost:1521/cdb1

SQL> SELECT current_scn FROM v$database;

CURRENT_SCN

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

2074756

SQL> CREATE TABLE cdb1_tab(c1 NUMBER) ;

Table created.

SQL> ALTER SESSION SET CONTAINER=app_root;

Session altered.

SQL> CREATE TABLE app_root_tab (c1 NUMBER) ;

Table created.

SQL> ALTER SESSION SET CONTAINER=app_pdb1;

Session altered.

SQL> CREATE TABLE app_pdb1_tab (c1 NUMBER) ;

Table created.

SQL> conn / as sysdba

Connected.

SQL> ALTER PLUGGABLE DATABASE app_root CLOSE;

Pluggable database altered.

SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756;

Flashback complete.

Which table or set of tables will exist after the Flashback operation has

Completed?

A.

CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB

B.

CDB1_TAB and APP_PDB1_TAB

C.

CDB1_TAB and APP_ROOT_TAB

D.

CDB1_TAB only

E. none of the tables, because all three tables will be dropped

[不定项选择题]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 the best answer.Examine this output of an export from the

Current release of an Oracle multitenant database: $ sqlplus system/oracle .

SQL> col name for a10

SQL> select name, open_mode from v$pdbs;

NAME OPEN_MODE

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

PDB$SEED READ ONLY

PDB1 READ WRITE

PDB2 MOUNTED

SQL> exit

Next you execute: $ expdp system/oracle full=y What is the outcome?

A.

It fails because Data Pump cannot be used while connected to the root container.

B.

It creates a full export of the root and pdb1.

C.

It creates a full export of the root and all pdbs

.

D.

It creates a full export of the root container and all open pdbs.

E.

It creates a full export of only the root container

[不定项选择题]choose three Which three are true about Transparent Data Encryption

(TDE)?

A. It uses a single master key for a database.
B. It replaces secure application roles.
C. It encrypts only data on the client.
D. It stores the current and all past master keys in the keystore.
E. Master encryption keys are managed by Oracle Database Vault.
F. It can encrypt data at the column level.

[不定项选择题]Choose the best answer. Examine this configuration:

1CDB1 is a container database.

2 DEFAULT_SHARING is METADATA.

3APP_ROOT is an application root contained in CDB1.

4APP_PDB1 is an application PDB contained in APP_ROOT.

5COMPANYAPP is an application contained in APP_ROOT.

6EMP is a common table created in APP_ROOT and all its application PDBs,

Created when version 1.0 of COMPANYAPP was installed.

You execute these commands:

$ sqlplus sys/orac1e@localhost:1521/cdb1 as sysdba

SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA;

System altered.

SQL> ALTER SESSION SET CONTAINER=app_root;

Session altered.

SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN

UPGRADE '1.0' TO '2.0';

Pluggable database altered.

SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL) ;

Table altered.

SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END

UPGRADE TO '2.0';

Pluggable database altered.

SQL> ALTER SESSION SET CONTAINER=app_pdb1;

Session altered.

SQL> DESC emp;

Name

Null?

Type

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

ENO

NUMBER

ENAME

VARCHAR2 (20)

SQL> SELECT * FROM emp;

ENO

ENAME

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

100

Alan

200

Ben

SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC;

What will be the outcome and why?

A.

SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.

B.

SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows.

C.

It will return an error because the SYNC operation is not allowed when

Constraints are added to common objects.

D.

It will return an error because EMP is not empty in APP_ROOT.

E. It will return an error because EMP.SAL is empty in APP_ROOT.

[不定项选择题]Choose three. Which three are performed by Oracle Automatic
Storage Management (ASM) instances?
A. mounting disk groups
B. acting as an I/O server to read data file blocks from ASM disks on behalf of
Database server processes
C. managing extent allocation for Oracle database segments
D. managing Allocation Units (AUs) for disk group content
E. managing space allocation for Oracle ASM files
F. acting as an I/O server to write data file blocks to ASM disks on behalf of
Database Writer processes (DBWn)

[不定项选择题]Choose the best answer. Which statement correctly describes the SQL

Profiling performed by the SQL Tuning Advisor?

A.

It is a set of recommendations by the optimizer to change the access methods

Used.

B.

It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.

C.

It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.

D.

It is auxiliary information collected by the optimizer for a SQL statement to

Help use better joins orders.

E. It is a set of recommendations by the optimizer to create new indexes.

[不定项选择题]Choose two. In performance management, which two factors might
Reduce the ability of an application to scale to a larger number of users?
A. poorly trained users who do not commit transactions
B. the number of tablespaces containing tables updated by a transaction
C. issuing multiple savepoints during a transaction
D. the number of data files containing extents belonging to tables updated by a
Transaction
E. poorly written SQL

[不定项选择题]choose three
You want to duplicate one of your databases when
Connected to the target database and to the recovery catalog.
Which three are true about this type of database duplication?
A.) The duplication process can create backup sets or image copies.
B.) The target database must be open.
C.) The duplication process can use existing backup sets or image copies.
D.) The target database must be in mount state.
E.) The duplication process pushes backup sets to the auxiliary instance.
F.) The duplication process pushes image copies to the auxiliary instance.