PL SQL Interview Questions

Q.  Which of the following has internal components that can be manipulated individually, such as the elements of an array, record, or table?

a. A Composite
b. A LOB
c. A Reference
d. A Scalar


ANSWER: See Answer
 
No explanation is available for this question!
MCQs:  Which Exception is also known as Oracle named exception handler?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  WRAP command is used to encrypt a PL/SQL application.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which Package lets you use database triggers to alert an application when specific database values change?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  PL/SQL packages are schema objects that group logically related PL/SQL types, variables and subprograms.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which statement lets you create standalone functions that are stored in an Oracle database?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which parameter acts like a constant inside the subprogram?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which of the following is used to define code that is executed / fired when certain actions or event occur?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which Operator Returns TRUE if a subquery returns at least one row?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  How many attributes does every explicit cursor and cursor variable have?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  The DBMS_SQL package should be used in which of the following situations?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  A function called from SQL statements must obey certain rules meant to control side effects.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Collection is an ordered group of elements, all of the same type.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Arrays in other languages become varrays in PL/SQL.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  How many nested IF clauses can be included within an IF clause?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  In PL/SQL, a warning or error condition is called an exception.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which datatypes can be used with a RECORD Type?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  SIGNTYPE lets you restrict an integer variable to the values -1, 0, and 1, which is useful in programming tri-state logic.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Is it possible to define a NOT NULL field in a record?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  PL/SQL keywords are not case-sensitive.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  PL/SQL stands for -
Category: Computer Science MCQs,   Published by: T-Code Scripts