Embedded SQL Multiple Choice Questions with Answers – 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