DB2 MCQ Questions And Answers - Mainframe Development

DB2 MCQs : This section focuses on "basics" of DB2. These Multiple Choice Questions (MCQ) should be practiced to improve the DB2 skills required for various interviews (campus interviews, walk-in interviews, company interviews), placements, entrance exams and other competitive examinations.

1. Which command used to find the number of rows in a DB2 table?

A. SUM (*)
B. ADD (*)
C. COUNT (*)
D. CALCULATE (*)

View Answer


2. Which command used to find the duplicate values be eliminated from DB2 SELECT?

A. duplicate
B. distinct
C. dvalue
D. None of the above

View Answer


3. ______________ functions are built-in mathematical tools that are used in the DB2 SELECT clause.

A. Sum Up
B. Add Up
C. Calculate
D. Aggregate

View Answer


4. Is it possible using MAX on a CHAR column?

A. Yes
B. No
C. Can be yes or no
D. Can not say

View Answer


5. ____________ is the function that eliminates duplicates in the table.

A. Union All
B. Union
C. Both A and B
D. None of the above

View Answer


6. The physical storage length of DATE is ________ bytes.

A. 1
B. 2
C. 4
D. 8

View Answer


7. DCLGEN refers to?

A. Data Generator
B. Defined Generator
C. Declaration Getting
D. Declaration Generator

View Answer


8. Major fields in SQLCA are?

A. SQLCODE
B. SQLERRM
C. SQLERRD
D. All of the above

View Answer


9. Can there be more than one cursor open for any program?

A. Yes
B. No
C. Can be yes or no
D. Can not say

View Answer


10. Is there any restriction on the use of UNION in Embedded SQL?

A. Yes
B. No
C. Can be yes or no
D. Can not say

View Answer




Discussion


* You must be logged in to add comment.