Which statement is a true regarding indexes?
A. you can create an index on one or more columns
B. you can create an index only on column that contains primary key
C. indexes always show down the speed of query process
D. index is generated automatically with defining primary key
Answer: Option A
Join The Discussion
Comments (1)
Related User Ask Questions
Which of the following is not a primary function of a Bank?
A. Granting Loans
B. Collecting Cheques/Drafts customers
C. Facilitating import of goods
D. Issuing Bank Drafts
A. Regulatory jurisdictional fight between SEBI and IRDA
B. They don’t offer better tax benefits
C. They offer lesser returns compared to traditional insurance policies
D. All of the above
The Chameli Devi Jain Award is given for an outstanding woman ____?
A. Scientist
B. Reporter
C. Player
D. Teacher

Which of the following is true regarding Index?
► Index can only be created for a single table in database
► Index can maximum be created for two tables in database
► Index should be created for every table in the database
► Index can be created for every table in the database