In the Chen and Crow’s Foot notations, an entity is represented with a rectangle
containing the entity’s name.
a. True
b. False
Which of the following is a disadvantage of the hierarchical data model?
a. It does not promote data sharing.
b. It is not efficient with 1:M relationships.
c. It does not promote data integrity.
d. It does not have standards.
A(n)________ is a query that is embedded (or nested) inside another query.
a. alias
b. operator
c. subquery
d. view
The ANSI has defined standards that govern SQL database transactions. Transaction
support is provided by two SQL statements:_______ and ROLLBACK.
a. RETRIEVE
b. ASSIGN
c. UPDATE
d. COMMIT
SQL supports the conditional execution of procedures (IF-THEN-ELSE statements) that
are typically supported by a programming language.
a. True
b. False
Every XML document has a_____________ .
a. root element
b. base tag
c. schema
d. DTD
A table that is in 2NF and contains no transitive dependencies is said to be
in_____________ .
a. 1NF
b. 2NF
c. 3NF
d. 4NF
The_________ depicts the arrangement of higher-level entity supertypes (parent
entities) and lower-level entity subtypes (child entities).
a. subtype discriminator
b. inheritance
c. specialization hierarchy
d. entity supertype
The first step in the ER model verification process is to_______________ .
a. identify each module and its components
b. identify the ER model’s central entity
c. verify all processes against the ER model
d. identify each module’s internal transaction requirements
The label “stateless system” indicates that, at any given time, there is an open
communication line between the server and each client accessing it.
a. True
b. False
On the client side, the objective is to generate an SQL query that returns a correct
answer in the least amount of time, using a minimum amount of resources at the server
end. The activities required to achieve this goal are commonly referred to as
__________tuning.
a. client SQL
b. database SQL
c. SQL performance
d. DBMS performance
The existence of a(n) _________entity indicates that its minimum cardinality is zero.
a. ternary
b. optional
c. strong
d. weak
An implementation-ready data model should contain a description of the data structure
that will store the end-user data.
a. True
b. False
From a data analyst’s point of view, decision support data differ from operational data in
three main areas: time span, granularity, and_________ .
a. usability
b. dimensionality
c. transaction processing
d. sparsity
In a relational model,________ are also used to establish relationships among tables
and to ensure the integrity of the data.
In a 1:M relationship, to avoid the possibility of referential integrity errors, the data of
the “1” side must be loaded first.
a. True
b. False
Under___________ the scenario, all record- and file-locking activities are performed at
the end-user location.
a. single-site processing, single-site data
b. multiple-site processing, single-site data
c. single-site processing, multiple-site data
d. multiple-site processing, multiple-site data
“What are the requirements of the current system’s end users?” is a question asked
during the______ phase of the Systems Development Life Cycle (SDLC).
a. planning
b. analysis
c. implementation
d. maintenance
Which of the following is used to select partial table contents?
a. SELECT <column(s)>
FROM <Table name>
BY <Conditions>;
b. LIST <column(s)>
FROM <Table name>
BY <Conditions>;
c. SELECT <column(s)>
FROM <Table name>
WHERE <Conditions>;
d. LIST<column(s)>
FROM <Table name>
WHERE <Conditions>;
_____ is a scripting language that allows web authors to design interactive sites.
a. Visual Basic
b. HTML
c. JavaScript
d. Java
The relationships depicted within the specialization hierarchy are sometimes described
in terms of “isa”
relationships.
a. True
b. False
The data format for SQL character is____________ .
a. CHAR and VARCHAR
b. VARCHAR only
c. alphanumeric
d. CHAR only
Each table in a relational database must have a primary key.
a. True
b. False
The organization of data within folders in a manual file system is determined
by___________ .
a. its date of creation
b. its expected use
c. the title of the documents in the folder
d. the data processing specialist
Another name for a database server-side extension program is ________________.
a. a web server
b. a web application middleware
c. web-to-database middleware
d. a database application server
A(n)_______ is the equivalent of a field in a file system.
a. attribute
b. entity
c. relationship
d. constraint
A distributed database management system (DDBMS) governs the storage and
processing of logically related data over interconnected computer systems.
a. True
b. False
From a structural point of view, 3NF is better than____________ .
a. 4NF
b. 2NF
c. 5NF
d. 6NF
The _____________operator could be used in place of INTERSECT if the DBMS does
not support it.
a. IN
b. OF
c. AND
d. UNION
The implicit beginning of a transaction is_____________ .
a. when the database is started
b. when a table is accessed for the first time
c. when the first SQL statement is encountered
d. when the COMMIT command is issued
____________extends SQL so that it can differentiate between access requirements for
data warehouse data and operational data.
a. ROLAP
b. OLAP
c. DBMS
d. BI
The introduction of a DBMS represents a big change and challenge, and is likely to
have a profound impact throughout the organization.
a. True
b. False
How many rows would be returned from a cross join of tables A and B, if A contains 8
rows and B contains 18?
a. 8
b. 18
c. 26
d. 144
The objective of _____________control is to ensure the serializability of transactions in
a multiuser database environment.
Each column in a relation represents a(n)______________ .
Explain the two criteria that help a designer in determining when to use subtypes and
supertypes.
What are the sources of business rules, and what is the database designer’s role with
regard to business rules?
A(n)___________ is performed when data are retrieved from more than one table at a
time.
What is the ROLLUP extension to the GROUP BY clause? Provide the syntax for this
extension.
Although the DBMS is designed to recover a database to a previous consistent state
when an interruption prevents the completion of a required set of transactions, the
transactions themselves are defined by the end user or programmer and must be correct.
Differentiate between specialization and generalization.
An ERD is created through an____________ process.
Failure to understand the distinction between mandatory and optional________ in
relationships might yield designs in which awkward (and unnecessary) temporary rows
(entity instances) must be created just to accommodate the creation of required entities.
What are the components in the basic ODBC architecture?
If a user adds a new column to a table that already has rows, the existing rows will
default to a value of_____________ for the new column.
___________________can take place at any of the following levels: database, table,
page, row, or field.
A(n)____________ provides a detailed description of all tables found within the
user/designer-created database.
Each row in the relational table is known as a(n) _________________–.