UTA INSY 2303 EXAM 3 REVIEW (UNITS 9-11) LATEST 2026 UPDATED
QUESTIONS AND VERIFIED 100% SOLUTIONS (2026/2027) |A+
GRADED |GUARANTEED PASS
A(n) _________ sort uses one field, to arrange records. A(n) _________ sort arranges
information by more than one field. - Answers -Single-level; multi-level.
An efficiently designed database uses computed fields whenever possible because they do not
require manual data entry. - Answers -True
The SQL ________ command allows you to temporarily join and simultaneously access the data
in more than one table. - Answers -JOIN
Which database tool is best for simple flat files that involve calculations? - Answers -
Spreadsheet software
In a key-value database, each data item has a key that is a unique identifier similar to a
relational database key - Answers -True
A(n) _________ database is used to collect, modify, and maintain data on a daily basis. -
Answers -Operational
1|Page
, The goal of normalization is to minimize data redundancy. - Answers -True
In a database, a(n) __________ contains the smallest unit of meaningful information - Answers -
Field
Which of the following is not considered to be type of database client? - Answers -Apps, local
software, and browsers.
Spreadsheet software offers database capabilities for establishing relationships between
different record types. - Answers -False
In a relational database, relationships are specified by joining common data stored in records
from different tables. - Answers -True
Which of the following is not one of the main activities associated with operational databases? -
Answers -Providing an executive dashboard for decision makers.
The relationship between record types can be depicted graphically with a(n) _________. -
Answers -ERD
2|Page
QUESTIONS AND VERIFIED 100% SOLUTIONS (2026/2027) |A+
GRADED |GUARANTEED PASS
A(n) _________ sort uses one field, to arrange records. A(n) _________ sort arranges
information by more than one field. - Answers -Single-level; multi-level.
An efficiently designed database uses computed fields whenever possible because they do not
require manual data entry. - Answers -True
The SQL ________ command allows you to temporarily join and simultaneously access the data
in more than one table. - Answers -JOIN
Which database tool is best for simple flat files that involve calculations? - Answers -
Spreadsheet software
In a key-value database, each data item has a key that is a unique identifier similar to a
relational database key - Answers -True
A(n) _________ database is used to collect, modify, and maintain data on a daily basis. -
Answers -Operational
1|Page
, The goal of normalization is to minimize data redundancy. - Answers -True
In a database, a(n) __________ contains the smallest unit of meaningful information - Answers -
Field
Which of the following is not considered to be type of database client? - Answers -Apps, local
software, and browsers.
Spreadsheet software offers database capabilities for establishing relationships between
different record types. - Answers -False
In a relational database, relationships are specified by joining common data stored in records
from different tables. - Answers -True
Which of the following is not one of the main activities associated with operational databases? -
Answers -Providing an executive dashboard for decision makers.
The relationship between record types can be depicted graphically with a(n) _________. -
Answers -ERD
2|Page
