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

2 months 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

Wilbert

11 days ago

E) configuring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode

upvoted 0 times

...

Lewis

12 days ago

B) re-creating the control files

upvoted 0 times

...

Rolland

19 days ago

A) renaming the control files

upvoted 0 times

...

Reuben

2 months 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

Burma

11 days ago

D) dropping a tablespace in your database

upvoted 0 times

...

Tori

14 days ago

C) dropping a user in your database

upvoted 0 times

...

Edelmira

16 days ago

B) re-creating the control files

upvoted 0 times

...

Anna

1 months ago

A) renaming the control files

upvoted 0 times

...

William

1 months ago

D) dropping a tablespace in your database

upvoted 0 times

...

Jeanice

1 months ago

C) dropping a user in your database

upvoted 0 times

...

Maurine

2 months ago

B) re-creating the control files

upvoted 0 times

...

Vannessa

2 months ago

A) renaming the control files

upvoted 0 times

...

Erasmo

2 months 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

Breana

1 months ago

I think E as well. Mount state is needed for configuring the database instance.

upvoted 0 times

...

Lorriane

1 months ago

I agree, it's not C or D. E seems like the right choice.

upvoted 0 times

...

Raina

2 months 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

...