wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

1-50

Total questions: 50

Worksheet time: 1hrs 15mins

Name
Class
Date
1.

What is the full form of DBMS?

a)

Database Management System

b)

Data of Binary Management System

c)

Database Management Service

d)

Data Backup Management System

e)

Digitalbase Management Server

2.

Bus, star, ring are examples of

a)

network topology

b)

device topology

c)

program topology

d)

file topology

e)

folder topology

3.

Any device attached to the network capable of communicating with other network devices is ...

a)

node

b)

transmission media

c)

server

d)

application

e)

IP address

4.

Which network topology requires a central controller or hub?

a)

Star

b)

Mesh

c)

Ring

d)

Bus

e)

Hub

5.

Show the correct definition of IP address

a)

an unique name that is used to identify a computer or device on network

b)

is the schematic description how the arrangement of the network is including the connecting lines and devices

c)

a way to identify and locate computers connected to internet

d)

is a document or site in the World Wide Web

e)

is the internet protocol to send data in the form of message units between computers over the internet

6.

Physical or logical arrangement of network is

a)

 Topology

b)

Routing

c)

Networking

d)

Control

e)

Hub

7.

An unique name that is used to identify  a computer or device  on network.

a)

IP address

b)

IP router

c)

IP server

d)

IP device

e)

IP topology

8.

Show the main function of Ring topology

a)

connects all computers in a ring on which messages travel in one direction

b)

use a single cable to connect all devices

c)

is the schematic description of the arrangement of the network

d)

each device performs as root of a tree of the network devices

e)

all devices connected to a central devices called hub or switch

9.

A computer network is ...

a)

a collection of computers and devices connected together via communication devices and transmission media

b)

a device that uses the services provided by a server

c)

a device attached to the network capable of communicating with other network devices

d)

Internet Protocol address

e)

a device or application that uses the services provided by a server

10.

End devices include … 

a)

computers, network printers, security camera

b)

document, spreadsheet, database

c)

communication lines, signals, devices

d)

hub, switch, router, modem, repeater

e)

metal wire, glass, air

11.

A way to identify and locate computers connected to internet

a)

Domain name

b)

Browser

c)

TCP

d)

URL

e)

Web site

12.

The device for data transmission between computers through a telephone network is ...

a)

modem

b)

network

c)

switches

d)

hubs

e)

router

13.

The main function of Bus topology

a)

use a single cable to connect all devices

b)

is the schematic description of the arrangement of the network

c)

connects all computers in a ring on which messages travel in one direction

d)

each device performs as root of a tree of the network devices

e)

all devices connected to a central devices called hub or switch

14.

Router, modem, hub examples of 

a)

intermediary devices

b)

data models

c)

architecture of computers

d)

microsystems

e)

database levels

15.

A collection of computing devices that are connected in various ways in order to communicate and share resources

a)

Computer network

b)

Computer system

c)

Client/server

d)

Network node

e)

Internet Protocol address

16.

Bluetooth is an example of

a)

Personal area network

b)

Wide area network

c)

Local area network

d)

Global area network

e)

Operating system

17.

Any set of programs that tells the hardware what to do and how to do 

a)

Software

b)

Hardware

c)

Operating system

d)

Database

e)

Graphical user interface

18.

Show the models of databases.

a)

Hierarchical model, Network model, Relational model

b)

Archive model , Embedded model

c)

Computer model, External model

d)

Internal model,Computer model, External model

e)

Relational model, Archive model , Embedded model

19.

Which of the following Operating System does not implement multitasking truly?

a)

MS DOS

b)

Windows 10

c)

Android

d)

Linux

e)

Unix

20.

Spreadsheet is …

a)

group of cells organized into columns and rows containing data

b)

data files created with Excel

c)

the highlighted cell

d)

table that located at the top left corner of the worksheet

e)

part of the database

21.

Specify number of rows in MS Excel 2007 spreadsheet:

a)

more than 1 000 000

b)

less than 1 000 000

c)

1 000 000

d)

less than 100 000

e)

16356

22.

Whаt іs tһe mаіn gоаl оf dаtа mіnіng?

a)

To classify data for further tasks

b)

To turn raw data into helpful information

c)

To store and distribute data

d)

Continuous data

e)

Descriptive modelling

23.

What is the shortcut key to replace a data with another in sheet?

a)

Ctrl + H

b)

Ctrl + Shift + R

c)

Ctrl + R

d)

