A SQL consists of a set of facilities that are provided specifically to allow…
2025
A SQL consists of a set of facilities that are provided specifically to allow the construction of generalized, online and possibly interactive applications is known as
- A.
Standard SQL
- B.
Embedded SQL
- C.
Static SQL
- D.
Dynamic SQL
Attempted by 230 students.
Show answer & explanation
Correct answer: D
Dynamic SQL is a programming technique that allows you to build and execute SQL statements at runtime. Unlike Static SQL, where the query is fixed, Dynamic SQL is highly flexible.
Interactive Applications: Because Dynamic SQL can be constructed while the application is running, it is ideal for interactive applications where the user’s input (like search filters or column choices) determines the final query.
Generalized & Online: It allows developers to create generalized code that can handle various database tasks without hardcoding every possible query.
Runtime Execution: The SQL statement is compiled and executed by the database engine at the time the application is actually being used.