Intro to Database Midterm Practice Exam

How many tables make up the KimTay database?

5

In general, when designing tables, which type of structure is most preferable?

Simple

Information about the services requested by StayWell residents is stored in the _____ table.

SERVICE_REQUEST

The KimTay database stores several items for each customer's invoice, including the _____.

Invoice date

The KimTay database must combine data from all of its tables in order to print a(n) _____.

Invoice

KimTay's database allows sales reps to sell the same item for different prices by _____.

including a QUOTED_PRICE column in the INVOICE_LINE table

In the StayWell database, each rental property is identified by _____.

A unique integer

Combining the INVOICE_LINE and INVOICES tables in the KimTay database will _____.

make the table more complicated

StayWell rents out and helps to maintain _____.

one-to-five bedroom properties

A property of an entity is _____.

an attribute

In a relational database, _____.

each row should be unique

The duplication of data is formally called _____.

redundancy

One of the categories of update anomalies is _____.

inconsistant data

Suppose you have a table with a primary key composed of two columns. When another column in this table is dependent on only one of the two columns in the primary key, this poses a risk for _____.

update anomalies

In an entity-relationship (E-R) diagram, tables are represented by _____.

Rectangles

When the commonly accepted shorthand representation is used to describe a database, _____.

it is always acceptable to qualify column names

A relational database _____.

consists of tables called relations

Why have Social Security numbers traditionally been used as primary keys for database tables that store personal data on individual people?

All other columns in such a table are functionally dependent on the Social Security number column.

Which statement regarding primary keys is true?

Some tables include more than one column that can be used as a primary key.

In the following shorthand representation of a database, the underlined items are _____.

primary keys

When you are designing a database, _____.

you might be able to determine the relationships between tables directly from the requirements

When you convert an unnormalized table to a table in first normal form, the primary key of the table in first normal form _____.

is usually the primary key of the unnormalized table concatenated with the key for the repeating group

A table in second normal form should be improved to third normal form because _____.

its determinants can cause update anomalies

Within an entity-relationship diagram, which of the following would indicate that the relationship between A and B is one (A) to many (B)?

A line drawn from rectangle A ends in a crow's foot at rectangle B.

SQL was developed in the mid-____.

1970s

What was the original name for SQL?

SEQUEL

It is recommended that table names be limited to _____.

30 characters

Which of the following is a valid name for a table?

TBL_1

You indicate the end of a SQL command by typing a ____.

semicolon

Which SQL command do you use to remove an entire row from a table?

DELETE

Which data type should you use for columns that contain letters and special characters or numbers that will not be used in calculations?

CHAR

Which of the following SQL commands changes the value in the column LAST_NAME within the row containing a REP_ID of 007?

UPDATE SALES_REP SET LAST_NAME = 'Bond' WHERE REP_ID = '007';

A MySQL database includes a CUSTOMER table, which stores each customer's current balance in U.S. dollars and cents, among other information. The correct data type for the BALANCE column in the CUSTOMER table is _____.

DECIMAL

When a script file contains more than one command, each command must end with a(n) _____.

semicolon

Which MySQL command do you use to define a table’s structure by listing its columns, data types, and column lengths?

CREATE TABLE

What special value is used in SQL to represent cases in which an actual value is unknown, unavailable, or not applicable?

null

Which SQL command is used to add rows to a table once its structure has been defined?

INSERT

When you add a row for which you have incomplete information to a SQL table, _____.

you use the INSERT command and name the columns for which you are entering data

Which SQL command is used to view the data in a table?

SELECT

What SQL command do you use to query a database?

SELECT

In the SELECT clause, you can indicate that you want to include all columns using the _____.

* Symbol

Preceding a condition with which SQL operator reverses the truth of the original condition?

NOT

Which of the following operators can be used for a column computation?

+

Which operator uses one or more wildcard characters to test for a pattern match?

LIKE

Mallory would like to display the rows from a MySQL table that have "Red," "Pink," or "White" in the COLOR column. A concise way of writing her query would be to use a(n) _____.

IN clause

When you need to sort data on two columns, the less important column is called the _____.

minor sort key

Which function calculates a total of the values in a column?

SUM

Which clause lets you group data on a particular column?

GROUP BY

Which operator finds rows that do not contain a null value in the specified column?

IS NOT NULL

Adding a ORDER BY UNIT_PRICE clause to a SQL query will _____.

display the results in ascending order by UNIT_PRICE

Which MySQL clause used with the query SELECT* FROM PACKAGE would be the most likely to yield the following results?

ORDER BY PRICE DESC, PACKAGE_NAME

When a subquery is used in a SQL statement _____.

the subquery is evaluated first

What does the following SQL query do?

SELECT INVOICE_NUM FROM INVOICE_LINE WHERE PROD_CODE IN (SELECT PROD_CODE FROM PRODUCTS WHERE (PROD_TYPE = 'Cupcake'));

lists the invoice numbers for invoices containing line items with a "Cupcake" product type

When you need to find rows with null values in a MySQL table, you can use the _____.

IS NULL operator