BUSN.10139 - Test #1

The current model being used for databases is the Relational Model. Which model(s) preceded this?

• Predictive Model
• Network Model
• Dimensional Model
• Adaptive Model
• Hierarchical Model

A database is a collection of related ______?

• Files
• Tables
• Records
• Relations

What type of key is used to uniquely identify a record in another table?

• Primary key
• Foreign key
• Composite key
• Unique key

The Relational Database Model allows any table to be related to another table using a common attribute.

• True
• False

Which of the following best describes a one-to-one relationship in a database?

• One table is related to many other tables.
• One row in a table is related to only one row in another table.
• Multiple rows in one table relate to multiple rows in another table.
• One table is not related to any other table.

Data about attributes of an entity are contained in _____?

• Rows
• Cells
• Columns
• Data store

Which of the following is NOT a type of relationship in database management?

• Mandatory Relationships
• Optional Relationships
• Composite Relationship
• Recursive Relationships

Select the following which are characteristics of a relation:

• Rows contain data about an entity.
• No two rows may hold identical sets of data values.
• The order of the columns is unimportant.
• All entries in a column are of the same kind.
• All of the above.

Is MS Access a type of database ?

• True
• False

Which of the following is a function of a Database Management System (DBMS)?

• Browsing the internet
• Creating, processing, and administering databases
• Designing user interfaces
• Printing documents