8/4/2019 CIS-311

1/4

DATABASE MANAGEMENT

Basic concepts of database systems: types of database systems; design and implementation of relational databases;

data protection; database management and administration; SQL. (3 s.h.) CIS-311-TE

This is a two-hour examination in which you must answer 100 multiple-choice questions (worth 1 point each).

A passing score is 65 out of 100 points.

Here are the topics covered and their approximate importance on the test:

I. BASIC CONCEPTS (65%)

A. General database systems concepts (10%)

B. Types of databases (10%)

C. Design of relational databases (15%)

1. Candidate keys

2. Primary keys

3. Foreign keys

4. Normal forms

D. Entity - Relationship diagrams (ER diagrams) (5%)

E. Data protection (10%)

1. Data integrity

2. Concurrency control

F. Implementation issues (10%)

1. Data structures

2. Indexes

G. Database management and administration (5%)

II. DATABASE LANGUAGES (35%)

A. General concepts (25%)

1. Data description

2. Data manipulation3. Data control

B. SQL (10%)

Textbooks to help you prepare:

Date, C. J. An Introduction to Database Systems.

Current edition. Reading, MA: Addison-Wesley

Elmasri, Ramez and S. Navathe. Fundamentals of Database Systems

Current edition. Reading, MA: Addison-Wesley

Hoffer, Jeffrey, Prescott, Mary and Fred McFadden. Modern Database Management.

Current edition. Upper Saddle River, NJ: Prentice-Hall

Kroenke, David. Database Concepts .

Current edition. Upper Saddle River, NJ: Prentice-Hall

>> This text is especially good for beginners.

8/4/2019 CIS-311

2/4

SAMPLE QUESTIONS

1. The data dictionary is

a. a utility program

b. a list of database personnel

c. different from an index procedure

d. an application generator

2. Users usually retrieve information from a database using

a. FORTRAN

b. COBOL

c. SQL

d. PL/1

3. What is embedded SQL?

a. A subset of SQL for Macintosh system

b. An SQL compiler built by Microsoft

c. SQL statements used in a program written in some other programming language, usually prefixed bysome symbols recognizable by preprocessor

d. SQL written for embedded systems, used in a program written in some other programming language

e. A UNIX version of SQL

4. Relationship 'attends' from 'student' to 'class' is an example of

a. one-to-one relationship

b. many-to-one relationship

c. one-to-many relationship

d. many-to-many relationship

5. An integrated collection of related data files is called a

a. record

b. database

c. table

d. data element

6. What file access method allows the user to directly access records organized sequentially using an index of

key fields?

a. Sequential access method

b. Indexed sequential access method

c. Direct access method

d. Relational access method

7. Adding new data, modifying existing data, and deleting data are the three basic operations of data

a. maintenance

b. management

c. retrieval

d. backup

8/4/2019 CIS-311

3/4

8. Which of the following keywords is NOT included in most data retrieval statements?

a. SELECT

b. AS

c. FROM

d. WHERE

9. Functions include

a. COUNT, MIN, OR

b. MAX, SUM, AND

c. AVG, IF, COUNT

d. COUNT, SUM, AVG

10. What is the smallest unit of data recognized by database software?

a. Rowb. Field

c. Record

d. Table

11. Data integrity controls may include

a. default values, null value control, denormalization

b. default values, hashing, referential integrity

c. range control, hashing, denormalization

d. range control, referential integrity, default values

12. Another name for a synonym is a(n)

a. alias

b. homonym

c. constraint

d. enterprise key

13. All of the following are basic constructs of E-R modeling EXCEPT

a. attributes

b. entity types

c. relationships

d. identifiers

14. A base table is a

a. mathematical table

b. table with indexing

c. table that physically exists in the database

d. virtual table

15. In a multi-user database environment, the word key is synonymous with the word

a. index

b. password

c. superuser

d. lock

8/4/2019 CIS-311

4/4

ANSWERS TO SAMPLE QUESTIONS

1. c 2. c 3. c 4. d 5. b 6. b 7. a 8. b

9. d 10. b 11. d 12. a 13. d 14. c 15. a