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
(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 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.