Embedded and Dynamic SQL Multiple Choice Questions (MCQ) 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