Information Management Prefinals

Which command is used to delete an existing table?

• CLEAR TABLE

• DELETE TABLE

• ERASE TABLE

• DROP TABLE

Which command ensures that a column cannot be empty upon creating a table?

• CHECK

• DEFAULT

• NOT NULL

• UNIQUE

Which command is used to delete an existing database?

• CLEAR DATABASE

• DELETE DATABASE

• ERASE DATABASE

• DROP DATABASE

What does S in SQL stand for?

• Sequenced

• Standard

• Statement

• Structured

Which command sets a default value for a column when there is no value specified?

• CHECK

• DEFAULT

• NOT NULL

• UNIQUE

This command is used to uniquely identify a row in another table.

• CHECK

• DEFAULT

• FOREIGN KEY

• PRIMARY KEY

Which operator is used with WHERE to check whether a value matches any value within a given list?

• BETWEEN

• IN

• IS NULL

• LIKE

Which command is used to modify the columns of an existing table?

• ALTER

• EDIT

• MODIFY

• UPDATE

This command ensures that all the values in a column satisfy a specific condition upon creating a table.

• CHECK

• DEFAULT

• NOT NULL

• UNIQUE

This command ensures that all the values in a column are different upon creating a table.

• CHECK

• DEFAULT

• NOT NULL

• UNIQUE