DB2 Programming MCQs (Chapterwise Multiple Choice Questions)

How are ODBC calls binded?

They are not binded because they use standard functions to execute SQL.

They are binded at compile time.

They are pre-process binded.

They are binded using standard functions in SQL.

Answer & Explanation

Correct Answer: They are not binded because they use standard functions to execute SQL.

Note: This Question is unanswered, help us to find answer for this one

In what form is data physically stored in DB2

VSAM ESDS

Flat Files

Tables

VSAM LDS

Answer & Explanation

Correct Answer: VSAM LDS

Note: This Question is unanswered, help us to find answer for this one

Which of the following DB2 objects allows multiple users to access data in a table with each only being able to access certain subsets of the data?

Mirrored Tables

Indexes

Aliases

Views

Answer & Explanation

Correct Answer: Views

Note: This Question is unanswered, help us to find answer for this one

Which of the following is a DB2 mechanism that ensures data integrity between tables related by Primary & Foreign Keys

B & C

Referential integrity

Data Integrity

Pre-compilation

Answer & Explanation

Correct Answer: Referential integrity

Note: This Question is unanswered, help us to find answer for this one

What are three examples of languages you can use to program in DB2?

HTML, MSDOS, Python.

PHP, Ruby on Rails, and Haskell.

Perl, Python, and PL/SQL.

COBOL, Fortran, and Perl.

Answer & Explanation

Correct Answer: COBOL, Fortran, and Perl.

Note: This Question is unanswered, help us to find answer for this one

Given the following cursor declaration: DECLARE CLASSUPDATE CURSOR FOR SELECT CSTITLE FROM T001.CLASSS FOR UPDATE OF CDUR Which of the following embedded SQL statements will use this cursor correctly?

UPDATE T001.CLASSS SET CDUR = 5

UPDATE T001.CLASSS SET CDUR = 5 WHERE CURRENT OF CLASSUPDATE

UPDATE SET CDUR = 5 WHERE CURRENT OF CLASSUPDATE

UPDATE T001.CLASSS C SET C.CSTITLE = 'New Title' WHERE CURRENT OF CLASSUPDATE

Answer & Explanation

Correct Answer: UPDATE T001.CLASSS SET CDUR = 5 WHERE CURRENT OF CLASSUPDATE

Note: This Question is unanswered, help us to find answer for this one

What happens to SQL statements if there are no stored procedures?

They are embedded.

They are disregarded.

They are corrupted.

They are locked.

Answer & Explanation

Correct Answer: They are embedded.

Note: This Question is unanswered, help us to find answer for this one

What technique can DB2 use to more effectively interpret data from EXPLAIN tables?

Networked processing.

Parallel processing.

Unilateral processing.

Quadratic processing.

Answer & Explanation

Correct Answer: Parallel processing.

Note: This Question is unanswered, help us to find answer for this one

What is a benefit of concurrency in SQL application programming?

Increase of data conflicts.

Minimization of data access conflicts.

Increasing data access points.

Multi-threaded compiling.

Answer & Explanation

Correct Answer: Minimization of data access conflicts.

Note: This Question is unanswered, help us to find answer for this one

Which of the following is not one of the types of authorizations associated with a DB2 user?

Current SQLID

Primary Authorization ID

SQL Authorization ID

Secondary Authorization ID

Answer & Explanation

Correct Answer: SQL Authorization ID

Note: This Question is unanswered, help us to find answer for this one

DB2 Programming Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.