exam questions

Exam 1z0-062 All Questions

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

Exam 1z0-062 topic 1 question 254 discussion

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

You are managing an Oracle Database 12c database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.
Which three statements are true about these backups? (Choose three.)

  • A. The backups would be consistent.
  • B. The backups would be possible only if the database is running in ARCHIVELOG mode.
  • C. The backups need to be restored and the database has to be recovered in case of a media failure.
  • D. The backups would be inconsistent.
  • E. The backups by default consist of all the data blocks within the chosen files or the full database.
Show Suggested Answer Hide Answer
Suggested Answer: BCD 🗳️
References:
https://docs.oracle.com/cd/E18283_01/server.112/e10897/backrest.htm#insertedID4

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
Ray_gk
3 years, 1 month ago
Selected Answer: CDE
Why would B be correct? Backups using RMAN are in fact possible with the database in noarchivelog mode. However, the backups would be cold (offline) backups. We would only be able to restore the DB to the most previous backup but we can in fact take the backup.
upvoted 1 times
Ray520
3 years, 1 month ago
If database is open then backup with RMAN can only be done when database is in archivelog mode. Question says database is in open mode.
upvoted 2 times
Ray_gk
3 years ago
I circled back to this because I was not certain I was correct. I verified with Oracle DB and you are correct. I should have paid more attention. Thanks.
upvoted 2 times
...
...
Ray_gk
3 years, 1 month ago
A is not correct as the database must be shut down for backups to be consistent. The question states that the database is open.
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 ...