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