A ____ index is based on 0 and 1 bits to represent a given condition.
a. logical
b. multidimensional
c. star
d. bitmapped
The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and
the V_NAME, V_AREACODE, V_PHONE and V_CONTACT fields from the
VENDOR table, where the values of V_CODE match and the output is ordered by the
price is ____.
a. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,
V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <>
VENDOR.V_CODE; ORDER BY P_PRICE;
b. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,
V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE =>
VENDOR.V_CODE; ORDER BY P_PRICE;
c. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,
V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <=
VENDOR.V_CODE; ORDER BY P_PRICE;
d. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,
V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE =
VENDOR.V_CODE; ORDER BY P_PRICE;
In a typical star schema, each dimension record is related to thousands of ____ records.
a. attribute
b. fact
c. key
d. star
To delete a row from the PRODUCT table, use the ____ command.
a. COMMIT
b. DELETE
c. ERASE
d. KILL
The DBMS ____ the SQL query using the chosen execution plan.
a. parses
b. executes
c. fetches
d. processes
The relational data model was developed in the ____.
a. 1960s x
b. 1970s
c. relational
d. 1990s
A(n) ____ join will select only the rows with matching values in the common
attribute(s).
a. natural
b. cross
c. full
d. outer
For most business transactional databases, we should normalize relations into ____.
a. 1NF
b. 2NF
c. 3NF
d. 6NF
____ data exist in a format that does not lend itself to processing that yields
information.
a. Structured
b. Semistructured
c. Unstructured
d. Historical
The initial assessment and the feasibility study are part of the SDLC’s ____ phase.
a. planning
b. analysis
c. detailed systems design
d. implementation
The maintenance and evolution phase of the DBLC involves ____.
a. defining objectives
b. introducing changes
c. testing the database
d. installing the DBMS
The relational database model enables you to view data ____ rather than ____.
a. relationally, hierarchically
b. hierarchically, relationally
c. physically, logically
d. logically, physically
A(n) ____ join links tables by selecting only the rows with common values in their
common attribute(s).
a. equal
b. unique
c. foreign
d. natural
The person responsible for the control of the centralized and shared database is the
database ____.
a. analyst
b. administrator
c. programmer
d. user
What is the first step in the exchange between a Web browser and a database?
a. The HTML output is displayed on the client computer’s Web browser.
b. The middleware receives the query result and creates the HTML-formatted page.
c. The client’s Web browser requests a page from a Web server.
d. The Web-to-database middleware uses ODBC to connect to the database.
____ attributes can have many values.
a. Composite
b. Simple
c. Single-valued
d. Multivalued
The SQL command that lets you permanently save data changes is ____.
a. INSERT
b. SELECT
c. COMMIT
d. UPDATE
A ____ occurs when you have one entity in two 1:M relationships to other entities, thus
producing an association among the other entities that is not expressed in the model.
a. surrogate primary keys
b. time-variant data
c. design trap
d. fan trap
____ combines all rows from two tables, excluding duplicate rows.
a. INTERSECT
b. UNION
c. DIFFERENCE
d. SELECT
The data cache or ____ is a shared, reserved memory area that stores the most recently
accessed data blocks in RAM.
a. buffer cache
b. procedure cache
c. SQL cache
d. permanent storage
____ yields only the rows that appear in both tables.
a. INTERSECT
b. UNION
c. DIFFERENCE
d. SELECT
The SDLC is most important to the ____.
a. programmer
b. manager
c. system designer
d. database administrator
Of the following, what is one of the benefits of rapid development at manageable costs
for Internet technologies?
a. Platform independence and portability
b. Availability of multiple development tools
c. Reduced requirements
d. Reduced training time
What is one of the main characteristics of OLAP systems?
a. They use single-dimensional data analysis techniques.
b. They provide complex command-line end-user interfaces.
c. They provide minimal database support.
d. They support client/server architecture.
“Union-compatible” means that the ____.
a. names of the relation attributes can be different, but the data types must be alike
b. names of the relation attributes must be the same, but the data types can be different
c. names of the relation attributes must be the same and their data types must be alike
d. number of attributes must be the same, but the names and data types can be different
The ____ is responsible for ensuring database security and integrity.
a. database programmer
b. systems analyst
c. data administrator
d. database security officer
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 use of the ____________________ operator allows you to compare a single value
with a list of values returned by the first subquery (sqA) using a comparison operator
other than EQUALS.
Most designers consider the BCNF as a special case of the ____.
a. 1NF
b. 2NF
c. 3NF
d. 4NF
____ distributed database systems integrate only one type of centralized DBMS over a
network.
a. Homogeneous
b. Heterogeneous
c. Fully heterogeneous
d. Combination
Some attributes are classified as ____.
a. simple
b. complex
c. defined
d. grouped
Attributes may share a ____.
a. name
b. domain
c. location
d. table
An organization is subject to a(n) _________________________ cycle; that is, the data
user applies intelligence to data to produce information that is the basis of knowledge
used in decision making by the user.
Once data enter the data warehouse, they are never removed.
___________________________________ are quantifiable measurements (numeric or
scale based) that assess the company’s effectiveness or success in reaching its strategic
and operational goals.
A(n) ____________________, also known as a nested query or an inner query, is a
query that is embedded (or nested) inside another query.
What is transaction transparency? What are some of the basic concepts that you should
know to understand how transactions are managed in a DDBMS?
Because the relational model uses attribute values to establish relationships among
tables, many database users correctly assume that the term relation refers to such
relationships.
What are the wildcard characters that are used with the LIKE command? Provide one or
more examples of each.
What is JavaScript?
The most distinct characteristic of modern OLAP tools is their capacity for
____________________ analysis.
The DBA works with managers to ensure the quality and integrity of database design
and transactions.
A(n) ____________________ attributeis an attribute that must have a value.
A statement-level trigger is assumed if you omit the FOR EACH ROW keywords.
In ____________________, relationships are represented by a diamond connected to
the related entities through a relationship line.
The purpose of an I/O operation is to move data to and from different computer
components or devices.
A data warehouse can store data derived from many sources.
ColdFusion is a Web application server.
Any attribute that is at least part of a key is known as a(n) ____________________.
One of the main functions of a database system is to provide timely answers to end
users.
Durability requires that all portions of the transaction must be treated as a single, logical
unit of work in which all operations are applied and completed to produce a consistent
database.