Information and

Communication Technology
Class IX-X

Chapter-6
MCQ
 Md. Mustafizur Rahman
 Lecturer, ICT(EMMS)
 Rajuk Uttara Model College
After processing data is organized and turn into a
meaning full context called...........
a) Data b) Information
c) Field d) Query
What is singular of the word ‘Data’?
a) Database
b) Datum
c) Dates
d)information
Which is the smallest part of information ?
a) Data
b) database
c) field
d) record
In what data stored in a computer based system
can be retrieved and restored?
a) database
b) data structure
c) spreadsheet
d) word processing
Which one of the following remains in a
Database?

a) table, record, field

b) row, column, cell
c) Insert, picture, format
d) layer, grid, blur
How many heading each column have?

a) 1
b) 2
c) 3
d) 4
 What are the total field and record number
there?

 a) Field 3 and record 1.

 b) Field 1 and record 3
 c) table 1 and record 3
 d) table 3 and record 1
 What is formed by several fields in a same
row?

 a) Record.
 b) Table
 c) field
 d) Column
 What kind of program oracle is?
 a) spreadsheet
 b) word processing
 c) presentation
 d) Database
 What is called setting the data Entry limit by
conditional terms in the database?

 a) input validation.
 b) query processing
 c) checking entry
 d) keeping backup
What is used to exchange data between
multiple tables based on a particular field
?

a) Relation.
b) Query
c) Index
d) Report
 Which one is crated to get rid of the
same work repeatedly in the database?

 a) Filter
 b) Macro
 c) Index
 d) Query
 To open the new database of access
program which icon have to click?

 a) Blank database.
 b) Open Database
 c) Database Query
 d) Database Index
 In which window of Database Data
Entry is done?.
 a) Datasheet View
 b) Datasheet New
 c) Datasheet Create
 d) Datasheet Opne
 To add a new field to the database
which window should be used?
 a) Design view window.
 b) Data sheet View
 c) Data grid View
 d) Add new record
What is called showing arranged data in
data table?
a) Sorting.
b) Query
c) Field
d) Record
 In which icon one have to click in
conditional search of Database?

 a) Filter
 b) Report
 c) Index
 d) Relation
 Database program is-
 i. debase
 ii. oracle
 iii. fourth dimension
 Which one is correct?
 a) i and ii b) i and iii c) ii and iii d) i, ii and iii
Where data is stored in a database?
a) Query
b) Form
c) Report
d) Table
 Which contain similar type of data?
 a) field b) data table
 c) record d) relational field
 In a database there are information of 50 teacher
available. Each teacher has 4 fields: Name, ID no.,
Date of Birth & Cell No.
How many records available in the database?
 a) 25 b) 50 c) 100 d)200
 Which is the basic unit of Database?
 a) Record
 b) field
 c) query
 d) table
There 40 boys students and 60 girls students in
a database. Each record consist of Roll,
Name, date of birth and GPA fields.
How many records in this database?
a) 4 b) 40 c) 60 d) 100
 Roll Name Admission fee Group DOB
101 Abir $12000.00 Sc 01.02.1998
102 Mehdi $12000.00 B.St 21.01.1999
103 Javed $12000.00 Hum 11.06.1997

How many fields present in the table above?

A) 3 b)4 c)5 d) 6

How many records there are in above table?

a) 1 b) 3 c) 5 d) 10
 What is right sequence of creating database?
 (a) Field –Database-table
 (b) Table-Field-Record
 (c) Field-Record-Table
 (d) Table-Field- Database
 Storehouse of information is called …………
a) Data b) Information
c) Database d) Record
In a database file a row represent…………….
a) Column b) Table
c) Record d) Field

 A record is consist of several-

 a) Database b) File
 c) Table d) Field
-------------consists of one or one more tables.
a) field b) table
c) Database d) Key Field

In a database file a column heading

represent…………….
a) Data b) information
c) Field d) Record
 Which is consist of some interrelated files?
 (a) Table (b) Database
 (c) records (d) Field
 Which is consist of some interrelated fields?
 (a) Table (b) Database
 (c) records (d) Field

 Collection of interrelated data is called ……..

(a) Information (b) Database
(c) Data type (d) Data Manipulaton
 Which is consists of one or one more files?
 (a) Fields (b) Record
 (c) Database (d) Table

 ---------------------Consist of few number of

field?
 (a) File (b) Table
 (c) Record (d) DB
 Database file consists of ………..
 a) collection of data
 b) collection of field
 c) collection of record
 d) collection of information

 Heart of Database is---------

 a) Table b)Record c)file d) Field
 in the above stem “A” is called…
