PL SQL Interview Questions


Q.  Which datatypes can be used with a RECORD Type?

a. NUMBER,VRCHAR2
b. %TYPE,OR %ROWTYPE
c. REF,CURSOR
d. BOTH A & B
e. BOTH B & C


ANSWER: See Answer
 
No explanation is available for this question!
MCQs:  Which of the following returns all distinct rows selected by either query?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which statements are used to control a cursor variable?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  What is the maximum number of triggers that can apply to a single table?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  The variables or expressions passed from the calling subprogram are -
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Subprograms are named PL/SQL blocks that can be called with a set of parameters.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which of the following is not a schema object?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which package lets PL/SQL programs read and write operating system (OS) text files?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  You can pass parameters to procedures or functions in a package.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  When creating a function, in which section will you typically find a return key word?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which of the following returns the current error message text?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which datatypes are PL/SQL-only datatypes that are more efficient than the SQL datatypes NUMBER or INTEGER for integer arithmetic?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  In which binding operation a database value is assigned to a PL/SQL variable or a host variable by the RETURNING clause of an INSERT, UPDATE, or DELETE statement.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which datatypes make it practical to write PL/SQL programs to do number-crunching, for scientific applications involving floating-point calculations.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  The AUTONOMOUS_TRANSACTION pragma changes the way a subprogram works within a transaction.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  __________ is a numeric expression that must return a value of type PLS_INTEGER,BINARY_INTEGER, or a value implicitly convertible to that datatype.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which statements execute a sequence of statements multiple times?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which methods implement some internal logic for comparing two objects? For example, a rectangle is bigger than another rectangle if both its sides are bigger.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  The comparison methods are used for comparing objects. How many ways are available for comparing objects?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  When implementing methods using PL/SQL, you cannot call a base or supertype object method with the super keyword or an equivalent method in a derived object.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  For a user-defined exception, SQLCODE returns 1, and SQLERRM returns ___________.
Category: Computer Science MCQs,   Published by: teswesm