Multiple choice questions. . .
One
Two
Three
All the above
TO_CHAR
LOWER
LPAD
CEIL
03-NOV-00
10-NOV-00
28-NOV-00
17-NOV-00
NULL
0
Results in a compilation error
An exception will be raised
True
False
Undefined
Null
When a SELECT statement returns no rows
When a SELECT statement returns more than one row
When the datatypes of SELECT clause and INTO clause do not match
Header
Declarative
Executable
Exception
Limits the column data that are returned
Limits the row data are returned
Both A and B are correct.
Neither a or b is correct
You do not create them with SQL
They execute against only some applications that access a database
They have an event, condition, and action
They cannot cascade (cause another trigger to fire).
Cursor CAPITALS is
Select CITY, STATE
Into my_city, my_state
From CITIES
Where CAPITAL = 'Y'
There are no errors in these statements