Implicit Cursors are created by users in PL/SQL block.
True
False
Oracle engine creates Cursors for every SELECT statements.
There are 4 attributes of Cursor variables
Explicit Cursors need to be opened in DECLARE section.
Which SQL keyword is used to retrieve a minimum value?
MIN
LOW
DOWN
LOWER
The table rows are also known as...
Records
Fields
Attributes
Cardinality
What is the ABS SQL function used for?
To return the absolute, positive value of a numeric expression.
To return the average value of a numeric expression.
To return the maximum value of a numeric expression.
To return the minimum value of a numeric expression.
Which SQL keyword is used to retrieve only unique values?
DISTINCTIVE
UNIQUE
DISTINCT
DIFFERENT
What does DML stand for?
Data Mode Lane
Data Manipulation language
Data Model Language
Different Mode Level
Which of the following commands is used to delete data from a SQL database table?
DELETE
UNION
SELECT
INSERT