Q1. Examine the parameters for your database instance: 

NAMETYPE VALUE 

undo_management string AUTO 

undo_retentioninteger 12 00 

undo_tablespace string UNDOTBS1 

You execute the following command: 

SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; 

Which statement is true in this scenario? 

A. Undo data is written to flashback logs after 1200 seconds. 

B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace. 

C. You can perform a Flashback Database operation only within the duration of 1200 seconds. 

D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed. 

View Answer

Q2. Which two statements are true about the Oracle Direct Network File system (DNFS)? 

A. It utilizes the OS file system cache. 

B. A traditional NFS mount is not required when using Direct NFS. 

C. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver. 

D. Direct NFS is available only in UNIX platforms. 

E. Direct NFS can load-balance I/O traffic across multiple network adapters. 

View Answer

Q3. You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications: 

Applications will connect to the database via a middle tier. 

The number of concurrent user connections will be high. 

The database will have mixed workload, with the execution of complex BI queries scheduled at night. 

Which DBCA option must you choose to create the database? 

A. a General Purpose database template with default memory allocation 

B. a Data Warehouse database template, with the dedicated server mode option and AMM enabled 

C. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled 

D. a default database configuration 

View Answer

Q4. Your database is open and the listener LISTNENER is up. You issue the command: 

LSNRCTL> RELOAD 

What is the effect of reload on sessions that were originally established by listener? 

A. Only sessions based on static listener registrations are disconnected. 

B. Existing connections are not disconnected; however, they cannot perform any operations until the listener completes the re-registration of the database instance and service handlers. 

C. The sessions are not affected and continue to function normally. 

D. All the sessions are terminated and active transactions are rolled back. 

View Answer

Q5. You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12c. Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions. 

After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs. 

How do you accomplish this? 

A. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs. 

B. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file. 

C. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view. 

D. Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information. 

View Answer

Q6. Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database 

Resource Manager? 

A. Maximum Undo per consumer group 

B. Maximum Idle time 

C. Parallel server limit 

D. CPU 

E. Exadata I/O 

F. Local file system I/O 

View Answer

Q7. On your Oracle Database, you issue the following commands to create indexes: 

SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; 

SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); 

Which two statements are true? 

A. Only the ORD_CUSTOMER_IX1 index created. 

B. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table. 

C. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table. 

D. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true. 

E. Both the indexes are created and used by the optimizer for queries on the ORDERS table. 

F. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table. 

View Answer

Q8. Which statement is true about the Log Writer process? 

A. It writes when it receives a signal from the checkpoint process (CKPT). 

B. It writes concurrently to all members of multiplexed redo log groups. 

C. It writes after the Database Writer process writes dirty buffers to disk. 

D. It writes when a user commits a transaction. 

View Answer

Q9. 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 

View Answer

Q10. Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command: 

SQL > CREATE UNDO TABLESPACE undotb01 

DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; 

What is the result? 

A. It executes successfully and creates an UNDO tablespace in HR_PDB. 

B. It falls and reports an error because there can be only one undo tablespace in a CDB. 

C. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command. 

D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command. 

E. It executes successfully but neither tablespace nor the data file is created. 

View Answer