PL SQL Interview Questions

Q.  Which collection method Returns the index number that precedes index n in a collection?

a. PRIOR(n)
b. LAST
c. LIMIT
d. COUNT


ANSWER: See Answer
 
No explanation is available for this question!
MCQs:  How many bytes does each character in the UTF8 encoding take up?
Category: Computer Science MCQs,   Published by: T-Code Scripts
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: T-Code Scripts
MCQs:  Which datatype is not allowed in the definition of PL/SQL record?
Category: Computer Science MCQs,   Published by: T-Code Scripts
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: T-Code Scripts
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: T-Code Scripts
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: T-Code Scripts
MCQs:  Assigning a value to a collection element can cause exceptions, such as
Category: Computer Science MCQs,   Published by: T-Code Scripts
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: T-Code Scripts
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: T-Code Scripts
MCQs:  Which operations cannot be performed on cursor expressions?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Cursor attributes are not affected by autonomous transactions.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  PL/SQL has two types of subprograms, procedures and functions. Which subprogram is used to compute a value?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which is a procedural extension of Oracle- SQL that offers language constructs similar to those in imperative programming languages?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  In which subprogram a RETURN statement does not return a value and so cannot contain an expression?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which of the following combines the data manipulating power of SQL with the data processing power of Procedural languages?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  The constructs of a procedure, function or a package are ________ .
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Any subprogram not in the package specification but coded in the package body is called a ___________ .
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which of the following are the advantages of PL/SQL Packages?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  In internal exception oracle raises the exception for you implicitly. You still need to declare the exception and handle it, but you don’t need to raise it.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which PL/SQL warning categories gives Messages for conditions that do not have an effect on performance or correctness, but that you might want to change to make the code more maintainable, such as unreachable code that can never be executed?
Category: Computer Science MCQs,   Published by: T-Code Scripts