Solved Objectives: Ekta Publication

EKTA PULICATION

Chapter 8: Database Management System

1.            Fill in the blanks.

a)            A database is a collection of related data.

b)            A table contains records and field.

c)            A primary key is a fixed field which uniquely identifies every record in a table.

d)            You cannot enter duplicate values in a primary key field.

e)            A combination of two or more keys which can be used as a primary key is called a compositekey.

f)             Maximum width of field is 64 characters.

g)            Memo field can hold 65535characters.

h)            Full form of DBMS is Database Management system.

i)              Access is a relationaldatabase management system software.

j)              Access can be used as front end tool.

4. State whether the following statements are true or false.

a) Access is management software. True

b) You cannot insert any field after entering data in the table. False

c) Query allows viewing the desired records only. False

d) You can also insert the picture in the database. True

e) Logical field has the size 2.False

2.            Select the best alternatives from the given choices.

a)            What kind of data is kept in memo field?                                                          

(i) Hyperlink       (ii) Software     (iii) Data          (iv) Pictures

Ans:Data

b)            What is the extension of database file in Access?                                              

(i) .DB                (ii) .MDB                     (iii) .DBF         (iv) .ADB

Ans: .MDB

c)            What is the default size of Access?                                                       

(i) 10       (ii) 20               (iii) 30  (iv) 50

Ans: 50