PL SQL Interview Questions

Q.  The DBMS_SQL package should be used in which of the following situations?

a. 15. There is an unknown number of input or output variables, such as the number of column values returned by a query, that are used in a dynamic SQL s
b. The dynamic code is too large to fit inside a 32K bytes VARCHAR2 variable.
c. Both A & B
d. None of the above


ANSWER: See Answer
 
No explanation is available for this question!
MCQs:  Which statements execute a sequence of statements multiple times?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Oracle predefined errors are not associated with specific error codes.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which of the following cannot be used with associative arrays?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  In the Restrictions on Record Inserts and Updates, which of the following are not supported?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  By using which clause, the mode is OUT, so you cannot specify a parameter mode for output bind arguments?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  You can use the BULK COLLECT INTO clause with the EXECUTE IMMEDIATE statement to store values from each column of a query's result set in a separate collection.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which of the following returns all distinct rows selected by either query?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which statements are used to control a cursor variable?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  What is the maximum number of triggers that can apply to a single table?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  The variables or expressions passed from the calling subprogram are -
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Subprograms are named PL/SQL blocks that can be called with a set of parameters.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which of the following is not a schema object?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which package lets PL/SQL programs read and write operating system (OS) text files?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  You can pass parameters to procedures or functions in a package.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  When creating a function, in which section will you typically find a return key word?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which of the following returns the current error message text?
Category: Computer Science MCQs,   Published by: T-Code Scripts
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: T-Code Scripts
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: T-Code Scripts
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: T-Code Scripts
MCQs:  The AUTONOMOUS_TRANSACTION pragma changes the way a subprogram works within a transaction.
Category: Computer Science MCQs,   Published by: T-Code Scripts