____ CASE tools provide support for the planning, analysis, and design phases.
a. Front-end
b. Back-end
c. Vertical
d. Horizontal
Instructions to create a password are an example of a ____.
a. rule
b. policy
c. standard
d. procedure
All data in a database are stored in ____ files.
a. table
b. data
c. RAM
d. system
A ____ derives its name from the fact that a group of multiple entries of the same type
can exist for any single key attribute occurrence.
a. partial dependency
b. transitive dependency
c. repeating group
d. primary key
____ data can have only a true or false (yes or no) values.
a. Logical
b. Character
c. Date
d. Numeric
No data entry at all is known as a(n) ____.
a. nil
b. null
c. empty
d. zero
The ____ schema is designed to optimize data query operations rather than data update
operations.
a. relational
b. circle
c. star
d. matrix
In the optimistic approach, during the ____ phase, a transaction scans the database,
executes the needed computations, and makes the updates to a private copy of the
database values.
a. read
b. validation
c. write
d. shared
VMS/VSAM is an example of a(n) ____.
a. hierarchical model
b. file system data model
c. relational data model
d. XML data model
The ____ model uses the term connectivity to label the relationship types.
a. relational
c. object-oriented
b. network
d. entity relationship
The objective of ____ optimization is to minimize the total cost associated with the
execution of a request.
a. data
b. remote
c. transaction
d. query
When introducing a database into an organization, a(n) ____ impact is likely because
the database approach creates a more controlled and structured information flow and
thus affects people, functions, and interactions.
a. cultural
b. managerial
c. technical
d. operational
At the level of middle management, the database must be able to ____.
a. represent and support the company operations as closely as possible
b. deliver the data necessary for tactical decisions and planning
c. produce query results within specified performance levels
d. provide access to external and internal data to identify growth opportunities and to
chart the direction of such growth
____ is used to reveal the meaning of data.
a. Raw facts
b. Knowledge
c. Formatting
d. Information
The ____ relational type is the “relational model ideal.”
a. 1:1
b. 1:M
c. M:1
d. M:N
Had ____ been as pivotal to business operations a few years back, crises precipitated by
the likes of Enron, WorldCom, and Arthur Andersen might have been avoided.
a. OLAP
b. data mining
c. governance
d. networking
If you have three different transitive dependencies, ____ different determinant(s) exist.
a. one
b. two
c. three
d. four
____ relationships occur when there are multiple relationship paths between related
entities.
a. Redundant
b. Duplicated
c. Time-variant
d. Supertype
The most important characteristic of an entity is its ____ key, used to uniquely identify
each entity instance.
a. primary
b. natural
c. foreign
d. surrogate
The organization of the data within the folders in a manual file system was determined
by ____.
a. the date of creation
b. its expected use
c. the title of the documents in the folder
d. the data processing specialist
In 2008, Wal-Mart, the world’s largest company, had over four ____ of data in its data
warehouses.
a. megabytes
b. gigabytes
c. terabytes
d. petabytes
Assume you are using the MINUS operator to combine the results from two tables with
identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains
10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and
Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table.
How many records are returned when using the MINUS operator?
a. 0
b. 2
c. 8
d. 10
UPDATE tablename
*****
[WHERE conditionlist];
The ____ command replaces the ***** in the syntax of the UPDATE command, shown
above.
a. SET columnname = expression
b. columnname = expression
c. expression = columnname
d. LET columnname = expression
The ____ data type is considered compatible with VARCHAR(35).
a. DATE
b. INT
c. TINYINT
d. CHAR(15)
To generate database object statistics manually, you could use the following syntax:
____.
a. ANALYZE <TABLE/INDEX> object_name;
b. CREATE <TABLE/INDEX> object_name;
c. ANALYZE <TABLE/INDEX> object_name COMPUTE STATISTICS;
d. CREATE <TABLE/INDEX> object_name COMPUTE STATISTICS;
Students and classes have a ____ relationship.
a. one-to-one
b. one-to-many
c. many-to-one
d. many-to-many
The ____ scenario describes a fully distributed DBMS with support for multiple data
processors and transaction processors at multiple sites.
a. multiple-site processing, single-site data
b. single-site processing, multiple-site data
c. single-site processing, single-site data
d. multiple-site processing, multiple-site data
BCNF can be violated only if the table contains more than one ____ key.
a. primary
b. candidate
c. foreign
d. secondary
The Oracle string concatenation function is ____.
a. CONCAT
b. +
c. ||
d. &&
____ allow(s) physical access to areas by authorized personnel only.
a. Physical security
b. Password security
c. Access rights
d. Data encryption
A server-side extension ____.
a. provides its services to the Web server in a way that is totally transparent to the client
browser
b. must be downloaded and installed in the client computer
c. is only available for servers running Windows 2000 or greater
d. is not required to access a database over the Internet
The attribute B is ____ the attribute A if each value in column A determines one and
only one value in column B.
a. logically dependent on
b. owned by
c. determined by
d. functionally dependent on
In a MOLAP system, the MOLAP ____ allows end users to interact with the MOLAP
server and request data for analysis.
a. GUI
b. operational database
c. multidimensional database
d. data cube
In the IBM DB2 system catalog tables, ____________________ stores one row for
each column of each table or view.
In most implementations, the data warehouse and OLAP are stand-alone, independent
environments.
A(n) ____________________ request is a low-level (read or write) data access
operation to/from computer devices.
____________________ makes a copy of a table and places it in a different location to
improve access time.
A database language enables the user to perform complex queries designed to transform
the raw data into useful information.
Implementing non-overlapping subtypes requires the use of one discriminator attribute
for each subtype.
All factors must be checked to ensure that each system component operates at its
optimum level and has sufficient resources to minimize the occurrence of bottlenecks.
A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the
occurrence of a given data manipulation event.
Describe the use of SQL in relation to ROLAP.
____________________ exists when the same data are stored unnecessarily at different
places.
End users and the DBMS interact through the use of ____________________ to
generate information.
Usually, a data modeler uses a natural identifier as the ____________________ of the
entity being modeled, assuming that the entity has a natural identifier.
Relationship strength depends on how the primary key of the related entity is
formulated, while the relationship ____________________ depends on how the
business rule is written.
From a database point of view, the collection of data becomes meaningful only when
the business ____________________ are defined.
Normalization is a very important database design ingredient and the highest level is
always the most desirable.