ICT-225 PRE-ASSESSMENT QUIZ
QUESTIONS WITH COMPLETE
SOLUTIONS
A __________ is typically responsible for detailed technical knowledge of an existing
database management system, indexes, and SQL so that improvements can be
made in speed and response times.
a. performance analyst
b. database architect
c. data modeler
d. research analyst - Answer-a. performance analyst
Microsoft Access is probably NOT appropriate in which of the following cases?
a. Few people use the database at the same time.
b. The database is distributed over a large area network.
c. Only trusted users work with the database.
d. Data is organized in related tables. - Answer-b. The database is distributed over a
large area network.
Two tables have a one-to-one relationship when one record in the first table
__________.
a. relates to no more than one record in the other table.
b. relates to one, none, or many records in the other table.
c. relates to no records in the other table.
d. relates only to another record in the same table. - Answer-a. relates to no more
than one record in the other table.
If you create a copy of a database and distribute it to other computers or locations,
the copy is called a(n) __________.
a. dupe
b. synch
c. decoy
d. replica - Answer-d. replica
Being able to change a field property without changing associated programs
dependent on that data is an example of __________.
a. data independence
b. key integrity constraints
c. record-level locking
d. data integrity - Answer-a. data independence
A(n) __________ is a common name for a unique value that identifies each person
and is generally a combination of characters that reflect a person's name or
employee number.
a. user ID
b. encryption key
, c. biometric ID
d. alternate key - Answer-a. user ID
As you convert lists of data into third normal form, what other task must you perform
to build a healthy relational database?
a. connect tables in correct one-to-many relationships
b. modify user views
c. design meaningful reports
d. create metadata - Answer-a. connect tables in correct one-to-many relationships
Which of the following is generally considered a fundamental technical competency
for a database administrator?
a. SQL
b. JavaScript
c. Microsoft Word
d. macOS - Answer-a. SQL
In a client/server system, the database resides on a computer called the
__________, and a user accesses the database through a __________.
a. database manager, user manager
b. server, peer
c. client, server
d. server, client - Answer-c. client, server
x
What does the expression Max([Salary]) in the query grid of Microsoft Access Query
Design View return?
a. the number of values in the Salary field
b. the sum of the values in the Salary field
c. the highest value in the Salary field
d. the most common value in the Salary field - Answer-c. the highest value in the
Salary field
A database __________ contains a collection of persons, places, events, items, or
other similar transactions for which you want to store and process data.
a. field
b. row
c. property
d. entity - Answer-d. entity
In Microsoft Access, what data type would you most likely assign to a field containing
price values?
a. Currency
b. Number
c. Price
d. Short Text - Answer-a. Currency
A query that retrieves fields and records from the database is commonly called a
__________.
a. select query
QUESTIONS WITH COMPLETE
SOLUTIONS
A __________ is typically responsible for detailed technical knowledge of an existing
database management system, indexes, and SQL so that improvements can be
made in speed and response times.
a. performance analyst
b. database architect
c. data modeler
d. research analyst - Answer-a. performance analyst
Microsoft Access is probably NOT appropriate in which of the following cases?
a. Few people use the database at the same time.
b. The database is distributed over a large area network.
c. Only trusted users work with the database.
d. Data is organized in related tables. - Answer-b. The database is distributed over a
large area network.
Two tables have a one-to-one relationship when one record in the first table
__________.
a. relates to no more than one record in the other table.
b. relates to one, none, or many records in the other table.
c. relates to no records in the other table.
d. relates only to another record in the same table. - Answer-a. relates to no more
than one record in the other table.
If you create a copy of a database and distribute it to other computers or locations,
the copy is called a(n) __________.
a. dupe
b. synch
c. decoy
d. replica - Answer-d. replica
Being able to change a field property without changing associated programs
dependent on that data is an example of __________.
a. data independence
b. key integrity constraints
c. record-level locking
d. data integrity - Answer-a. data independence
A(n) __________ is a common name for a unique value that identifies each person
and is generally a combination of characters that reflect a person's name or
employee number.
a. user ID
b. encryption key
, c. biometric ID
d. alternate key - Answer-a. user ID
As you convert lists of data into third normal form, what other task must you perform
to build a healthy relational database?
a. connect tables in correct one-to-many relationships
b. modify user views
c. design meaningful reports
d. create metadata - Answer-a. connect tables in correct one-to-many relationships
Which of the following is generally considered a fundamental technical competency
for a database administrator?
a. SQL
b. JavaScript
c. Microsoft Word
d. macOS - Answer-a. SQL
In a client/server system, the database resides on a computer called the
__________, and a user accesses the database through a __________.
a. database manager, user manager
b. server, peer
c. client, server
d. server, client - Answer-c. client, server
x
What does the expression Max([Salary]) in the query grid of Microsoft Access Query
Design View return?
a. the number of values in the Salary field
b. the sum of the values in the Salary field
c. the highest value in the Salary field
d. the most common value in the Salary field - Answer-c. the highest value in the
Salary field
A database __________ contains a collection of persons, places, events, items, or
other similar transactions for which you want to store and process data.
a. field
b. row
c. property
d. entity - Answer-d. entity
In Microsoft Access, what data type would you most likely assign to a field containing
price values?
a. Currency
b. Number
c. Price
d. Short Text - Answer-a. Currency
A query that retrieves fields and records from the database is commonly called a
__________.
a. select query
