Author Topic: Oracle DBA Question 101  (Read 110 times)

0 Members and 1 Guest are viewing this topic.

Offline ralph0595

  • Full Member
  • *
  • Posts: 107
  • Karma: +0/-0
    • View Profile
Oracle DBA Question 101
« on: May 11, 2009, 11:50:12 AM »
Question:

Which is true when considering the number of indexes to create on a table?

A. Every column that is updated requires and index.
B. Every column that is queried is a candidate for an index.
C. Columns that are part of a WHERE clause are candidates for an index.
D. On a table used in a Data Warehouse application there should be no indexes.

Answer: C





pls visit http://www.ralph0595.dragonadopters.com/dragon_97462 thanks you very much for your kindness..GOD Bless..

Techronnati | where technology never sleeps

Oracle DBA Question 101
« on: May 11, 2009, 11:50:12 AM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
72 Views
Last post April 19, 2009, 06:39:28 AM
by ralph0595
0 Replies
65 Views
Last post April 19, 2009, 06:41:37 AM
by ralph0595
0 Replies
66 Views
Last post April 19, 2009, 06:46:32 AM
by ralph0595
0 Replies
62 Views
Last post April 19, 2009, 06:51:28 AM
by ralph0595
0 Replies
60 Views
Last post November 16, 2016, 11:40:31 AM
by nomadic

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.