Information Management-MidQuiz

Which key attribute is used to establish relationships between entities in a relational database?

• Candidate key

• Primary key

• Foreign key

• Alternate key

A key attribute that consists of two or more attributes used together to uniquely identify records.

• Composite key

• Primary key

• Candidate key

• Foreign key

Which data integrity constraint enforces that values in a column must be unique but allows for NULL values?

• Not null constraint

• Unique Constraint

• Null constraint

• Data Redundancy

What does SQL stand for?

• Strong Question Language

• Structured Question Language

• Structured Query Language

• Strong Query Language

What does the SQL DROP TABLE statement do?

• Deletes a table and all its data from the database

• Renames an existing table

• Copies a table and its data to a new table

• Clones a table

Which one of the following sorts rows in SQL?

• ALIGN BY

• ORDER BY

• SORT BY

• GROUP BY

Which SQL statement is used to add new record in a database?

• INSERT NEW

• ADD NEW

• INSERT INTO

• ADD RECORD

The result of a SQL SELECT statement is a ______.

• FILE

• REPORT

• FORM

• TABLE

In SQL, how do you select a column named "FirstName" from a table named Student?

• SELECT Student.FirstName

• EXTRACT FirstName FROM Student

• SELECT FirstName FROM Student

• SELECT Student FROM FirstName

Which operator performs pattern matching?

• BETWEEN

• LIKE

• EXISTS

• OR