Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

A. An ASM instance mounts an ASM control file

B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly

D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

You issued the following command:

CREATE GLOBAL TEMPORARY TABLE admin_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT DELETE ROWS TABLESPACE tbs_t1;

An index is then created on the ADMIN_WORK_AREA temporary table.

Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.)

A. It stores only the temporary table but not its indexes.

B. It stores both the temporary table as well as its indexes.

C. It must be a nondefault temporary tablespace for the database.

D. It can be a default or nondefault temporary tablespace for the database.

E. It must be the default temporary tablespace of the user who issues the command.

Which three elements can a job chain process involve? (Choose three)

A. an event

B. a schedule

C. a program

D. another chain

E. a lightweight job

You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;

Which requirement must be fulfilled for this command to succeed?

A. The tablespace must be locally managed.

B. The tablespace must have only one temp file.

C. The tablespace must be made nondefault and offline.

D. The tablespace can remain as the default but must have no active sort operations.

When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?

A. Filter versions

B. Filter loads

C. Filter tasks

D. Filter options

View the Exhibit to examine the replay settings for replay parameters.

What is the implication for setting the values for replay parameters? (Choose all that apply.)

Exhibit:

A. The COMMIT order in the captured workload is preserved during replay.

B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.

C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.

D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.

E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.

You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:

SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file 'C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE \INITORCL.ORA'

Using RMAN, how would you respond to this error?

A. Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.

B. Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.

C. Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.

D. Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.

E. Issue the restore spfile from autobackup command from the RMAN prompt.

Upon starting your database, you receive the following error:

SQL> startup ORACLE instance started. Total System Global Area 171581440 bytes Fixed Size 1298640 bytes Variable Size 146804528 bytes Database Buffers 20971520 bytes Redo Buffers 2506752 bytes Database mounted.

ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/oracle01/oradata/orcl/redo01.log' ORA-00312: online log 1 thread 1: '/oracle01/oradata/orcl/redo01a.log'

You can choose from the following steps: a: Restore the database datafiles.

b: Issue the alter database clear unarchived logfile group 1 command.

c: Issue the alter database open command.

d: Issue the alter database open resetlogs command.

e: Recover the database using point-in-time recovery.

f: Issue the Startup Mount command to mount the database.

g: Back up the database.

Which is the correct order of these steps in this case?

A. a, f, e, d, g

B. f, e, d

C. f, b, c, g

D. a, f, c

E. The database cannot be recovered.

You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?

a.

Shut down the database.

b.

Restore a control-file copy from backup media.

c.

Use the create control file command to create a new control file.

d.

Copy the backup control file into place.

e.

Create a new copy of the control file from one of the surviving control files.

f.

Recover the database using the recover database using BACKUP CONTROLFILE command.

g.

Start up the database.

A.

a, b, f, g

B.

c, f, g

C.

a, d, f, g

D.

a, f, g

E.

a, e, g

Why would you run the delete obsolete command? (Choose all that apply.)

A. To remove missing backup set pieces physically from disk

B. To remove metadata related to backup set pieces in the control file and the recovery catalog

C. To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets

D. To delete backup set pieces associated with backups that are no longer needed due to retention criteria

E. To remove old versions of RMAN backups