Online Access Free 1Z1-050 Practice Test

You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.)

• A.The KEEP option is an attribute of an individual backup piece.
• B.The backup contains data files, the server parameter file, and the control file even if the control file autobackup is disabled.
• C.The KEEP option overrides the configured retention policy.
• D.The backup contains only data files and archived redo log files.

Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)

• A.You can package and upload diagnostic data to Oracle Support.
• B.You can manually run health checks to gather diagnostic data for a problem.
• C.You can track the Service Request (SR) and implement repairs.
• D.Generate reports on data failure such as data file failures,

What are the recommendations for Oracle Database 11 g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)

• A.Flash recovery area and data file location should be created under Oracle base in a
  non-Automatic Storage Management (ASM) setup.
• B.An Oracle base should have only one Oracle home created in it.
• C.ORACLE_BASE should be set explicitly.
• D.Flash recovery area and data file location should be on separate disks.

The following databases are registered in the base recovery catalog: PROD1 , PROD2, and PROD3. The database user CAT OWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog.
Given below are some of the commands required to achieve this:
1 .SQL> GRANT recovery_catalog_owner TO vpc1;
2.RMAN> CONNECT CATALOG vpc1/password@catdb;
3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1;
4.RMAN> CONNECT CATALOG catowner/password@catdb;
5.RMAN> CREATE VIRTUAL CATALOG;
What is the correct sequence in which the commands have to be executed?

• A.1,4,5,2,3
• B.2,3,4,5, 1
• C.4,5,2,3, 1
• D.1,4,2,3,5
• E.1,4,3,2,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 disk automatically goes offline.
• D.The ASM tracks the extents that are modified during the outage.