Question 6 of 37

Which three are true about auditing? (Choose three.)

    Correct Answer: A, B, F

    DDL statements can be audited when they fail to execute, which means auditing can track unsuccessful attempts at making changes to the database schema. Audit of the use of system privileges can be enabled for individual database users, allowing for targeted monitoring of privileged operations within the database. DML statements can be audited when they execute successfully, ensuring that operations modifying data are properly tracked.

Question 7 of 37

Which two are true about AWR snapshots? (Choose two.)

    Correct Answer: D, E

    AWR snapshots are stored in the SYSAUX tablespace, ensuring that the captured performance data is organized in a specific area of the database. They can also be retained indefinitely by adjusting the retention settings through the MODIFY_SNAPSHOT_SETTINGS Procedure. Setting the retention to 0 allows snapshots to be kept forever.

Question 8 of 37

Examine these facts about a database:

1. The database default tablespace is USERS

2. DEFERRED_SEGMENT_CREATION IS TRUE

3. The default tablespace of USER1 is tbs1

4. USER1 has only these privileges:

✑ CREATE SESSION

✑ CREATE TABLE

✑ UNLIMITED quota on tbs1

Examine these commands executed by USER1:

What will be the outcome of the INSERT operation and why?

    Correct Answer: D

    The insert operation will successfully add a row into the EMP table but will not create an index entry in the EMP_IDX index because the column eno in the inserted row contains a NULL value. In most databases, NULL values are not indexed by default; therefore, an index entry will not be created when inserting a NULL value in the indexed column.

Question 9 of 37

Examine these commands and their output:

A power failure occurs. The instance is restarted and this query is executed.

SQL> SELECT ename FROM emp;

What is the outcome?

    Correct Answer: E

    The initial state of the table includes only Adam and Alan. After inserting Ben with ENO 102, a commit is performed, ensuring Ben's addition is saved even if a power failure occurs. The subsequent update to change Ben's name to Bryan did not get committed before the power failed. Therefore, the final query will display Adam, Alan, and Ben, but not Bryan.

Question 10 of 37

Which are three of the various resources that must be accessible to keep a database open? (Choose three.)

    Correct Answer: A, B, E

    To keep a database open, the SYSTEM tablespace, spfile, and control file are required resources. The SYSTEM tablespace is essential for storing the core data dictionary information, the spfile is needed for database configuration, and the control file records the physical structure of the database, which includes the locations of datafiles and redo log files. While SYSAUX is important, it is not strictly necessary to keep the database open. Similarly, although the redo log files are important for transaction recovery, not all members of a redo log group are required to keep the database open.