New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Oracle Database 12c 1z0-067 Oracle Study Notes

Page: 6 / 10
Total 263 questions

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP Questions and Answers

Question 21

You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.

What is the outcome?

Options:

A.

The PDB is closed.

B.

The PDB is placed in mount state.

C.

The command executes only if the common user is granted the set container privilege for the PDB.

D.

The command results in an error because the PDB can be shut down only by a local user.

Question 22

Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

Options:

A.

Oracle Data Pump

B.

Oracle Recovery Manager (RMAN)

C.

Oracle Label Security

D.

Oracle Database Vault

E.

Oracle Real Application Security

Question 23

You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs). You execute the command to start up the CDB:

SQL>STARTUP

Which statement is true?

Options:

A.

CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode

B.

CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state

C.

CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode

D.

CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode

E.

CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode

Question 24

In a database supporting an OLTP workload, tables are frequently updated on both key and non-keycolumns.

Reports are also generated by joining multiple tables.

Which table organization or type would provide the best performance for this hybrid workload?

Options:

A.

heap table with a primary key index

B.

external table

C.

hash clustered table

D.

global temporary table

E.

index clustered table

Page: 6 / 10
Total 263 questions