DATA BASE JEOPARDY

1

100

What does the Drop statement do?

Removes an object from the database

200

Name all the DML statements.

Select, Insert, Update, Delete, & Merge

300

Which keyword can be used in a create table statement?

d. UNIQUE

400

Data in a database is stored in:

Tables

500

You work at a coffee shop. They ask you to set up a website that stores charges on purchases. You need to recommend a data type in a database table to run financial functions against the charged amounts. Which data type should you recommend?

Varchar

2

100

Select is a _______ command.

DML

200

Name 4 the DDL statements.

Use, Create, Alter, & Drop

300

You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?

INTEGER

400

You need to establish a set of permissions that you can routinely assign to new users. What should you create?

Role

500

You develop a database to store data about textbooks. The data must be stored to process at a later time.Which database object should you use to store the data?

Stored procedure

3

100

What Statement can remove rows from a table or view?

Delete

200

What is DDL a subset of?

Transact-SQL language.

300

You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used. Which data type should you use?

VARCHAR (30)

400

Which database term is used to describe the process of applying a backup to a damaged or corrupt database?

Restore

500

On which database structure does an insert statement operate?

Table

4

100

What does DDL stand for?

Data Definition Language

200

Which key uniquely identifies a row in a table? Which key uniquely identifies a row in a table?

Primary

300

Which permission does a user need in order to run a stored procedure?

EXECUTE

400

One difference between a function and a stored procedure is that a function:

Must return a value.

500

Which statement should you use to remove a foreign key?

ALTER TABLE

5

100

What does DML stand for?

Data Manipulation Language

200

You need to enable a new employee to authenticate to your database. Which command should you use?

CREATE USER

300

Which constraint ensures a unique value in the ID column for each customer?

PRIMARY KEY

400

You need to retrieve data from two related database tables based on a column that exists in both tables. Which command should you use in a query?

UNION

500

You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:

Cascade delete