DBMS Revision

1.Define data.

Ans. Data can be the fact, figure, numbers, letters, symbols or any character which may or may not have sense and is in raw state. Example: Ram, 14, Kathmandu

2. What is database?

Ans. Database is the collection of related data that can be used for particular purpose.

Eg. Dictionary, Telephone Directory.

3.While designing table structure which data types are suitable to store information about teacher's name, address, salary and date of birth?

Ans. Name: text, address: text, salary: currency, date of birth: Date and Time

4.List any four data types in Ms-Access.

Ans. Datatype refers to the nature of data that a field supports. Four data types of Ms-Access are:

i. text

ii.memo

iii.OLE

iv.number

5. Mention any four objects of Ms-Access.

Ans.

i.Form

ii.Query

iii.Report

iv.Table

6. Define query and mention its two importance.

Ans. Query is the object of database which retrieves the desired record from single or multiple tables. Importance:

i. It performs the calculations.

ii. It allows add, edit or delete the content from database.

7. Write any two advantages of computerized database.

Ans.

i. Highly secured

ii. Faster, reliable and accurate

8. List two types of query.

Ans.

i.SELECT query

ii.ACTION query

9.What do you mean by DBMS?

Ans. DBMS is the software which is used to handle the database in systematic manner for easy access, retrieval and manipulation along with security. For example: Ms-Access, Oracle, foxPro, My-SQL etc.

10.Define primary key. Mention its importance.

Ans. Primary key is the field property that uniquely identifies the record which neither accepts null value nor repeated values.

Importance:

i. It reduces the data redundancy.

ii. It establishes the relationships between tables.

11. Name the logical data type in Ms-Acces.

Ans. Yes/No

12.Which view is used to modify a table in Ms-Access?

Ans. Design view is used to modify a table in Ms-Access.

13. Write down the criteria for a query which display all records having Name start with "P".

Ans. *P

14. Define sorting.

Ans. The process of arranging the records either in ascending or descending order is called sorting. It helps in fast searching.

15. Define filtering.

Ans. The process of selecting only the required record from database leaving the non-required records as it is in database is called filtering.

16. Define report.

Ans. Report is an object of database which displays the output in an effective way to present the

data in a printed format.

17. Mention the importance of report.

Ans. The importance of report are:

i) It displays the information the way we want to view it.

ii) It presents the information retrieved through queries or tables.

iii) It presents the information in designed layouts by adding necessary titles, setting font colour

or font size, etc.

A q c

13.Select the correct answer:  

a.…………… is not data type of MS-Access.

i) Number  ii) Text    ii) Memo    iv) Form

Form

b.……………  is the DBMS.

i) Fox-pro    ii) MS-Excel   iii) Lotus 1-2-3   iv) All of the above

Fox-pro

c. Primary key does not accept……………

i) Text      ii) Number    iii) Null value    iv) None of the above

Null value 

d. In MS-Access we enter data using……………

i) Form  ii) Table    iii) Report    iv) Both (i) and (ii

 Form  

e.…………… is suitable data type of MS-Access for writing long paragraph.

i) Number  ii) Text    ii) Memo    iv) Currency

Memo 

f. ……………  is the extension of MS-Access

i) . mbd    ii) .dbm   iii) .mdd   iv) None of the above

None of the above

g.  ……………filters the input.

i) Input Mask    ii) Validation Rule   iii) Validation Text   iv) None of the above

Input Mask 

h. In MS-Access we print result using……………

i) Form  ii) Table    iii) Report    iv) Both (i) and (ii)

Report 

14. State whether the given statements are True or False.

a) A form is useful for entering and editing records.True

b) DBMS is word processing software.False

c) The table of MS-Access has .tbl extension.False

e) A field name can have maximum number of 64 characters.True

f) In the Table Datasheet view, a user can change the data type of field.False

g) A row of table is known as field in MS-Access.False

h) A query can be created without tables.False

i) A report can be used to modify data of a table.False

j)A row in a table is called record.True

k).MS Access is a DBMS.True

l).Primary key supports null value.False

m).Index decrease the speed of query and sort operations.False

n).Video can be stored in database.True

15.Match the following:

             Group A      Group B

a) Query         ( ) Printed format

b) Form         ( ) Stores data

c) Table         ( ) Allows view, edit, input data

d) Report         ( ) Extracts selected record for view

                                ( ) DBMS

Ans.

Query=  Extracts selected record for view   

Form=   Allows view, edit, input data

Table=   Stores data

Report= Printed format

16.Match the following:

Group A Group B

(a) OLE (i) Final Output

(b) Caption (ii) Data entry

(c) Report (iii) Limits the value

(d) Form         (iv) Field Property

        (v) 1 GB

Ans.

OLE= 1GB

Caption= Field Property

Report= Final Output

Form= Data Entry

17.Match the following:

            Group A      Group B

a)Sorting         ( ) 65535 characters 

b)MySQL ( ) Searching fast

c)OLE ( ) Allows view, edit, input data

d)Memo ( ) Upto 1 GB

          ( ) DBMS

Ans.

Sorting= Searching fast

MySQL= DBMS

OLE= Upto 1GB

Memo= 65535 characters