Author Topic: Oracle DBA Question 67  (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 67
« on: April 21, 2009, 01:42:13 PM »
Question:
You need to create an index in the CUSTOMER_ID column of the CUSTOMERS table. The index has these requirements:


1. The index will be called CUST_PK.
2. The index should be sorted in ascending order.
3. The index should be created in the INDEX01 tablespace, which is a dictionary managed tablespace.
4. All extents of the index should be 1 MB in size.
5. The index should be unique.
6. No redo information should be generated when the index is created.
7. 20% of each data block should be left free for future index entries.
Which command creates the index and meets all the requirements?

A. CREATE UNIQUE INDEX cust_pk ON customers(customer_id)
TABLESPACE index0l
PCTFREE 20
STORAGE (INITIAL lm NEXT lm PCTINCREASE 0);
B.  CREATE UNIQUE INDEX cust_pk ON customers(customer_id)
TABLESPACE index0l
PCTFREE 20
STORAGE (INITIAL lm NEXT lm PCTINCREASE 0)
NOLOGGING;
C. CREATE UNIQUE INDEX cust_pk ON customers(customer_id)
TABLESPACE index0l
PCTFREE 80
STORAGE (INITIAL lm NEXT lm PCTINCREASE 0)
NOLOGGING;
D. CREATE UNIQUE INDEX cust_pk ON customers(customer_id)
TABLESPACE index0l
PCTFREE 80
STORAGE (INITIAL lm NEXT lm PCTINCREASE 0);

Answer: B

Techronnati | where technology never sleeps

Oracle DBA Question 67
« on: April 21, 2009, 01:42:13 PM »

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.