Multiple Choice Questions
1. DBMS is a
B) Set of computer programs.
2. Which of the following key composed of additional fields?
C) Super Key.
3. Which option is used to change the appearance and size of various controls of a Form?
A) Design View.
4. Which key defines a relationship between two tables?
B) Candidate key.
5. Which icon indicates the edit mode in Access?
C) Pencil.
Fill in the Blanks
1. In __________ database data are stored in multiple tables to remove redundancy.
Relational
2. A candidate key is called __________ key, if it is not designated as primary key.
Alternate
3. Microsoft Access is a ________________ database.
Relational
4. __________ view displays the table as grid.
Datasheet
5. __________ allows you to add and update data in a table, one record at a time.
Form
Answer the Following Questions
1. What is Database? Give examples.
A database is an organized collection of data that can be accessed, managed, and updated easily. Example: Library database, Student database, Banking system database.
2. What is the need for database?
Databases reduce redundancy, ensure data consistency, provide security, allow easy retrieval of information, and support multiple users simultaneously.
3. Define: Primary key, Foreign key, Candidate key, Super key.
- Primary Key: A field that uniquely identifies each record in a table.
- Foreign Key: A field in one table that refers to the primary key of another table.
- Candidate Key: Fields that can uniquely identify a record but only one is chosen as primary key.
- Super Key: A set of one or more attributes that uniquely identify a record.
4. Differentiate between Flat file database and Relational database.
- Flat File Database: Stores data in a single table, less flexible, more redundancy.
- Relational Database: Stores data in multiple related tables, removes redundancy, ensures consistency.
5. What are data types? List the various types of data types used in Access 2007 and explain any four of them.
Data types define the kind of values a field can hold. In MS Access 2007, common data types are:
- Text
- Number
- Date/Time
- Currency
- Memo
- Yes/No
Examples:
- Text: Stores alphanumeric characters like names.
- Number: Stores numeric values for calculations.
- Date/Time: Stores dates and time values.
- Currency: Stores monetary values with precision.
6. What is a query? Explain the parts of a query window.
A query is a request to retrieve specific data from a database. In MS Access, a query window includes:
- Table pane – shows tables used.
- Field pane – lists fields selected.
- Criteria row – defines conditions for filtering.
- Output grid – shows how results will appear.
7. What do you understand by criteria?
Criteria are conditions applied in queries to filter records. Example: "Age > 18" retrieves records of persons older than 18.