Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
1.
|
You
never define the FK at the entity level for any entity, no matter its relationship(s) to other
entities. You must ensure that the following actions are taken:
a. | All the FK
components that are inherent from related entities will be properly inserted into each entity that
requires the use of such inherited PK attribute(s). | b. | The FKs will
always inherit the attribute characteristics from the PKs that they point
to. | c. | a
only | d. | b
only | e. | a and
b | | |
|
|
|
2.
|
The
verification process is used to establish that:
a. | the design
properly reflects the end-user or application views of the database. | b. | all database
transactions - inserts, updates, deletes are defined and modeled to ensure that the implementation of
the design will support all transaction-processing requirements. | c. | a only
| d. | b
only | e. | a and
b | | |
|
|
|
3.
|
The
verification process is used to establish that:
a. | The database
design is capable of meeting all output requirements, such as query screens, forms, and report
formats. | b. | All required input screens and data entry forms are
supported. | c. | a and b | d. | a
only | e. | b
only | | |
|
|
|
4.
|
The
verification process is used to establish that:
a. | The design is
sufficiently flexible to support expected enhancements and modifications | b. | The database
design is capable of meeting all output requirements, such as query screens, forms, and report
formats. | c. | a only | d. | a and
b | e. | b
only | | |
|
|
|
5.
|
In
spite of the fact that we sometimes are forced to revise an E-R diagram it is still possible
that:
a. | Some of the
relationships are not clearly identified and may have been misidentified. | b. | The model
contains design redundancies. | c. | a only | d. | a and
b | e. | b
only | | |
|
|
|
6.
|
In
spite of the fact that we are sometimes forced to revise an E-R diagram it is still possible
that:
a. | The model can be
enhanced to improve semantic precision and to better represent the operation in the
real-world. | b. | The model most be modified to better meet the user requirements
such as processing performance or security. | c. | a
only | d. | a and
b | e. | b
only | | |
|
|
|
7.
|
The
advantage(s) of letting CASE tool write all of the table structures and relationships
are:
a. | The database
will match the design precisely. | b. | All the relationships have already been tested by CASE tool to
ensure that they are logically correct and that they are implementable as
design. | c. | a only | d. | a and
b | e. | b
only | | |
|
|
|
8.
|
The
advantage(s) of letting CASE tool write all the table structures and relationships
are:
a. | All the
relationships have already been tested by CASE tool to ensure that they are logically correct and
that they are implementable as design. | b. | All of the FK attribute definitions and characteristics that
match those of the referenced PKs. | c. | a only | d. | a and
b | e. | b
only | | |
|
|
|
9.
|
Several indexes can be created to improve access time, such as
a. | indexes created
for all primary keys will increase access speed when a foreign key references in tables is
made. | b. | indexes can also be created for all alternate search
keys. | c. | indexes can be created for all columns used in the WHERE, ORDER
BY, and GROUP BY clauses of a SELECT statement. | d. | a and
b | e. | a, b and
c | | |
|
|
|
10.
|
There
are several techniques used to ensure appropriate data entries. Among some of these techniques
we can find
a. | down-down lists
to limit the input selections. | b. | automated data entry completions based on the input
selections. | c. | system-generated computations to avoid end-user computational
errors. | d. | b and c only | e. | a, b and
c | | |
|
|
|
11.
|
Several measures may enhance the UCL system's performance. At the physical
level, each DBMS/hardware combination has its own specific advantages. The following techniques
are acceptable:
a. | Define system configuration parameters to enhance
performance. | b. | Augment the amount of workspace that is used by different
statements by increasing the shared segments database parameter. | c. | a
only | d. | a and
b | e. | b
only | | |
|
|
|
12.
|
Several measures may enhance the UCL system's performance. At the physical
level, each DBMS/hardware combination has its own specific advantages. The following techniques
are acceptable:
a. | Enhance system performance through the reorganization of the
database. | b. | Enhance system performance by fine-tuning the local area
network parameters and increasing the amount of RAM used in each of the network's
computers. | c. | a only | d. | a and
b | e. | b
only | | |
|
|
|
13.
|
Recovery procedures must delineate the steps to ensure full recovery of the system
after a system failure or physical disaster. The system backup and recovery scenario should
include
a. | each computer in
the system has an uninterrupted power supply to protect the computers against electrical
interruptions. | b. | periodic backups should be made and the use of transaction logs
for recovery for a database from a given state when a disaster occurs. | c. | a
only | d. | a and
b | e. | b
only | | |
|
|
|
14.
|
The
DBA's responsibilities should include:
a. | monitoring and fine tuning the
database. | b. | planning for and allocating resources for changes and
enhancements. | c. | planning for and allocating resources for periodic system
upgrades. | d. | a and c only | e. | a, b and
c | | |
|
|
|
15.
|
The
DBA's responsibilities should include:
a. | providing preventive and corrective
maintenance. | b. | providing end-user management
services. | c. | performing periodic security audits. | d. | a and c
only | e. | a, b and
c | | |
|
|
|
16.
|
The
DBA's responsibilities should include:
a. | marketing the database to the organization's
users. | b. | ensuring completion of database projects within time and budget
constraints. | c. | a only | d. | a and
b | e. | b
only | | |
|