DBMS

DBMS allows a user to do all of these tasks except:

• Speed up the operation of a computer

• Create a blank database table

• Extract a data set from a number of tables

• Produce reports that combine and summarise the data.

Which of the following is not a DBMS despite having database capabilities:

• Microsoft Excel or similar spreadsheets

• Oracle

• MySQL

• Microsoft Access or similar

Which of the following is the most important feature of DBMS:

• Command language like SQL

• Ability to back up data

• Ease of use

• Ability to automate some tasks

In DBMS systems data is separated from control.

• True

• False

It is hard to get one DBMS system to exchange data with another DBMS.

• False

• True

All DBMS systems use SQL as a command language.

• False

• True

DBMS can summarise the data stored in the database and produce an easy to read _____:

• reports

• queries

• tables

• criteria

A database entity is also known as:

• a table

• a field

• a row

• a report

A particular DBMS uses SQL for extracting data. The SQL command "WHERE" is usually followed by:

• a criteria

• a table name

• a user name

• a mathematical formula

A DBMS system is made up of:

• queries, forms, reports

• tables, entities, fields

• rows, columns, criteria

• data and commands