Tag: databases

TRUE

FALSE

BOTH

NONE

Scalar

LOB

Reference

host

True

False

CASCADE

UNIQUE

NONUNIQUE

CHECK

PRIMARY KEY

NOT NULL

INSERT

UPDATE

SELECT

DESCRIBE

DELETE

RENAME

the use of rowed

a GROUP BY clause

an ORDER BY clause

only an inline view

an inline view and an outer query

UNIQUE

NOT NULL

CHECK

PRIMARY KEY

FOREIGN KEY

creates a view with constraints

creates a view even if the underlying parent table has constraints

creates a view in another schema even if you don't have privileges

creates a view regardless of whether or not the base tables exist

GRANT select ON dept TO ALL USERS;

GRANT select ON dept TO ALL;

GRANT QUERY ON dept TO ALL USERS;

GRANT select ON dept TO PUBLIC;

A MERGE statement is used to merge the data of one table with data from another

A MERGE statement replaces the data of one table with that of another

A MERGE statement can be used to insert new rows into a table

A MERGE statement can be used to update existing rows in a table