LYCEUM INTERNATIONAL SCHOOL

MONTHLY TEST 

COMPUTER

MAY - 2008

 

 

(1) Underline the correct answer.

 

1 . What is the incorrect statement regarding database?

 

(a) Field is a single entry in a table .

(b) You can have multiple tables in a computer .

(c) A field has only one data type .

(d) A single record consists of many fields .

 

2 . What does DBMS stand for ?

 

(a) Database Management Solution

(b) Database Master System

(c) Database Management System

(d) Database  Master Solution

 

3 . Out of the data types number can include ?

 

(a) numbers and symbols

(b) Numbers only

(c) Number and currency

(d) Number or a date

 

4 . Which statement is true ?

 

(a) record is a collection of related data items within a database

(b) Text can include numbers , letters , symbol

(c) Primary key can contain the same value more than once

(d) A record is also called a column in a table.

 

5 . What is relevant to primary key field

 

(a) Age can be primary key in the student table

(b) The primary key cannot prevent enter duplicate value

(c) It is an unique identifier

(d)  None of the above

 

(2)

(i) What is database ?

          A organized collection related data which you can easily retrieve and use .

 

(ii) What is DBMS ?

          Database Management System.

         

(3)

(i) Write 3 disadvantage of DBMS?

· Duplication never occurs

· Higher accuracy of data

· Higher consistency

 

(ii) Write 3 disadvantages of DBMS?

· It is expensive

· It needs proper security

· It is difficult to set up a database

 

(4)

(i) Write down the hierarchy of database and explain each in brief

 

                                        Fields

                                       

                                        Table

 

                                      Record

 

                                        Field

 

                                    Data types

 

 

File - Is a collection of tables

Table  - Is a collection of records

Record - Is a collection of fields

Fields - Is  single entry in a database

Data Type - Properties of each field 

 

(5) Write 7 objects in database?

· Table

· Queries

· Forms

· Reports

· Pages

· Macro

· Modules

 

(6) The management of Lyceum International School decided to enter the details of students to a database . If they need your help in the connection?

 

(i) What is the most convenient software you would suggest /

· Ms.Access

 

(ii) Write the 2 ways of loading it?

· Start - All Programs - ms office - ms excel

· Double click on the ms access icon

 

(iii) Fill the 2 columns in screen A using the sample record given below

 

Sample record : details of Bhagya Silva

 

 

 

 

 

 

Screen A

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(iv)    What field will you assign as the primary key?

· Student No

 

(v) If you want to add or delete what is the icon you should click?

 

 

 

 

 

 

                                       

[HOME]  [2]  [3]  [4]  [5]  [6]  [7]  [8]  [9]  [10]  [11]  [12]  [13]  [14]  [15]  [16]  [17]  [18]  [19]  [20]  [21]  [22]  [23]  [24]  [25]  [26]  [27]  [28]  [29] [30]  [31]  [32]  [33] 

<<[PREVIOUS]                   [NEXT]>>

 

 

www.kiddiesnet.com