ACC 356 Test Bank 4 Questions And Answers With
Verified Solutions
Using a file-oriented approach to data and information, data is maintained in
many separate files.
In a well-structured relational database,
every table must be related to at least one other table.
Previous
Play
Next
Rewind 10 seconds
Move forward 10 seconds
Unmute
0:00
/
0:15
Full screen
Brainpower
Read More
File-oriented approaches create problems for organizations because of
multiple master files.
Which statement is true regarding files systems?
Multiple master files create problems with data consistency.
The ________ acts as an interface between the database and the various application programs.
database management system
The combination of the database, the DBMS, and the application programs that access the database through the
DBMS is referred to as the
database system
The person responsible for the database is the
database administrator
All of the following are benefits of the database approach except:
decentralized management of data.
, The physical view of a database system refers to
how and where the data are physically arranged and stored.
The ________ handles the link between the way data are physically stored and each user's logical view of that data.
database management (DBMS) software
The logical structure of a database is described by the
schema
The schema that provides an organization-wide view of the entire database is known as the
conceptual-level schema
A set of individual user views of the database is called the
external-level schema
A low-level view of the database that describes how the data are actually stored and accessed is the
internal-level schema
Record layouts, definitions, addresses, and indexes will be stored at the ________ level schema
internal
The ________ contains information about the structure of the database.
data dictionary
Which of the following would not be found in a data dictionary entry for a data item?
physical location of the data
The data dictionary usually is maintained
automatically by the DBMS
Reports produced using the data dictionary could include all of the following except a list of
the schemas included in the database
Which statement below concerning the database management system (DBMS) is false?
The DBMS automatically creates application software for users, based on data dictionary parameters.
Which would not generally be considered a data dictionary output report?
A list of cash balances in the organization's bank of accounts.
Creating an empty table in a relational database requires use of the ________, and populating that table requires the
use of ________.
DDL; DML
When the human resources manager wants to gather data about vacation and personal day usage by employees and
by departments, the manager would use which language?
Data Query Language
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 Nipsey. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.