Pl Sql Interview Questions Start Creating PDF

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

1. Along with the row
2. Outside the row
3. Both A & B
4. None of the above

MCQ: What is the advantage of using the %ROWTYPE datatype?

1. 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
2. It can be used even if data type of the table columns is not known.
3. It ensures that data type of the variable changes dynamically if the underlying table is altered.
4. All mentioned above
5. Both A & B

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

1. True
2. False

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

1. True
2. False

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

1. Integration with database
2. Better Performance
3. Higher Productivity
4. Portability
5. All mentioned above

MCQ: Can BOOLEAN datatype be used in functions that are called from SQL statements?

1. Yes
2. No

MCQ: Which data type supports only sequential access of objects?

1. LONG
2. LOB
3. Both A & B
4. None of the above

MCQ: Is it possible to define a CONSTANT value in a record?

1. Yes
2. No

MCQ: Which datatype is used to store large blocks of character data in the database, in-line or out-of-line? Both fixed-width and variable-width character sets are supported.

1. BLOB
2. CLOB
3. BFILE
4. NCLOB

MCQ: A nested cursor is implicitly opened when the containing row is fetched from the parent cursor. The nested cursor is closed in which of the following case(s)?

1. The nested cursor is explicitly closed by the user
2. The parent cursor is re-executed
3. The parent cursor is closed
4. The parent cursor is canceled
5. All mentioned above