Technology | Practice Questions | Aliensbrain

Multiple choice technology databases

INSERT, UPDATE, DELETE commands when used in a PL/SQL block, should contain INTO clause to hold the data returned by SQL statement

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

IF-THEN-ELSE-ENDIF construct is used for conditional control in a PL/SQL block. What happens if the condition in IF-THEN-ELSE-ENDIF block evaluates to NULL?

The SQL statements in the IF condition are processed.
The SQL statements in the ELSE condition are processed.
IF-THEN-ELSE-ENDIF construct is skipped.
The SQL statements in the IF condition as well as ELSE condition are processed.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Identify the ITERATIVE control constructs in PL/SQL. Choose all that apply

Cursors
Cursor For Loop
Simple Loop
Exit Loop
Numeric For Loop
While Loop

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which ITERATIVE control construct in PL/SQL is also called as INFINITE LOOP?

Cursor For Loop
Numeric For Loop
While Loop
Simple Loop

Reveal answer Fill a bubble to check yourself

Multiple choice technology web technology

STATEMENT LABELS can be used primarily for naming ... Choose all that apply

Loop
IF-THEN-ELSE-ENDIF construct
Block
Exception

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Implicit cursors, process ... Choose all that apply

All INSERT statements
All DELETE statements
All UPDATE statements
Single row SELECT statements
Multiple row SELECT statements
Zero row SELECT statements

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Explicit cursors are used to process multiple row SELECT statements

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Index of numeric for loop always increments by one

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

When dealing with Cursor For Loops, which steps are taken care of implicitly? Choose all that apply

DECLARE
OPEN
FETCH
CLOSE
PROCESS

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Identify the CURSOR attribute that returns the number of rows fetched so far by the cursor?

%FOUND
%NOTFOUND
%ROWCOUNT
%ISOPEN

Reveal answer Fill a bubble to check yourself

Tag: technology

Questions Related to technology