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
|
MCQs: Which operations cannot be performed on cursor expressions?
Category: Computer Science MCQs, Published by: teswesm
|
MCQs: Cursor attributes are not affected by autonomous transactions.
Category: Computer Science MCQs, Published by: teswesm
|
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: teswesm
|
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: teswesm
|
MCQs: In which subprogram a RETURN statement does not return a value and so cannot contain an expression?
Category: Computer Science MCQs, Published by: teswesm
|
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: teswesm
|
MCQs: The constructs of a procedure, function or a package are ________ .
Category: Computer Science MCQs, Published by: teswesm
|
MCQs: Any subprogram not in the package specification but coded in the package body is called a ___________ .
Category: Computer Science MCQs, Published by: teswesm
|
MCQs: Which of the following are the advantages of PL/SQL Packages?
Category: Computer Science MCQs, Published by: teswesm
|
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: teswesm
|