Oracle Exam 1Z0-497 Topic 6 Question 70 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 70
Topic #: 6

[All 1Z0-497 Questions]

For which database operation do you need the database to be in MOUNT state?

Arenaming the control files

Bre-creating the control files

Cdropping a user in your database

Ddropping a tablespace in your database

Econfiguring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode

Show Suggested Answer

Suggested Answer: A, C

https://docs.oracle.com/database/121/SQLRF/statements_8028.htm#SQLRF55699

by Nichelle at Feb 03, 2023, 04:59 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-497 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Alecia

1 days ago

Hmm, I'm torn between B and E. Maybe I should just ask the database itself for the answer. 'Hey, database, what state do you need to be in for this?' *crickets*

upvoted 0 times

...

Reuben

11 days ago

Haha, I bet you need the database to be in MOUNT state to do your taxes! Just kidding, I think the answer is B. Gotta love those control files!

upvoted 0 times

...

Erasmo

17 days ago

Definitely not C or D. Dropping a user or tablespace doesn't require the database to be in MOUNT state. I'm going with E on this one.

upvoted 0 times

...

Raina

19 days ago

I'm not sure, but I'm leaning towards E. Configuring the database to operate in ARCHIVELOG or NOARCHIVELOG mode seems like it would need the database to be in MOUNT state.

upvoted 0 times

...