Referential________ dictates that the foreign key must contain values that match the
primary key in the related table, or must contain null.
a. integrity
b. uniqueness
c. model
d. attribute
In the database query scenario, the web server generates the webpage contents before it
sends the page to the client web browser.
a. True
b. False
A(n)__________ is an orderly arrangement used to logically access rows in a table.
a. primary rule
b. superkey
c. relationship
d. index
A data model is usually graphical.
a. True
b. False
_______________is a relational set operator.
a. MINUS
b. PLUS
c. ALL
d. EXISTS
APIs are implemented as dynamic-link libraries that are dynamically invoked when
needed.
a. True
b. False
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
The web browser’s job is to interpret the HTML code that it receives from a web server
and to:
a. develop web-based applications.
b. display it in a standard formatted way.
c. perform immediate data entry validation.
d. extract details, such as order data, from it.
When data are entered into a form and saved, they are placed in the underlying database
as knowledge.
a. True
b. False
____________________, also known as RESTRICT, yields values for all rows found in
a table that satisfy a given condition.
a. INTERSECT
b. UNION
c. DIFFERENCE
d. SELECT
Each table___________represents an attribute.
a. column
b. row
c. dimension
d. value
The Crow’s Foot notation easily identifies multivalued attributes.
a. True
b. False
DBMS performance tuning includes global tasks such as managing the DBMS
processes in primary memory and managing the structures in physical storage.
a. True
b. False
A _____ is a dynamic table that not only contains the SQL query command to generate
the rows, but also stores the actual rows.
a. SQL view
b. materialized view
c. star schema
d. data cube
The initial assessment and the feasibility study are part of the Systems Development
Life Cycle’s (SDLC’s)_________ phase.
a. planning
b. analysis
c. detailed systems design
d. implementation
___________requires that all operations of a transaction be completed.
a. Specificity
b. Atomicity
c. Durability
d. Time stamping
A ____________key is defined as a key that is used strictly for data retrieval purposes.
a. lookup
b. foreign
c. candidate
d. secondary
The preferred placement for a foreign key when working with a 1:1 relationship is to .
a. use the same primary key for both entities
b. create a bridge entity
c. place the foreign key in one of the entities
d. place the surrogate key in both entities
Concurrent backups take place while the user is working on the database.
a. True
b. False
Distributed database systems do not require complex mechanisms to manage
transactions and ensure the database’s consistency and integrity.
a. True
b. False
To generate a surrogate key, Microsoft Access uses a(n)_________ data type.
a. character
b. sequence
c. AutoNumber
d. identity
There are________ stages in the Database Life Cycle (DBLC).
a. four
b. five
c. six
d. seven
The ANSI prescribes a standard SQL”the current fully approved version is known as
SQL07.
a. True
b. False
Any changes made to the contents of a table are not physically saved on disk until you
use the SAVE <table name> command.
a. True
b. False
A(n)_________ condition occurs when two or more transactions wait for each other to
unlock data.
a. deadlock
b. exclusive lock
c. binary lock
d. two-phase lock
Which of the following queries is used to list a unique value for V_CODE, where the
list will produce only a list of those values that are different from one another?
a. SELECT ONLY V_CODE FROM PRODUCT;
b. SELECT UNIQUE V_CODE FROM PRODUCT;
c. SELECT DIFFERENT V_CODE FROM PRODUCT;
d. SELECT DISTINCT V_CODE FROM PRODUCT;
In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose
errors found in PL/SQL blocks.
a. True
b. False
A(n)__________ exists when there are functional dependencies such that XY is
functionally dependent on WZ, X is functionally dependent on W, and XY is the
primary key.
a. atomic attribute
b. repeating group
c. partial dependency
d. transitive dependency
Fact and dimension tables are related by_______ keys.
a. shared
b. primary
c. foreign
d. linked
The relational data model was developed in the_______ .
a. 1960s
b. 1970s
c. 1980s
d. 1990s
When joining three or more tables, you need to specify a join condition for one pair of
tables.
a. True
b. False
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
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;
_________________is the process that establishes the need for, and the extent of, an
information system.
_____ are numeric measurements (values) that represent a specific business aspect or
activity.
Because a partial dependency can exist only when a table’s primary key is composed of
several attributes, a table whose__________ key consists of only a single attribute is
automatically in 2NF once it is in 1NF.
Oracle uses the_________ function to extract the various parts of a date.
A user-friendly ___________is one advantage of a distributed database management
system (DDBMS) .
Describe the characteristics of an Oracle sequence.
An attribute that cannot be further subdivided is said to display______________ .
____________are ordered sets of values that are crucial in speeding up data access.
What do specialization hierarchies do?
The relational model’s foundation is a mathematical concept known as
a________________ .
What are the disadvantages of database systems?
Usually, a data modeler uses a natural identifier as the_____________ of the entity
being modeled, assuming that the entity has a natural identifier.
To make the output more readable, the SQL standard permits the use of aliases for any
column in a______________ statement.
Explain recursive relationships with the help of an example.
Describe any five of the 12 commandments formulated by C. J. Date for distributed
databases.
Once an SQL statement is transformed, the DBMS creates what is commonly known as
a(n)_____________ plan.
If the DBMS does not support the INTERSECT statement, one can use
a(n)___________ subquery to achieve the same result.