MIS Final Exam - APPENDIX C (Databases)

Many-to-many relationship between two table in a database requires A. two one-to-many relationships between the table B. an additional table C. a foreign key D. a composite primary key

B. an additional table

SellPhone company offers family plans that allow up to eight devices on the same plan. Each device belongs to only one plan. Which of the following is true about the Plan table and the Device table in the company database? A. PlanID is the primary key in the Plan table and a foreign key in the Device table B. DeviceID is the primary key in the Device table and a foreign key in the Plan table C. There is a junction table in the database with composite primary key including PlanID and DeviceID D. DeviceID is a foreign key in both Plan table and Device table

A. PlanID is the primary key in the Plan table and a foreign key in the Device table

The specific number of possible instances of one entity participating in a relationship is called A. null-valued attribute B. cardinality C. business rule D. composite entity

B. cardinality

A person's age is an example of A. multivalued attribute B. derived attribute C. null-valued attribute D. stored attribute

B. derived value

What is a primary key? A. a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables B. a field that uniquely identifies a given record in a table C. a foreign key of one table that appears as an entity in another table that acts to provide a logical relationship between the two records D. a table that uniquely identifies a given record in a field

B. a field that uniquely identifies a given record in a table

What is a foreign key? A. a field that uniquely identifies a given record in a table B. a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables C. a foreign key of one table that appears as an entity in another table and acts to provide a logical relationship between the two records D. a table that uniquely identifies a given record in a field

B. a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between two tables

What value should be assigned to "Email" attribute for a person who does not have an email address? A. missing value B. null value C. dummy value D. default value

B. null value

SQL is a programming language designed to A. Enforce referential integrity databases B. visualize many-to-many relationships C. create and run queries to tables in databases D. show the content of databases tables to the end users

C. create and run queries to tables in databases

A chart showing relationships between tables in a database environment is called A. relational database model B. data model C. entity-relationship diagram D. database

C. entity-relationship diagram

"One customer may have many stored credit cards" is an example of A. business relational diagram B. attribute C. entity D. business rule

D. business rule

In a movies database, every actor may participate in multiple movies, and each movie features multiple actors. This is an example of A. one-to-many relationship B. composite entity C. one-to-one relationship D. many-to-many relationship

D. many-to-many relationship

When an instance of one entity can be related to only one instance of a related entity, it is called A. one-to-many relationship B. composite entity C. many-to-many relationship D. one-to-one relationship

D. one-to-one relationship