195k views
2 votes
Static: hardcode SQL into the program.

Dynamic: any DDL, DML, QL at run-time.

Options:
A. Fixed, Adaptive
B. Constant, Variable
C. Embedded, Runtime
D. Hard, Soft

User Tim Bender
by
8.3k points

1 Answer

1 vote

Final answer:

The correct answer to the student's question is C. Embedded and Runtime, which accurately represent static and dynamic SQL respectively.

Step-by-step explanation:

The student's question is about the comparison between static and dynamic SQL in programming. Options A through D each pair a term related to static SQL (where SQL statements are hardcoded into a program) with a term related to dynamic SQL (where SQL statements such as DDL, DML, or QL are constructed and executed at run-time). The correct pairing for these concepts is C. Embedded and Runtime. Embedded SQL is SQL that is hardcoded into the program and compiled into the source code, making it static and unchangeable during execution. Runtime SQL, on the other hand, allows for dynamic creation and execution of SQL statements during the execution of the program, making it adaptable based on conditions and inputs at the time.

User Axel Donath
by
8.3k points