DOWN

LOW

MIN

LOWER

returns all rows that have matching value in the field on which the 2 tables are joined.

returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined.

returns all rows from 2 tables.

returns all the matching rows from 2 tables.

DISTINCTIVE

DIFFERENT

DISTINCT

UNIQUE

There is no default value.

DESC

ASC

Random

An index is a database table attribute, which speeds-up data search within a table.

An index is the same as alias.

An index is a special way to join 2 or more tables.

An index is a database row attribute, which speeds-up data search within a table.

Access. Consistency. Isolation. Data.

Access. Constraint. Index. Data.

Access. Constant. Information. Data.

Atomicity. Consistency. Isolation. Durability.

TRUNCATE Sales TABLE

TRUNCATE * FROM TABLE Sales

TRUNCATE TABLE Sales

TRUNCATE * FROM COLUMN Sales

Is used with the DISTINCT SQL keyword only.

Is used with the INSERT SQL keyword only.

Determines if a value matches any of the values in a list or a sub-query.

Defines the tables we are selecting or deleting data from.

UPDATE statements only.

INSERT statements only.

DELETE statements only.

UPDATE, DELETE, INSERT and SELECT statements.

WHERE clause.

ORDER BY clause.

JOIN clause.

GROUP BY clause.