Question

Which of the following is/are a function of dynamic SQL?

(a) Allowing a program to construct an SQL query in a character string

(b) Submitting the query

(c) Retrieving the result into the program variables a tuple at a time

(d) All of the mentioned

The question was posed to me in an interview for job.

This interesting question is from Accessing SQL From a Programming Language in section Intermediate and Advanced Sql of RDBMS

Answer 1

The correct option is (d) All of the mentioned

Easy explanation: Dynamic SQL allows the program to construct the queries in character string format, it submits them, and then retrieves the data into the program variables one tuple at a time.