PL SQL Interview Questions

Q.  “NO_DATA_FOUND” and “TOO_MANY_ROWS” are the two most common errors found when executing a SELECT statement.

a. True
b. False


ANSWER: See Answer
 
No explanation is available for this question!
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
MCQs:  Pragmas are processed at ___________ .
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which statement chooses from a sequence of conditions, and executes a corresponding statement?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Constructors are functions that return a new object as its value.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  An object type can represent any real-world entity.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which of the following is used for reading and writing operating-system files?
Category: Computer Science MCQs,   Published by: T-Code Scripts