Database Management Systems Test 1 (with Errorless
answers)
keep track of things correct answers A database may be used to help people:
A database may be used to help people: correct answers know the current inventory levels of
products their company sells
-look up their checking account balance over the Internet.
-check on the estimated arrival time of an incoming flight at an airport.
-track which student is assigned to a particular advisor.
relational model correct answers Today almost every commercial database is based on:
Structured Query Language correct answers SQL stands for:
Users Database Application DBMS Database correct answers Basic Component of a database
system:
metadata correct answers The component of a database that makes it self-describing is the:
DBMS correct answers The creation of a database and its tables is a function of which
component of the database system?
Function of the database application in a database system correct answers Intermediary between
user and dbms.
Read or modify database data by sending sql statements to DBMS.
Present data to users in forms and reports.
database management system correct answers Microsoft SQL Server is an example of a:
accdb mdb correct answers Microsoft Access 2013 database files are stored using the file
extension:
DBMS functions correct answers create database
create tables
create supporting structures
read database data
modify database data
maintain database structures
enforce rules
control concurrency
provide security
perform backup and recovery
duplicate column names correct answers Which of the following is not true about a relation?
answers)
keep track of things correct answers A database may be used to help people:
A database may be used to help people: correct answers know the current inventory levels of
products their company sells
-look up their checking account balance over the Internet.
-check on the estimated arrival time of an incoming flight at an airport.
-track which student is assigned to a particular advisor.
relational model correct answers Today almost every commercial database is based on:
Structured Query Language correct answers SQL stands for:
Users Database Application DBMS Database correct answers Basic Component of a database
system:
metadata correct answers The component of a database that makes it self-describing is the:
DBMS correct answers The creation of a database and its tables is a function of which
component of the database system?
Function of the database application in a database system correct answers Intermediary between
user and dbms.
Read or modify database data by sending sql statements to DBMS.
Present data to users in forms and reports.
database management system correct answers Microsoft SQL Server is an example of a:
accdb mdb correct answers Microsoft Access 2013 database files are stored using the file
extension:
DBMS functions correct answers create database
create tables
create supporting structures
read database data
modify database data
maintain database structures
enforce rules
control concurrency
provide security
perform backup and recovery
duplicate column names correct answers Which of the following is not true about a relation?
