Page 373 - TP_IT_V1.0_C10_flipbpookl
P. 373
Exercise
Solved
SECTION A (Objective Type Questions)
A. Choose the correct option.
1. Which of the following is not an example of a database?
a. MySql b. MongoDB
c. LibreOffice Base d. FileMaker Pro
2. is a collection of related data stored in the form of rows and columns.
a. Rows b. Column
c. Database d. Table
3. Name the relationship in which one record of master table is related to only one record of transaction table.
a. One to One b. Many to One
c. One to Many d. Many to
4. data type takes the values in the form of 0 and 1 in the database. [CBSE Sample Paper 2021]
a. Integer b. Text
c. Boolean d. Memo
5. Database is made up of all the following components except.
a. tables b. queries
c. forms d. formula bar
6. Which of the following is not a database object?
a. Lists b. Queries
c. Reports d. Forms
7. Duplication of data is known as .
a. data security b. data incomplete
c. data redundancy d. data inconsistency
8. For what memo data type is used?
a. To add table b. To store objects created in other programs
c. For long text entries d. For short text entries
9. Out of the following, which one is the most appropriate data field in context of employee table, if only one of these
is required?
a. Age_ in_ years b. Date_ of_ birth
c. Age_ in_ days d. Age_ in_months
10. Aadya wants to create a connection between two or more tables. Suggest her the option to accomplish the task.
[CBSE Sample Paper 2021]
a. Table b. Form
c. Relationships d. Sorting
11. Rudraksh wants that the name column of a table must not be left blank. Help him to identify the field property for
this purpose. [CBSE Sample Paper 2021]
a. Length b. Default
c. Entry required d. Format
Database Management System using LibreOffice Base 371

