PL SQL Interview Questions

Q.  Which keyword is used instead of the assignment operator to initialize variables?

a. NOT NULL
b. DEFAULT
c. %TYPE
d. %ROWTYPE


ANSWER: See Answer
 
No explanation is available for this question!
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
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: T-Code Scripts
MCQs:  Which statements execute a sequence of statements multiple times?
Category: Computer Science MCQs,   Published by: T-Code Scripts
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: T-Code Scripts
MCQs:  The comparison methods are used for comparing objects. How many ways are available for comparing objects?
Category: Computer Science MCQs,   Published by: T-Code Scripts
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: T-Code Scripts
MCQs:  For a user-defined exception, SQLCODE returns 1, and SQLERRM returns ___________.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which of the following is handled with the help of exception-handling section in an PL/SQL block. For eg, SELECT INTO statement, which does not return any rows.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  A package will have which of these mandatory parts?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which collection method Returns the index number that precedes index n in a collection?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Subprograms let you extend the PL/SQL language. Which subprogram acts like new expressions and operators?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  In which parameter mode Formal parameter acts like an initialized variable?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which attribute returns NULL?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  With PL/SQL, it is very simple to issue a query, retrieve each row of the result into a %ROWTYPE record, and process each row in a loop.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  You can use the BULK COLLECT INTO clause with the FETCH statement to store values from each column of a cursor in a separate collection.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  To process most dynamic SQL statements, you use the EXECUTE IMMEDIATE statement. To process a multi-row query (SELECT statement), which of these statements would you use?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  You can use the RETURNING BULK COLLECT INTO clause with the EXECUTE IMMEDIATE statement to store the results of which statements in a set of collections?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which of the following is a group of related data items stored in fields, each with its own name and datatype?
Category: Computer Science MCQs,   Published by: T-Code Scripts