Oracle Exam 1Z0-497 Topic 3 Question 98 Discussion

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

Question #: 98
Topic #: 3

[All 1Z0-497 Questions]

Which three statements are true about a database instance that has mounted a database but has not opened it?

ASystem administrators and users with the CREATE SESSION system privilege may connect to the instance.

BData files are open in read-only mode.

CA control file is open.

DSystem Global Area (SGA) is allocated and background processes are started.

EAn alert log and trace files are open.

FInstance recovery is performed for the database.

Show Suggested Answer

Suggested Answer: C

http://docs.oracle.com/database/121/DWHSG/ch2logdes.htm#DWHSG9225

by Huey at Jul 13, 2024, 03:35 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Nicolette

3 days ago

E is a tricky one. The alert log and trace files are typically open, but I'm not sure if that's a requirement for a mounted but not opened database instance.

upvoted 0 times

...

Huey

8 days ago

F is definitely not true. Instance recovery is only performed when the database is opened, not when it's just mounted.

upvoted 0 times

...

Latonia

11 days ago

I believe statement D is also true because SGA is allocated and background processes are started.

upvoted 0 times

...

Malinda

11 days ago

B is not correct, as the data files are not open in read-only mode when the database is mounted but not opened. That's a good one though!

upvoted 0 times

...

Loise

12 days ago

I agree with Ma. Statement A makes sense to me.

upvoted 0 times

...

Ma

14 days ago

I think statement A is true because system administrators and users with the CREATE SESSION privilege can connect.

upvoted 0 times

...

Ma

17 days ago

A, C, and D seem to be the correct answers here. The instance is mounted but not opened, so users can connect, the control file is open, and the SGA is allocated with background processes running.

upvoted 0 times

...