Chapter 9
A(n) ____ is a field or set of fields used to uniquely identify each row. a. primary key b. foreign key c. object identifier d. attribute
a. primary key
Which of the following contains both global and local schemas with distinct DBMSs? a. Decentralized database b. Distributed database c. Heterogeneous distributed database d. Homogeneous distributed database
c. Heterogeneous distributed database
A(n) ____ describes the structure, content, and access controls of a physical data store or database. a. relation b. DBMS c. schema d. attribute
c. schema
Each class on an class diagram is represented by a(n) ____ in a relational database. a. attribute b. row c. table d. column
c. table
Data elements in a relational database are organized into ____. a. attributes b. objects c. tables d. tuples
c. tables
A relational database table is in ____ normal form if no non-key field is functionally dependent on any other non-key field. a. first b. second c. third d. fourth
c. third
____are a critical element of relational database design because they are the bases for representing relationships among tables. a. Keys b. Attributes c. Fields d. Table
a. Keys
Which of the following is NOT a component or function of a typical database management system (DBMS)? a. Low-level process management b. Direct query processor c. Application program interface processor d. Administrative interface
a. Low-level process management
In a many-to-many association, the primary key of the created table consists of which of the following? a. The primary keys of the associated tables b. An invented key with computer generated values c. The foreign keys of the associated tables d. Does not need a key field
a. The primary keys of the associated tables
A database lock that does not allow another user to update the data is called what? a. Write lock b. Shared lock c. Transaction lock d. Database lock
a. Write lock
One column of a table in a relational database is called a(n) ____. a. attribute b. relation c. tuple d. element
a. attribute
All ____ in a table are guaranteed to be unique if the table's primary key is guaranteed to be unique. a. columns b. foreign keys c. rows d. values
a. columns
A relational database table is in ____ normal form if it has no repeating fields or groups of fields, and hence all rows have the same columns. a. first b. second c. third d. fourth
a. first
An a relational database, a row can be referred to as a(n) ____. a. field b. tuple c. attribute d. relation
b. tuple
Microsoft SQL Server is an example of what? a. An application server b. A database management system c. A programming language compiler d. A Web server
b. A database management system
What can be said about the following relational database table (key is underlined): (Choose the most correct answer.) CourseSectionID, StudentID, Grade, StudentName a. Not in any valid normal form b. In First Normal Form c. In First and Second Normal Form d. In First, Second, and Third Normal Form
b. In First Normal Form
Referential integrity is normally enforced by the ____. a. application programmer b. database management system c. operating system d. user
b. database management system
A(n) ____ is a field or set of fields stored in one table that also exists as a primary key in another table. a. primary key b. foreign key c. object identifier d. candidate key
b. foreign key
In a distributed database when the data is divided so that separate columns of the same table are at distinct locations that is referred to as _________. a. data replication b. horizontal partitioning c. vertical partitioning d. synchronization
b. horizontal partitioning
In a distributed database when the data is divided so that separate rows of the same table are at distinct locations that is referred to as _________. a. data replication b. horizontal partitioning c. vertical partitioning d. synchronization
b. horizontal partitioning c. vertical partitioning?????
A relational database table is in ____ normal form if every non-key field is functionally dependent on the primary key. a. first b. second c. third d. fourth
b. second
What can be said about the following relational database table (key is underlined): (Choose the most correct answer) StudentID, Name, Major, CreditsCompleted, GPA, AcademicStanding a. Not in any valid normal form b. In First Normal Form c. In First and Second Normal Form d. In First, Second, and Third Normal Form
c. In First and Second Normal Form
A separate relation must be created to store the attributes of a ____ relationship among two other classes. a. one-to-one b. one-to-many c. many-to-many d. not any (not necessary
c. many-to-many
Which is NOT one of the responsibilities of the database administrator? a. Backup the database b. Do performance tuning c. Set up user authentication d. Determine data confidentiality
d. Determine data confidentiality
Which is not one of the responsibilities of the DA? a. Provide data naming standards b. Keep track of who owns the data c. Set up standards for data validation d. Establish user authentication for data access
d. Establish user authentication for data access
___Is where the value in one field determines the value in another field in the same record. a. First normal form b. Second normal form c. Referential integrity d. Functional dependency
d. Functional dependency
___Is a consistent relational database state in which every foreign key value also exists as a primary key value. a. First normal form (1NF) b. Database synchronization c. Function dependency d. Referential integrity
d. Referential integrity
A field in a relational table called "address" would be an example of what? a. candidate data type b. primitive data type c. compound data type d. complex data type
d. complex data type
Which of the following is not a synonym of the others? a. row b. Tuple c. record d. field
d. field
Which of the following is not a synonym of the others? a. column b. attribute c. field d. tuple
d. tuple
