Chapter 7: Advanced SQL
Q1) User-defined data types:
A) can be a subclass of a standard type.
B) can behave as an object.
C) can have defined functions and methods.
D) can have all of the above.
See Q1 Verified Answer
Q2) User-defined data types:
A) can be a subclass of a standard type.
B) can behave as an object.
C) can have defined functions and methods.
D) can have all of the above.
See Q2 Verified Answer
Q3) The most commonly used form of join operation is the:
A) outer join.
B) union join.
C) equi-join.
D) natural join.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Chapter 8: Database Application Development
Q1) Web services allow for communication between programs over the Internet.
See Q1 Verified Answer
Q2) Java servlets execute from within another program and reside on the server.
See Q2 Verified Answer
Q3) VBScript is a scripting language based upon Java that is used to achieve
interactivity on Web pages.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 2
Chapter 12: Distributed Databases
Q1) A form of distributed database in which all data across a network are kept
continuously updated,so a user can access any data anywhere on the network and get
the same answer is called a(n)________ distributed database.
See Q1 Verified Answer
Q2) Which of the following supports a simple path to other databases,without the
benefits of one logical database?
A) Linked; differential
B) Gateways
C) Autonomous; cross-linked
D) Federated; nonautonomous
See Q2 Verified Answer
Q3) A(n)________ is a single logical database spread physically across computers in
multiple locations that are connected by a data communications link.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 3
Chapter 2: Modeling Data in the Organization
Q1) An attribute of an entity that must have a value for each entity instance is a(n):
A) optional attribute.
B) composite attribute.
C) required attribute.
D) fuzzy attribute.
See Q1 Verified Answer
Q2) A cardinality constraint tells what kinds of properties are associated with an entity.
See Q2 Verified Answer
Q3) A business rule should be internally consistent.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 4
Chapter 14: Using Relational Databases to Provide Object
Persistence
Q1) An advantage of the SQL query mapping framework is:
A) direct access to all DBMS capabilities provided through SQL.
B) SQL code generated automatically.
C) database access code is easier to manage than with call-level APIs.
D) both A and C.
See Q1 Verified Answer
Q2) A performance problem caused by too many select statements generated by an
ORM framework is called:
A) N+J selects problem.
B) N* selects problem.
C) N+1 selects problem.
D) selection classification problem.
See Q2 Verified Answer
Q3) ________ is a structure that defines relationships between domain classes in the
object-oriented model and relations in the relational model.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 5
Chapter 11: Data and Database Administration
Q1) Which of the following is a type of network security:
A) authentication of the client workstation.
B) password naming conventions.
C) guidelines for frequency of password changes.
D) all of the above.
See Q1 Verified Answer
Q2) What is the difference between shared locks and exclusive locks?
See Q2 Verified Answer
Q3) The actions that must be taken to ensure data integrity is maintained during
multiple simultaneous transactions are called ________ actions.
A) logging
B) concurrency control
C) transaction authorization
D) multiple management
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 6
Chapter 9: Data Warehousing
Q1) A(n)________ is an
integrated,subject-oriented,updateable,current-valued,detailed database designed to
serve operational users as they do their decision support processing.
See Q1 Verified Answer
Q2) Which of the following data-mining techniques searches for patterns and
correlations in large data sets?
A) Case reasoning
B) Rule discovery
C) Signal processing
D) Neural nets
See Q2 Verified Answer
Q3) Conformed dimensions allow users to do the following:
A) share nonkey dimension data.
B) query across fact tables with consistency.
C) work on facts and business subjects for which all users have the same meaning.
D) all of the above.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 7
Chapter 5: Physical Database Design and Performance
Q1) When would you use horizontal partitioning and when would you use vertical
partitioning?
See Q1 Verified Answer
Q2) Explain the differences between sequential and indexed file organizations.
See Q2 Verified Answer
Q3) Indexes are most useful for columns that frequently appear in ________ clauses of
SQL statements.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 8
Chapter 4: Logical Database Design and the Relational
Model
Q1) The attribute on the left-hand side of the arrow in a functional dependency is the:
A) candidate key.
B) Determinant.
C) foreign key.
D) primary key.
See Q1 Verified Answer
Q2) When transforming a one-to-one relationship,a new relation is always created.
See Q2 Verified Answer
Q3) Which of the following is NOT a reason to create an instance of a relational schema
with sample data?
A) Sample data can be used to improve user communications.
B) Sample data can be used for prototype generation.
C) Sample data can reverse database implementation errors.
D) Sample data provide a convenient way to check the accuracy of your design.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 9
Chapter 6: Introduction to SQL
Q1) SQL has been implemented only in the mainframe and midrange environments.
See Q1 Verified Answer
Q2) The following query totals sales in state= 'MA' for each salesperson.
Select salesperson_id,sum(sales)
from salesperson
group by salesperson_id
having state = 'MA';
See Q2 Verified Answer
Q3) Which of the following is a technique for optimizing the internal performance of the
relational data model?
A) Avoiding indexes on secondary keys
B) Clustering data
C) Not reporting statistics to save machine resources
D) Using random index organizations
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 model is a graphical system used to capture the nature and relationships
among data,
See Q1 Verified Answer
Q2) Many of the disadvantages of file processing systems can also be limitations of
databases.
See Q2 Verified Answer
Q3) Application programs are only used with databases.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 11
Chapter 10: Data Quality and Integration
Q1) The best place to improve data entry across all applications is:
A) in the users.
B) in the level of organizational commitment.
C) in the database definitions.
D) in the data entry operators.
See Q1 Verified Answer
Q2) A data steward is a person assigned the responsibility of ensuring the organizational
applications properly support the organization's enterprise goals for data quality.
See Q2 Verified Answer
Q3) High quality data are data that are:
A) accurate.
B) consistent.
C) available in a timely fashion.
D) all of the above.
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 12
Chapter 13: Object-Oriented Data Modeling
Q1) An instance of a subclass is not always an instance of its superclass.
See Q1 Verified Answer
Q2) 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 Q2 Verified Answer
Q3) A(n)________ is a concept,abstraction,or thing that has a state,behavior,and
identity.
A) relationship
B) attribute
C) key
D) object
See Q3 Verified Answer
Click here! To get all questions and flashcards with answers for this chapter
Page 13