Q1. Which two statements are true about standard database auditing? (Choose two.)

A. DDL statements can be audited.

B. Statements that refer to standalone procedure can be audited.

C. Operations by the users logged on as SYSDBA cannot be audited.

D. Only one audit record is ever created for a session per audited statement even though it is executed more than once.

View Answer

Q2. View the Exhibit.

You are creating an additional database by using the Database Configuration Assistant (DBCA).

You opted to create a General Purpose database and during the database creation realize that the Block Size field is not enabled.

What could be the reason for this?

A. You have chosen the File System option as the storage option.

B. You have chosen the Automatic Storage Management (ASM) as the storage option.

C. The data block size can be increased only when DBCA is invoked from Oracle Universal Installer (OUI).

D. You are using General Purpose template and not the Custom Database template to create the database.

View Answer

Q3. Which three statements are true about logical structures of the Oracle database? (Choose three.)

A. Each segment contains one or more extents.

B. Multiple tablespaces can share a single data file.

C. A data block is the smallest unit of input/output (I/O) in data files.

D. It is possible to have tablespaces of different block sizes in a database.

E. Each data block in the database always corresponds to one operating system block.

View Answer

Q4. View the Exhibits and examine lock waits. Users HR and SH complain that their transactions on one of the application tables, EMP, are waiting for response.

Which action would you take to release the lock and enable users HR and SH to continue with their transactions?

07 (exhibit):

A. Kill the session of the user SCOTT with session ID118.

B. Issue manual checkpoint using the ALTER SYSTEM command.

C. Modify the profile used by user SCOTT to reduce the CONNECT_TIME limit.

D. Flush the Shared Pool to remove the SQL statement causing "wait" in memory.

View Answer

Q5. In which of the scenario will the DBA perform recovery? (Choose all that apply.)

A. The alert log file is corrupted

B. A tablespace is accidentally dropped

C. One of the redo log members is corrupted

D. A database user terminates the session abnormally

E. The hard disk on which the data files is stored is corrupted

View Answer

Q6. Note the functionalities of various background processes:

1: Perform recovery at instance startup.

2: Free the resources used by a user process when it fails.

3: Cleanup the database buffer cache when a process fails.

4: Dynamically register database services with listeners.

5: Monitor sessions for idle session timeout.

6: Cleanup unused temporary segments.

7: Record the checkpoint information in control file.

Which option has the correct functionalities listed for a background process?

A. Checkpoint (CKPT): 1, 2, 5

B. System Monitor (SMON): 1, 6

C. Process Monitor (PMON): 4, 6, 7

D. Database Writer (DBWR): 1, 3, 4

View Answer

Q7. Which two statements are true about checkpointing? (Choose two.)

A. The checkpoint frequency decreases with the smaller redo log file size.

B. It ensures that all committed data is written to the data files during normal shutdown.

C. The frequent full checkpoint in a database can cause the overall degradation of the database performance.

D. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.

View Answer

Q8. Which three descriptions are correct about the effects of the TRUNCATE command on a table?

(Choose three.)

A. The corresponding indexes for the table are also truncated.

B. Delete triggers on the table are fired during the execution of the TRUNCATE command.

C. The child table is truncated when the TRUNCATE command is applied on the parent table.

D. The highwater mark (HWM) is set to point to the first usable data block in the table segment.

E. No undo or very little undo data is generated during the execution of the TRUNCATE command.

View Answer

Q9. Your database instance is functional for the past one month. The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of the previous day. Choose two actions any of which can be referred to first to diagnose the problem. (Choose two.)

A. Use the Active Session History report.

B. Use the AWR Compare Periods report.

C. Use an ADDM analysis between 7 PM and 9 PM of the previous day.

D. Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.

View Answer

Q10. You executed the following commands to find the location of the alert log file:

Where is the alert log file stored? (Choose all that apply.)

A. in the BACKGROUND_DUMP_DEST location; in text format

B. in the BACKGROUND_DUMP_DEST location; in XML format

C. in the BACKGROUND_DUMP_DEST location; in both text and XML format 

D. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in text format 

E. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in XML format

F. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in both text and XML format

View Answer