a) Record b)Field c) Data d) Table

 In the above stem “A” is called…

a) Information b)Field c) Value d) file
Which one is DBMS?
a) Access
b) Mozilla
c) Excel
d) Powerpoint

Example DBMS software ...........

i) MySQL
ii) Access
iii) Oracle
Which is correct?
a) i & ii b) i&iii c) ii & iii d) i,ii & iii
 What a Database program does?
 (a) Information management
 (b) Word Processing
 (c) Mathematical calculation
 (d) Power Point presentation
 Feature of DBMS----
 i. find necessary data
 ii. Control data entry
 iii. Unable to mathematical task
 Which of the following is correct?
 a) i & ii b) i & iii c) ii & iii d) i, ii & iii
 Mr. Ismail used to keep all accounting
information of his company written in paper.
In this way he suffer a lot of problem. He also
suffer lose in business because he can’t
provide necessary information in time .
 What type of software he need to use for
solving his problem?
 a) word processing
 b) web page
 c) programming
 d) databse
 Which used to develop database software?
 a) Python b) Java
 c) C/C++ d) Oracle
What is Query?
a) Always Update data in database
b) Storing databse file properly
c) Supply necessary data
d) Arranging tables in databse
 Finding data applying conditions is called...
 a) Module
 b) Query
 c) Sorting
 d) Indexing
 Roll Name Reg. No Result
1001 Zahid 630001 A+
1002 Nehal 630002 A
1003 Laboni 630003 B
1004 Sattar 630004 A

 Which can help to find the Rolls who got A from the
table above?
 a) Sorting
 b) Searching
 c) Query
 d) Indexing
 Using which language can a user request
information from a database ?
a) Query b) Relational
c) Structural d) Compiler
 Principal of a college has taken a decision to store all
information of the institution by database. After
implement the decision he has taken initiative to present
the list of weak students separately.
 Which method is used to represent the list?
 a) Sorting b) indexing c) Query d)Encryption

 By implementation the decision of Principal---

 i. every types of security for information can be provided
 ii. Information can be arranged in any type
 iii. Data of the students can be presented quickly
 Which one is correct?
 a)i & ii b) i & ii c) ii & iii d) i, ii & iii
How can we exress more than tk 20,000
a) <= 20,000
b) > 20,000
c) >= 20,000
d) < 20,000
How can we exress less than or equel
tk 10,000
a) < 10,000
b) > 10,000
c) >= 10,000
d) <=10,000
What should be used to find the students who have
blood group of O+
 a) table
 b) Query
 c) form
 d) report
 What is the faster process of finding the records who
got salary more than 30,000?
 a) Searching b) Sorting c) indexing d) Query
 Information can be presented attractively by--
 a) query
 b) report
 c) search
 d) tool
 Which format of Information is used to supply
and distribute in database software?
 a. Report
 B. Table
 C. Form
 D. Query
 The characteristics of database program are -
 i. Create a link among files
 ii. create a mailing label with the necessary records
 iii. Data can be presented with attractive graphs,
charts
 Which one is correct?
 a)i & ii b) i & ii c) ii & iii d) i, ii & iii
 Which one is used to set field name?
 A. Field size
 B. Field
 C. Create
 D. Design view
 Which one is used to set the size of field?
 A. Field size
 B. Field name
 C. Create
 D. view
 Which command is used to delete unnecessary
records from database?
 a) Select specific record Home Delete No

 b) Select specific record Home Delete Yes

 c) Select specific record Home Insert No

 d) Select specific record Home Insert Yes

 Database software can be used to create.......
 i) special application program
 ii) interface for input/output
 iii) necessary report
 Which one is correct ?
 a) i & ii b) i & iii c) ii & iii d) i, ii & iii
 Which is NOT Database Software?
 a) DB-2 b) SQL
 c) C++ d) MySQL
Rony used to keep accounce details of his shop in written. Its
very time consuming method and bring lose his business.
According to the suggestion of an IT expert, he decided to use
DBMS.

Which will help Rony to make his work easy?

a) MS Access
b) MS Excel
c) MS Word
d) HTML
From the advice of the specialist Rony will be
benefitted.
i) For generating Report
ii) Composing Biodata
iii) Searching Record
Which is correct?
a) i & ii b) i&iii c) ii & iii d) i,ii & iii
 The primary task of a DBMS ............
i. Database create
ii. Data entry and store
iii. Report generation and print
 Which of the following is correct?
 a) i & ii b) i & iii c) ii & iii d)i, ii & iii
 By which a specific type of data and field can
be presented ?
 a) report b) table
 c) data d) record
 By based on which given information