Ctrl + F

e)

Shift + Ctrl + F

24.

We have copied an image from one document, now which shortcut will we used to paste it in another document ?

a)

Ctrl + V

b)

Ctrl + D

c)

Ctrl + X

d)

Shift + C

e)

Shift + Alt+ V

25.

Select the correct spreadsheet formula entry

a)

=A2*A3-A4

b)

C3+4*D4

c)

C3=C1+2*C2

d)

A5B5+23

e)

None of above

26.

What is Android?

a)

An operating system for smartphones and tablets

b)

An operating system for desktop computers

c)

A specific smartphone model

d)

The games of mobile phones

e)

None of above

27.

Software are referred to

a)

computer programs

b)

hardware

c)

procedure

d)

binary data

e)

digital information

28.

The smallest structural unit within a table is ..

a)

cell

b)

row

c)

kolumn

d)

range

e)

counting

29.

What is the intersection of a column and a row on a worksheet called ?

a)

Cell

b)

Column

c)

Value

d)

Address

e)

Column Chart

30.

Which among following is associated with excel ?

a)

Spreadsheet

b)

Graphic program

c)

None of these

d)

MS-Excel

e)

Varaible

31.

A Spreadsheet contains ?

a)

rows and columns

b)

rows

c)

columns

d)

None of above

e)

Formatting

32.

If you press ___, the cell accepts your typing as its contents ?

a)

Enter

b)

Alt+Enter

c)

Ctrl+Enter

d)

Tab

e)

Alt+Enter+Shift

33.

On an excel sheet the active cell in indicated by ?

a)

A dark wide border

b)

A dotted border

c)

By italic text

d)

A blinking border

e)

Comment

34.

With which of the following all formulas in excel starts ?

a)

=

b)

/

c)

==

d)

*

e)

**

35.

Microsoft Excel is a multifunctional

a)

Spreadsheet package

b)

Interconnection

c)

Word processing package

d)

Communication S/W Package

e)

DBMS package

36.

A keyboard is this kind of device—

a)

input

b)

output

c)

word Processing

d)

black

e)

scanning

37.

The ____ , also called the “brains” of the computer, is responsible for processing data.

a)

CPU

b)

RAM

c)

memory

d)

motherboard

e)

mouse

38.

Select the smallest memory size.

a)

Kilobyte

b)

Terabyte

c)

Gigabyte

d)

Megabyte

e)

Exabyte

39.

Which of the following is an Open-Source computer operating system?

a)

Linux

b)

MAC OS-X

c)

MS DOS

d)

Windows 10

e)

Windows XP

40.

For the top table (i.e. Order Table), which is the primary key?

a)

Pupil_ID

b)

Surname

c)

Forename

d)

TG

e)

Contact number

41.

In context to database management system, SQL stands for

a)

Structured Query Language

b)

Standard Query Language

c)

Specific Query Language

d)

Special Query Language

e)

Super Query Language

 

42.

What should a primary key contain?

a)

A unique value

b)

A null value

c)

A lot of different values

d)

A foreign key

e)

All properties

43.

Below is part of a table from a database.  How many records are there in the database table?

a)

Six

b)

Seven

c)

Four

d)

Five

e)

About fifty

44.

Below is part of a table from a database. How many fields are there in the database table?

a)

Five

b)

Three

c)

Six

d)

Four

e)

None

45.

The Microsoft program used for Databases is:

a)

Access

b)

Word

c)

Excel

d)

Paint

e)

Publisher

46.

Which of the following is a feature of DBMS?

a)

Single-user Access only

b)

Minimum Duplication and Redundancy of Data

c)

Support ACID Property

d)

Table processing

e)

ROM

47.

Which of the following is not an example of DBMS?

a)

Google

b)

MySQL

c)

Microsoft Acess

d)

IBM DB2

e)

Foxpro

48.

In which of the following formats data is stored in the database management system?

a)

Table

b)

Image

c)

Text

d)

Graph

e)

Video

49.

What is a database?

a)

Organized collection of information that can be accessed, updated, and managed

b)

Organized collection of information that cannot be accessed, updated, and managed

c)

Collection of data or information without organizing

d)

Organized collection of data that cannot be updated

e)

Other

50.

What is DBMS?

a)

DBMS stores, modifies and retrieves data

b)

DBMS is a collection of queries

c)

DBMS is a high-level language

d)

DBMS is a programming language

e)

DBMS is vehicle