UTA INSY 3304 EXAM QUESTIONS AND ANSWERS
LATEST UPDATE (ALREADY GRADED A+)
A _______ is anything about which data are to be collected and stored.
entity
A ________ is bidirectional.
relationship
Database designers determine the data and information that yield the required understanding of the
entire business.
False
In an SQL-based relational database, each table is dependent on every other table.
False
An operational database is sometimes referred to as an enterprise database.
False
Corporations use only structured data.
False
Business rules apply to businesses and government groups, but not to other types of organizations
such as religious groups or research labs.
False
________ data exist in a format that does not lend itself to processing that yields information.
Unstructured
A data warehouse can store data derived from many sources.
True
A ____ is a collection of related records.
file
A noun in a business rules translates to an ______ in the data model.
entity
The database structure in a DBMS is stores as a
collection of files.
, M:N relationships are not appropriate in a relational model.
True
___________ relates to the activities that make the database execute transactions more efficiently in
terms of storage and access speed.
Performance tuning
Data processing can be as simple as organization data to reveal patterns.
True
An _________ is the equivalent of a field in a file system.
attribute
Within the database environment, a data model represents data structures with the purpose of
supporting a specific problem domain.
True
Data is the results of processing raw facts to reveal its meaning.
False
A desktop database is a ________ database.
single-user
A workgroup database is a ________ database.
multiuser
_________ provide a description of the data characteristics and the set of relationships that link the
data found within the database.
Metadata
Database programming languages receive all application requests and translate them into the
complex operations required to a fulfill those requests.
False
Each row in the relational table is known as an entity instance or entity occurrence in the ER model.
True
The external model is the representation of the database as "seen" by the DBMS
False
An _______ database is used by an organization and supports many users across many departments.
enterprise
LATEST UPDATE (ALREADY GRADED A+)
A _______ is anything about which data are to be collected and stored.
entity
A ________ is bidirectional.
relationship
Database designers determine the data and information that yield the required understanding of the
entire business.
False
In an SQL-based relational database, each table is dependent on every other table.
False
An operational database is sometimes referred to as an enterprise database.
False
Corporations use only structured data.
False
Business rules apply to businesses and government groups, but not to other types of organizations
such as religious groups or research labs.
False
________ data exist in a format that does not lend itself to processing that yields information.
Unstructured
A data warehouse can store data derived from many sources.
True
A ____ is a collection of related records.
file
A noun in a business rules translates to an ______ in the data model.
entity
The database structure in a DBMS is stores as a
collection of files.
, M:N relationships are not appropriate in a relational model.
True
___________ relates to the activities that make the database execute transactions more efficiently in
terms of storage and access speed.
Performance tuning
Data processing can be as simple as organization data to reveal patterns.
True
An _________ is the equivalent of a field in a file system.
attribute
Within the database environment, a data model represents data structures with the purpose of
supporting a specific problem domain.
True
Data is the results of processing raw facts to reveal its meaning.
False
A desktop database is a ________ database.
single-user
A workgroup database is a ________ database.
multiuser
_________ provide a description of the data characteristics and the set of relationships that link the
data found within the database.
Metadata
Database programming languages receive all application requests and translate them into the
complex operations required to a fulfill those requests.
False
Each row in the relational table is known as an entity instance or entity occurrence in the ER model.
True
The external model is the representation of the database as "seen" by the DBMS
False
An _______ database is used by an organization and supports many users across many departments.
enterprise
