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

Princess

2 months ago

I wonder if the database instance is feeling a bit Mount Rushmore-d in this scenario, you know, just kind of hanging out, not doing much.

upvoted 0 times

Bulah

15 days ago

C) A control file is open.

upvoted 0 times

...

Roselle

1 months ago

B) Data files are open in read-only mode.

upvoted 0 times

...

Mindy

1 months ago

A) System administrators and users with the CREATE SESSION system privilege may connect to the instance.

upvoted 0 times

...

Nicolette

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

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

Shawnta

15 days ago

B) Data files are open in read-only mode.

upvoted 0 times

...

Marget

1 months ago

A) System administrators and users with the CREATE SESSION system privilege may connect to the instance.

upvoted 0 times

...

Latonia

2 months ago

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

upvoted 0 times

...

Malinda

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

2 months ago

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

upvoted 0 times

...

Ma

2 months ago

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

upvoted 0 times

...

Ma

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

Amber

2 months ago

That's correct. The background processes are running as well.

upvoted 0 times

...

Nadine

2 months ago

Yes, you're right. Users can connect, the control file is open, and the SGA is allocated.

upvoted 0 times

...