DBMS_B1_18032020

which of the following is true about implicit cursors?

• Implicit cursors are used for SQL statements that are not named.

• developers should use implicit cursors with great care

• implicit cursors are used in cursor for loop for data processing

• Implicit cursors are no longer a feature of ORACLE

which of the following is not a feature of cursor for loop?

• ROWTYPE type declaration

• opening and parsing of SQL statments

• Fetching of records from cursor

• requires exit condition to be defined.

A developer would like to use referential datatype declaration on a variable. The variable name is EMPLOYEE_LASTNAME, and the corresponding table and column is EMPLOYEE, and LNAME, respectively. How would the developer define this variable using referential datatypes?

• Use EMPLOYEE.LNAME%TYPE.

• Use EMPLOYEE.LNAME%ROWTYPE.

• Look up datatype for EMPLOYEE column on LASTNAME table and use that.

• Declare it to be type LONG.

The command used to open a CURSOR FOR loop is

• open

• fetch

• parse

• None, cursor for loops handle cursor opening implicitly.

As a procedural language by definition, PL/SQL provides several iteration constructs, including basic LOOP statements, WHILE loops, ________, and Cursor FOR loops.

• Imperative programming

• Programming language

• Control flow

• For loop

Find the ODD one out of the following

• OPEN

• CLOSE

• INSERT

• FETCH

What is the Result of the following 'VIK'||NULL||'RAM' ?

• Error

• VIK RAM

• VIKRAM

• NULL

declare

a number := 5; b number := null; c number := 10;

begin

if a > b AND a < c then

a := c * a;

end if;

end;

What will be the value of 'a' after execution ?

• 50

• NULL

• 5

• None of the above

All LOOP statements in PL/SQL must end with a _________statement

• end loop

• end;

• end loop;

• end

The ________ statement retrieves the rows from the active data set opened in the server.

• retrieve

• get

• fetch