DB2 Intermediate Online Exam

20 questions • 30 minutes • Passing score: 60%

Intermediate level — Applied knowledge: real-world scenarios and combined concepts.
Read the rules and click below when you are ready.
The timer starts immediately.

20 multiple-choice questions
30 minutes time limit — the test auto-submits when time runs out
Passing score: 60%
Use the number buttons to jump between questions

Questions:

- Q1. COUNT(*) versus COUNT(SALARY): the difference is
- ANo difference
- BCOUNT(SALARY) ignores nulls, COUNT(*) counts every row
- CCOUNT(*) is slower
- DCOUNT(SALARY) counts nulls
- Q2. To find rows where COMM is null, code
- AWHERE COMM = NULL
- BWHERE COMM IS NULL
- CWHERE COMM = 0
- DWHERE COMM = ' '
- Q3. SALARY + COMM evaluates to null when
- ACOMM is zero
- BCOMM is null
- CSALARY is zero
- DAlways
- Q4. A LEFT OUTER JOIN returns
- AOnly matched rows
- BAll left-table rows, with nulls where the right side has no match
- CAll right-table rows
- DNo duplicates
- Q5. A correlated subquery
- ARuns once
- BReferences the outer query and is evaluated for each outer row
- CCannot use WHERE
- DIs always faster
- Q6. WHERE EXISTS (SELECT ...)
- AIs always false
- BIs true when the subquery returns at least one row
- CCounts rows
- DDeletes rows
- Q7. UNION ALL differs from UNION in that it
- ASorts results
- BKeeps duplicate rows
- CIs faster to type
- DAllows more columns
- Q8. The HAVING clause
- AReplaces WHERE
- BFilters groups after GROUP BY
- CSorts output
- DJoins tables
- Q9. In LIKE 'SM_TH', the _ character
- AMatches any string
- BMatches exactly one character
- CIs literal
- DMatches digits only
- Q10. WHERE SALARY BETWEEN 1000 AND 2000
- AExcludes 1000 and 2000
- BIncludes 1000 and 2000
- COnly works on dates
- DIs invalid syntax
- Q11. A cursor declared WITH HOLD
- AIs read-only
- BStays open across COMMIT
- CHolds locks forever
- DIs faster
- Q12. The correct order of cursor operations is
- AOPEN, DECLARE, FETCH, CLOSE
- BDECLARE, OPEN, FETCH, CLOSE
- CFETCH, OPEN, DECLARE, CLOSE
- DDECLARE, FETCH, OPEN, CLOSE
- Q13. UPDATE ... WHERE CURRENT OF CUR1
- AUpdates all rows
- BUpdates the row most recently fetched by CUR1
- CDeletes the row
- DCloses the cursor
- Q14. SQLCODE -803 means
- ANot found
- BDuplicate key: unique constraint violated
- CTimeout
- DSyntax error
- Q15. SQLCODE -911 means
- ASuccess
- BDeadlock or timeout; the unit of work was rolled back
- CNull indicator missing
- DTable not found
- Q16. SQLCODE -305 means a null value was fetched
- ASuccessfully
- BWithout an indicator variable
- CInto a char field
- DTwice
- Q17. SQLCODE -811 means a singleton SELECT
- AFound no rows
- BReturned more than one row
- CTimed out
- DWas too slow
- Q18. In EXEC SQL statements, COBOL host variables are written as
- A&VAR
- B:WS-VAR
- C$VAR
- D@VAR
- Q19. An indicator variable holding -1 means the column value
- AIs zero
- BIs null
- CWas truncated
- DIs positive
- Q20. A clustering index
- AIs always unique
- BDetermines the physical order of rows in the table
- CClusters jobs
- DCannot be dropped

Let's understand Mainframe

DB2 Intermediate Online Exam

DB2 Intermediate Online Exam

Exam Result