ITE 100 EXAM 4 (UNIT 10, UNIT 11, UNIT 12) QUESTIONS
WITH ACCURATE SOLUTIONS
1) What is a more user-friendly interface some users use instead of interacting directly
with a DBMS?
a) data file
b) home page
c) front end
d) user environment -- Answer ✔✔ front end
2) Which of the following, with regard to the entire database, should be made on a
regular basis?
a) after image
b) retread
c) backup
d) baseline -- Answer ✔✔ backup
3) Applications best suited for relational databases are those whose data can be
organized in a two-dimensional table.
True or False -- Answer ✔✔ True
,4) Which of the following is a huge database that stores and manages the data required
to analyze historical and current transactions?
a) data distribution
b) data analysis
c) data warehouse
d) data marketing -- Answer ✔✔ data warehouse
5) What is data redundancy?
a) Data is linked to multiple records in a database.
b) Each department has its own files, so the same data might be stored in
multiple files.
c) In the same database, each department enters data without checking to
ensure it has not already been entered.
d) There is no primary key to distinguish records. -- Answer ✔✔ Each
department has its own files, so the same data might be stored in
multiple files.
6) What is a feature that has a graphical user interface to assist users with retrieving
data?
a) SQL
b) DBE
c) NoSQL
d) QBE -- Answer ✔✔ QBE
,7) A data model defines how users view the organization of data.
True or False -- Answer ✔✔ True
8) In what kind of recovery does the DBMS use the log to reenter changes made to a
database since the last save or backup?
a) baseline
b) integrated
c) instant
d) forward -- Answer ✔✔ forward
9) Data integrity is important because computers and people use information to make
decisions and take actions.
True or False -- Answer ✔✔ True
10) What database term is used to describe a request for specific data from the
database?
a) retrieval
b) information
c) analysis
d) query -- Answer ✔✔ query
11) What is the smallest unit of data the computer can process?
a) reg
b) bit
c) log
d) byte -- Answer ✔✔ bit
, 12) What is the process of presenting data graphically as charts, maps, or other pictorial
formats in order to understand the resulting information easily?
a) data velocity
b) data integrity
c) data visualization
d) data relationships -- Answer ✔✔ data visualization
13) Which of the following is a window on the screen that provides areas for entering or
modifying data in a database?
a) recovery screen
b) change screen
c) form
d) report -- Answer ✔✔ form
14) Which of the following is an advantage of a multidimensional database?
a) It can store data in two dimensions.
b) All multidimensional databases have a dimension of time.
c) The content of all dimensions is the same regardless of the subject.
d) There is a common query language. -- Answer ✔✔ It can store data in
two dimensions.
15) You create a database that stores data in tables that consist of rows and columns.
Each row has a primary key, and each column has a unique name. Which data model
did you use?
WITH ACCURATE SOLUTIONS
1) What is a more user-friendly interface some users use instead of interacting directly
with a DBMS?
a) data file
b) home page
c) front end
d) user environment -- Answer ✔✔ front end
2) Which of the following, with regard to the entire database, should be made on a
regular basis?
a) after image
b) retread
c) backup
d) baseline -- Answer ✔✔ backup
3) Applications best suited for relational databases are those whose data can be
organized in a two-dimensional table.
True or False -- Answer ✔✔ True
,4) Which of the following is a huge database that stores and manages the data required
to analyze historical and current transactions?
a) data distribution
b) data analysis
c) data warehouse
d) data marketing -- Answer ✔✔ data warehouse
5) What is data redundancy?
a) Data is linked to multiple records in a database.
b) Each department has its own files, so the same data might be stored in
multiple files.
c) In the same database, each department enters data without checking to
ensure it has not already been entered.
d) There is no primary key to distinguish records. -- Answer ✔✔ Each
department has its own files, so the same data might be stored in
multiple files.
6) What is a feature that has a graphical user interface to assist users with retrieving
data?
a) SQL
b) DBE
c) NoSQL
d) QBE -- Answer ✔✔ QBE
,7) A data model defines how users view the organization of data.
True or False -- Answer ✔✔ True
8) In what kind of recovery does the DBMS use the log to reenter changes made to a
database since the last save or backup?
a) baseline
b) integrated
c) instant
d) forward -- Answer ✔✔ forward
9) Data integrity is important because computers and people use information to make
decisions and take actions.
True or False -- Answer ✔✔ True
10) What database term is used to describe a request for specific data from the
database?
a) retrieval
b) information
c) analysis
d) query -- Answer ✔✔ query
11) What is the smallest unit of data the computer can process?
a) reg
b) bit
c) log
d) byte -- Answer ✔✔ bit
, 12) What is the process of presenting data graphically as charts, maps, or other pictorial
formats in order to understand the resulting information easily?
a) data velocity
b) data integrity
c) data visualization
d) data relationships -- Answer ✔✔ data visualization
13) Which of the following is a window on the screen that provides areas for entering or
modifying data in a database?
a) recovery screen
b) change screen
c) form
d) report -- Answer ✔✔ form
14) Which of the following is an advantage of a multidimensional database?
a) It can store data in two dimensions.
b) All multidimensional databases have a dimension of time.
c) The content of all dimensions is the same regardless of the subject.
d) There is a common query language. -- Answer ✔✔ It can store data in
two dimensions.
15) You create a database that stores data in tables that consist of rows and columns.
Each row has a primary key, and each column has a unique name. Which data model
did you use?
