In Oracle,____ make(s)it possible to merge SQL and traditional programming constructs,such as variables,conditional processing (IF-THEN-ELSE),basic loops (FOR and WHILE loops,)and error trapping.
A) triggers
B) indexes
C) embedded SQL
D) procedural SQL

Question

Quizplus · Accepted Answer

Procedural SQL, also known as PL/SQL, allows for the integration of SQL and traditional programming constructs. It enables the use of variables, conditional processing, loops, and error handling within SQL statements. Triggers and indexes are SQL database objects that are used for different purposes and do not provide the same functionality as procedural SQL. Embedded SQL is a method of including SQL statements in a program written in another programming language, such as C or Java.

In Oracle,____ Make(s)it Possible to Merge SQL and Traditional Programming