Author Topic: Oracle DBA Question 50  (Read 58 times)

0 Members and 1 Guest are viewing this topic.

Offline ralph0595

  • Full Member
  • *
  • Posts: 107
  • Karma: +0/-0
    • View Profile
Oracle DBA Question 50
« on: April 21, 2009, 07:10:08 AM »
Question:
You have two undo tablespaces defined for your database. The instance is currently using the undo tablespace named UNDOTBS_1. You issue this command to switch to UNDOTBS 2 while there are still transactions unsing UNDOTBS_1:
ALTER SYSTEM SET UNDO_TABLESPACE = undotbs 2
Which two results occur? (Choose two.)

A. New transactions are assigned to UNDOTBS_2.
B. Current transactions are switched to the UNDOTBS_2 tablespace.
C. The switch to UNDITBS_2 fails and an error message is returned.
D. The UNDOTBS_1 undo tablespace enters into a PENDING OFFLINE mode (status).
E. The switch to UNDOTBS_2 does not take place untill all transactions in UNDOTBS_1 are completed.

Answer: A, D

Techronnati | where technology never sleeps

Oracle DBA Question 50
« on: April 21, 2009, 07:10:08 AM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
63 Views
Last post April 19, 2009, 06:01:21 AM
by ralph0595
0 Replies
64 Views
Last post April 19, 2009, 06:39:28 AM
by ralph0595
0 Replies
56 Views
Last post April 19, 2009, 06:41:37 AM
by ralph0595
0 Replies
59 Views
Last post April 19, 2009, 06:46:32 AM
by ralph0595
0 Replies
55 Views
Last post April 19, 2009, 06:51:28 AM
by ralph0595

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.