Db2 Mock Test 3
10 Questions
Settings
-
+
Questions and Answers
- 1.What is the collection of data designed to be used by different people is called
- A.
File
- B.
Database
- C.
Table
- 2.DB2 is
- A.
Relational Database Management system
- B.
D) Programming language
- C.
) Database
- 3.What are the aggregate functions supported by DB2 ?
- A.
SUM, MAX, MIN, AVG and COUNT
- B.
SUM and AVG
- C.
NONE
- 4.EXPLAIN allows the user to obtain information regarding the optimizer’s choice of access strategy for a given SQL statements
- A.
True
- B.
False
- 5.SELECT * FROM ………. will retrieve all columns of the table meeting the selection criteria .
- A.
True
- B.
False
- 6.How does the defining of a stored procedure affect the size of a DB2 database?
- A.
It decreases the size of the database.
- B.
It increases the size of the database.
- C.
It does not affect the size of the database. It does not affect the size of the database
- 7.Which authority can be granted to a group of users using the GRANT statement?
- A.
SYSCTRL
- B.
DBCTRL
- C.
SYSADM
- 8.Given the statement CREATE TABLE userid.test ( date_taken DATE NOT NULL, number SMALLINT NOT NULL, PRIMARY KEY (number))
- A.
Userid
- B.
Number
- C.
Test
- 9.Which system catalog view can be used to determine when a bind operation was performed on a given package?
- A.
SYSCAT.PACKAGES
- B.
SYSCAT.TIMESTAMP
- C.
SYSCAT.ACCESSPLAN
- 10.Which type of cursor should be used so that its position will be maintained between transactions?
- A.
FOR FETCH
- B.
FOR UPDATE
- C.
WITH HOLD
Back to top