Page 249 - Computer - 10(A&B)

2. A computer based application used to create, store, or manipulate database is known as:

Database Manipulation System Database Modification System
Database Management System Data Maintenance System
3. In a Relational Database Management System, data is organised in the form of:
Single Table Multiple Tables

Multiple Databases None of these
4. _________________ component of a database is used to extract specific information from one or more
tables.
Table Form
Query Report

5. A table in a database:
must have a primary key may have a primary key
has multiple primary keys may have multiple primary keys
6. The most suitable data type for a telephone number field in a table is:

Text Number
Boolean Date
7. The database object which is used to access records in a table or query is:

Form Query
Report Table
8. What kind of relationship does a teacher and a student table have?
One-to-one Many-to-Many
One-to-many Many-to-one

9. What can we mention in the Filed section of Query design view?
Field name Formula
Both (a) and (b) Alias name

B. Fill in the blanks.

1. A _________________ is an organised collection of data.
2. A _________________ is a software package that can be used for creating and managing databases.
3. A _________________ is a database management system that is based on the relational model.
4. Three popular RDBMS software are _________________, _________________, and _________________.

5. A _________________ represents a single data item in a table.
6. _________________ are used to identify which type of data we are going to store in the database.
7. A _________________ is a unique value that identifies a row in a table.
8. Data in the tables is stored in the form of _________________ and_________________.

C. Very short answer questions.

1. Define database.
2. What is record?
3. What is data?

131