1Z0-053 | The Secret of Oracle 1Z0-053 braindumps
Q11. To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)
A. LOG_HISTORY
B. JOB_LOG_RETENTION
C. WINDOW_LOG_RETENTION
D. WHICH_LOG
E. LOG_NAME
Answer: AD
Q12. To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?
A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.
B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.
C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.
D. Either B or C.
Answer: A
Q13. To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:
BEGIN
dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,'TASK1');
END;
/
BEGIN
dbms_advisor.set_task_parameter('TASK1','ANALYSIS_SCOPE','ALL');
dbms_advisor.set_task_parameter('TASK1','MODE','COMPREHENSIVE');
END;
/
BEGIN
dbms_advisor.execute_task('TASK1');
dbms_output.put_line(dbms_advisor.get_task_script('TASK1'));
END;
/
The blocks of code execute successfully; however, you do not get the required outcome.
What could be the reason?
A. A template needs to be associated with the task.
B. A workload needs to be associated with the task.
C. The partial or complete workload scope needs to be associated with the task.
D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.
Answer: B
Q14. Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.
The steps to recover the damaged data files are follows:
1. Mount the database
2. Open the database
3. Recover the data file
4. Restore the data file
5. Make the data file offline
6. Make the data file online
Which option identifies the correct sequence that you must use to recover the data files?
A. 2, 4, 3
B. 1, 4, 3, 2
C. 2, 5, 4, 3, 6
D. 5, 2, 4, 3, 6
E. 1, 5, 4, 3, 6, 2
Answer: E
Q15. What is the purpose of the catalog command?
A. To review RMAN control file and recovery catalog metadata and ensure that it's correct
B. To delete RMAN backup-related metadata from the recovery catalog
C. To create metadata in the control file and the recovery catalog related to backup set pieces
D. To create a report that lists database backups
E. To rebuild the recovery catalog
Answer: C
Q16. Observe the following PL/SQL block:
BEGIN
dbms_spm.configure('SPACE_BUDGET_PERCENT', 30);
END;
Which statement is correct regarding the above PL/SQL block?
A. It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace.
B. It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB).
C. It reserves 30% of the space in the SYSTEM tablespace for SMB.
D. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace.
Answer: D
Q17. View the Exhibit to observe the error.
You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the chance of this error in future, when implemented?
A. setting the PRE_PAGE_SGA parameter to TRUE
B. locking the SGA in memory
C. increasing the value of SGA_MAX_SIZE
D. automatic memory management
Answer: D
Q18. You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.
You executed the following RMAN commands:
RMAN> CONNECT TARGET sys/sys@APPPROD
RMAN> CONNECT AUXILIARY sys/sys@DUPDB
RMAN> DUPLICATE TARGET DATABASE
TO dupdb
FROM ACTIVE DATABASE
PASSWORD FILE
SPILE
NOFILENAMECHECK;
What are the implications of this command?
A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.
B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.
C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.
D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
Answer: B
Q19. Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.
Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)? (Choose three.)
A. redo logs
B. control file
C. temporary files of temporary tablespace
D. the latest backup of only the damaged data file
E. the latest backup of all the data files In the USERS tablespace
Answer: ABD
Q20. Which type of database file is spread across all disks in a disk group?
A. All types of files are spread across all disks in the disk group.
B. Datafiles
C. Redo log files
D. Archived redo log files
E. Control files
Answer: A