Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING
=> ‘Y’);
Which two statements are true? (Choose two.)

• A.Database operations will be monitored only when they consume a significant amount of resource.
• B.Database operations for all sessions will be monitored.
• C.Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
• D.Only DML and DDL statements will be monitored for the session.
• E.All subsequent statements in the session will be treated as one database operation and will be monitored.

Comment: *

Name: *

Email: *

Verification: *

You executed this command to create a password file:
$ orapwd file = orapworcl entries = 10 ignorecase = N
Which two statements are true about the password file?

• A.It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
• B.It contains username and passwords of database users who are members of the OSOPER operating system group.
• C.It contains usernames and passwords of database users who are members of the OSDBA operating system group.
• D.It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
• E.It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

Comment: *

Name: *

Email: *

Verification: *

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

What are three possible causes for the latch-related wait events?

• A.The size of the shared pool is too small.
• B.Cursors are not being shared.
• C.A large number COMMITS are being performed.
• D.There are frequent logons and logoffs.
• E.The buffers are being read into the buffer cache, but some other session is changing the buffers.

Comment: *

Name: *

Email: *

Verification: *

You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1 . Place all the user-defined tablespace in read-only mode on the source database.
2 . Upgrade the source database to a 12c version.
3 . Create a new PDB in the target container database.
4 . Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the
DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the
DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.

• A.2, 1, 3, 4, 5, 6
• B.1, 3, 4, 5, 6, 7
• C.1, 4, 3, 5, 6, 7
• D.2, 1, 3, 4, 5, 6, 7
• E.1, 5, 6, 4, 3, 2

Comment: *

Name: *

Email: *

Verification: *

You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

• A.The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.
• B.The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
• C.The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
• D.The statement results in an error because there are open PDBs.

Comment: *

Name: *

Email: *

Verification: *