ROLL NO.
- _________
NPPS2425
UNIT TEST 03
CLASS - 08
SUBJECT – COMPUTER
Time Allowed: 90 Mins Maximum Marks: 40
General Instructions:
1. ALL QUESTIONS ARE COMPULSORY.
2. ATTEMPT QUESTIONS SERIAL - WISE.
1. Choose the correct answer - [5]
1. What is the extension of MS-Access file in higher version?
a) .accdb b) .mdb
c) .accdbv d) .accdbd
2. A table can be created using ______.
a) Design Wizard b) Design view
c) Both a) and b) d) None of these
3. Logically related data in a context, gives out ______.
a) Data b) Database Administrator
c) Information d) All of these
4. The process of taking out information using a query is called ______.
a) Formation b) Manipulation
c) Selection d) Extraction
5. The term ______ can be defined as a raw fact.
a) Field b) Information
c) Database Administrator d) Data
2. Fill in the blanks – [5]
(Options: Data, Parent, Foreign, Table, OLE object)
1. Table containing a primary key is also called ______ table.
2. ______ is a collection of data related to a single topic.
3. “AJAY”, 47, “COUNTRY” - these are examples of ______.
4. ______ is used to get the data from other software like excel, paint, etc. in MS-Access.
5. Table having a ______ key is called child table or dependant table
3. Match the following. [5]
Column-I Column-II
1. Acid Properties a. Extracts desired information from the tables in a database.
2. Data b. Atomicity, Consistency, Isolation, Durability
3 DBMS c. Collection of related data for any object, transaction or event.
4. Table d. Database Management System
5. Query f. It can be defined as a raw fact with an incomplete meaning.
4. Tick (✓) the correct statement and cross out (✗) the incorrect one. [5]
1. A number data type specifies the currencies and displays them in different formats.
2. A table stores the data in records/rows also known as attributes.
3. Primary key cannot be based on multiple columns or keys.
4. Degree refers to the number of columns in a relation.
5. Table containing a primary key is also known as Parent table.
5. Answer the following questions. [10]
1. What do you mean by relational database?.
2. Explain two types of queries in short.
3. Describe any four data-types used in MS Access with an example.
4. List four characteristics of any DBMS.
5. What is the difference between primary and foreign key?
5. Answer the following questions. [10]
1. Explain foreign key with a small example.
2. What is the significance of Primary key in a database?
