What is the ability to have object-oriented programming languages such as Java write SQL that can change the columns or database tables on the fly depending on the input parameters?
A) Static SQL
B) Dynamic SQL
C) Database views
D) SQL

Question

Quizplus · Accepted Answer

This is referring to Dynamic SQL, which is SQL code that is generated at runtime based on input parameters. It allows for flexibility in modifying columns or tables based on user input. Static SQL would not offer this flexibility as the code is pre-written and cannot be modified during runtime. Database views are a separate concept and involve creating a virtual table based on a SELECT statement. The option for just "SQL" is too broad as it could refer to both static and dynamic SQL.

What Is the Ability to Have Object-Oriented Programming Languages Such