BUAN 6320 QUIZ 1
If X is a foreign key of table T referencing the same table T's primary key A, then X must be unique. -
correct answer ✔✔true
For each column in a table, the ___________________ defines a set of values and permissible
operations on those values. - correct answer ✔✔data type
A language such as SQL allowing the user to specify the parts of a database rather than to code a
complex procedure is called a nonprocedural database language. - correct answer ✔✔True
Which one of the following is the least likely to be viewed as a transaction?
a. Retrieving a customer's latest purchase correct
b. Transferring $1000 from a customer's savings account to the customer's checking account
c. Reserving a seat on a planed.
d. Reserving a hotel room
e. None of the above - correct answer ✔✔a. Retrieving a customer's latest purchase correct.
A database is said to be shared when multiple users can access the same database for multiple uses, but
must take turns accessing the database. - correct answer ✔✔false
don't need to take turns
Data is said to be persistent when it resides on stable storage and is never removed or archived for the
life of the business. - correct answer ✔✔false
-should be removed/archived
To ensure that a database contains valid connections, the _____________________ rule states that the
values of columns in one table must match the values of columns in other tables. - correct answer
✔✔none of the above
referential integrity - must match values of columns in SOURCE table.
If X is a foreign key of table T referencing the same table T's primary key A, then X must be unique. -
correct answer ✔✔true
For each column in a table, the ___________________ defines a set of values and permissible
operations on those values. - correct answer ✔✔data type
A language such as SQL allowing the user to specify the parts of a database rather than to code a
complex procedure is called a nonprocedural database language. - correct answer ✔✔True
Which one of the following is the least likely to be viewed as a transaction?
a. Retrieving a customer's latest purchase correct
b. Transferring $1000 from a customer's savings account to the customer's checking account
c. Reserving a seat on a planed.
d. Reserving a hotel room
e. None of the above - correct answer ✔✔a. Retrieving a customer's latest purchase correct.
A database is said to be shared when multiple users can access the same database for multiple uses, but
must take turns accessing the database. - correct answer ✔✔false
don't need to take turns
Data is said to be persistent when it resides on stable storage and is never removed or archived for the
life of the business. - correct answer ✔✔false
-should be removed/archived
To ensure that a database contains valid connections, the _____________________ rule states that the
values of columns in one table must match the values of columns in other tables. - correct answer
✔✔none of the above
referential integrity - must match values of columns in SOURCE table.
