MySQL Database Questions

C. is a term used to describe an environment in which the SQL statement is generated at run time A. A(n)is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server a. persistent stored module b. permanent SQL module c. SQL nested statement d. program manipulation command a. Embedded SQL b. Dynamic SQL c. Procedural SQL d. Sequential SQL B. Ais procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event. After writing embedded SQL code within the host language instructions, the next step would be to. a. use the embedded SQL statement to retrieve data from the database a. stored procedure b. stored function c. index d. trigger b, compile the program using the host language compiler to create an object c. transform the embedded SQL into specialized DBMS-specific procedure d. create an access plan module to run the embedded code at run time code module calls using a preprocessor