|
MCQs: Subprograms let you extend the PL/SQL language. Which subprogram acts like new expressions and operators?
Category: Computer Science MCQs, Published by: teswesm
|
|
MCQs: In which parameter mode Formal parameter acts like an initialized variable?
Category: Computer Science MCQs, Published by: teswesm
|
|
MCQs: Which attribute returns NULL?
Category: Computer Science MCQs, Published by: teswesm
|
|
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: teswesm
|
|
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: teswesm
|
|
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: teswesm
|
|
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: teswesm
|
|
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: teswesm
|
|
MCQs: Nested tables are a good choice when
Category: Computer Science MCQs, Published by: teswesm
|
|
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
|
