Page 20 - ModularV1.1 _c8_flipbook
P. 20
B. Write ‘T’ for true and ‘F’ for false.
1. MS Access is an example of the flat-file database. ............................
2. A set of values for the fields is called a Record. ............................
3. DBMS stands for Database Management System. ............................
4. A database minimises the duplication of data by integrating and sharing
the data files. ............................
C. Fill in the blanks using the words given below.
fields, query, relational, primary
1. A ............................ helps you to retrieve information from a table based on some criteria or
condition.
2. The columns in a table represent ............................ .
3. The ............................ key is defined in order to show the uniqueness of data.
4. A ............................ database is a type of database that stores data in several tables.
D. Short answer type questions.
1. What is a database?
......................................................................................................................................................................................................
2. What do you mean by flat file database?
......................................................................................................................................................................................................
3. What is the use of a form in a database?
......................................................................................................................................................................................................
E. Long answer type questions.
1. What is a relational database? Give an example of a relational database management system.
2. Write any three advantages of a database system.
In the lab Subject Enrichment
Look at the following table and answer the questions:
Reg No. Name Date of Submission Marks Obtained Grade
T/121/15 Anshu Verma 11/07/15 18 A
T/137/15 Anjali Kumari 12/07/15 20 A+
T/145/15 Deepak Kohli 14/07/15 17 B+
• How many fields are there in the table?
• How many records are there in the table?
Discuss about different relational database management systems such as MS SQL Server and Oracle.
18 Modular (Ver. 1.1)-VIII

