SQL Interview Questions and Answers

Prepare for your Interview today!

Test your skills through the online practice test: SQL Quiz Online Practice Test

Related differences

Ques 131. Which of the following is not a feature of a cursor FOR loop?

1. Record type declaration.
2. Opening and parsing of SQL statements.
3. Fetches records from cursor.
4. Requires exit condition to be defined.

Is it helpful? Yes No Add Comment View Comments

Ques 132. 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.

Is it helpful? Yes No Add Comment View Comments

Ques 133. Which three of the following are implicit cursor attributes?

1. %found
2. %too_many_rows
3. %notfound
4. %rowcount
5. %rowtype

Is it helpful? Yes No Add Comment View Comments

Ques 134. If left out, which of the following would cause an infinite loop to occur in a simple loop?

1. LOOP
2. END LOOP
3. IF-THEN
4. EXIT

Is it helpful? Yes No Add Comment View Comments

Ques 135. Which line in the following statement will produce an error?

1. cursor action_cursor is
2. select name, rate, action
3. into action_record
4. from action_table;
5. There are no errors in this statement.

Is it helpful? Yes No Add Comment View Comments

Most helpful rated by users:

About Withoutbook

This site contains most of the quality computer technologies which can help all the related students and employees. We have large number of interview questions and answers, online test, difference between on many subjects.

SQL Interview Questions and Answers

Related differences

Ques 131. Which of the following is not a feature of a cursor FOR loop?

Ques 132. 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?

Ques 133. Which three of the following are implicit cursor attributes?

Ques 134. If left out, which of the following would cause an infinite loop to occur in a simple loop?

Ques 135. Which line in the following statement will produce an error?

About Withoutbook

Social Links

Quick Links