Answer the following statements true (T) or false (F)

1) A cursor variable is a dynamic cursor that can refer to different SQL statements at different times.
2) An implicit cursor is used when an SQL statement in the PL/SQL block returns
more than one row from the table.
3) The ORDER BY clause is not allowed in the SELECT statement of an explicit
cursor’s declaration.
4) If a cursor FOR loop uses a subquery with the IN clause, there is no need to declare that cursor.
5) A nonpredefined Oracle server error is declared with a PRAGMA EXCEPTION_INIT directive.


1) T
2) F
3) F
4) T
5) T

Computer Science & Information Technology

You might also like to view...

How many elements can be stored in the following array? float salaries [4] [3] [50];

What will be an ideal response?

Computer Science & Information Technology

Which of the following does not complete the sentence correctly?

An interface . a) forces classes that implement it to declare all the interface methods. b) is used in place of an MustInherit class when there is no default implementation to inherit. c) cannot be instantiated. d) can be instantiated.

Computer Science & Information Technology

Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line.  _________________________

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

If you upsample, Photoshop assigns a new color to the pixel based on an average ____.

a. indexing b. concatenation c. interpolation d. losing

Computer Science & Information Technology