PL SQL Interview Questions


Q.  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.

a. out-bind
b. in-bind
c. define
d. None of the above


ANSWER: See Answer
 
No explanation is available for this question!
MCQs:  Associative arrays also known as index-by tables.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which type of cursor is automatically declared by Oracle every time an SQL statement is executed?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  An Explicit cursor is defined by the program for any query that returns more than one row of data.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  To handle raised exceptions, you write separate routines called exception handlers.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  What are the different datatypes that can be defined in a PL/SQL block?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  The BINARY_INTEGER and PLS_INTEGER datatypes are not identical.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which of the following results are true, when a ROLLBACK statement is issued to the database, the transaction has ended?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  PL/SQL Expressions are constructed using.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which of the following are used for displaying output on a web page?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Like all identifiers, the names of constants, variables, and parameters are case sensitive.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Cursor attributes are not affected by autonomous transactions.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  How many bytes does each character in the UTF8 encoding take up?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Use the ROWID datatype only for backward compatibility with old applications. For new applications, use the UROWID datatype.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which datatype is not allowed in the definition of PL/SQL record?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is raised when no rows satisfy the SELECT criteria?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which collection types is also known as index-by tables, lets you look up elements using arbitrary numbers and strings for subscript values?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Assigning a value to a collection element can cause exceptions, such as
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Nested tables can be sparse: you can delete arbitrary elements, rather than just removing an item from the end.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which of the following retains duplicate rows in the result of a query or in an aggregate expression?
Category: Computer Science MCQs,   Published by: teswesm