Author Topic: Oracle DBA Question 61  (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 61
« on: April 21, 2009, 11:54:42 AM »
Question:
You issue these queries to obtain information about the REGIONS table:
SQL> SELECT segment_name, tablespace_name
2>FROM user_segments
3>WHERE segment_name = \'REGIONS\';
You then issue this command to move the REGIONS table:
ALTER TABLE regions
MOVE TABLESPACE user_data;
What else must you do to complete the move of the REGIONS table?

A. You must rebuild the REG_ID_PK index.
B. You must re-create the REGION_ID_NN and RED_ID_PK constraints.
C. You must drop the REGIONS table that is in the SAMPLE tablespace.
D. You must grant all the privileges that were on the REGIONS table in the SAMPLE tablespace to the REGIONS table in the USER_DATA tablespace

Answer: A

Techronnati | where technology never sleeps

Oracle DBA Question 61
« on: April 21, 2009, 11:54:42 AM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
62 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
55 Views
Last post April 19, 2009, 06:41:37 AM
by ralph0595
0 Replies
58 Views
Last post April 19, 2009, 06:46:32 AM
by ralph0595
0 Replies
54 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.