Databases - 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 / condition/s
• 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