Oracle Database 11g: New Features for 9i OCPs (1Z0-055) Free Practice Test

Question 1

The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?

A. restructuring of SQL recommendations

B. statistics recommendations

C. index-related recommendations

D. SQL profile recommendations

Correct Answer: D

Question 2

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

A. It cannot be stored persistently in the data dictionary.

B. It is built by Automatic Tuning Optimizer.

C. It can be used by the query optimizer automatically.

D. It can be created manually by using the CREATE PROFILE command.

Correct Answer: B,C

Question 3

You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tape drives of only 10 GB each. Which method would accomplish the task quickly and efficiently?

A. parallel image copy backup

B. parallel backup with MAXPIECESIZE configured for the channel

C. backup with MAXPIECESIZE configured for the channel

D. intrafile parallel backup

Correct Answer: D

Question 4

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:
LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive'
LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1'
DB_RECOVERY_FILE_DEST = '/u01/oradata'
Examine the following RMAN command issued to set the deletion policy for archived log files:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY
TO BACKED UP 2 TIMES TO sbt;
Which statement is true regarding what this command accomplishes?

A. All archived redo log files backed up at least twice to tape are deleted.

B. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.

C. All archived redo log files backed up at least once to tape are eligible for deletion.

D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

Correct Answer: D

Question 5

You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario? (Choose all that apply.)

A. The ASM migrates the extents from the unavailable disk to the remaining disks.

B. The disk is immediately dropped from the disk group.

C. The ASM tracks the extents that are modified during the outage.

D. The disk automatically goes offline.

Correct Answer: C,D

Question 6

Evaluate the following command:
SQL> CREATE TABLE design_data (id NUMBER, doc CLOB)
LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);
Which statement is true regarding the above command?

A. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

B. The LOB values are automatically compressed.

C. The LOB values are cached by default in the buffer cache.

D. The LOB values are automatically stored in encrypted mode.

Correct Answer: A

Question 7

You issued the following command to mount the DATA disk group in restricted mode:
ALTER DISKGROUP data MOUNT RESTRICT;
What is the implication of this command?

A. A new disk cannot be added to a disk group.

B. The client RDBMS instance cannot access the files in the disk group.

C. A disk in a disk group can be taken offline.

D. The client RDBMS instance can access the file as a read-only file.

Correct Answer: B

Question 8

You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?

A. The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.

B. The EMPLOYEES table will be changed to read-only mode during the shrink operation.

C. Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

D. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.

Correct Answer: D

Question 9

Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)

A. It generates recommendations to run SQL Tuning Advisor to tune regressed SQL statements.

B. It produces results that can be used to create the SQL plan baseline.

C. The importance of SQL statements is based on the size of the objects accessed.

D. It shows only the overall impact on workload and not the net SQL impact on workload.

E. It detects changes in SQL execution plans.

Correct Answer: A,B,E

Question 10

Which three statements correctly describe the features of the I/O calibration process? (Choose three.)

A. It can be used to estimate the maximum number of I/Os and maximum latency time for the system.

B. It automates the resource allocation for the Automated Maintenance Tasks.

C. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRU

D. It improves the performance of the performance-critical sessions while running.

E. Only one I/O calibration process can run at a time.

Correct Answer: A,C,E

Question 11

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 must be the default temporary tablespace of the user who issues the command.

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

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

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

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

Correct Answer: B,C

Welcome to TestSimulate

Oracle Database 11g: New Features for 9i OCPs (1Z0-055) Free Practice Test