1Z0-053 | how many questions of 1Z0-053 vce?
Q101. When you're performing active database duplication, a backup of what kind is required?
A. A current RMAN backup-set backup is required.
B. No backup is required.
C. An RMAN image backup is required.
D. A manual backup is required.
E. A "duplicate" preparatory backup is required.
Answer: B
Q102. Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?
A. Oracle will automatically take the datafile out of hot backup mode, generate a warning message, and then open the database.
B. Oracle will automatically take the datafile out of hot backup mode and then open the database.
C. Oracle will generate an error when trying to open the database, indicating that a datafile is in hot backup mode. You will need to correct this error before you can open the database.
D. The database will open with the file in hot backup mode. You can restart the backup at any time.
E. The datafile in hot backup mode will be corrupted and you will have to recover it.
Answer: C
Q103. Which of these components correctly identify the unique value of the NAME column in the DBA_RESUMABLE view?
A. Username, instance number, session ID
B. Instance number, username, session ID
C. Instance number, session ID, username
D. Username, session ID, instance number
E. None of the above
Answer: D
Q104. Which three statements are true regarding persistent lightweight jobs? (Choose three.)
A. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.
B. The user cannot set privileges on persistent lightweight jobs.
C. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.
D. Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.
E. The use of a template is mandatory to create persistent lightweight jobs.
Answer: BCE
Q105. Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)
A. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
B. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.
C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
D. Health Monitor checks are always initiated manually when there is some critical error.
Answer: AB
Q106. To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?
A. EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor
B. EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor
C. EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor
D. Either B or C
E. All of the above
Answer: D
Q107. Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
A. The user has dropped an important table that needs to be recovered.
B. The database files are corrupted when the database is open.
C. You are not able to start up the database instance because the required database files are missing.
D. The archived log files are missing for which backup is not available.
Answer: BC
Q108. You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?
A. run {
open script backup_database;
run script backup_database
}
B. run {
engage script backup_database;
}
C. run {
run script backup_database;
}
D. Run {
execute script backup_database;
}
E. The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.
Answer: D
Q109. Which three are the valid statements in relation to SQL plan baselines? (Choose three.)
A. The plans can be manually loaded to the SQL plan baseline.
B. The plans in the SQL plan baseline are verified and accepted plans.
C. The plans generated for every SQL statement are stored in the SQL plan baseline by default.
D. The plan baselines are stored temporarily in the memory as long as the database instance is running.
E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
Answer: ABE
Q110. You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.
Which two statements are true in this scenario for the features enabled for ASM? (Choose two.)
A. The ASM-preferred mirror read feature is enabled.
B. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.
C. The ASM disk is dropped immediately from a disk group when it becomes unavailable.
D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
Answer: AB