What is embedded SQL, and what considerations are necessary when using it in an application?
What will be an ideal response?
Embedded SQL are SQL statements used, or embedded, in program code, triggers or stored procedures. Applications are typically written in program code, using a programming language. There are two problems that arise. First, the results of SQL statements must be assigned to programming language variables. DBMS products typically provide the means of doing this. Second, SQL is table or set-oriented and SQL results use tables or sets of rows, whereas application programming languages are variable or row-oriented. This is resolved by treating SQL results as pseudofiles. A cursor is then used to move through the pseudofile one.
You might also like to view...
Of the following selection methods, which is the least likely to be perceived as an invasion of privacy by job applicants?
a. asking for a hair sample for drug testing b. reviewing social media sites such as Facebook c. using a cognitive ability test d. conducting a background check
Which of the following acts exempts all documents given to the Securities and Exchange Commission by foreign regulators from Freedom of Information Act disclosure requirements?
A) the Market Reform Act of 1990 B) the Bankruptcy Abuse Prevention and Consumer Protection Act of 2005 C) the Foreign Corrupt Practices Act of 1977 D) the International Securities Enforcement Cooperation Act of 1990