Embedded SQL Multiple Choice Questions (MCQ) PDF Download

MCQ 1: If the SQL query results in an error, the database system stores an error diagnostic in the SQL

1. Communication area variables
2. Connection area variables
3. SQL area variables
4. Programming area variables

MCQ 2: A relation is conceptually a set, the tuples of the result of a query are in some

1. Physical order
2. Random order
3. Fixed physical order
4. NO order

MCQ 3: A query string can be constructed and prepared at runtime, using a statement of the form

1. EXEC PREP
2. EXEC SQL PREPARE
3. SQL PREPARE
4. EXEC DEFINE PREPARE

MCQ 4: The iteration through all the tuples can be performed in the embedded statements by using the

1. Select operation
2. Define operation
3. Fetch operation
4. Commit operation

MCQ 5: In some languages such as Cobol, the semicolon is replaced with

1. EXEC
2. START-EXEC
3. END-EXEC
4. SQL-EXEC