Chapter 7: Advanced SQL
Q1) Dynamic SQL:
A) is used to generate appropriate SQL code on the fly, as an application is processing.
B) is quite volatile.
C) is not used widely on the Internet.
D) creates a less flexible application.
See Q1 Verified Answer
Q2) Dynamic SQL:
A) is used to generate appropriate SQL code on the fly, as an application is processing.
B) is quite volatile.
C) is not used widely on the Internet.
D) creates a less flexible application.
See Q2 Verified Answer
Q3) Using an ________ produces this information: rows that do not have matching
values in common columns are also included in the result table.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Chapter 4: Logical Database Design and the Relational
Model
Q1) Discuss when it is best to create a surrogate key for an associative entity.
See Q1 Verified Answer
Q2) The relational data model consists of which components?
A) Data structure
B) Data manipulation
C) Data integrity
D) All of the above
See Q2 Verified Answer
Q3) An enterprise key is a foreign key whose value is unique across all relations.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 2
Chapter 2: Modeling Data in the Organization
Q1) A multivalued attribute may take on more than one value for a particular entity
instance.
See Q1 Verified Answer
Q2) An entity type name should always be a singular noun.
See Q2 Verified Answer
Q3) It is not permissible to associate attributes with relationships.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 3
Chapter 13: Object-Oriented Data Modeling
Q1) According to the UML Notation Guide,overlapping means:
A) a descendant may be descended from more than one of the subclasses.
B) a descendant may not be descended from more than one of the subclasses.
C) all subclasses have been specified, and no others are expected.
D) the list of objects is stable, but relationships will change.
See Q1 Verified Answer
Q2) ________ is the technique of hiding the internal implementation details of an
object from its external view.
A) Grouping
B) Encapsulation
C) Classification
D) Mining
See Q2 Verified Answer
Q3) A class-scope operation applies to a class rather than an object instance.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 4
Chapter 10: Data Quality and Integration
Q1) The process of transforming data from detailed to summary levels is called
normalization.
See Q1 Verified Answer
Q2) What are some of the errors and inconsistencies in data that the cleansing process
is looking to rectify?
See Q2 Verified Answer
Q3) A ________ is a person assigned the responsibility of ensuring that organizational
applications properly support the organization's enterprise goals of data quality.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 5
Chapter 9: Data Warehousing
Q1) Discuss some of the characteristics of derived data.
See Q1 Verified Answer
Q2) The real-time data warehouse accepts ________ feeds of transactional data and
immediately transforms and loads the data into the data warehouse.
See Q2 Verified Answer
Q3) What are some approaches to handling slowly changing dimensions?
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 6
Chapter 12: Distributed Databases
Q1) A synchronized replication strategy has a(n)________ reliability.
A) excellent
B) good
C) fair
D) medium
See Q1 Verified Answer
Q2) Users of distributed database systems always need to know the location of the data.
See Q2 Verified Answer
Q3) The purpose of time-stamping is to allow transactions to be processed in parallel.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 7
Chapter 8: Database Application Development
Q1) Storing XML data is becoming a big question as XML data becomes more prevalent.
See Q1 Verified Answer
Q2) A technical specification for creating a distributed registry of Web services and
businesses that are open to communicating through Web services is called:
A) HTML.
B) B2B.
C) UDDI.
D) XML.
See Q2 Verified Answer
Q3) Explain how middleware is used in a two-tier application.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 8
Chapter 3: The Enhanced E-R Model and Business Rules
Q1) A subgrouping of the entities in an entity type that shares common attributes or
relationships is called a(n)________.
See Q1 Verified Answer
Q2) In the figure below,to which of the following entities are the entities "CAR" and "TRUCK"
generalized?
A) Make
B) Vehicle
C) Model
D) Price
See Q2 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 9
Chapter 6: Introduction to SQL
Q1) What result set will the following query return?
Select item_no,description
From item
Where weight > 100 and weight < 200;
A) The item_no and description for all items weighing less than 100
B) The item_no for all items weighing between 101 and 199
C) The item_no and description for all items weighing between 101 and 199
D) The item_no for all items weighing more than 200
See Q1 Verified Answer
Q2) Which of the following finds all groups meeting stated conditions?
A) Select
B) Where
C) Having
D) Find
See Q2 Verified Answer
Q3) Indexes generally slow down access speed in most RDMS.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 10
Chapter 1: The Database Environment and Development
Process
Q1) A data warehouse derives its data from:
A) on-line transactions.
B) various operational data sources.
C) reports.
D) a datamart.
See Q1 Verified Answer
Q2) Which of the following is an integrated decision support database with content
derived from various operational databases?
A) Corporate data structure
B) Relational DBMS
C) Data warehouse
D) Client-server system
See Q2 Verified Answer
Q3) The systems development life cycle is the traditional methodology used to
develop,maintain,and replace information systems.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 11
Chapter 11: Data and Database Administration
Q1) An organization should have one data warehouse administrator for every:
A) 100 users.
B) 100 gigabytes of data in the enterprise data warehouse.
C) department.
D) processor.
See Q1 Verified Answer
Q2) A(n)________ is a facility by which the DBMS refuses to accept any new
transactions.
See Q2 Verified Answer
Q3) Loss of data integrity does not impact the quality of data in a database.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 12