Font size
WorksheetsDatabase and Computer Maintenance Quiz
Total questions: 61
Worksheet time: 33mins
A data model describes ______ data for storage.
unclear
integer
structured
undefined
Which is NOT a standard data model?
ISO 10303
ISO 15926
IDEAS
Newton Model
The basic building block of an ERD is an ________.
entity
icon
device
component
A table in a relational database is also called a ______
file
relation
sheet
record
A primary key must be _______
empty
duplicated
a unique identifier
a number
Which of the following is a foreign key?
A key linking two tables
The shortest field
A deleted field
A numeric value
A one-to-many relationship is shown as:
1 : 0
1 : 1
1 : M
M : M
“A student registers for many courses” is:
1 : 1
1 : M
M : M
none
Normalization is used to reduce
beauty
redundancy
storage
queries
Which normal form removes repeating groups?
1NF
2NF
3NF
BCNF
2NF removes ______ dependencies.
trivial
partial
absolute
none
3NF removes ______ dependencies.
multivalued
transitive
additive
numeric
A composite key is made of
one field
two or more fields
images
symbols
A relationship between two primary keys is called
composite table
junction table
entity table
page file
Which is a constraint?
SELECT
FOREIGN KEY
RETURN
A tuple refers to a ______
row
column
table
key
A domain refers to the set of possible ______
tables
keys
values
diagrams
An attribute is a ______ of an entity.
description
picture
sound
folder
Deleting a record is part of ______ operations.
DDL
DML
SQL*
DNS
The SQL command to create a table is
INSERT
CREATE
DELETE
An index is a ______ of a table.
sorted copy
backup
folder
picture
An index entry contains a key value and a ______
stamp
pointer
name
row
Clustered indexes require data to be ______
random
sorted
deleted
encrypted
A table can have only one ______ index
unclustered
clustered
deleted
foreign
Unclustered indexes store keys in
random order
different structure from main file
the same table
no file
Indexes improve
power usage
query speed
RAM size
viruses
An index that stores every search-key value is
sparse
empty
dense
minimal
A sparse index stores
one entry per row
one entry per block
all entries twice
no entries
An index is mostly used in ______ operations.
update
search
format
backup
A search key in an index may contain
only numbers
any field
only primary keys
images
A primary index is created on the ______
first field
primary key
last row
domain
A secondary index can be created on a ______
primary key only
non-key attribute
table name
server
Range queries retrieve records
in a single row
within specific limits
without conditions
randomly
Composite search keys contain ______
text only
two or more fields
images
numbers only
The search key in a sparse index must be
large
sorted
unique
encrypted
Secondary indexes are mostly
sparse
empty
dense
random
A multi-level index is used to improve
speed
colours
screen size
user accounts
Which of the following is an example of a range query?
WHERE age = 10
WHERE age BETWEEN 10 AND 20
WHERE name = 'Dan'
SELECT * FROM table
Which type of index uses block-level pointers?
dense
sparse
unique
composite
Composite keys are useful when
one key cannot uniquely identify a row
no keys exist
tables are empty
indexes fail
Before cleaning a PC, always
update drivers
shut down and unplug
remove the CPU
delete files
A computer case should be cleaned
weekly
yearly
every 5 years
never
Dust inside a PC is removed using
wet cloth
compressed air
petrol
soap water
Which is safe for cleaning screens?
paper towel
microfiber cloth
sandpaper
brush
Keyboards are best cleaned using
water
vacuum or blower
soap
grease
Mice should be cleaned using
isopropyl alcohol
kerosene
engine oil
water
Overheating is caused by
too much RAM
blocked air vents
low brightness
large fonts
To avoid electrical shock, avoid touching components with
bare hands
metal tools
dry hands
glasses
This tool removes screws in hardware work
plier
screwdriver
broom
chisel
Anti-static wrist straps prevent
dust
electric discharge damage
noise
heat
Maintenance that fixes errors is
corrective
preventive
adaptive
perfective
Maintenance that improves performance is
adaptive
corrective
perfective
destructive
Changing software to suit new hardware is
adaptive
perfective
random
preventive
Preventive maintenance involves
cleaning RAM
anticipating & reducing future problems
deleting the OS
corrupting files
A good maintenance routine includes
disk cleanup
deleting antivirus
overcharging battery
removing updates
Defragmentation improves
colour
file access speed
virus spread
boot time only
Software updates help to
cause bugs
improve security
slow the system
delete files
A backup is stored
on multiple media
only on RAM
in the recycle bin
on deleted folders
Removing unused apps is part of
destructive maintenance
performance tuning
virus creation
nothing
Antivirus software helps to
damage files
detect malware
delete OS
reduce RAM
Explain the difference between data and information. Give one example of each.
