WorksheetsDatabases - DBMS
Total questions: 10
Worksheet time: 4mins
Name
Class
Date
1.
DBMS allows a user to do all of these tasks except:
a)
Speed up the operation of a computer
b)
Create a blank database table
c)
Extract a data set from a number of tables
d)
Produce reports that combine and summarise the data.
2.
Which of the following is not a DBMS despite having database capabilities:
a)
Microsoft Excel or similar spreadsheets
b)
Oracle
c)
MySQL
d)
Microsoft Access or similar
3.
Which of the following is the most important feature of DBMS:
a)
Command language like SQL
b)
Ability to back up data
c)
Ease of use
d)
Ability to automate some tasks
4.
In DBMS systems data is separated from control.
a)
True
b)
False
5.
It is hard to get one DBMS system to exchange data with another DBMS.
a)
False
b)
True
6.
All DBMS systems use SQL as a command language.
a)
False
b)
True
7.
DBMS can summarise the data stored in the database and produce an easy to read _____:
a)
reports
b)
queries
c)
tables
d)
criteria
8.
A database entity is also known as:
a)
a table
b)
a field
c)
a row
d)
a report
9.
A particular DBMS uses SQL for extracting data. The SQL command "WHERE" is usually followed by:
a)
a criteria
b)
a table name
c)
a user name
d)
a mathematical formula
10.
A DBMS system is made up of:
a)
queries, forms, reports
b)
tables, entities, fields
c)
rows, columns, criteria
d)
data and commands
100 %
