View the Exhibit to observe the error.

You receive this error regularly and have to shutdown the database instance to overcome the error. AutomaticShared Memory Management is configured for the instance.

What can you do to reduce the chance of this error in the future?

A. Increase the value of SGA_MAX_SIZE

B. Enable automatic memory management

C. Set the PRE_PAGE_SGA parameter to true

D. Lock the System Global Area (SGA) in memory

You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN):

RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

Identify the statement that correctly describes the implications of this command.

A. when there are already three backups, for the fourth backup RMAN removes the oldest backup.

B. When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete.

C. the number of backups that are retained is equal to three and it includes full, incremental, and cumulativebackups.

D. when there are already three backup, one of the existing backups must be removed manually before takingthe fourth backup.

For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?

A. fixed tables

B. heap tables

C. external tables

D. temporary tables

E. Index-Organized Tables (IOTs)

F. views

While exporting data with Data Pump, you find that the export takes longer than expected. You decide to stop the job and restart it during off-peak hours.

Which view would you query to determine the name and status of the stopped job?

A. DBA_JOBS

B. V$SESSION

C. V$SESSION_LONGOPS

D. DBA_DATAPUMP_JOBS

E. DBA_DATAPUMP_SESSIONS

Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables.

1.

CREATE TABLE employee_ext

2.

(employee_id, first_name, department_name)

3.

ORGANIZATION EXTERNAL

4.

(

5.

TYPE ORACLE_LOADER

6.

DEFAULT DIRECTORY ext_dir

7.

LOCATION ('emp1.dmp')

8.

)

9.

PARALLEL

10.

AS

11.

SELECT e.emplyee_id, e.first_name, e.last_name, d.department_name

12.

FROM employees e, departments d; Which line of the command would cause an error?

A. line 2, because the column names have been specified

B. line 7, because file name must have a .dat extension

C. line 3, because ORGANIZATION EXTERNAL has been specified

D. line 9, because the PARALLEL option cannot be specified with one file name

E. line 12, because there is no join defined between EMPLOYEES and DEPARTMENTS table

F. line 5, because ORACLE_LOADER is not a valid structure for external table creation with the SELECT statement

Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS.

Which two actions will permit the TSPITR to work? (Choose two.)

A. Taking the MASTERTBS tablespace offline

B. Dropping the relationship between the tables

C. Adding the MASTERTBS tablespace to the recovery set

D. Putting the MASTERTBS tablespace in read-only mode

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario?

A. You must shut down the database instance to perform the backups.

B. You must configure the flash recovery area (fast recovery area) for the database.

C. You can perform complete database backups without closing the database.

D. All the previous closed database backups including control files become invalid after you configure the database to ARCHIVELOG mode.

Identify two correct statements about the Active Session History (ASH) data.

A. A part of SGA memory is used to store ASH data as rolling buffer.

B. The ASH data can be analyzed between any two small time intervals.

C. All ASH data in memory are flushed to disk by MMON in every 3 seconds.

D. All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.

Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)

A. It is a copy or a subset of the target database.

B. It is opened in RESTRICT mode after a duplicating operation.

C. It is created by using backups and archived redo log files from the target database.

D. It is created with the same database identifier (DBID) as that of target database.

You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)

A. Its entries are specific to a single database.

B. It contains file systems that have been mounted by Direct NFS.

C. It is globally available to all Oracle 11g databases on the machine.

D. It contains file systems that have been mounted by the kernel NFS system.