NEW
Font size
Worksheets1-50
Total questions: 50
Worksheet time: 1hrs 15mins
What is the full form of DBMS?
Database Management System
Data of Binary Management System
Database Management Service
Data Backup Management System
Digitalbase Management Server
Bus, star, ring are examples of
network topology
device topology
program topology
file topology
folder topology
Any device attached to the network capable of communicating with other network devices is ...
node
transmission media
server
application
IP address
Which network topology requires a central controller or hub?
Star
Mesh
Ring
Bus
Hub
Show the correct definition of IP address
an unique name that is used to identify a computer or device on network
is the schematic description how the arrangement of the network is including the connecting lines and devices
a way to identify and locate computers connected to internet
is a document or site in the World Wide Web
is the internet protocol to send data in the form of message units between computers over the internet
Physical or logical arrangement of network is
Topology
Routing
Networking
Control
Hub
An unique name that is used to identify a computer or device on network.
IP address
IP router
IP server
IP device
IP topology
Show the main function of Ring topology
connects all computers in a ring on which messages travel in one direction
use a single cable to connect all devices
is the schematic description of the arrangement of the network
each device performs as root of a tree of the network devices
all devices connected to a central devices called hub or switch
A computer network is ...
a collection of computers and devices connected together via communication devices and transmission media
a device that uses the services provided by a server
a device attached to the network capable of communicating with other network devices
Internet Protocol address
a device or application that uses the services provided by a server
End devices include …
computers, network printers, security camera
document, spreadsheet, database
communication lines, signals, devices
hub, switch, router, modem, repeater
metal wire, glass, air
A way to identify and locate computers connected to internet
Domain name
Browser
TCP
URL
Web site
The device for data transmission between computers through a telephone network is ...
modem
network
switches
hubs
router
The main function of Bus topology
use a single cable to connect all devices
is the schematic description of the arrangement of the network
connects all computers in a ring on which messages travel in one direction
each device performs as root of a tree of the network devices
all devices connected to a central devices called hub or switch
Router, modem, hub examples of
intermediary devices
data models
architecture of computers
microsystems
database levels
A collection of computing devices that are connected in various ways in order to communicate and share resources
Computer network
Computer system
Client/server
Network node
Internet Protocol address
Bluetooth is an example of
Personal area network
Wide area network
Local area network
Global area network
Operating system
Any set of programs that tells the hardware what to do and how to do
Software
Hardware
Operating system
Database
Graphical user interface
Show the models of databases.
Hierarchical model, Network model, Relational model
Archive model , Embedded model
Computer model, External model
Internal model,Computer model, External model
Relational model, Archive model , Embedded model
Which of the following Operating System does not implement multitasking truly?
MS DOS
Windows 10
Android
Linux
Unix
Spreadsheet is …
group of cells organized into columns and rows containing data
data files created with Excel
the highlighted cell
table that located at the top left corner of the worksheet
part of the database
Specify number of rows in MS Excel 2007 spreadsheet:
more than 1 000 000
less than 1 000 000
1 000 000
less than 100 000
16356
Whаt іs tһe mаіn gоаl оf dаtа mіnіng?
To classify data for further tasks
To turn raw data into helpful information
To store and distribute data
Continuous data
Descriptive modelling
What is the shortcut key to replace a data with another in sheet?
Ctrl + H
Ctrl + Shift + R
Ctrl + R
Ctrl + F
Shift + Ctrl + F
We have copied an image from one document, now which shortcut will we used to paste it in another document ?
Ctrl + V
Ctrl + D
Ctrl + X
Shift + C
Shift + Alt+ V
Select the correct spreadsheet formula entry
=A2*A3-A4
C3+4*D4
C3=C1+2*C2
A5B5+23
None of above
What is Android?
An operating system for smartphones and tablets
An operating system for desktop computers
A specific smartphone model
The games of mobile phones
None of above
Software are referred to
computer programs
hardware
procedure
binary data
digital information
The smallest structural unit within a table is ..
cell
row
kolumn
range
counting
What is the intersection of a column and a row on a worksheet called ?
Cell
Column
Value
Address
Column Chart
Which among following is associated with excel ?
Spreadsheet
Graphic program
None of these
MS-Excel
Varaible
A Spreadsheet contains ?
rows and columns
rows
columns
None of above
Formatting
If you press ___, the cell accepts your typing as its contents ?
Enter
Alt+Enter
Ctrl+Enter
Tab
Alt+Enter+Shift
On an excel sheet the active cell in indicated by ?
A dark wide border
A dotted border
By italic text
A blinking border
Comment
With which of the following all formulas in excel starts ?
=
/
==
*
**
Microsoft Excel is a multifunctional
Spreadsheet package
Interconnection
Word processing package
Communication S/W Package
DBMS package
A keyboard is this kind of device—
input
output
word Processing
black
scanning
The ____ , also called the “brains” of the computer, is responsible for processing data.
CPU
RAM
memory
motherboard
mouse
Select the smallest memory size.
Kilobyte
Terabyte
Gigabyte
Megabyte
Exabyte
Which of the following is an Open-Source computer operating system?
Linux
MAC OS-X
MS DOS
Windows 10
Windows XP
For the top table (i.e. Order Table), which is the primary key?
Pupil_ID
Surname
Forename
TG
Contact number
In context to database management system, SQL stands for
Structured Query Language
Standard Query Language
Specific Query Language
Special Query Language
Super Query Language
What should a primary key contain?
A unique value
A null value
A lot of different values
A foreign key
All properties
Below is part of a table from a database. How many records are there in the database table?
Six
Seven
Four
Five
About fifty
Below is part of a table from a database. How many fields are there in the database table?
Five
Three
Six
Four
None
The Microsoft program used for Databases is:
Access
Word
Excel
Paint
Publisher
Which of the following is a feature of DBMS?
Single-user Access only
Minimum Duplication and Redundancy of Data
Support ACID Property
Table processing
ROM
Which of the following is not an example of DBMS?
MySQL
Microsoft Acess
IBM DB2
Foxpro
In which of the following formats data is stored in the database management system?
Table
Image
Text
Graph
Video
What is a database?
Organized collection of information that can be accessed, updated, and managed
Organized collection of information that cannot be accessed, updated, and managed
Collection of data or information without organizing
Organized collection of data that cannot be updated
Other
What is DBMS?
DBMS stores, modifies and retrieves data
DBMS is a collection of queries
DBMS is a high-level language
DBMS is a programming language
DBMS is vehicle
