exam questions

Exam 1z0-052 All Questions

View all questions & answers for the 1z0-052 exam

Exam 1z0-052 topic 3 question 81 discussion

Actual exam question from Oracle's 1z0-052
Question #: 81
Topic #: 3
[All 1z0-052 Questions]

Your database is configured in archivelog mode.
The USERS01 tablespace is currently online.
You are required to take the tablespace offline.
Which clause or clauses ensure that no media recovery is required when the tablespace is brought back online?

  • A. either the NORMAL or the IMMEDIATE clause
  • B. only the IMMEDIATE clause
  • C. either the NORMAL or the TEMPORARY clause
  • D. only the TEMPORARY clause
  • E. only the NORMAL clause
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces005.htm#ADMIN11377

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
alvatros1269
5 years, 2 months ago
I also was in doubt about if only temporal or also temporal + normal. According to the Andrew's link below, it also stays something of no required Recovery if using offline normal clause: Caution: If you must take a tablespace offline, use the NORMAL clause (the default) if possible. This setting guarantees that the tablespace will not require recovery to come back online, even if after incomplete recovery you reset the redo log sequence using an ALTER DATABASE OPEN RESETLOGS statement. My question here now comes(confuse me), Is it same to say no need media recovery versus only Recovery?. Are they the same meaning ? If so, then normal and temporary clause are valid answer. What do you think?
upvoted 1 times
...
giovi411
5 years, 5 months ago
However, I was undecided between the following two answers: Either the NORMAL or the TEMPORARY clause OR the Only the normal clause. But maybe it's just the answer that says Only the Normal clause. As I think it is a little ambiguos... Do you definitivaly confirm it ?
upvoted 1 times
...
Andrew
5 years, 6 months ago
Correct answer E: only the Normal clause https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces005.htm#ADMIN11377 TEMPORARY A tablespace can be taken offline temporarily, even if there are error conditions for one or more files of the tablespace. When you specify OFFLINE TEMPORARY, the database takes offline the datafiles that are not already offline, checkpointing them as it does so. If no files are offline, but you use the temporary clause, media recovery is not required to bring the tablespace back online. However, if one or more files of the tablespace are offline because of write errors, and you take the tablespace offline temporarily, the tablespace requires recovery before you can bring it back online. If you must take a tablespace offline, use the NORMAL clause (the default) if possible. This setting guarantees that the tablespace will not require recovery to come back online, even if after incomplete recovery you reset the redo log sequence using an ALTER DATABASE OPEN RESETLOGS statement.
upvoted 1 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago