One of the three most common data integrity and consistency problems
is______________ .
a. lost updates
b. disk failures
c. user errors
d. deadlocks
The____________ analyzes the SQL query and finds the most efficient way to access
the data.
Repeating groups must be eliminated by ensuring that each row defines a single entity.
a. True
b. False
______________is a web application server that provides the ability to connect web
servers to multiple data sources.
a. MS Access
b. ColdFusion/JRun
c. FoxPro
d. dBase
Composite attributes make it easier to facilitate detailed queries.
a. True
b. False
A____________ distributed database system will support different database
management systems (DBMS) that may even support different models running under
different computer systems.
a. fully heterogeneous
b. fully homogeneous
c. homogeneous
d. heterogeneous
Dependencies that are based on only a part of a composite primary key are called
transitive dependencies.
a. True
b. False
Assume a designer is using the UNION 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 Jenna
and Howard are included in the CUSTOMER table as well as in the CUSTOMER_2
table. How many records are returned when using the UNION operator?
a. 7
b. 10
c. 15
d. 17
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
ODBC works on the____________ operating system.
a. Kronos
b. UNIX
c. Windows
d. Mac
A(n) _____ physically stores the database’s data.
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
One of the main functions of a database system is to provide timely answers to end
users.
a. True
b. False
_____________fragmentation allows a user to break a single object into two or more
segments, or fragments.
a. Horizontal
b. Vertical
c. Data
d. Request
The___________ constraint assigns a value to an attribute when a new row is added to
a table.
a. CHECK
b. UNIQUE
c. NOT NULL
d. DEFAULT
Entity subtypes do not inherit the relationships in which the supertype entity
participates.
a. True
b. False
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. database
The last step in the Database Life Cycle (DBLC) is______________ .
a. maintenance and evolution
b. operation
c. testing and evaluation
d. implementation and loading
M:N relationships are not appropriate in a relational model.
a. True
b. False
Business intelligence tools use the data warehouse data as the raw materials for data
analytics to generate business knowledge.
a. True
b. False
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 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;
b. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,
V_PHONE FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
c. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,
V_PHONE FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
d. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,
V_PHONE FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE => VENDOR.V_CODE;
A__________ occurs when two or more transactions wait for each other to unlock data.
a. livelock
b. database deadlock
c. distributed deadlock
d. phantom deadlocks
A total completeness constraint is represented by _________.
a. a smaller circle inside a bigger circle
b. a rhombus inside a circle
c. a double horizontal line under a circle
d. a single horizontal line above a circle
The_________ constraint can be placed on a column to ensure that every row in the
table has a value for that column.
a. UNIQUE
b. NOT NULL
c. VALUE
d. EMPTY
The_______________ process analyzes SQL queries and finds the most efficient way
to access data.
a. optimizer
b. scheduler
c. listener
d. user
The object-oriented data model was developed in the__________ .
a. 1960s
b. 1970s
c. 1980s
d. 1990s
The database contents are loaded during the _______phase of the Systems
Development Life Cycle (SDLC).
a. analysis
b. detailed systems design
c. implementation
d. maintenance
Discovery of user requirements, existing system evaluation, and logical system design
are part of the________ phase of the Systems Development Life Cycle (SDLC).
a. planning
b. analysis
c. detailed systems design
d. implementation
When you define a table’s primary key, the DBMS automatically creates
a(n)__________ index on the primary key column(s) you declared.
a. key
b. composite
c. unique
d. primary
Oracle users can use the Access QBE (query by example) query generator.
a. True
b. False
The__________ describes the general conditions in which a company operates, its
organizational structure, and its mission.
In a distributed database management system (DDBMS),_______________ control is
used to manage simultaneous data access and ensure data consistency across database
fragments.
In a distributed database management system (DDBMS), occurs to determine the data
location of local and remote fragments.
A(n)____________ develops when all required changes in the redundant data are not
made successfully.
To deliver efficient decision support, OLAP tools must have advanced
data_____________ features.
Describe the five types of users identified in a database system.
____________are underlined in an ER diagram.
Discuss any three functions performed by the DBMS that guarantee the integrity and
consistency of the data in the database.
The advent of very sophisticated application generators and_________ has substantially
decreased coding and testing time.
A DBMS that supports________ exchanges can integrate with external systems such as
the web, mobile data, and legacy systems, thus enabling the creation of new types of
systems.
An initial assessment of the information flow-and-extent requirements must be made
during the _______portion of the Systems Development Life Cycle (SDLC).
How can a table be deleted from the database? Provide an example.
An alias is especially useful when a table must be joined to itself in a(n)_____________
query.
_______________is evaluated based on client perspective.
Unnormalized tables yield no simple strategies for creating virtual tables known
as___________ .
To support a(n) _____ adequately, the DBMS might be required to support advanced
storage technologies, and even more importantly, to support multiple-processor
technologies, such as a symmetric multiprocessor (SMP) or a massively parallel
processor (MPP).
Participation is_________- if one entity occurrence does not require a corresponding
entity occurrence in a particular relationship.
____________is the result of processing raw data to reveal its meaning.
The____________ is the representation of a database as “seen” by the DBMS.
In multidimensional terms, the ability to focus on slices of the cube to perform a more
detailed analysis is known as _____.