Exercise Answers
Multiple Choice Questions:
1. Most widely used Database is:
a. Network DBMS
b. Hierarchical DBMS
c. Relational DBMS
d. Microsoft Access
Ans. d. Microsoft Access
2. Which database consists of Fields, Records and Tables?
a. Network Database
b. Hierarchical DBMS
c. MS Word
d. Relational Database
Ans. d. Relational Database
3. Microsoft office Access 2010 from Microsoft Office Suite is a type of:
a. Relation Database
b. Network Database
c. Hierarchical DBMS
d. Word Processor
Ans. a. Relation Database
4. What are the screens used for displaying data and entering/updating data in tables known as?
a. Tables
b. Forms
c. Reports
d. Queries
Ans. b. Forms
5. Reports are:
a. Formatted output to display/print batches of records
b. Screens displaying data and entering/updating data in the tables
c. Having data storage capability
d. Used to display the record that match a certain criteria, sort the data etc.
Ans. a. Formatted output to display/print batches of records
6. In MS Access, which technology data type is used to store rates, prices etc.
a. Text
b. Currency
c. Memo
d. Number
Ans. b. Currency
7. In MS Access, which data type stores unique sequential increment by 1 which is automatically inserted when a record is added, or decrement by 1 when a record is deleted?
a. Number
b. Memo
c. Auto Number
d. Yes/No
Ans. c. Auto Number
State the following statements as true or false:
1. Relational database consists of Fields, records, and tables. TRUE
2. Tables are building blocks of a database. TRUE
3. Tables can be created in the Data sheet view in the design view. FALSE
4. In the number data field, a unique sequential increment by 1 is automatically inserted when a record is added or decremented by 1 when a record is deleted. FALSE
5. In the design view, you can easily define the field names and enter data in those in a spreadsheet like view. TRUE
6. While creating a table in the design view, the validation rule lets you create an expression, which is tested against the data entered. TRUE
Fill in the blanks:
1. A _______is an organised way of sorting data and record keeping in computer.
Ans. Database
2. _______ are building blocks of a database.
Ans. Tables
3. With a _______ you can display the records that match certain criteria.
Ans. Query
4. A _______ is the formatted output to display/print batches of records.
Ans. Report
5. In the _______ view, you can create tables and specify the field types and the field lengths according to your requirement.
Ans. Design
6. The _______ key is used to define the data in a field uniquely (there should be no duplicate value).
Ans. Primary
Match the following:
Ans.
1. g
2. f
3. e
4. c
5. d
6. b
7. a
Answer the following in one word/sentence.
1. Give an example of a DBMS.
Ans. Microsoft office Access 2010
2. What are the building blocks of a Database?
Ans. Tables
3. What are the screens for displaying data in entering / updating data in the table is known as?
Ans. Forms
4. In which view a spreadsheet like format will be provided to create the table?
Ans. Design view
5. Which data type stores the date or time fields as required?
Ans. Date/time field
6. Which field property lets you create an expression which is tested against the data entered?
Ans. Validation Rule
7. What is validation rule?
Ans. This rule lets you create an expression, which is tested against the data entered.
8. Which key is used to define the data in a field uniquely (there should be no duplicate value)?
Ans. Primary key
0 Comments