Chapter 6
Database Part I
EXERCISE
1. MCQ
l. DBMS is a
A) Type of database. B) Set of computer programs. C) Key D) Field
2. Which of the following key composed of additional fields?
A) Primary B) Foreign C) Super D) Alternate
3. Which option is used to change the appearance and size of various controls of a Form?
A) Design View B) Form View C) Layout View D) None of these
4) Which key defines a relationship between two tables?
A) Primary key B) Candidate key C) Secondary key D) None of these
5) Which icon indicates the edit mode in Access?
A) Clip B) Pen C) Pencil D) None of these
2.Fill in the blanks:
1. In ___________ database data are stored in multiple tables to remove redundancy.
2. A candidate key is called __________ key, if it is not designated as primary key.
3. Microsoft Access is a ___________ database.
4. __________view displays the table as grid.
5. ___________ allows you to add and update data in a table, one record at a time.
3. Answer the following questions:
1. What is Database? Give examples
2. What is the need for database?
3. Define: Primary key, Foreign key, Candidate key, Super key.
4. Differentiate between Flat file database and Relational database.
5. What are data types? List the various types of data types used in Access 2007 and explain any four of them.
6. What is a query? Explain the parts of a query window.
7. What do you understand by criteria?