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 […]
Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
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.
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 […]
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?
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.)
Observe the following PL/SQL block:BEGINdbms_spm.configure(‘SPACE_BUDGET_PERCENT’, 30);END;Which statement is correct regarding the above PL/SQL block?
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.)
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? […]
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 […]