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
|