Information Management - QUIZ 05 - SQL 03

The FLOAT data type in SQL is used exclusively for storing integer values.

• True

• False

The CHAR data type is used for storing variable-length character strings.

• True

• False

A PRIMARY KEY can consist of multiple columns in a table.

• True

• False

The BOOLEAN data type stores numerical values like 1 or 0.

• True

• False

The ALTER command is used to retrieve data from tables.

• True

• False

A DECIMAL(5,2) data type can store numbers with up to 5 digits before the decimal point and 2 digits after.

• True

• False

The VARCHAR data type can store strings of unlimited length.

• True

• False

A FOREIGN KEY enforces referential integrity by ensuring that values in one table match those in another.

• True

• False

The TIME data type stores both date and time values.

• True

• False

The DROP command can be used to delete specific rows from a table.

• True

• False