All the above
Results in a compilation error
An exception will be raised
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
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
Where CAPITAL = 'Y'
There are no errors in these statements