PL SQL Interview Questions


Q.  Which statement lets you create standalone functions that are stored in an Oracle database?

a. SQL CREATE PROCEDURE
b. SQL CREATE FUNCTION
c. Both A & B
d. None of the above


ANSWER: See Answer
 
No explanation is available for this question!
MCQs:  Which error occurs while the program is running and cannot be detected by the PL/SQL compiler?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which keyword is used instead of the assignment operator to initialize variables?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  PL/SQL programs are written as lines of text using a specific set of characters.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  How many bytes does each character in the AL16UTF16 encoding take up?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  LOB locators are values, which specify the location of the large object.
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:  Oracle predefined errors are not associated with specific error codes.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which of the following cannot be used with associative arrays?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  In the Restrictions on Record Inserts and Updates, which of the following are not supported?
Category: Computer Science MCQs,   Published by: teswesm
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: teswesm
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: teswesm
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