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 th...
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 benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller CertifiedGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.49. You're not tied to anything after your purchase.
