1Z0-053-ocp11

1Z0-053 Oracle Database 11g: Administration II

Exam A

QUESTION 1

While deploying a new application module, the software vendor ships the application software along with

appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the

consequences? (Choose two.)

A. The plan baselines can be evolved over time to produce better performance.

B. The newly generated plans are directly placed into the SQL plan baseline without being verified.

C. The new SQL statements initially run with the plans that are known to produce good performance under

because you want to use the adaptive threshold. Which statement factors in this consideration while

increasing the size of the moving window?

A. The collection level for the AWR should be set to BASIC.

B. The moving window size must be less than Undo Retention.

C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention

period.

D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR)

retention period.

Answer: D

QUESTION 3

A. ALTER DATABASE DROP LOGFILE GROUP 1;

B. ALTER DATABASE CLEAR LOGFILE GROUP 1;

C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

D. ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';

Answer: C

Explanation/Reference:

"First Test, First Pass" - www.lead2pass.com 155

Oracle 1Z0-053 Exam

QUESTION 4

Which three components does the Scheduler use for managing tasks within the Oracle environment?

QUESTION 5

Examine the section of the Health Check report given below:

DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')

Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode :

REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time :

2007-05-12 22:11:20.835135 -07:00 Error Encountered : 0

Source Incident Id : 7418

Number of Incidents Created :0

Which two statements are true regarding the Health Check report? (Choose two.)

A. Health Check was performed manually.

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema

owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema

owned by the user RCAT10.

You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10,

into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import.

You executed the following commands to achieve this:

RMAN> CONNECT CATALOG rco11/password@catdb

RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;

What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10

catalog?

Answer: D

QUESTION 7

You need to configure fine-grained access control to external network resources from within your database.

You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.

Which statement is true regarding the ACL created?

A. It is a list of remote database links stored in the XML file that are available to the users of the database.

B. It is a list of users and network privileges stored in the XML file according to which a group of users can

connect to one or more hosts.

users can connect to one or more hosts.

D. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your

Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile

LOBs?

D. Local and global indexes are maintained automatically during the operation.

Answer: B

QUESTION 9

Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for

LOB space usage?

A. It returns space usage of only BasicFile LOB chunks.

B. It returns space usage of only SecureFile LOB chunks.

C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.

D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.

Answer: B

On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement

is true regarding the backup of the TOOLS tablespace?

"First Test, First Pass" - www.lead2pass.com 157

Oracle 1Z0-053 Exam

A. The RMAN backup fails because the TOOLS tablespace is read-only

B. The RMAN skips the backup of the tablespace because backup optimization is enabled

C. The RMAN makes backup because optimization can be enabled only for backups to disk

D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

Answer: D

QUESTION 11

C. Oracle determines when an adaptive threshold has been breached based on the maximum value

captured by the baseline.

D. The total concurrent number of threshold violations, which must occur before an alert is raised for the

metric, has been set to zero.

Answer: A

QUESTION 12

You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER

option.

After some days, you want to change the status of the database backup and you issued the following

command:

RMAN>CHANGE BACKUPSET 231 NOKEEP;

QUESTION 13

View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is the

"First Test, First Pass" - www.lead2pass.com 158

Oracle 1Z0-053 Exam

Significance Level threshold type not available in the threshold setting?