11gocmu by Oracle Valid Free Exam Practice Test

Question 1

Which of the following are not fundamental tasks of the Support Workbench? (Choose all that apply.)

A. Create a Service Request B. View problem details C. View long-running SQL workloads D. Clean up incident data after upload to Oracle Support E. Gather additional diagnostic information

Correct Answer: C,D

Question 2

What components are present in an ASM instance? (Choose three.)

A. Database parameter file or spfile B. Database datafiles C. SGA D. Database processes E. Control files

Correct Answer: A,C,D

Question 3

You want the Automatic SQL Tuning process to stop accepting and implementing the recommended SQL profiles automatically. Which action would you perform to achieve this?

A. Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance. B. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE. C. Edit the automatic maintenance window group configuration. D. Set the CURSOR_SHARING parameter to EXACT for the database instance.

Correct Answer: B

Question 4

You are managing an ASM instance. You previously issued the following statements:
ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5;
You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue?

A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5; B. You cannot cancel the pending disk drops. C. ALTER DISKGROUP dg1 UNDROP DISKS; D. ALTER DISKGROUP dg1 UNDROP;

Correct Answer: C

Question 5

When running the tablespace point-in-time command
recover tablespace users
until time '10/06/2008:22:42:00'
auxiliary destination 'c:\oracle\auxiliary';
you receive the following error:
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
===========================================================
RMAN-03002: failure of recover command at 10/08/2008 16:00:30
RMAN-20202: Tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "USERS"
What is the likely cause of the error?

A. The database is in ARCHIVELOG mode. B. The USERS tablespace is not eligible for TSPITR because it has invalid objects. C. The recover tablespace command is incorrect and generates the error. D. The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone. E. There is not a current backup of the database available.

Correct Answer: E

Question 6

Which two statements regarding a SQL profile are true? (Choose two.)

A. It cannot be stored persistently in the data dictionary. B. It can be created manually by using the CREATE PROFILE command. C. It can be used by the query optimizer automatically. D. It is built by Automatic Tuning Optimizer.

Correct Answer: C,D

Question 7

You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?
a.restore controlfile until time '09/30/2008:18:00:00';
b.restore database until time '09/30/2008:18:00:00';
c.restore spfile until time '09/30/2008:18:00:00';;
d.recover database until time '09/30/2008:18:00:00';
e.alter database open resetlogs;
f.alter database open;

A. c, a, b, d, e B. c, a, b, d, f C. a, b, d, e D. b, d, e E. b, d, f

Correct Answer: D

Question 8

While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block?

A. RECOVER CORRUPTION LIST; B. None of the above C. RECOVER BLOCK CORRUPTION LIST; D. RECOVER DATAFILE 1201 BLOCK 1968; E. RECOVER FILE=1201 BLOCK=1968;

Correct Answer: A,D

Question 9

Every resource plan must contain an allocation to which consumer group?

A. OTHER_GROUPS B. BASE_GROUP C. SYS_GROUP D. DEFAULT_GROUP E. LOW_GROUP

Correct Answer: A

Question 10

Which dynamic view displays the status of block-change tracking?

A. V$BLOCK_CHANGE B. V$BLOCK_TRACKING C. V$BLOCK_CHANGE_TRACKING D. V$BLOCKCHANGE

Correct Answer: C

Question 11

You have three temporary tablespace groups named G1, G2, and G3 in your database.
You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M
TABLESPACE GROUP '';
Which statement regarding the above command is correct?

A. It will create the tablespace TEMP1 in the default group. B. It will create the tablespace TEMP1 in group G3. C. It will create the tablespace TEMP1 in group G1. D. It will not add the tablespace TEMP1 to any group.

Correct Answer: D

Question 12

Which of the following best describes a full backup?

A. All datafiles of a database B. All datafiles and control files C. All the used blocks in a datafile D. All datafiles, archive logs, and control files

Correct Answer: C

Question 13

True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.

A. False B. True

Correct Answer: A

Oracle Database 11g Certified Master Upgrade - 11gocmu Exam Practice Test