Database Design Exam Test

Database Design Mid Term Exam

Spring 2020

Name: ____________________________

1. What is a data model?

A. method of storing files on a disk drive

B. simple representation of complex real-world data structures

C. name of system for designing software

D. method of designing invoices for customers

2. A Relationship Database system consists of 3 parts: a client front end for sending information to a command processor, a middle tier that interprets user commands, and a management frame work for storing, organizing and securing data.

a. True

b. False

3. What are the 3 components of a table:

A. Row, column, value

B. Row, top, bottom

C. Column, row, top

D. Top, middle, end

4. What does the column represent in a table?

a. Attribute of the table records

b. A complete record in the table

c. The system log from the database

d. A list of database tables

5. What does a row in the table represent?

a. A complete data record

b. List of system logs

c. A list of file systems on database server

d. The primary keys from all the tables.

6. Which of the following is an example of data definition language (DDL)?

a. UPDATE

b. V$SYSLOG

c. CREATE

d. DETAIN

7 . Which of the following is an example of data manipulation language (DML)?

A. SELECT

B. ABORT

C. GRANT

D. REVOKE

8. A _______ key is an attribute that uniquely identifies a record in a table.

9. A _______ key is an attribute that is a primary key in one table and is used as a reference in a second table to establish a relationship between the two tables.

10. When running a ‘SELECT’ join, what is returned from the table:

A. ROW

B. Column

C. single attribute

D. all tables in the database

11. When running a ‘PROJECT’ join, what is returned from the table:

A. COLUMN

B. ROW

C. Single Attribute

D. a list of tables in the database

12. What are the 3 types of relationships commonly shown on an entity relationship diagram?

A. 1 to 1

B. 1 to Many

C. Many to Many

D. All the above

E. None of the above

13. What is an entity relationship diagram (ERD)?

A. graphical representation of all entities in a database and how the entities are related

b. list of the log files in the database.

C. list of all the tablespace names in a database

D. A diagram that shows how data is written to a physical disk drive.

14. The definition of an attribute in a table that has no value is:

A. ZERO

b. NULL

c. ZILTCH

D. NONE

15. A ____________ attribute can either be stored on retrieve on an ad hoc basis.

16. Briefly describe the advantages and disadvantages of storing a derived attribute?

17. A database can process many types of data classifications. Which of the following is not a data classification or architecture that databases can process:

A. Structured

B. Semi-structured

C. undelimited

D. Unstructured

18. The process by which functional/partial dependency and transitive dependency is removed from a database table is called:

a. sharding

b. normalization

c. defragmentation

d. reallocation

19. A type of database that is used for decision making and business intelligence is what type of database:

a. general purpose database

b. content management database

c. analytical database

d. cloud database

20. All of the following are disadvantages to database systems except which of the choices below:

a. Vendor dependence

b. increased security

c. increased management complexity

d. Frequent upgrade cycles