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

0 Members and 1 Guest are viewing this topic.

Offline ralph0595

  • Full Member
  • *
  • Posts: 107
  • Karma: +0/-0
    • View Profile
Oracle DBA Question 77
« on: May 06, 2009, 06:58:56 AM »
Question:
Evaluate the SQL statement:

CREATE TABLESPACE hr_tbs
         DATAFILE \'  / usr / oracle9i / OraHome1 /hr_data.dbf \' SIZE 2M
         AUTOEXTEND ON
         MINIMUM EXTENT 4K
         NOLOGGING
         DEFAULT STORAGE (INITIAL 5K NEXT 5K PCTINCREASE 50)
         EXTENT MANAGEMENT DICTIONARY
SEGMENT SPACE MANAGEMENT AUTO;

Why does the statement return an error?

A. The value of PCTINCREASE is too high.
B. The size of the data file is too small.
C. You cannot specify default storage for dictionary managed tablespaces.
D. Segment storage management cannot be set to auto for a dictionary managed tablespace.
E. You cannot specify default storage for a tablespace that consists of an autoextensible data file
F. The value specified for INITIAL and NEXT storage parameters should be a multiple of the value specified for MINIMUM EXTENT.

Answer: D

Techronnati | where technology never sleeps

Oracle DBA Question 77
« on: May 06, 2009, 06:58:56 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
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.