Which command do you use to create a local role while you are connected as the local user?

A. create local role l_hr;

B. create role c##_hr container=current;

C. create role l_hr container=current;

D. create role l_hr container=all;

Which two statements are true about this common user?

A. SQL> conn c##usr/pwd@pdb1 You are connected to PDB1 successfully.

B. SQL> conn c##usr/pwd@pdb2 You are connected to PDB2 successfully.

C. SQL> conn c##usr/pwd@pdb2 You are unable to create a connection. You first need to sync PDB2 by executing: SQL> conn / as sysdba SQL>exec DBMS_PDB.SYNC_PDB;

D. SQL> conn c##usr/pwd@pdb2 You are unable to create a connection. You need to create the common user c# #usr explicitly in PDB2 by executing: SQL>conn system/pwd@pdb2 SQL> CREATE USER c##usrIDENTIFIED BYpwd CONTAINER=CURRENT; Now you are able to connect as common user c##usr to PDB2.

Your database is down. You log in as the SYS user and issue this command: SQL> STARTUP

What happens after the instance is started?

A. Nothing else happens.

B. The database is mounted but not opened.

C. The database is mounted and finally opened.

D. The database is opened and finally mounted.

An Oracle instance is a combination of______.

A. database files and parameter file (initialization parameter file or server parameter file)

B. System Global Area (SGA) and background processes

C. a listener process, server processes, and background processes

D. System Global Area (SGA), server processes, and background processes

E. database files, System Global Area (SGA), and background processes

Your customer needs server availability that provides uninterrupted access to database services, handling any unexpected failure of one or more machines hosting the database server, due to a hardware or software fault. Which product should your customer use?

A. Oracle Data Guard

B. Oracle Streams

C. Oracle Real Application Clusters

D. Oracle GoldenGate

You create a CDB with four containers: the loot, the seed, and two pluggable databases PDB1 and PDB2.

Which four items can reside In PDB1, but not in the root?

A. shared UNDO and default database temporary tablespace

B. Oracle-supplied metadata

C. shared Oracle-supplied data

D. CDB views providing information across PDBs

E. application tablespaces

F. local temporary tablespaces

G. local users and local roles

H. non-shared local metadata

Which is the default isolation level in Oracle Database 12c?

A. serializable

B. read-only

C. read committed

D. read uncommitted

After a ___________ statement is issued, a transaction ends. (select three)

A. COMMIT

B. ROLLBACK

C. SAVEPOINT

D. SELECT

E. CREATE

Which statement is true about Enhanced Real-Time ADDM in Oracle Database 12c?

A. The analyzed result is lost when the database instance is restarted.

B. It runs every 1 hour automatically.

C. It is shipped only with Oracle Enterprise Manager 12c.

D. It analyzes high CPU trend and identifies problems before they can threaten application performance.

Your customer is looking for zero-data-loss failover with maximum data protection and high availability for their primary database. Which two solutions would you recommend to the customer if the distance between the primary and the standby location is more than 300 miles?

A. Asynchronous redo transport with Data Guard

B. Synchronous redo transport with Data Guard

C. Active Data Guard Far Sync

D. Data Guard SQL Apply