Want to know Ucertify 1Z0-053 Exam practice test features? Want to lear more about Oracle Oracle Database 11g: Administration II certification experience? Study 100% Guarantee Oracle 1Z0-053 answers to Renovate 1Z0-053 questions at Ucertify. Gat a success with an absolute guarantee to pass Oracle 1Z0-053 (Oracle Database 11g: Administration II) test on your first attempt.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-053 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q81. Which two statements are true regarding the SQL Repair Advisor? (Choose two.)
A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
Q82. What is the purpose of the RMAN recovery catalog? (Choose all that apply.)
A. It must be used because all RMAN-related backup and recovery metadata information is contained in it.
B. It provides a convenient, optional, repository of backup- and recovery-related metadata.
C. It provides the ability to store RMAN scripts for global use by any database that has access to the repository.
D. It provides a means of storing all RMAN backup sets physically in an Oracle database server.
E. It provides the ability to store backup records for more than a year.
Q83. On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)
A. fixed tables
B. heap tables
C. external tables
D. temporary tables
E. Index-Organized Tables (IOTs)
Q84. Within a resource-plan definition, what differentiates a top-level plan from a subplan?
A. A subplan has the PLAN_SUB parameter value set to SUB.
B. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definition.
C. There is no difference in the resource-plan definition.
D. A subplan always has the CPU_MTH parameter value set to RATIO.
E. The string TOP_LEVEL is appended to the name of top-level resource plans.
Q85. What is the purpose of the recover command? (Choose all that apply.)
A. Recover database datafiles from physical disk backup sets.
B. Recover required incremental backups from physical disk backup sets.
C. Recover required archived redo logs from physical disk backup sets.
D. Apply incremental backups to recover the database.
E. Apply archived redo logs to recover the database.
Q86. You perform a backup using the following BACKUP command:
RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;
Which statement is true of this command?
A. A different procedure is required to restore a database from compressed backups
B. The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
C. Using this command to create backups minimizes the bandwidth consumed
D. Using this command to create backups improves the performance of the backup process
Q87. You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?
A. parallel image copy backup
B. backup with MAXPIECESIZE configured for the channel
C. parallel backup with MAXPIECESIZE configured for the channe
D. intrafile parallel backup
Q88. Given the following steps, which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file autobackups enabled?
a. backup archivelog all;
b. backup database all;
c. backup controlfile;
d. backup archivelog, database, controlfile delete input;
e. backup database plus archivelog delete input
B. a, b, a, c
D. b, a, c
E. b, a, c, d, e
Q89. Which are the correct steps, in order, to deal with the loss of an online redo log if the database has not yet crashed?
a. Issue a checkpoint.
b. Shut down the database.
c. Issue an alter database open command to open the database.
d. Startup mount the database.
e. Issue an alter database clear logfile command.
f. Recover all database datafiles.
A. a, b, c, d
B. b, d, e, c
C. a, b, d, e, c
D. b, f, d, f, c
E. b, d, a, c
Q90. The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA, based on the amount of memory available on the system?
A. 20% SGA, 80% PGA
B. 25% SGA, 75% PGA
C. 50% SGA, 50% PGA
D. 75% SGA, 25% PGA
E. 80% SGA, 20% PGA