Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
7 Cards in this Set
- Front
- Back
What are the interface mechanisms for SQL? |
1. Direct invocation: no host language is used 2. Embedded SQL: statements are embedded in a conventional language 3. Module language SQL: the statement is in a procedure which can be called from a host language 4. Call level interface: a set of routines called by the host language |
|
What is the use of a precompiler in a hoat language? |
Turns the SQL statements into a form that is compilablebe the host language. |
|
What does the precompiler do? |
1. Host language statements are unchanged 2. SQL statements are commented out 3. Host language external function calls to the DBMS are inserted |
|
What does the INTO statement do? |
Retrieves data into the host language variables. |
|
Describe the purpose of a cursor! |
When a set of rows (more than one) are retrieved, a cursor has to used that allows processing the result row-by-row. The cursor has to be DECLARED, OPENED and CLOSED! |
|
Describe the FETCH statement! |
It is used to position an open cursor to a row. |
|
Describe dynamic SQL! |
Allows us to create SQL statements at runtime. 1. PREPARE statement: parsing is done and the statement is bound to a variable. 2. EXECUTE statement: executes the prepared statement. |