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 1 question 156 discussion

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

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.
You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to
ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

  • A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB.
  • B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.
  • C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.
  • D. Take the USERDATA tablespace offline in ACCOUNTS_PDB.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
* You can take an online tablespace offline so that it is temporarily unavailable for general use. The rest of the database remains open and available for users to access data. Conversely, you can bring an offline tablespace online to make the schema objects within the tablespace available to database users. The database must be open to alter the availability of a tablespace.
by khan at April 29, 2019, 10:49 p.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
jackymak
2 years, 9 months ago
Selected Answer: B
https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/pdb/pdb_pitr/pdb_pitr.html#t4
upvoted 1 times
jackymak
2 years, 9 months ago
sorry, It should be D for restore table space. https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1#tablespace-and-datafile-recovery
upvoted 1 times
...
...
khan
5 years, 7 months ago
Thought of sharing. In the Exam for this question answer option was different. To select one of this. ALTER TABLESPACE users OFFLINE IMMEDIATE; ALTER TABLESPACE users OFFLINE TEMPORARY; ALTER TABLESPACE users OFFLINE NORMAL; https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces005.htm#ADMIN11375
upvoted 3 times
Havok
4 years, 10 months ago
Would this tablespace be taken OFFLINE IMMEDIATE? since it is in ARCHIVELOG mode, and it was offline due to error.
upvoted 2 times
...
Khel
3 years, 3 months ago
@Khan, I believe the exam answer was B. Alter TABLESPACE users OFFLINE TEMPORARY
upvoted 2 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