SQL (Structured Query Language) Question:
Download Job Interview Questions and Answers PDF
How would the developer define this variable using referential datatypes?
Answer:
A developer would like to use referential datatype declaration on a variable. The variable name is EMPLOYEE_LASTNAME, and the corresponding table and column is EMPLOYEE, and LNAME, respectively. How would the developer define this variable using referential datatypes?
1. Use employee.lname%type.
2. Use employee.lname%rowtype.
3. Look up datatype for EMPLOYEE column on LASTNAME table and use that.
4. Declare it to be type LONG.
1. Use employee.lname%type.
2. Use employee.lname%rowtype.
3. Look up datatype for EMPLOYEE column on LASTNAME table and use that.
4. Declare it to be type LONG.
Download SQL Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Which of the following statements is true about implicit cursors? | If left out, which of the following would cause an infinite loop to occur in a simple loop? |