Tag: databases

Questions Related to databases

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

  1. Cursors

  2. Cursor For Loop

  3. Simple Loop

  4. Exit Loop

  5. Numeric For Loop

  6. While Loop

Show answer
Correct Option: B,C,E,F

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

  1. Cursor For Loop

  2. Numeric For Loop

  3. While Loop

  4. Simple Loop

Show answer
Correct Option: D

Implicit cursors, process ... Choose all that apply
technology databases

  1. All INSERT statements

  2. All DELETE statements

  3. All UPDATE statements

  4. Single row SELECT statements

  5. Multiple row SELECT statements

  6. Zero row SELECT statements

Show answer
Correct Option: A,B,C,D

Explicit cursors are used to process multiple row SELECT statements

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Index of numeric for loop always increments by one

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

  1. DECLARE

  2. OPEN

  3. FETCH

  4. CLOSE

  5. PROCESS

Show answer
Correct Option: B,C,D

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

technology databases

  1. %FOUND

  2. %NOTFOUND

  3. %ROWCOUNT

  4. %ISOPEN

Show answer
Correct Option: C

Identify the CURSOR attribute that evaluates to TRUE if cursor returns at least 1 row?
technology databases

  1. %FOUND

  2. %NOTFOUND

  3. %ROWCOUNT

  4. %ISOPEN

Show answer
Correct Option: A

Identify the CURSOR attribute that evaluates to FALSE if cursor returns at least 1 row?

technology databases

  1. %FOUND

  2. %NOTFOUND

  3. %ROWCOUNT

  4. %ISOPEN

Show answer
Correct Option: B

Identify the CURSOR attribute that evaluates to TRUE if cursor is OPEN?
technology databases

  1. %FOUND

  2. %NOTFOUND

  3. %ROWCOUNT

  4. %ISOPEN

Show answer
Correct Option: D