Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Each time the end user clicks a hyperlink, the browser generates a(n) ____ GET page
request that is sent to the designated Web server, using the TCP/IP Internet protocol.
a. HTML
b. browser
c. HTTP
d. API
From the 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
Incremental backups produce a backup of all data.
The ____ processor is the software component found in each computer that requests
data. It receives and processes the application's data requests.
a. database
b. transaction
c. data
d. network
A ____ relationship exists when three entities are associated.
a. unary
b. binary
c. ternary
d. weak
Knowing the sparsity of a column helps you decide whether the use of ____ is
appropriate.
a. query processing
b. query optimization
c. an index
d. a full table scan
In a star schema, attributes are often used to search, filter, or classify ____.
a. tables
b. stars
c. facts
d. dimensions
The first step in developing the conceptual model using ER diagrams is to ____.
a. normalize the entities
b. complete the initial ER diagram
c. identify, analyze, and refine the business rules
d. define the attributes, primary keys, and foreign keys for each of the entities
The property of ____ enables an entity subtype to inherit the attributes and relationships
of the supertype.
a. subtype discriminator
b. inheritance
c. specialization hierarchy
d. entity supertype
Knowing the ____ number of entity occurrences is very helpful at the application
software level.
a. maximum
b. minimum
c. approximate
d. maximum and minimum
From a structural point of view, 2NF is better than ____.
a. 1NF
b. 3NF
c. 4NF
d. BCNF
____'s main goal is to provide a comprehensive and consistent definition of all data
within an organization.
a. DBMS
b. OLAP
c. Data warehousing
d. MDM
Date attributes contain calendar dates stored in a special format known as the ____ date
format.
a. Epoch
b. Calendar
c. Julian
d. logical
Data ____ implies that all business entities, data elements, data characteristics, and
business metrics are described in the same way throughout the enterprise.
a. volatility
b. time-variation
c. subject-orientation
d. integration
When designing a database, you should ____.
a. make sure entities are in normal form before table structures are created
b. create table structures then normalize the database
c. only normalize the database when performance problems occur
d. consider more important issues such as performance before normalizing
The first step in the DBLC is ____.
a. operation
b. database initial study
c. database design
d. implementation and loading
A table where every determinant is a candidate key is said to be in ____.
a. BCNF
b. 2NF
c. 3NF
d. 4NF
Attribute A ____ attribute B if all of the rows in the table that agree in value for
attribute A also agree in value for attribute B.
a. determines
b. derives from
c. controls
d. owns
A table that is in 1NF and includes no partial dependencies is said to be in ____.
a. BCNF
b. 2NF
c. 3NF
d. 4NF
The last step in the DBLC is ____.
a. maintenance and evolution
b. operation
c. testing and evaluation
d. implementation and loading
In a real-world environment, we must strike a balance between design integrity and
____.
a. robustness
b. flexibility
c. uniqueness
d. ease of use
If one exists, a data modeler uses a ____ as the primary key of the entity being
modeled.
a. foreign key
b. combination key
c. surrogate key
d. natural identifier
A ____ contains at least all of the attribute names and characteristics for each table in
the system.
a. data dictionary
b. relational schema
c. logical schema
d. join
What is a characteristic of ROLAP?
a. It uses the star schema
b. It does not require high resources.
c. It is limited to predefined dimensions.
d. It has low flexibility.
The conceptual design step that defines the DBMS and data model to use is ____.
a. database analysis and requirements
b. ER modeling and normalization
c. data-model verification
d. distributed database design
The SQL command that lets you select attributes from rows in one or more tables is
____.
a. INSERT
b. SELECT
c. COMMIT
d. UPDATE
It is common practice to define the DBA function by dividing the DBA operations
according to the ____ phases.
a. SLA
b. DBLC
c. SDLC
d. MRA
A(n) ____ is bidirectional.
a. attribute
b. entity
c. relationship
d. constraint
The most recent fully approved version of standard SQL prescribed by the ANSI is
____.
a. SQL-99
b. SQL-2003
c. SQL-4
d. SQL-07
____ exists when different versions of the same data appear in different places.
a. Data inconsistency
b. Data consistency
c. Better data integration
d. Improved decision making
The DBA's ____ role is focused on personnel management and on interactions with the
end-user community.
a. administrative
b. arbitration
c. technical
d. managerial
A Web browser's function is to display a page on the client computer. The browser,
through its use of HTML, does not have computational abilities beyond formatting
output text and accepting form field inputs.
Disjoint subtypes are also known as ____________________ subtypes.
A Web ____________________ server is a middleware application that expands the
functionality of Web servers by linking them to a wide range of services.
The ER diagram represents the conceptual database as viewed by the end user.
In both the Chen and Crow's Foot models, an entity is represented with a rectangle
containing the entity's name.
A determinant is any attribute whose value determines other values within a column.
The star schema is designed to optimize data query operations rather than data update
operations.
In multidimensional terms, the ability to focus on slices of the cube to perform a more
detailed analysis is known as ____________________.
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.
Because a partial dependency can exist only if a table's primary key is composed of
several attributes, if a table in 1NF has a single-attribute primary key, then the table is
automatically in 2NF.
An entity cluster is a "virtual" entity type used to represent multiple entities and
relationships in the ERD.
The practical significance of taking the logical view of a database is that it serves as a
reminder of the simple file concept of data storage.
In ____________________, no row may contain two or more multivalued facts about
an entity.
A(n) ____________________ uses special proprietary techniques to store data in
matrix-like n-dimensional arrays.
What command is used to save changes to the database? What is the syntax for this
command?
Explain single-valued attributes and provide an example. Is an attribute that is
single-valued always simple? Why or why not? Use an example to illustrate your point.
A(n) ____________________ is an information system component that handles a
specific business function, such as inventory, orders, payroll, and so on.