reports are made?

 a) Index
 b) Print
 c) Relation
 d) Query
 A govornment organization interested to store data
automatically. So they made deal with a software firm and the
firm provided necessary techical facility. Than all types of data
analysis become much faster than ever before.
 Which software used for the govornment organization in the
stem?
 a) Oracle b) Nexus c) Firefox d) Pascal

 What can happen after applying the software?

 a) increase manpower
 b) increase cost for data management
 c) generate report on demand
 d) security under risk
The task of a database---------
i) Insert new record in a databse
ii) Delete unncesseray record
iii) Searching desire record
 Which of the following is correct?
 a) i & ii b) i & iii c) ii & iii d) i, ii & iii
 Report is ---------------
 (a)Presenting databse in many ways
 (b) Indexing and sorting of data
 (c)Represent some specific data
 (d) Ensure database system security
 What type of data will be needed for a field if we want
keep the record:
 House #1, Road#30, Sector #7Dhaka
 a) Number
 b) Date/time
 c) Currency
 d) text
Which is the largest data type ?
a) Text
b) OLE
c) currency
d) Memo
Roll Name Date of Birth

1 A 11 May, 99
2 B 13 June, 99
3 C 23 June, 99

 What is the data type of Last field of the above table?

 i. Text
 ii. Number
 iii. Date/Time
 a) i only b) iii only c) i & ii d) ii & iii
What kind of data should be used for Name?
a) Logical b) Number
c) Text d) Currency

Data type of a field depends on----

a) Data that used in a field
b) Size of data used in a field
c) Name of the field
d) Size of the field
 3 Jan-1979
 What type of date/field type used here?
 a) Short
 b) Medium
 c) Long
 d) large
 Data type of ID no. can be.........
 i) Currency
 ii) Numeric
 iii) Auto Number
Which is correct?
a) i & ii b) I & iii c) ii & iii d) i, ii & iii
 December 31, 2018
 What type of date/field type used here?
 a) Short
 b) Medium
 c) Long
 d) large
 Data type of Address field can be…
 i. memo
 ii. Number
 iii. Text
Which is correct?
a) i & ii b) I & iii c) ii & iii d) i, ii & iii
The field ‘Registration No.’ must be declare as number
and also………………..
a) Single
b) double
c) Integer
d) Currency
If ‘Total Price’ is a field, the data types of this field will
should be…………..
a) Number
b) Single
c) Currency
d) Integer
 Roll Name Admission fee Group DOB
101 Abir $12000.00 Sc 01.02.1998
102 Mehdi $12000.00 B.St 21.01.1999
103 Javed $12000.00 Hum 11.06.1997

 What data type of DOB?

 a)Short date b) General date
 c) mediam date d) long date

 What data type of Admission fee?
 a) single number b) double number
 c) Integer Number d) currency
 Auto Number can be used to-----------
 i. Transfer data to another program
 ii. Maintain sequence.
 iii. Allow automatically data entry
 Which is correct?
 a) i & ii b) i & iii c) ii and iii d) i, ii and iii
 Auto Number can be used to-----------
 i. Transfer data to another program
 ii. Other program can be bring into database
 iii. Allow automatically data entry
 Which is correct?
 a) i Only b) iii Only c) ii and iii d) i, ii and iii
Dipu want to connect his database with
facebook fan page. which data type he need
assign for that field?
a) Logical b) text c) OLE d) Hyperlink
 For providing error free data entry, which
Data type is used?
 (a) logical (b) Memo
 (c) lookup wizard (d) Text
 Advantage of Auto Number data type-
 (i) Can bring Other data type
 (ii) Numeric value entry easier.
 (iii) No need to typing or entering data.
Which is correct?
a) i and ii b) i and iii c) ii and iii d) i, ii and iii
 Memeory space needed for Currency Data
type............
 a) 8 Byte b) 4 Byte c) 2 Byte d)1 Byte

How many characters can be accommodated in

memo type data
 a) 56,536 b) 65,356
 c) 55,365 d) 65,536
 Which option needed to create a new field?
a) Add row of table
b) Insert Row in design
(c) Insert column of design view
(d) Add new column of design view
 Which option needed to create a new field in
a table?
(a) Add row (b) Row
(c) Insert column (d)New column
 For logical data field how many Bytes are
required?
 (a)1 Byte (b) 2 Byte
 (c)4 Byte (d) 8 Byte
 What type of data used to insert picture in
RDBMS?
 a) Memo b) Lookup Wizard
 c) OLE object d) Hyperlink

 How many letter allowed in text data type?

 a) 128 b) 255 c) 256 d) 512
