Want to know Examcollection 1z0-050 Exam practice test features? Want to lear more about Oracle Oracle Database 11g: New Features for Administrators certification experience? Study Tested Oracle 1z0-050 answers to Leading 1z0-050 questions at Examcollection. Gat a success with an absolute guarantee to pass Oracle 1z0-050 (Oracle Database 11g: New Features for Administrators) test on your first attempt.
♥♥ 2017 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-050 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q101. You enabled Flashback Data Archive on the INVENTORY table.
Which DDL operation is supported on the table after enabling Flashback Data Archive?
A. Drop the table.
B. Partition the table
C. Truncate the table.
D. Add a column to the table.
E. Rename a column in the table.
Q102. You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.
What configuration would you effect to achieve your objective? (Choose all that apply.)
A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.
Q103. Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)?
A. The incident metadata is purged when the problem is resolved and the DBA closes the SR.
B. The incident files and dumps are not retained in the ADR for the manually created incidents.
C. The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR
D. The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month.
Q104. 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?
A. The scripts in the RCO11 catalog are overwritten.
B. RMAN renames the local stored scripts in the RCO11 catalog.
C. The RMAN session in which the command is executed aborts.
D. RMAN renames the global scripts that are imported from the RCAT10 catalog.
Q105. Which three statements are true about the stages of database startup? (Choose three.)
A. Data files and redo log files can be renamed at the MOUNT stage.
B. Control files are required to bring the database to the NOMOUNT stage.
C. Data files and online redo log files are checked for consistency while opening the database.
D. Data files and redo log files are made available to users at the OPEN stage.
E. Control files are read at the OPEN stage for the location of data files.
Q106. Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
A. The database files are corrupted when the database is open.
B. The archived log files are missing for which backup is not available.
C. The user has dropped an important table that needs to be recovered.
D. You are not able to start up the database instance because the required database files are missing.
Q107. The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations.
The details are given below:
LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive'
LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1'
DB_RECOVERY_FILE_DEST = '/u01/oradata'
Examine the following RMAN command issued to set the deletion policy for archived log files:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY
TO BACKED UP 2 TIMES TO sbt;
Which statement is true regarding what this command accomplishes?
A. All archived redo log files backed up at least twice to tape are deleted.
B. All archived redo log files backed up at least once to tape are eligible for deletion.
C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.
D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.
Q108. Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)
A. It can be used to allow the access privilege settings for users but not roles.
B. It can be used to allow the access privilege settings for users as well as roles.
C. It can be used to control the time interval for which the access privilege is available to a user.
D. It can be used to selectively restrict the access for each user in a database to different host computers.
E. It can be used to selectively restrict a user's access to different applications in a specific host computer.
Q109. You installed Oracle Database 11g afresh.
Which statements are true regarding the default audit settings in this database? (Choose all that apply.)
A. Auditing is enabled for all privileges.
B. Auditing is disabled for all privileges.
C. The audit trail is stored in the database.
D. The audit trail is stored in an operating system file.
E. Auditing is enabled for certain privileges related to database security.
Q110. You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group? (Choose all that apply.)
A. Extent management is completely automated.
B. The allocation unit size may vary but the extent size is fixed.
C. The au_size disk group attribute determines the size of allocation units in the disk group.
D. The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.