In the ____ model, the user perceives the database as a collection of records in 1:M
relationships, where each record can have more than one parent.
a. hierarchical
b. network
c. object-oriented
d. entity relationship
From a system functionality point of view, ____ attribute values can be calculated when
they are needed to write reports or invoices.
a. derived
b. atomic
c. granular
d. historical
____ transparency ensures that the system will continue to operate in the event of a
node failure.
a. Transaction
b. Distribution
c. Failure
d. Performance
Computed or derived facts are sometimes called ____to differentiate them from stored
facts.
a. details
b. attributes
c. metrics
d. fact tables
The response of the DBMS to a query is the ____.
a. ad hoc query
b. ad hoc response
c. query result set
d. integrated view of the data
A ____ is a query (SELECT statement) inside a query.
a. subquery
b. range query
c. join
d. set query
ODBC works on the ____ operating system.
a. mainframe
b. UNIX
c. Windows
d. Linux
The primary key’s main function is to uniquely identify a(n) ____ within a table.
a. attribute
b. entity instance or row
c. entity subtype
d. natural identifier
A single-user database system automatically ensures ____ of the database, because only
one transaction is executed at a time.
a. serializability and durability
b. atomicity and isolation
c. serializability and isolation
d. atomicity and serializability
The ____ modelis the end users’ view of the data environment.
a. abstract
b. external
c. conceptual
d. internal
____ transparency exists when the end user or programmer must specify both the
fragment names and their locations.
a. Local mapping
b. Location
c. Performance
d. Transaction
One important inheritance characteristic is that all entity subtypes inherit their ____ key
attribute from their supertype.
a. primary
b. natural
c. foreign
d. surrogate
The ____ guarantees that if a portion of a transaction operation cannot be committed,
all changes made at the other sites participating in the transaction will be undone to
maintain a consistent database state.
a. DO-UNDO-REDO protocol
b. two-phase commit protocol (2PC)
c. coordinator protocol
d. write-ahead protocol
____ fragmentation allows you to break a single object into two or more segments or
fragments.
a. Horizontal
b. Vertical
c. Data
d. Mixed
The ____ command would be used to delete the table row where the P_CODE is
‘BRT-345’.
a. DELETE FROM PRODUCT WHERE P_CODE = ‘BRT-345’;
b. REMOVE FROM PRODUCT WHERE P_CODE = ‘BRT-345’;
c. ERASE FROM PRODUCT WHERE P_CODE = ‘BRT-345’;
d. ROLLBACK FROM PRODUCT WHERE P_CODE = ‘BRT-345’;
All transactions must display ____.
a. atomicity, consistency, and durability
b. durability and isolation
c. consistency, durability, and isolation
d. atomicity, durability, consistency, and isolation
A ____ is a collection of related records.
a. database
b. field
c. column
d. file
Which of the following is a well-defined Web-server interface?
a. Common Gateway Interface
b. Disk Operating System
c. Windows 98
d. AppleTalk
Which query will output the table contents when the value of V_CODE is 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;
An example of denormalization is using a ____ denormalized table to hold report data.
This is required when creating a tabular report in which the columns represent data that
is stored in the table as rows.
a. transitive
b. 3NF
c. component
d. temporary
The ____ is actually a system-created database whose tables store the
user/designer-created database characteristics and contents.
a. meta dictionary
b. schema
c. data dictionary
d. system catalog
ANSI defines four events that signal the end of a transaction. Of the following events,
which is defined by ANSI as being equivalent to a COMMIT?
a. Five SQL statements are executed.
b. The end of a program is successfully reached.
c. The program is abnormally terminated.
d. The database is shut down for maintenance.
The associative entity is also known as a ____ entity.
a. unary
b. weak
c. strong
d. composite
The hierarchical data model was developed in the ____.
a. 1960s
b. 1970s
c. 1980s
d. 1990s
User requirements, existing system evaluation, and logical system design are part of the
____ phase of the SDLC.
a. planning
b. analysis
c. detailed systems design
d. implementation
The process of database design and implementation is ____ development.
a. systems
b. database
c. network
d. transformation
Which query will list all the rows in which the inventory stock dates occur on or after
January 20, 2010?
a. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT
WHERE P_INDATE >= ’20-JAN-2010′
b. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM
PRODUCT WHERE P_INDATE >= $20-JAN-2010$
c. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT
WHERE P_INDATE <= ’20-JAN-2010′
d. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM
PRODUCT WHERE P_INDATE >= {20-JAN-2010}
In a database context, the word ____indicates the use of the same attribute name to
label different attributes.
a. redundancy
b. homonym
c. duplicate
d. synonym
The process of creating an information system is known as ____ development.
a. systems
b. database
c. network
d. transformation
A ____ is a character or group of characters that has a specific meaning.
a. database
b. field
c. record
d. file
The ____ is the most specialized object in the ADO.NET framework.
a. Command
b. DataReader
c. DataAdapter
d. DataSet
A(n) ____ data dictionary is automatically updated by the DBMS with every database
access.
a. dynamic
b. active
c. passive
d. static
One of the major advantages of stored procedures is that they can be used to
encapsulate and represent business transactions.
Stored procedures must have at least one argument.
Referential and entity integrity are two names for the same thing.
The ____________________ relationship is the relational database norm.
What is transaction isolation and why it is important?
Participation is ____________________ if one entity occurrence does not requirea
corresponding entity occurrence in a particular relationship.
APIs are implemented as dynamic-link libraries that are dynamically invoked when
needed.
The ____________________ join is the traditional join in which only rows that meet a
given criteria are selected.
A security ____________________is a weakness in a system component that could be
exploited to allow unauthorized access or cause service disruptions.
A(n) ____________________ index is an index in which the index key can have only
one pointer value (row) associated with it.
One disadvantage of a database system over previous data management approaches is
increased costs.
A diagram that depicts all dependencies found within a given table structure is known
as a(n) ____________________.
Each statement inside the PL/SQL code must end with a period (“.”).
A table can be deleted from the database by using the ____________________
command.