1Z0-083 practice question 13 of 35
You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?
Full set: 286 questionsThe ALTER DATABASE BACKUP CONTROLFILE TO TRACE command reads the current control file and writes a human-readable script to a trace file in the Automatic Diagnostic Repository (ADR) trace directory. This script contains the CREATE CONTROLFILE SQL statement, which can be edited and executed to recreate the control file if all physical copies are lost. It is a critical part of disaster recovery planning, providing a logical backup of the control file's structure and contents.
A. A binary backup is created using the BACKUP CONTROLFILE TO 'filename' syntax or via RMAN, not with the TO TRACE clause.
B. The alert log records the location of the generated trace file, but it does not contain the full SQL script itself.
D. The generated file is a SQL script for control file creation, not an RMAN script for database duplication.
E. The output is a text-based trace file in the diagnostic destination, not a binary copy of the control file in the FRA.
1. Oracle Database SQL Language Reference, 19c. "ALTER DATABASE". In the section for backupcontrolfileclause, it states: "Specify TO TRACE to write a SQL script to a trace file that can be used to re-create the control file."
2. Oracle Database Backup and Recovery User's Guide, 19c. Chapter 15, "Managing the Control File". Section "Backing Up the Control File to a Trace File". It explains that this command creates a script with a CREATE CONTROLFILE statement.
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
