Q1. You must track all transactions that modify certain tables in the sales schema for at least three years. 

Automatic undo management is enabled for the database with a retention of one day. 

Which two must you do to track the transactions? 

A. Enable supplemental logging for the database. 

B. Specify undo retention guarantee for the database. 

C. Create a Flashback Data Archive in the tablespace where the tables are stored. 

D. Create a Flashback Data Archive in any suitable tablespace. 

E. Enable Flashback Data Archiving for the tables that require tracking. 

View Answer

Q2. To implement Automatic Management (AMM), you set the following parameters: 

When you try to start the database instance with these parameter settings, you receive the following error message: 

SQL > startup 

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. 

Identify the reason the instance failed to start. 

A. The PGA_AGGREGATE_TARGET parameter is set to zero. 

B. The STATISTICS_LEVEL parameter is set to BASIC. 

C. Both the SGA_TARGET and MEMORY_TARGET parameters are set. 

D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal. 

View Answer

Q3. You find this query being used in your Oracle 12c database: 

Which method a used by the optimizer to limit the rows being returned? 

A. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows 

B. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application. 

C. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows. 

D. A TOP-N query is created to limit the rows to 20 percent of the total rows 

View Answer

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

View Answer

Q5. Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? 

A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace. 

B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace. 

C. All the components may be moved into SYSAUX tablespace. 

D. All the components may be moved from the SYSAUX tablespace. 

View Answer

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

View Answer

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

Q8. Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. 

What should you use to achieve this? 

A. Database replay 

B. SQL Tuning Advisor 

C. SQL Access Advisor 

D. SQL Performance Analyzer 

E. Automatic Workload Repository compare reports 

View Answer

Q9. The ORCL database is configured to support shared server mode. You want to ensure that a user connecting remotely to the database instance has a one-to-one ratio between client and server processes. 

Which connection method guarantees that this requirement is met? 

A. connecting by using an external naming method 

B. connecting by using the easy connect method 

C. creating a service in the database by using the dbms_service.create_service procedure and using this service for creating a local naming service" 

D. connecting by using the local naming method with the server = dedicated parameter set in the tnsnames.ora file for the net service 

E. connecting by using a directory naming method 

View Answer

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

View Answer