Question 1. Which of the following is an example of an entity in a business?
Company
Business owner
CEO
Employees
Question 2. Which of the following is NOT a step in the Database Life Cycle?
Database Design
Maintenance and Redevelopment
Performance
Testing
Question 3. Conceptual design refers to
developing a database model that will support company operations.
focusing on understanding the business and its functional areas or business processes.
selecting the specific hardware characteristics based on data storage and data access requirements.
the process of converting your ERD into tables, and defining your rows and columns based your entities and attributes.
Question 4. All of the following should be considered in designing a relational database EXCEPT
compliance with PNPI regulations.
design for safety with redundant data.
design your database for 100-year usage.
store data in its smallest parts.
Question 5. All of the following describe a many-to-many relationship in Access EXCEPT
a junction (associative) table is used.
many matching records are found in each direction between tables.
may be used to connect to Oracle and other databases.
there must be at least two tables.
Question 6. A primary key
can be computer generated.
consists of one field only that uniquely identifies each record in a table.
is a relationship between two or more tables.
All of the above.
Question 7. Data validation refers to
a set of constraints that helps control illegal data entry.
correcting data errors after they are entered into a table.
duplicating a primary key in a table.
typing data accurately into a table.
Question 8. To which of the following does the term cascading refer?
Data changes travel from one table to another.
Data is put in sequential order.
Queries can retrieve data at a faster rate.
Records are arranged in order.
Question 9. Which of the following is NOT true of a birth date field?
A birth date is considered a constant.
A birth date would be defined as a date/time field.
The Age field is the same as a birth date field.
Date arithmetic can be applied to a birth date field.
Question 10. Which statement is true when referential integrity is enforced?
It is an automatic option in every table design.
Access checks the accuracy of spelling in the tables.
Insures data can be entered into a related table even if it does not exist in the primary table.
A record will not be added to the table if an ID that is referenced does not exist.