Q1. You want to configure and schedule offline database backups to run automatically.

Which tool or utility would you use to achieve this?

A. The XML script

B. The PL/SQL script

C. The DBMS_SCHEDULER package

D. Enterprise Manager to schedule the backup

View Answer

Q2. You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:

Warning (%): 90

Critical (%): 95

Which background process is responsible for issuing alerts when the threshold is crossed?

A. System monitor (SMON)

B. Process monitor (PMON)

C. Memory manager process (MMAN)

D. Manageability Monitor process (MMON)

View Answer

Q3. Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.

What would you do to recover the data file?

A. Take the USERS tablespace offline and re-create the lost data file

B. Shutdown the instance, restore the data file from the last consistent backup and restart the database instance

C. Shutdown the instance, restores all the database files from the last consistent backup and restart the database instance

D. Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the last consistent backup and make the tablespace online

View Answer

Q4. In your production database, data manipulation language (DML) operations are executed on the SALES table.

You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.

What action would you take to achieve this task?

A. Apply fine-grained auditing.

B. Implement value-based auditing.

C. Impose standard database auditing to audit object privileges.

D. Impose standard database auditing to audit SQL statements.

View Answer

Q5. Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?

A. An update in a leaf row takes place.

B. The index becomes invalid after the update.

C. The leaf block containing the row to be updated is marked as invalid.

D. A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted.

View Answer

Q6. Observe the information in the columns:

Which option has the correct match between the memory areas and their contents?

A. 1-c, 2-b, 3-d, 4-a

B. 1-b, 2-c, 3-d, 4-a

C. 1-a, 2-b, 3-c, 4-d

D. 1-a, 2-b, 3-d, 4-c

View Answer

Q7. Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOP

What happens to the sessions that are presently connected to the database instance?

A. The sessions are able to perform only queries

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

C. The sessions are terminated and the active transactions are rolled back

D. The sessions are not allowed to perform any operations till the listener is started

View Answer

Q8. You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file.

View the Exhibit and check the commands executed.

What is the location of the alert_orcl.log file?

A. ORACLE_HOME/dbs

B. ORACEL_HOME/rdbms

C. /u01/app/oracle/admin/orcl/adump

D. /u01/app/oracle/flash_recovery_area

E. ORACLE_BASE/diag/rdbms/orcl/alert

F. ORACLE_BASE/diag/rdbms/orcl/orcl/trace

View Answer

Q9. View the Exhibit and examine the PL/SQL package and procedure. You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body. Which statement is true after you recompile the EMP_ADMIN package body?

Exhibit:

A. The USE_P procedure remains valid.

B. The USE_P procedure becomes invalid.

C. The SHOW_DETAIL procedure becomes invalid.

D. The EMP_ADMIN package specification becomes invalid and needs to be recompiled.

View Answer

Q10. The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.

Which statement is true in this scenario?

A. The statistics collection continues until all objects are processed.

B. The job is terminated and the statistics collected are restored to a time before the job started.

C. This produces an error and the statistics collected are locked until the next time that the maintenance window is opened.

D. The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened.

View Answer