PL SQL Interview Questions

1.

PL/SQL is a transaction processing procedural language that has which of the following advantages?

A. Integration with database

B. Better Performance

C. Higher Productivity

D. Portability

E. All mentioned above

Answer & Solution Discuss in Board

2.

Explicit datatypes, %TYPE and %ROWTYPE, without size specification can be used for parameters in a procedure.

A. True

B. False

Answer & Solution Discuss in Board

3.

Oracle-supplied package called DBMS_LOB is used to manipulate the LOB objects.

A. True

B. False

Answer & Solution Discuss in Board

4.

What is the advantage of using the %ROWTYPE datatype?

A. It is useful to retrieve an entire row from a table. If you do not use the %ROWTYPE datatype, then you have to declare variables for each column separ

B. It can be used even if data type of the table columns is not known.

C. It ensures that data type of the variable changes dynamically if the underlying table is altered.

D. All mentioned above

E. Both A & B

Answer & Solution Discuss in Board

5.

The LOB objects can be stored in-line or out-of-line. The in-line storage means that objects are stored.

A. Along with the row

B. Outside the row

C. Both A & B

D. None of the above

Answer & Solution Discuss in Board

Practice MCQ Questions and answers on PL SQL Interview Questions

1. PL/SQL is a transaction processing procedural language that has which of the following advantages?

Answer & Solution

2. Explicit datatypes, %TYPE and %ROWTYPE, without size specification can be used for parameters in a procedure.

Answer & Solution

3. Oracle-supplied package called DBMS_LOB is used to manipulate the LOB objects.

Answer & Solution

4. What is the advantage of using the %ROWTYPE datatype?

Answer & Solution

5. The LOB objects can be stored in-line or out-of-line. The in-line storage means that objects are stored.

Answer & Solution

Read More Section(Computer Science MCQs)

1.

PL/SQL is a transaction processing procedural language that has which of the following advantages?

2.

Explicit datatypes, %TYPE and %ROWTYPE, without size specification can be used for parameters in a procedure.

3.

Oracle-supplied package called DBMS_LOB is used to manipulate the LOB objects.

4.

What is the advantage of using the %ROWTYPE datatype?

5.

The LOB objects can be stored in-line or out-of-line. The in-line storage means that objects are stored.