100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
IS 301 EXAM 2 Complete Solutions $9.49
Add to cart
Quickly navigate to
Preview
  2.  
  3. IS 301 EXM 2 Complete Solution
  4.  
  5. IS 301 EXM 2 Complete Solution

Exam (elaborations)

IS 301 EXAM 2 Complete Solutions
 0 purchase
  • Course
  • IS 301 EXM 2 Complete Solution
  • Institution
  • IS 301 EXM 2 Complete Solution

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...

[Show more]

Preview 3 out of 24  pages

Document information

  • October 30, 2024
  • 24
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

  • is 301 exam 2 complete solutions

Written for

  • IS 301 EXM 2 Complete Solution
  • IS 301 EXM 2 Complete Solution

Seller

avatar-seller
CertifiedGrades

Reviews received

Content preview

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 benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

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

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69411 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling
$9.49
  • (0)
Add to cart
Added