1. Which of the following is NOT required when integrating a SQL environment and a host language ?

A. A way to pass data from SQL environment to host language environment.

B. A way to pass data from host language environment to SQL environment.

C. Data types in SQL environment must have corresponding and compatible data types in host language environment.

D. Data types in host language environment must be exactly the same as data types in SQL environment.

2. Why is a cursor construct necessary in embedded SQL in C programs ?

A. A cursor is required to iterate through a result set of which the size is not known in advance.

B. A cursor is required so that it can be moved around the screen using a mouse.

C. A cursor construct is not necessary, but is a convenient shorthand.

D. A cursor construct is required because the C language does not have arrays.

3. Which of the following is NOT true of dynamic SQL queries?

A. The SQL is not fully specified at application compile time.

B. The SQL is fully specified at application runtime.

C. The SQL may incorporate additional parameters based on user input at application runtime.

D. Dynamic SQL queries are always vulnerable to SQL injection attacks.

4. Which of the following is NOT true of cursors ?

A. A cursor is read only.

B. A cursor is advanced using a fetch command.

C. A cursor is used to iterate through tables or query results.

D. A cursor is updateable.