HCA416 MIDTERM EXAM QUESTIONS AND ANSWERS
WITH COMPLETE SOLUTIONS VERIFIED
A data table
is made up of rows and columns
DBMS
Database Management System
Flat file database
database with only one table
Primary Key
uniquely identifies a record
Microsoft Access is an example of
relational database management software
SQL
Structured Query Language
SQL is used to
manipulate data in a relational database
What SQL statement will select all columns and rows from the table visits
SELECT* FROM visits
What is included in a data dictionary
field length, data type, field description
The field reference cpt. code in a SQL query refers to
, the table named code found in the database named cpt
Which phase of data modeling includes a description of the business process?
conceptual model
Which phase of data modeling describes the relationship between the data
tables?
logical model
Which phase of data modeling includes the selection of the database type?
Physical model
An entity-relationship diagram describes all of the following except
DBMS software
Which of the following is not a data base management software package?
Microsoft excel
These data do not have a true zero and the distance between the data points is
consistent
interval
These data separate records into mutually exclusive categories in a meaningful
order
ordinal
These data have a true zero and the distance between the data points is
consistent
ratio
these data separate records into mutually exclusive, named, categories with no
order
WITH COMPLETE SOLUTIONS VERIFIED
A data table
is made up of rows and columns
DBMS
Database Management System
Flat file database
database with only one table
Primary Key
uniquely identifies a record
Microsoft Access is an example of
relational database management software
SQL
Structured Query Language
SQL is used to
manipulate data in a relational database
What SQL statement will select all columns and rows from the table visits
SELECT* FROM visits
What is included in a data dictionary
field length, data type, field description
The field reference cpt. code in a SQL query refers to
, the table named code found in the database named cpt
Which phase of data modeling includes a description of the business process?
conceptual model
Which phase of data modeling describes the relationship between the data
tables?
logical model
Which phase of data modeling includes the selection of the database type?
Physical model
An entity-relationship diagram describes all of the following except
DBMS software
Which of the following is not a data base management software package?
Microsoft excel
These data do not have a true zero and the distance between the data points is
consistent
interval
These data separate records into mutually exclusive categories in a meaningful
order
ordinal
These data have a true zero and the distance between the data points is
consistent
ratio
these data separate records into mutually exclusive, named, categories with no
order
