Fact and dimension tables are related by ____ keys.
a. shared
b. primary
c. foreign
d. linked
Which of the following is true of business rules?
a. They allow the designer to set company policies with regard to data.
b. They allow the designer to develop business processes.
c. They can serve as a communication tool between the users and designers.
d. They provide a framework for the company’s self actualization.
The ____ type of cloud infrastructure is built by a third-party organization to sell cloud
services to the general public.
a. community
b. public
c. global
d. private
The SQL aggregate function that gives the number of rows containing non-null values
for the given column is ____.
a. COUNT
b. MIN
c. MAX
d. SUM
____ is a Web application server that provides the ability to connect Web servers to
multiple data sources.
a. Access
b. ColdFusion/JRun
c. FoxPro
d. dBase
Data mining is part of the “____” section of the business intelligence framework.
a. People
b. Management
c. Processes
d. Governance
____ security breaches include database access by computer viruses and by hackers
whose actions are designed to destroy or alter data.
a. Dangerous
b. Preserving
c. Corrupting
d. Authorized
A ____ attribute is one that cannot be subdivided.
a. composite
b. simple
c. single-valued
d. multivalued
____ is a disadvantage of a DDBMS.
a. Processor independence
b. The graphical user interface
c. Security
d. Data access that is too rapid
A detailed system specification is part of the ____ phase of the SDLC.
a. planning
b. analysis
c. detailed systems design
d. implementation
The special operator used to check for similar character strings is ____.
a. BETWEEN
b. IS NULL
c. LIKE
d. IN
The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields
from the PRODUCT table in ascending order by P_PRICE is ____.
a. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT
SEQUENCE BY P_PRICE;
b. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT LIST
BY P_PRICE;
c. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT
ORDER BY P_PRICE;
d. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT
ASCENDING BY P_PRICE;
A DBA determines the initial size of the data files that make up the database; however,
as required, the data files can automatically expand in predefined increments known as
____.
a. procedure cache
b. file group
c. data files
d. extends
The ____ processor is the software component residing on each computer that stores
and retrieves data located at the site.
a. transaction
b. network
c. data
d. management
The TP is the software component found in each computer that requests data.
When using the Oracle TO_DATE function, the code ____ represents a three-letter
month name.
a. MON
b. MM3
c. MONTH
d. MM
A ____ is a named collection of database access privileges that authorize a user to
connect to the database and use the database system resources.
a. user
b. role
c. profile
d. manager
____ coupling describes the extent to which modules are independent of one another.
a. Verification
b. Process
c. Module
d. Cohesive
Some ____ database modeling concepts can be expressed only using the Chen notation.
a. developmental
b. conceptual
c. actual
d. specific
Once the data has been loaded into the database, the ____ tests and fine-tunes the
database for performance, integrity, concurrent access, and security constraints.
a. programmer
b. manager
c. database administrator
d. systems administrator
Overlapping subtypes are subtypes that contain ____ subsets of the supertype entity set.
a. entity
b. subtypes
c. unique
d. nonunique
The ANSI standard defines ____ type(s) of outer join(s)
a. one
b. two
c. three
d. four
A(n) ____ is a block of code (containing standard SQL statements and procedural
extensions) that is stored and executed at the DBMS server.
a. PSM
b. PLS
c. SQL Statement
d. PMR
Under the ____ scenario, multiple processes run on different computers sharing a single
data repository.
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
When you issue the DELETE FROM tablename command without specifying a
WHERE condition, ____.
a. no rows will be deleted
b. the first row will be deleted
c. the last row will be deleted
d. all rows will be deleted
____ are in charge of presenting the data to the end user in a variety of ways.
a. Data stores
b. ETL tools
c. Data visualization tools
d. Data analysis tools
Within a specialization hierarchy, every subtype can have ____ supertype(s) to which it
is directly related.
a. zero
b. only one
c. one or many
d. many
____is a scripting language that allows Web authors to design interactive sites.
a. Visual Basic
b. HTML
c. JavaScript
d. Java
____ data exist in the format in which they were collected.
a. Structured
b. Semistructured
c. Unstructured
d. Historical
A growing phase in a two-phase lock is when a transaction acquires all the required
locks without locking any data.
____ transparency allows a transaction to update data at several network sites.
a. Transaction
b. Distribution
c. Failure
d. Performance
Analyzing decision support data to generate information is part of ____.
a. data warehousing
b. very large database systems
c. business intelligence
d. distributed processing
The ____ data type is compatible with NUMBER.
a. VARCHAR(15)
b. SMALLINT
c. DATE
d. CHAR(10)
Which query will output the table contents when the value of V_CODE is not equal to
21344?
a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE <> 21344;
b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE <= 21344;
c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344;
d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE => 21344;
The ANSI SQL standards are also accepted by the ISO.
All attributes are either simple or composite.
Character field comparisons are faster than numeric, date, and NULL comparisons.
The existing hardware and software systems are studied during the planning phase.
The DBMS must provide tools that give each level of management a different view of
the data and support the required level of decision-making.
The ____________________ is the conceptual organization of the entire database as
viewed by the database administrator.
The most useful feature of PL/SQL blocks is that they let you create code that can be
named, stored, and executed by the DBMS.
Using Oracle ____________________, you can write a PL/SQL code block by
enclosing the commands inside BEGIN and END clauses.
The phenomenon of uncommitted dataoccurs when two transactions are executed
concurrently and the first transaction is rolled back after the second transaction has
already accessed the uncommitted datathus violating the isolation property of
transactions.
After testing is concluded, the final ____________________ is reviewed and printed
and end users are trained.
Unnormalized database tables often lead to various data redundancy disasters in
production databases.
A client-side extension is a program that interacts directly with the Web server to handle
specific types of requests.
One of the disadvantages of stored procedures is that they increase network traffic.
The multiuser DBMS must implement controls to ensure serializability and isolation of
transactions, in addition to atomicity and durability, in order to guard the database’s
consistency and integrity.
The browser’s interpretation and presentation capabilities are sufficient to develop
Web-based applications.
To tie a KPI to the strategic master plan of an organization, a KPI will be compared to a
desired goal within a specific time frame.