What type of data used in the last field of the
above stem?
a)Text b) Number c)Date/Time d)Memo

What type of field type we need to use for adding

different object in Database?
a) Logical b) OLE c)Memo d)Hyperlink
 How many types of fields used in the above stem?
 a) 2 b) 3 c) 4 d) 5
 Why 1st field is considered as primary key?
 i) identifying records from database
 ii) establishing relationship among one more tables
 iii) ensure security of database
Which is correct?
a) i and ii b) i and iii c) ii and iii d) i, ii and iii
 which filed should be declared as memo data
type?
 a) designation b) name
 c) hobby d) blood group
 which data type links the web pages with the
database?
 a) OLE object b) Memo
 c) Hyper link d) lookup wizard
 01 Sohan Dhaka 10-07-2011

 What is indicated by above figure?

 a) Field
 b) Record
 c) table
 d) database
 Which is NOT database progarm?

 a) Access
 b) Oracle
 c) paradox
 d) VisiCalc
 Which is basic element of information?

 a) database
 b) data
 c) table
 d) cell
 What is purpose of index?

 a) finding information
 b) open a file
 c) delete information
 d) create new database
 What is purpose of index?

 a) finding information
 b) arrange information
 c) delete information
 d) create new database
 Which allows arrangement of data in
database without changing main file

 a) indexing
 b) sorting
 c) query
 d) relation
 Based on what relationship established
among 2 or more file?

 a) record
 b) filed
 c) cell
 d) table
 What correct sequence for opening MS
Access?

 a) All program-Start-MS office-MS Access

 b) Start-All program-MS office-MS Access
 c) MS Access-Start-All program-MS office
 d) MS office-MS Access-Start-All program
 Text, Number, Currency , date/time etc.
are name of--------

 a) data size
 b) data type
 c) design
 d) field
 What is the data type of “Bank account
number”?

 a) number
 b) currency
 c) text
 d) Memo
 What is called arrangement of data

 a) indexing
 b) report
 c) sorting
 d) query
 A database field arranged in such a way that
 X,….Y,……,Z . What method applied here?

 a) descending order
 b) ascending order
 c) numeric order
 d) symbolic method
 A database field arranged in such a way that
 D-C- B-A What method applied here?

 a) descending order
 b) ascending order
 c) numeric order
 d) symbolic method
 Which icon of ribbon is used to cancel record
those are set on condition?

 a) Toggle filter
 b) find
 c) selection
 d) filter
 Conditional arrange can be implemented by -

 a) removing filter
 b) Applying filter
 c) numbering filter
 d) between
 What is the full form of DDL?

 a) Data Definition Language

 b) Data Design Language
 c) Direct Data Limit
 d) Data Domain Language
 Database consists of --
 i. row
 ii. Column
 iii. Information
 Which one is correct?
 a) i and ii b) i and iii c) ii and iii d) i, ii and iii
 Another name of Database--
 i. DBMS
 ii. Information management
 iii. Data collecting system
 Which one is correct?
 a) i and ii b) i and iii c) ii and iii d) i, ii and iii
 Feature of database --
 i. query
 ii. Report generate
 iii. Update record
 Which one is correct?
 a) i and ii b) i and iii c) ii and iii d) i, ii and iii
 By using database an organization can--
 i. insert new information
 ii. Find necessary information
 iii. Reduce office management cost
 Which one is correct?
 a) i and ii b) i and iii c) ii and iii d) i, ii and iii
 Ascending order are---
 i. Z,Y,C,B,A
 ii. A,B,C,D
 iii. 10,20,30,
 Which one is correct?
 a) i and ii b) i and iii c) ii and iii d) i, ii and iii
 By query we can represent data from ---
 i. a specific field
 ii. a specific group
 iii. Specific condition
 Which one is correct?
 a) i and ii b) i and iii c) ii and iii d) i, ii and iii
 Name Date of Birth Zilla post code
Rana 5-9-2003 Dhaka 1200
Sumon 15-10-1963 Jessore 7100
Tarik 7-12-1993 Rajshahi 3400

 Which fields are arranged in order ?

 a) Zilla & post code
 b) Name & Zilla
 c) date of birth and post code
 d) post code & Name
 Which is the primary form of database ?

 a) query
 b) index
 c) Table
 d) report
 For decision making database is useful
because--
 i. huge collection of data
 ii. Supply necessary data
 iii. Resenting data many ways
 Which one is correct?
 a) i and ii b) i and iii c) ii and iii d) i, ii and iii
 What is the purpose of relation?

 a) macro for repeated work

 b) information exchange
 c) indexing and sorting
 d) query and report