Db2(Engineering > Computer Science And Engineering ) Questions and Answers
Question 1. How many clustering index we can have for a single table?
15
10
1
No Limit
Explanation:-
Answer: Option C. -> 1
Question 2. The final result of a DB2 BIND is
Load module
DB2 catalog
Data base request module
DB2 (application) Plan
Explanation:-
Answer: Option D. -> DB2 (application) Plan
Question 3. An INSERT statement:
May contain a subquery
Must contain a VALUES list
Must contain a column list
May create multiple table rows
Explanation:-
Answer: Option A. -> May contain a subquery
Question 4. AUTOMATIC RECOMPILATION occurs when
A existing index is dropped
A new index is created
Both A and B
None of the above
Explanation:-
Answer: Option B. -> A new index is created
Question 5. Which of the following allow you to perform administrative tasks against database objects?
Control Center
Journal
Task Center
Health Center
Explanation:-
Answer: Option A. -> Control Center
Question 6. Which of the following DB2 objects allows multiple users to access data in a table with each only being able to access certain portions of the data?
Views
Aliases
Indexes
Mirrored tables
Explanation:-
Answer: Option A. -> Views
Question 7. How can the locks be classified?
Size
Duration
Mode
All of these
Explanation:-
Answer: Option D. -> All of these
Question 8. Which of the following DB2 tools allows a user to set DB2 registry parameters?