Online Access Free 11gocmu Practice Test

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).
Which two are the prerequisites to perform this operation? (Choose two)

• A.You must ensure that the SALES database is mounted or open
• B.You must configure block change tracking file
• C.You must have full or level 0 backups for RMAN to restore blocks
• D.You must take the tools01.dbf data file offline before you start a block media recovery
• E.You must have first level 1 backups for RMAN to restore blocks

Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)

• A.Optimizer statistics gathering
• B.Automatic Database Diagnostics Monitor
• C.Automatic SQL Tuning Advisor
• D.SQL Access Advisor
• E.Segment Advisor

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 users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.
• 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.
• C.It is a list of remote database links stored in the XML file that are available to the users of the database.
• D.It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

What elements of globalization can be explicitly defined using the NLS_LANG environment variable? (Choose all that apply.)

• A.NLS_CHARACTERSET
• B.NLS_CALENDAR
• C.NLS_SORT
• D.NLS_LANGUAGE
• E.NLS_TERRITORY

As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query? (Choose two.)
SQL> select group_number, name, state from v$ASM_DISKGROUP;
GROUP_NUMBER NAME STATE
0 DGROUP1 DISMOUNTED
2 DGROUP2 MOUNTED
3 DGROUP3 MOUNTED

• A.This query has no meaning in an ASM instance.
• B.One of the redundant disks (DGROUP1) has been lost in a disk group.
• C.The DGROUP1 disk group was unmounted by another DB
• D.A datafile has been lost, causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
• E.A disk associated with a disk group was discovered after the ASM instance initially opened.