A ___________occurs when there is one entity in two 1:M relationships to other
entities, thus producing an association among the other entities that is not expressed in
the model.
a. surrogate primary key
b. time-variant data
c. design trap
d. fan trap
A security breach is a weakness in a system component that could be exploited to allow
unauthorized access or cause service disruptions.
a. True
b. False
Analyzing the company situation is part of the___________ phase of the Database Life
Cycle (DBLC).
a. database initial study
b. database design
c. testing, and evaluation
d. operation
Specialization is the top-down process of identifying lower-level, more specific entity
subtypes from a higher-level entity supertype.
a. True
b. False
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
UNION, INTERSECT, and MINUS work properly only if relations are
intersect-compatible, which means that the names of the relation attributes and their
data types must be different.
a. True
b. False
A good relational DBMS excels at managing denormalized relations.
a. True
b. False
In order to manage distributed data, copies or parts of the database processing functions
must be distributed to all data storage sites.
a. True
b. False
Character data can contain any character or symbol intended for mathematical
manipulation.
a. True
b. False
On the server side, the database environment must be properly configured to respond to
clients’ requests in the fastest way possible, while making optimum use of existing
resources. The activities required to achieve this goal are commonly referred to
as___________ tuning.
a. client and server
b. database SQL
c. SQL performance
d. DBMS performance
The detailed systems design phase of the Systems Development Life Cycle (SDLC)
includes all the necessary technical specifications for the screens, menus, reports, and
other devices used to make the system more efficient.
a. True
b. False
A fully distributed database management system (DBMS) must perform all the
functions of a centralized DBMS, and it must handle all necessary functions imposed
by the distribution of data and processing.
a. True
b. False
In standard SQL, the optimizer hint FIRST_ROWS is generally used for____________
mode processes.
a. batch
b. interactive
c. transaction
d. real-time
A___________ entity has a primary key that is partially or totally derived from the
parent entity in the relationship.
a. strong
b. weak
c. business
d. child
When selecting a foreign key placement for a 1:1 relationship, place the PK of the
entity on the mandatory side in the entity on the optional side as a FK, and make the FK
mandatory when______________ .
a. one side is mandatory and the other side is optional
b. one side participates in another relationship
c. both sides are optional
d. both sides are mandatory
_______________is an object-oriented programming language developed by Sun
Microsystems that runs on top of web browser software.
a. Visual Basic
b. Java
c. JavaScript
d. VBScript
A relational join operation merges rows from two tables.
a. True
b. False
In the context of OLE-DB, a_____________ is an object (application or process) that
requests and uses data.
Although SQL commands can be grouped together on a single line, complex command
sequences are best shown on separate lines, with space between the SQL command and
the command’s components.
a. True
b. False
Entity supertypes and subtypes are organized in a specialization hierarchy.
a. True
b. False
In the context of the database design process, the conceptual design step that determines
end-user views, outputs, and transaction-processing requirements is ___________.
a. data analysis and requirements
b. entity relationship modeling and normalization
c. data model verification
d. distributed database design
Just like database triggers, stored procedures are stored in the database.
a. True
b. False
The entity relationship model uses the associative entity to represent a(n)__________-
relationship between two or more entities.
a. M:N
b. 1:M
c. N:1
d. M:1
Which of the following refers to the situation where different versions of the same data
are stored at different places because they weren”t updated consistently?
a. Data query
b. Data integrity
c. Data dictionary
d. Data redundancy
The NEXT command for a cursor is used to retrieve a row from the cursor and place it
in the respective PL/SQL variables.
a. True
b. False
A sequence is not associated with a table and can be dropped from a database with a
DROP SEQUENCE command.
a. True
b. False
The primary objective in database design is to create complete, normalized,
nonredundant, and fully integrated conceptual, logical, and physical database models.
a. True
b. False
One of the major advantages of stored procedures is that they can be used to
encapsulate and represent business transactions.
a. True
b. False
Which of the following is a well-defined web-server interface?
a. Common Gateway Interface
b. Tiny Internet Interface
c. Windows NT
d. Command Line Interface
The special operator used to check whether a subquery returns any rows
is_________– .
a. BETWEEN
b. EXISTS
c. LIKE
d. IN
Knowing the sparsity of a column helps you decide whether the use of____________ is
appropriate.
a. query processing
b. query optimization
c. an index
d. a full table scan
The ROLLUP extension is used with the GROUP BY clause to generate aggregates by
the listed columns, including the last one.
a. True
b. False
The process of creating an information system is known as____________ .
a. systems development
b. database development
c. network development
d. enterprise development
_______________functionality ranges from simple data gathering and transformation
to very complex data analysis and presentation.
A(n)__________ process is based on repetition of processes and procedures.
Describe the three parts involved in any SQL-based relational database application.
Describe query optimization and the modes that an optimizer can operate in.
In case a company installs several incompatible databases and assigns a DBA for each
of them, the general coordinator of all such DBAs is known as the___________
administrator.
________________is data about data through which the end-user data are integrated
and managed.
The first step in_____________ is to discover the data element characteristics.
U.S. state abbreviations are always two characters, so____________ (2) is a logical
choice for the data type representing a state column.
Describe a dependency diagram and explain its purpose.
A table is also called a(n)________ because the relational model’s creator, E. F. Codd,
used the two terms as synonyms.
A security ______________is a weakness in a system component that could be
exploited to allow unauthorized access or cause service disruptions.
As a rule, a(n)____________ must unlock the object after its termination.
A data _____ is a small, single-subject data warehouse subset that provides decision
support to a small group of people.
A specialty field in mathematics, known as _________algebra, is dedicated to the use of
logical operators.
The___________ catalog can be described as a detailed system data dictionary that
describes all objects within the database, including data about table names, the table’s
creator and creation date, the number of columns in each table, the data type
corresponding to each column, index filenames, index creators, authorized users, and
access privileges.
A(n)__________ index is an index in which the index key can have only one pointer
value (row) associated with it.
If one department chaira professorcan chair only one department, and one department
can have only one department chair. The entities PROFESSOR and DEPARTMENT
exhibit a(n)__________ relationship.
In a real-world environment, changing granularity requirements might dictate changes
in primary key selection, and those changes might ultimately require the use
of_________ keys.
Explain user requirements gathering as part of the DBA’s end-user support services.
The concept of relationship strength is based on how the___________ of a related
entity is defined.