Embedded and Dynamic SQL Multiple Choice Questions with Answers – PDF Download

MCQ 1: In database management systems, the record which contains all the data regarding tuples of database is called:

1. statement record
2. environment record
3. description record
4. connection record

MCQ 2: The type of iterator which is used to list the types of attributes that are included in the query result is called:

1. positional iterator
2. named iterator
3. unnamed iterator
4. non-positioned iterator

MCQ 3: The variable in DBMS used to communicate error conditions between database management system and program are:

1. SQLCODE
2. SQLSECTION
3. SQLSTATE
4. both b and c

MCQ 4: In database management system, if the cursor is to be moved to next rows in queries result then the command is classified as:

1. OPEN CURSOR command
2. FETCH command
3. UPDATE command
4. CLOSE CURSOR command

MCQ 5: The general purpose programming languages such as COBOL and ADA is classified as:

1. server language
2. client language
3. host language
4. referential language