exam questions

Exam 1z0-083 All Questions

View all questions & answers for the 1z0-083 exam

Exam 1z0-083 topic 1 question 157 discussion

Actual exam question from Oracle's 1z0-083
Question #: 157
Topic #: 1
[All 1z0-083 Questions]

You execute this command successfully:

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

What is the outcome?

  • A. It creates a file that contains SQL statements to re-create the control file
  • B. It creates a file that contains RMAN scripts to create a duplicate database
  • C. It creates a copy of the control file in the fast recovery area (FRA)
  • D. It creates a binary backup of the control file
  • E. It updates the alert log with the location and contents of the control file
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
LeandroHPN
Highly Voted 1 year, 1 month ago
Selected Answer: A
A correct. BACKUP CONTROLFILE Clause TO TRACE Specify TO TRACE if you want Oracle Database to write SQL statements to a trace file rather than making a physical backup of the control file. You can use SQL statements written to the trace file to start up the database, re-create the control file, and recover and open the database appropriately, based on the created control file.
upvoted 6 times
...
_gio_
Most Recent 6 months, 3 weeks ago
Selected Answer: A
sure of A
upvoted 1 times
...
ScottL
9 months, 1 week ago
Selected Answer: A
A for sure
upvoted 1 times
...
maryk
10 months, 2 weeks ago
https://docs.oracle.com/cd/E18283_01/server.112/e17120/control005.htm now doubt letter E
upvoted 1 times
...
vkra
11 months ago
I think also A but E is not far away: "This command writes a SQL script to a trace file where it can be captured and edited to reproduce the control file. View the alert log to determine the name and location of the trace file." from : https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-control-files.html#GUID-204AF8CF-6C51-4D0F-ADE2-BA804352EA93
upvoted 1 times
vkra
11 months ago
It must be A because: "E. It updates the alert log with the location and contents of the control file" The "location" is true but not the "content of the control file" is in the alert log.
upvoted 1 times
...
...
frankkk
1 year ago
A correct
upvoted 2 times
...
hilaire
1 year ago
A correct
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago