Have any questions?
[email protected]
English
Vietnamese
French
Spanish
Korean
Japanese
Thai
Chinese
Indonesian
Login
Signup
Contact
Login
Home
Which columns are good for indexing?
Question 1:
Which columns are good for indexing?
A.
Primary Key Columns
B.
Foreign Key Columns
C.
Columns with unique values
D.
All of these
Feedback
The purpose of index is to retrieve the data faster. So we choose those columns which are unique
These questions are from this test. Would you like to take a practice test?
DB2 Quiz 4 | Englishfreetest.com
20 minutes
10 questions
Do test
Some questions from the same exam
If a transaction takes a Update lock on some data, then other transactions can get what type of lock?
Which columns are good for indexing?
What is not a valid DB2 data type?
Which of the following can refer to both local as well as remote tables?
Which DB2 component is used for remote database server connection?
Which component is responsible for execution of SQL statements?
How many databases can a DB2 system manage?
Which table space houses only one table?
Which table space is divided into segments of 4 to 64 pages in increments of 4 and each segment holds data for only one table?
Write a query to delete a table TAB from database.
Some other questions you may be interested in
Which suffix means foot?
Which suffix means one who?
Which prefix means across a distance?
Which of the following prefixes does not mean not?
Which prefix means together?
Freya was the goddess of this.