3.1 & 3.2 TestOut Review

Which of the following should not be used as a primary key in a table?

• First Name

• Social Security number

• Username

• Employee ID

In a relational database table, rows are better known as ______________ .

• fields

• records

• instances

• categories

In a relational database table, columns are better known as ________________ .

• Instances

• Records

• Categories

• Fields

A value that's used to identify a record from a linked table is called a ____________ .

• Foreign Key

• Borrowed Key

• Primary Key

• Linked Key

Which of the following database features would provide a formatted, easy-to-read listing of the results of a query?

• Form

• SQL command

• Record

• Report

A NOT NULL ________________ is a rule that prevents certain fields in a database from being left blank.

• schema

• scalability

• query builder

• constraint

Marty, a database administrator, has added a foreign key to a table in a database. Which of the following describes the purpose of a foreign key?

• For one database to reference another database.

• For one table to reference records in another table.

• To provide a way to distinguish records within a table.

• To allow the storage of unstructured data.

A database administrator wants to export all the data in a database to a comma separated value (.CSV) where it can be opened by spreadsheet software. Which of the following would be the EASIEST way to create the exported file?

• Transact SQL

• SQL query

• Database dump

• Database form

A database administrator wants to export a table as a backup before changes are made to the table structure. Whcich of the following commands should be executed?

• SELECT

• BACKUP

• ALTER TABLE

• UPDATE

Which of the following SQL commands would you use to delete an entire table and all of its data?

• DROP

• UPDATE

• DELETE

• ALTER TABLE