NEW QUESTION 1
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.

Answer: B

NEW QUESTION 2
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns?

• A. The index remains invisible.
• B. The index is not updated by the DML statements on the indexed table.
• C. The index automatically becomes visible in order to have it updated by DML on the table.
• D. The index becomes unusable but the table is updated by the DML.
• E. The index is updated by the DML on the table.

Answer: AE

NEW QUESTION 3
Identify two valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

• A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEE
• B. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEE
• C. Use the DBMS_PDB package to clone an existing PD
• D. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CD
• E. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CD

Answer: AD

NEW QUESTION 4
You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;
Which statement is true about the audit record that generated when auditing after instance restarts?

• A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
• B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
• C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
• D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables use
• E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables use

Answer: D

NEW QUESTION 5
You database is running an ARCHIVELOG mode.
The following parameter are set in your database instance:
LOG_ARCHIVE_FORMAT = arch+%t_%r.arc
LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’
DB_RECOVERY_FILE_DEST_SIZE = 50G
DB_RECOVERY_FILE = ‘/u01/oradata’
Which statement is true about the archived redo log files?

• A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
• B. They are created only in the Fast Recovery Are
• C. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
• D. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.

Answer: A

NEW QUESTION 6
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

• A. ALTER TABLE SPLIT PARTITION
• B. ALTER TABLE MERGE PARTITION
• C. ALTER TABLE TRUNCATE PARTITION
• D. ALTER TABLE ADD PARTITION
• E. ALTER TABLE DROP PARTITION
• F. ALTER TABLE MOVE PARTITION

Answer: CE

NEW QUESTION 7
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.
On further investigation, you find that buffer busy waits is caused by contention on data blocks.
Which option would you consider first to decrease the wait event immediately?

• A. Decreasing PCTUSED
• B. Decreasing PCTFREE
• C. Increasing the number of DBWN process
• D. Using Automatic Segment Space Management (ASSM)
• E. Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

Answer: D

NEW QUESTION 8
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 share
• C. A large number COMMITS are being performe
• 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.

Answer: ABE

NEW QUESTION 9
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12C.
Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

• A. The valid time columns employee_time_start and employee_time_end are automatically create
• B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
• C. The valid time columns are not populated by the Oracle Server automatically.
• D. The valid time columns are visible by default when the table is describe
• E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Answer: ABE

NEW QUESTION 10
Which two statement is true concerning dropping a pluggable database (PDB)?

• A. The PDB must be open in read-only mode.
• B. The PDB must be in mount state.
• C. The PDB must be unplugge
• D. The PDB data files are always removed from disk.
• E. A dropped PDB can never be plugged back into a multitenant container database (CDB).

Answer: CD

NEW QUESTION 11
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:

Which two statements are true?

• A. The C # # ROLE1 role is created in the root database and all the PDBs.
• B. The C # # ROLE1 role is created only in the root database because the container clause is not use
• C. Privileges are granted to the C##A_ADMIN user only in the root database.
• D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
• E. The statement for granting a role to a user fails because the CONTAINER clause is not use

Answer: AC

NEW QUESTION 12
Examine these two statements:

Which three are true about the MRKT tablespace?

• A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
• B. The MRKT tablespace may be dropped if it has no contents.
• C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
• D. No more data files can be added to the tablespace.
• E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

Answer: CDE

NEW QUESTION 13
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?

• A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
• B. Increase the database buffer cache size.
• C. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
• D. Configure Automata Shared Memory Management.
• E. Configure Automatic Memory Management-

Answer: A

NEW QUESTION 14
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.
You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

• A. All users except SYS
• B. All users except SCOTT
• C. All users except sys and SCOTT
• D. All users except sys, system, and SCOTT

Answer: B

NEW QUESTION 15
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.

Answer: AD

NEW QUESTION 16
You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform?

• A. Parallel compilation of only the stored PL/SQL code
• B. Sequential recompilation of only the stored PL/SQL code
• C. Parallel recompilation of any stored PL/SQL code
• D. Sequential recompilation of any stored PL/SQL code
• E. Parallel recompilation of Java code
• F. Sequential recompilation of Java code

Answer: CE

NEW QUESTION 17
Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’);
The possible outcome and actions to aggregate the trace files are as follows:
1.The command fails because a module name is not specified.
2.A trace file is created for each session that is running the SRV1 service.
3.An aggregated trace file is created for all the sessions that are running the SRV1 service.
4.The trace files may be aggregated by using the trcess utility.
5.The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?

• A. 1
• B. 2 and 4
• C. 2 and 5
• D. 3 and 4
• E. 3 and 5

Answer: B

NEW QUESTION 18
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.
Which three steps should you perform to recover the control file and make the database fully operational?

• A. Mount the container database (CDB) and restore the control file from the control file auto backup.
• B. Recover and open the CDB in NORMAL mode.
• C. Mount the CDB and then recover and open the database, with the RESETLOGS option.
• D. Open all the pluggable databases.
• E. Recover each pluggable database.
• F. Start the database instance in the nomount stage and restore the control file from control file auto backup.

Answer: CDF