Author Topic: Oracle DBA Question 71  (Read 61 times)

0 Members and 1 Guest are viewing this topic.

Offline ralph0595

  • Full Member
  • *
  • Posts: 107
  • Karma: +0/-0
    • View Profile
Oracle DBA Question 71
« on: April 23, 2009, 05:38:52 AM »
Question:
Which two statements are true about rebuilding an index? (Choose two.)

A. The resulting index may contain deleted entries.
B. A new index is built using an existing index as the data source.
C. Queries cannot use the existing index while the new index is being built.
D. During a rebuild, sufficient space is needed to accommodate both the old and the new index in their respective tablespaces.

Answer: B, D

Guide:
Index rebuilds have the following characteristics:
i* A new index is built using an existing index as the data source.
i* Sorts are not needed when an index is built using an existing index, resulting in better performance.
i* The old index id deleted after the new index is built. During the rebuild, sufficient space is needed to accommodate both the old and the new index in their respective tablespaces.
i* The resulting index does not contain any deleted entries. Therefore, this index uses space more efficiently.
i* Queries can continue to use the existing index while the new index is being built.

Techronnati | where technology never sleeps

Oracle DBA Question 71
« on: April 23, 2009, 05:38:52 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.