IS 301 EXAM 2 Complete Solutions
The structure and content of a database depends entirely on how users view their business activity.
✔️✔️True
A spreadsheet is used to store data with multiple themes. ✔️✔️False
The purpose of a database is to keep track of things that involve a single theme. ✔️✔️False
A database is a self-describing collection of integrated records. ✔️✔️True
A database is best described as a collection of tables which are not related to each other. ✔️✔️False
A group of similar rows or records is called a field. ✔️✔️False
Special data that describes the structure of a database is called metadata. ✔️✔️True
A key is a column or group of columns that identifies a unique row in a table. ✔️✔️True
Every table in a database must have a key associated with it. ✔️✔️False
Databases that carry their data in the form of tables and that represent relationships without using
foreign keys are called relational databases. ✔️✔️False
The format of metadata depends on the software product that is processing the database. ✔️✔️True
A DBMS is a software that helps to manage the operating system. ✔️✔️False
,Most organizations develop their own DBMS software in order to obtain control over the data.
✔️✔️False
MySQL is an open-source DBMS package which is license-free for most database applications.
✔️✔️True
To modify an existing table, the developer opens the metadata form for that table and adds a new row
of metadata. ✔️✔️True
In order to read, insert, modify, or delete data, applications have to call upon the DBMS in a
standardized way. ✔️✔️False
SQL is an international standard language for processing a database. ✔️✔️True
SQL cannot be used to create databases and database structures. ✔️✔️False
One of the functions of a DBMS is to provide tools to assist in the administration of the database.
✔️✔️True
One of the developmental tasks of the database administrator is to develop a system to record and
manage resolution of problems. ✔️✔️False
Managing the impact of database structure changes on applications and users is an operational task of
the database administrator. ✔️✔️False
DBMS can be used to set up security systems involving user accounts, passwords, permissions, and limits
for processing the database. ✔️✔️True
A database application is a collection of forms, reports, queries, and application programs that process a
database. ✔️✔️True
, A database must have only one application though the application can have one or more users.
✔️✔️False
In order to find the data one is looking for in the DBMS, one has to type in the keyword into a query
form. ✔️✔️True
Application programs process logic that is specific to a given business need. ✔️✔️True
Lost-update problem can be resolved by implementing multi-user database processing. ✔️✔️False
Some type of locking must be used to coordinate the activities of users who know nothing about one
another in order to prevent the lost-update problem. ✔️✔️True
Microsoft's SQL Server is an example of a personal DBMS product. ✔️✔️False
Microsoft Access is both a DBMS and an application development product. ✔️✔️True
A data model describes the data whereas a database explains the relationships among data that will be
stored in the database. ✔️✔️False
The entity-relationship data model is a tool for evaluating the existing data models. ✔️✔️False
In data models, physical objects are represented as entities whereas logical constructs and transactions
are represented as attributes. ✔️✔️False
Attributes are used to describe characteristics of the entity. ✔️✔️True
An identifier is an attribute or a group of attributes whose value is associated with one and only one
entity instance. ✔️✔️True
The structure and content of a database depends entirely on how users view their business activity.
✔️✔️True
A spreadsheet is used to store data with multiple themes. ✔️✔️False
The purpose of a database is to keep track of things that involve a single theme. ✔️✔️False
A database is a self-describing collection of integrated records. ✔️✔️True
A database is best described as a collection of tables which are not related to each other. ✔️✔️False
A group of similar rows or records is called a field. ✔️✔️False
Special data that describes the structure of a database is called metadata. ✔️✔️True
A key is a column or group of columns that identifies a unique row in a table. ✔️✔️True
Every table in a database must have a key associated with it. ✔️✔️False
Databases that carry their data in the form of tables and that represent relationships without using
foreign keys are called relational databases. ✔️✔️False
The format of metadata depends on the software product that is processing the database. ✔️✔️True
A DBMS is a software that helps to manage the operating system. ✔️✔️False
,Most organizations develop their own DBMS software in order to obtain control over the data.
✔️✔️False
MySQL is an open-source DBMS package which is license-free for most database applications.
✔️✔️True
To modify an existing table, the developer opens the metadata form for that table and adds a new row
of metadata. ✔️✔️True
In order to read, insert, modify, or delete data, applications have to call upon the DBMS in a
standardized way. ✔️✔️False
SQL is an international standard language for processing a database. ✔️✔️True
SQL cannot be used to create databases and database structures. ✔️✔️False
One of the functions of a DBMS is to provide tools to assist in the administration of the database.
✔️✔️True
One of the developmental tasks of the database administrator is to develop a system to record and
manage resolution of problems. ✔️✔️False
Managing the impact of database structure changes on applications and users is an operational task of
the database administrator. ✔️✔️False
DBMS can be used to set up security systems involving user accounts, passwords, permissions, and limits
for processing the database. ✔️✔️True
A database application is a collection of forms, reports, queries, and application programs that process a
database. ✔️✔️True
, A database must have only one application though the application can have one or more users.
✔️✔️False
In order to find the data one is looking for in the DBMS, one has to type in the keyword into a query
form. ✔️✔️True
Application programs process logic that is specific to a given business need. ✔️✔️True
Lost-update problem can be resolved by implementing multi-user database processing. ✔️✔️False
Some type of locking must be used to coordinate the activities of users who know nothing about one
another in order to prevent the lost-update problem. ✔️✔️True
Microsoft's SQL Server is an example of a personal DBMS product. ✔️✔️False
Microsoft Access is both a DBMS and an application development product. ✔️✔️True
A data model describes the data whereas a database explains the relationships among data that will be
stored in the database. ✔️✔️False
The entity-relationship data model is a tool for evaluating the existing data models. ✔️✔️False
In data models, physical objects are represented as entities whereas logical constructs and transactions
are represented as attributes. ✔️✔️False
Attributes are used to describe characteristics of the entity. ✔️✔️True
An identifier is an attribute or a group of attributes whose value is associated with one and only one
entity instance. ✔️✔️True
