When two or more tables share the same number of columns, and when their
corresponding columns share the same or compatible domains, they are said to
be___________ .
a. intersect-compatible
b. union-compatible
c. difference-compatible
d. select-compatible
The COMMIT command does not permanently save all changes. In order to do that,
you must use SAVE.
a. True
b. False
Which of the following is the last step in the exchange between a web browser and a
database?
a. The HTML output is displayed on the client computer’s web browser.
b. The middleware receives the query result and creates the HTML-formatted page.
c. The web browser requests a page from a web server.
d. The web-to-database middleware uses ODBC to connect to the database.
All changes in a table structure are made using the__________ command, followed by
a keyword that produces the specific changes a user wants to make.
a. ALTER TABLE
b. UPDATE TABLE
c. COMMIT TABLE
d. ROLLBACK TABLE
The function of the primary key is to describe an entity.
a. True
b. False
Data anomaly is defined as the condition in which all of the data in the database are
consistent with the real-world events and conditions.
a. True
b. False
SQL requires the use of the ADD command to enter data into a table.
a. True
b. False
In a document type definition (DTD) file, a plus (+) symbol beside an element indicates
that it is an optional child element within its parent.
a. True
b. False
The “_______________ ” characteristic of a primary key states that the selected
primary key must not be composed of any
attribute(s) that might be considered a violation.
a. unique values
b. nonintelligent
c. preferably single-attribute
d. security-compliant
The only time the client and server computers communicate is when the client requests
a page and the server sends the requested page to the client.
a. True
b. False
Corporations use only structured data.
a. True
b. False
A weak entity has a primary key that is partially or totally derived from the parent entity
in the relationship.
a. True
b. False
An entity is said to be ______________-dependent if it can exist in the database only
when it is associated with another related entity occurrence.
a. existence
b. relationship
c. business
d. data
All join conditions are connected through a(n)_____________ logical operator.
a. NOR
b. OR
c. AND
d. NOT
The ANSI standard defines____________ type(s) of outer join(s)
a. one
b. two
c. three
d. four
Coding, testing, and debugging are part of the___________ phase of the Systems
Development Life Cycle (SDLC).
a. planning
b. analysis
c. detailed systems design
d. implementation
The _________notation of entity-relationship modelling can be used for both
conceptual and implementation modelling.
a. Bachman
b. UML
c. Chen
d. Crow’s Foot
In an SQL-based relational database, each table is dependent on every other table.
a. True
b. False
When using an optimistic approach, during the write phase, the transaction is validated
to ensure that the changes made will not affect the integrity and consistency of the
database.
a. True
b. False
Operational data and decision support data serve the same purpose.
a. True
b. False
Distributed processing does not require:
a. database processing functions to be distributed to all data storage sites.
b. an existing distributed database.
c. a network of interconnected components.
d. multiple sites to share processing chores.
________________expresses the minimum and maximum number of entity
occurrences associated with one occurrence of the related entity.
a. Connectivity
b. Relationship
c. Dependence
d. Cardinality
Reporting anomalies in a table can cause a multitude of problems for managers and can
be fixed through application programming.
a. True
b. False
A specialization hierarchy can have ___________level(s) of supertype/subtype
relationships.
a. zero
b. only one
c. one or many
d. many
Which of the following queries uses the correct SQL syntax to list the table contents for
either V_CODE = 21344 or V_CODE = 24288?
a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE <= 24288;
b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE => 24288;
c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE > 24288;
d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE = 24288;
In order to meet performance requirements, portions of the database design may need to
be occasionally denormalized.
a. True
b. False
Evaluation of database performance is rendered easier by the fact there are no standards
to measure it.
a. True
b. False
If a table has multiple candidate keys and one of those candidate keys is a composite
key, the table can have___________based on this composite candidate key even when
the primary key chosen is a single attribute.
a. Boyce-Codd normal forms
b. redundancies
c. time-variances
d. partial dependencies
A _____________lets a single SQL statement access the data that are to be processed
by a single remote database processor.
a. remote request
b. remote transaction
c. distributed request
d. distributed transaction
In the Systems Development Life Cycle (SDLC), after testing is concluded, end-user
training is not necessary.
a. True
b. False
Indexes do not facilitate join operations.
a. True
b. False
The model uses the term connectivity to label the relationship types.
a. relational
b. network
c. object-oriented
d. entity relationship
The database administrator must be prepared to perform routine maintenance activities
within the database.
a. True
b. False
Only a single attribute, not multiple attributes, can define functional dependence.
a. True
b. False
The_________ cache is a shared, reserved memory area that stores the most recently
executed SQL statements or PL/SQL procedures, including triggers and functions.
A dependency based on only a part of a composite primary key is called
a______________ .
A web_______________ server is a middleware application that expands the
functionality of web servers by linking them to a wide range of services.
What is a key and how is it important in a relational model?
A transaction processor is also known as the_____________ processor.
In an INSERT command, a user can indicate just the attributes that have required values
by listing the_______ inside parentheses after the table name.
A(n)__________ is a unique name by which the data source will be known to ODBC,
and therefore, to applications.
The IN subquery uses a(n) ____________operator.
A(n)_____________ in a hierarchical model is the equivalent of a record in a file
system.
The__________– is central to a discussion of normalization.
Describe the conceptual model and its advantages. What is the most widely used
conceptual model?
______________is a language based on OO concepts that describes a set of diagrams
and symbols used to graphically model a system.
A(n)___________ is a logical group of database objects, such as tables and indexes,
that are related to each other.
One of the advantages of a distributed database management system (DDBMS) is
processor____________ .
A table can be deleted from the database by using the__________ command.