PL SQL Interview Questions


Q.  How many types of literals are available in PL/SQL?

a. 6
b. 2
c. 5
d. 4


ANSWER: See Answer
 
No explanation is available for this question!
MCQs:  The values of any IN OUT parameters are copied before the subprogram is executed.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  PL/SQL provides a feature to handle the Exceptions which occur in a PL/SQL Block known as exception Handling.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which Exception is also known as Oracle named exception handler?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  WRAP command is used to encrypt a PL/SQL application.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which Package lets you use database triggers to alert an application when specific database values change?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  PL/SQL packages are schema objects that group logically related PL/SQL types, variables and subprograms.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which statement lets you create standalone functions that are stored in an Oracle database?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which parameter acts like a constant inside the subprogram?
Category: Computer Science MCQs,   Published by: teswesm
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: teswesm
MCQs:  Which Operator Returns TRUE if a subquery returns at least one row?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  How many attributes does every explicit cursor and cursor variable have?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  The DBMS_SQL package should be used in which of the following situations?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  A function called from SQL statements must obey certain rules meant to control side effects.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Collection is an ordered group of elements, all of the same type.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Arrays in other languages become varrays in PL/SQL.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  How many nested IF clauses can be included within an IF clause?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  In PL/SQL, a warning or error condition is called an exception.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which datatypes can be used with a RECORD Type?
Category: Computer Science MCQs,   Published by: teswesm
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: teswesm
MCQs:  Is it possible to define a NOT NULL field in a record?
Category: Computer Science MCQs,   Published by: teswesm