100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
Previously searched by you
Essentials of Database Management 1st Edition By Jeffrey A. Hoffer; Heikki Topi; Ramesh Venkataraman 9780133405682 Chapter 1-9 Complete Guide .$17.99
Add to cart
essentials of database management 1st edition by j
essentials of database management
essentials of database management
Connected book
Book Title:
Author(s):
Edition:
ISBN:
Edition:
More summaries for
Essentials of Database Management 1st Edition By Jeffrey A. Hoffer; Heikki Topi; Ramesh Venkataraman 9780133405682 Chapter 1-9 Complete Guide .
Essentials of Database Management 1st Edition By Jeffrey A. Hoffer; Heikki Topi; Ramesh Venkataraman 9780133405682 Chapter 1-9 Complete Guide .
Test Bank for Essentials of Database Management, 1st Edition by Jeffrey A. Hoffer, 9780133405682, Covering Chapters 1-9 | Includes Rationales
All for this textbook (8)
Written for
Essentials of Database Management 1st Edition By J
All documents for this subject (3)
Seller
Follow
phinta004
Reviews received
Content preview
Test Bank For Essentials of Database Management 1st Edition
By Jeffrey A. Hoffer; Heikki Topi; Ramesh Venkataraman
9780133405682 Chapter 1-9 Complete Guide .
In the Weak to Strong Entity Type Transformation, a weak entity type and identifying relationship are
converted into
a) a M-N relationship.
b) multiple attributes
c) a strong (not weak) entity type and regular (non-identifying) relationship.
d) two entity types and a 1-M relationship. - ANSWER: c) a strong (not weak) entity type and regular
(non-identifying) relationship.
For complex problems involving joins and grouping, you can decompose a SELECT statement by
a) executing grouping operations alone without row operations.
b) executing row operations alone without group operations.
c) executing row and group operations together in the same statement.
d) executing grouping conditions alone without row conditions. - ANSWER: b) executing row
operations alone without group operations.
The persistent property of databases indicates
a) Data reside in volatile memory erased when user interaction completes.
b) Applications using a database never fail.
c) Data reside on stable storage as the long-term memory of an organization.
d) Data requires appropriate authorization for modification and retrieval. - ANSWER: c) Data reside on
stable storage as the long-term memory of an organization.
The inter-related property of databases indicates
a) Entities exist independently without relationships to other entities.
b) Databases maintain connections or relationships among entities to store business interactions.
c)Entities exist independently except when required for applications.
d) Databases maintain connections among applications using entities. - ANSWER: b) Databases
maintain connections or relationships among entities to store business interactions.
The shared property of databases indicates
a) Databases can have multiple users and uses (applications).
b) Each entity in a database can only have one active user.
c) Organizations forfeit access controls to databases.
d) Organizations must grant open access to databases. - ANSWER: a) Databases can have multiple
users and uses (applications).
What is the meaning of the SQL acronym?
a) Sequel
b) Structured Quotient Lingo
c) Super Query Language
d) Structured Query Language - ANSWER: d) Structured Query Language
Identify important DBMS features. More than one answer is possible.
a) Non procedural access
b) Data definition
c) Transaction processing
d) Workflow definition - ANSWER: a) Non procedural access
b) Data definition
c) Transaction processing
,Indicate the work emphasis of a database administrator. More than one answer is possible.
a) Focused on individual databases
b) Primary role for data planning
c) Requires skills and knowledge of specific DBMSs
d) Primary role for setting data standards for an organization - ANSWER: a) Focused on individual
databases
c) Requires skills and knowledge of specific DBMSs
Indicate the work emphasis of a data administrator. More than one answer is possible.
a) Focused on individual databases
b) Primary role for data planning
c) Requires skills and knowledge of specific DBMSs
d) Primary role for setting data standards for an organization - ANSWER: b) Primary role for data
planning
d) Primary role for setting data standards for an organization
What is an enterprise DBMS?
a) Supports small workgroups with modest performance and reliability capabilities
b) Resides in a larger system, either an application or a device with limited transaction processing,
memory, processing, and storage.
c) Supports mission critical information systems with high performance for storage, transaction
processing, and scalability.
d) Supports servers for website usage - ANSWER: c) Supports mission critical information systems with
high performance for storage, transaction processing, and scalability.
What is a desktop DBMS?
a) Supports small workgroups with modest performance and reliability capabilities
b) Resides in a larger system, either an application or a device with limited transaction processing,
memory, processing, and storage.
c) Supports mission critical information systems with high performance for storage, transaction
processing, and scalability.
d) Supports servers for website usage - ANSWER: a) Supports small workgroups with modest
performance and reliability capabilities
What is an embedded DBMS?
a) Supports small workgroups with modest performance and reliability capabilities
b) Resides in a larger system, either an application or a device with limited transaction processing,
memory, processing, and storage.
c) Supports mission critical information systems with high performance for storage, transaction
processing, and scalability.
d) Supports servers for website usage - ANSWER: b) Resides in a larger system, either an application
or a device with limited transaction processing, memory, processing, and storage.
Languages for non-procedural database access have explicit statements for looping.
a) True
b) False - ANSWER: b) False
What tools do enterprise DBMSs provide for non-procedural access? More than one answer is
possible.
a) the SQL SELECT statement
b) Graphical tools such as the Query Builder tool in the Oracle SQL Developer
c) Database programming languages combining a procedural language with non-procedural database
access.
d) The SQL CREATE TABLE statement - ANSWER: a) the SQL SELECT statement
b) Graphical tools such as the Query Builder tool in the Oracle SQL Developer
c) Database programming languages combining a procedural language with non-procedural database
access.
, What are the benefits of non-procedural database access? More than one answer is possible.
a) Improve software productivity
b) Improve accessibility of databases to users without programming skills and training.
c) Provide security for databases
d) Provide privacy for databases - ANSWER: a) Improve software productivity
b) Improve accessibility of databases to users without programming skills and training.
Indicate reasons that organizations use database programming languages. More than one reason is
possible.
a) Batch processing especially for big data tasks
b) Customization especially for ecommerce and automation
c) Data visualization for business analysts
d) Modularization to organize code performing database retrieval and modification - ANSWER: a)
Batch processing especially for big data tasks
b) Customization especially for ecommerce and automation
d) Modularization to organize code performing database retrieval and modification
What statements are true about database transactions. More than one answer is possible.
a) Support daily operations of an organization
b) A database transaction consists of a collection of database operations to read and write to a
database.
c) A transaction consists of a single database operation.
d) A DBMS reliably and efficiently processes each transaction as one unit of work. - ANSWER: a)
Support daily operations of an organization
b) A database transaction consists of a collection of database operations to read and write to a
database.
d) A DBMS reliably and efficiently processes each transaction as one unit of work.
Identify services provided in database transaction processing. More than one answer is possible.
a) Optimized processing of SQL SELECT statements
b) Control of interference among concurrent users
c) Recovery from failures without loss of completed transactions
d) Query modification - ANSWER: b) Control of interference among concurrent users
c) Recovery from failures without loss of completed transactions
Identify decision making levels with primary support by data warehouses. More than one answer is
possible.
a) Lower (operational) decisions such as resolving a shipping delay
b) Middle (tactical) decisions such as sales forecasting
c) Top (strategic) decisions such as identifying new markets
d) Micro (sub operational) decisions such as packet routing - ANSWER: b) Middle (tactical) decisions
such as sales forecasting
c) Top (strategic) decisions such as identifying new markets
Identify characteristics of data warehouses. More than one answer is possible.
a) Populated from operational databases and external data sources
b) Optimized for efficient and reliable processing of large volumes of daily transactions.
c) Transformations and integrations performed to support decision making
d) Optimized for reporting that summarizes large amounts of data - ANSWER: a) Populated from
operational databases and external data sources
c) Transformations and integrations performed to support decision making
d) Optimized for reporting that summarizes large amounts of data
Indicate characteristics of fourth generation DBMS products.
a) Object-oriented, NoSQL
b) Relational with non-procedural access
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 phinta004. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.99. You're not tied to anything after your purchase.
