True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Two
or more records in a table can have the same value for the Primary Key field.
|
|
|
2.
|
A
Primary Key can be made up of more than one field.
|
|
|
3.
|
Two
or more records in a table can have the same value for the Foreign Key field.
|
|
|
4.
|
In a
one-to-many relationship, the table on the "one" side is called the parent.
|
|
|
5.
|
SQL
is a proprietary Microsoft standard.
|
|
|
6.
|
Most
database systems have a graphical query builder, often called QBE.
|
|
|
7.
|
QBE
can do everything that SQL can do.
|
|
|
8.
|
SQL
can update multiple records in one operation.
|
|
|
9.
|
SQL
grew out of the early pre-relational databases.
|
|
|
10.
|
The
most recent SQL standard was released in 1992.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
11.
|
What
general kind of datatype would be used to hold a person’s street address? a. | numeric | c. | currency | b. | text | d. | yes/no | | | | |
|
|
|
12.
|
What
general kind of datatype would be used to record whether or not a student had a car? a. | numeric | c. | currency | b. | text | d. | yes/no | | | | |
|
|
|
13.
|
Which
of the following cannot be done with SQL? a. | Create tables | c. | Add records | b. | Create table
relationships | d. | None of the
above | | | | |
|
|
|
14.
|
Which
of the following tools provides the ability to build programming right inside the
database? a. | Table | c. | Query | b. | Stored Procedure | d. | View | | | | |
|
|
|
15.
|
Which
of the following tools is a saved query? a. | Table | c. | Query | b. | Stored
Procedure | d. | View | | | | |
|
|
|
16.
|
Which
of the following kinds of databases are not relational? a. | Network | c. | Object-Oriented | b. | Hierarchical | d. | All of the above | | | | |
|
|
|
17.
|
SQL
stands for: a. | Standard Query
Language | c. | Special Query
Language | b. | Structured Query Language | d. | None of the above | | | | |
|
|
|
18.
|
Relational databases have been around since the a. | 1950s | c. | 1970s | b. | 1960s | d. | 1980s | | | | |
|