DATABASE DESIGN USING NORMALIZATION QUIZ

To establish a range of values, < and > can be used.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL keyword BETWEEN is used:

as a wildcard.

to limit the columns displayed.

None of these

for ranges.

TRUE ANSWER : ?
YOUR ANSWER : ?

Which SQL keyword is used to retrieve only unique values?

DISTINCT

UNIQUE

DISTINCTIVE

DIFFERENT

TRUE ANSWER : ?
YOUR ANSWER : ?

Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

What operator tests column for the absence of data?

EXISTS operator

IS NULL operator

None of these

NOT operator

TRUE ANSWER : ?
YOUR ANSWER : ?

The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which SQL statement is used to delete data FROM a database?

DELETE

ALTER

COLLAPSE

REMOVE

TRUE ANSWER : ?
YOUR ANSWER : ?

The result of every SQL query is a table.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which SQL keyword is used to sort the result-set?

SORT BY

ORDER BY

SORT

ORDER

TRUE ANSWER : ?
YOUR ANSWER : ?

↑