Question 1

Which of the following is not true about the Constructors?

Options :

A : These are functions that return a new object as its value.

B : Every object has a system defined constructor method.

C : The name of the constructor is same as the object type.

D : None of the above.

Answer: D

Question 2

SERVEROUTPUT is enabled.Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

Options :

A :

B :

C :

D :

Answer: D

Question 3

Which of the following is true about PL/SQL nested tables?

Options :

A : Nested tables are like one-dimensional arrays with arbitrary number of elements.

B : Unlike arrays a nested table doesn’t have declared number of elements. The size of a nested table can increase dynamically.

C : Initially a nested array has consecutive subscripts or dense, but it can become sparse when elements are deleted from it.

D : All of the above.

Answer: D

Question 4

Which of the following is true about database transactions?

Options :

A : The SQL statements that constitute a transaction can collectively be either committed, i.e., made permanent to the database or rolled back (undone) from the database

B : A transaction has a beginning and an end.

C : None of the above.

D : Both A and B.

Answer: D

Question 5

What is the statement to remove a procedure from a database?

Options :

A : ALTER PROCEDURE

B : DROP PROCEDURE

C : DELETE PROCEDURE

D : TRUNCATE procedure.

Answer: B