ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-062 All Questions

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

Exam 1z0-062 topic 2 question 11 discussion

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

Which four statements are true about database instance behavior? (Choose four.)

  • A. An idle instance is created when a STARTUP NOMOUNT is successful
  • B. All dynamic performance views (v$ views) return data when queried from a session connected to an instance in NOMOUNT state
  • C. The consistency of redo logs and data files is checked when mounting the database
  • D. Redo log files can be renamed in MOUNT state
  • E. An SPFILE can be updated when connected to an idle instance
  • F. Datafiles can be renamed in MOUNT state
Show Suggested Answer Hide Answer
Suggested Answer: CDEF 🗳️
by NorthKorean at March 31, 2020, 11:12 a.m.

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
Submit Cancel
BlackstoneDB
2 years, 5 months ago
I check some dynamic views with nomount state and they are working.... Although in question is mention all dynamic views... Maybe B is correct
upvoted 1 times
...
andrewz
3 years, 11 months ago
C is wrong. the consistency checking is in open process. ADEF is correct.
upvoted 3 times
Ray_gk
2 years, 9 months ago
I agree with you about C. Interestingly enough, I think both A and C are wrong. When you get "connected to an idle instance" this means that your DB is not at least STARTED. The command startup nomount simply starts the database so it is not an idle instance. Either the correct question asks for only three correct answers, or the answer choices are written incorrectly in this dump (I have seen that is an occasional occurrence with this dump).
upvoted 1 times
...
dfabac
2 years, 8 months ago
A is wrong: after startup nomount, all memory structures are created, and basic background processes started (such as pmon). So the instance is not idle.
upvoted 1 times
...
...
NorthKorean
4 years, 10 months ago
ADEF is the answer
upvoted 4 times
NorthKorean
4 years, 10 months ago
Sorry CDEF is correct
upvoted 9 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago