Exam information

Exam 1Z0-053: Oracle Database 11g: Administration II (May 18th, 2013)

Other exams

What is the outcome of the above code?

Evaluate the following block of code: BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( acl => ‘mycompany-com-permissions.xml’, principal => ‘ACCT_MGR’, is_grant => TRUE, privilege => ‘connect’); DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL ( acl => ‘mycompany-com-permissions.xml’, host […]

(Choose two.)

Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)


Which steps are mandatory to enable Direct NFS?

Which steps are mandatory to enable Direct NFS? 1. Mount all required file systems using the kernel NFS driver. 2. Create an oranfstab file containing the attributes for each NFS server to be accessed usingDirect NFS. 3. Replace the ODM library libodm11.so_stub with libodm11.so.

What is the location of the Automatic Diagnostic Repository (ADR) home?

Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdumpUSER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udumpCORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdumpDIAGNOSTIC_DEST=The […]

Which type of backup should you perform?

You want to back up your 100-GB database on a remote tape device. You are required to ensurethat minimum network bandwidth is consumed while transferring the backups to the tape device.The current consumption of your CPU is approximately 40 percent.Which type of backup should you perform?

Which (two tasks are performed by these commands?

You execute the following Recovery Manager (RMAN) commands in (he following order:BACKUP VALIDATE DATABAERECOVER CORRUPTION LIST;Which (two tasks are performed by these commands? (Choose two.)

Which statement is correct regarding the above PL/SQL block?

Observe the following PL/SQL block:BEGINdbms_spm.configure(‘SPACE_BUDGET_PERCENT’, 30);END;Which statement is correct regarding the above PL/SQL block?

Which two statements describe the implications of this?

When executing a SQL workload, you choose to generate execution plans only, without collectingexecution statistics. Which two statements describe the implications of this? (Choose two.)

Which statements will be true in this scenario?

You are managing an Oracle Database 11g ASM instance having three disks in a disk group withASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the diskgroup becomes unavailable because of power failure. Which statements will be true in thisscenario? […]

What configuration would you effect to achieve your objective?

You are managing an Oracle Database 11g database with the ASM storage. The database ishaving big file tablespaces. You want files to open faster and less memory to be used in theshared pool to manage the extent maps. What configuration would you effect to achieve yourobjective? (Choose all […]

Page 1 of 6812345...102030...Last »