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
Statement: Quite independent of the global economic meltdown, India's neglect of its physical infrastructure has been a malaise demanding radical treatment.
Assumptions:
I. Radical treatment would reduce the adverse effects of global economic meltdown and India's neglect of its physical infrastructure.
II. Physical infrastructure is the base of high growth trajectory.
Statement: The price of the BIG cement has reduced.
Assumptions:
1) The cement may be of cheap quality.
2) The company will suffer losses by reducing the price.
Statement: In order to bring punctuality in our office, we must provide conveyance allowance to our employees. In charge of a company tells Personnel Manager.
Assumptions:
Conveyance allowance will not help in bringing punctuality.
Discipline and reward should always go hand in hand.
Statement: It is desirable to put the child in school at the age of 5 or so.
Assumptions:
I. At that age, the child reaches an appropriate level of development and is ready to learn.
II. The schools do not admit children after six years of age.
Statement: Films have become indispensable for the entertainment of people.
Assumptions:
I. Films are the only media of entertainment.
II. People enjoy films.
Statement : “India won the toss and choose to the bat first against Pakistan”
Assumptions :
I. Moisture Might Be fallen at night
II. India is Playing with no spinners