Object oriented
Block structured
Object structured
All the above
Declaration section
Command line
Executable section
Cannot assign at all
Schema
Index
Views
Segments
True
False
DDL
DML
DCL
None of the above
Primary key access
Access via unique index
Table access by ROWID
Full table scan
Column
1966_Invoices
Catch_#22
#Invoices
TO_CHAR
LOWER
LPAD
CEIL
Declarative
Executable
Exeption handling
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
SELECT LastName>'Hansen' AND LastName'Hansen' AND LastName'Hansen' AND LastName'Hansen' AND LastName
SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName
DELETE FirstName='Peter' FROM Persons
DELETE FROM Persons WHERE FirstName = 'Peter'
DELETE ROW FirstName='Peter' FROM Persons
Cursor CAPITALS is
Select CITY, STATE
Into my_city, my_state
From CITIES
Where CAPITAL = 'Y';
NULL
0
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
When INTO statement is missing in the SELECT statement
TRUE
FALSE
Undefined
NULL
Create or replace function vat (vat_rate IN NUMBER, price IN NUMBER)
Declare
L_vat NUMBER;
Begin
L_vat := (vat_rate/100) * price; return l_vat;
End;