The DBA must supervise the installation of all software and hardware designated to
support the data administration strategy, must have a thorough understanding of the
components being installed, and must be familiar with the installation, configuration,
and startup procedures of such components.
Today, most relational database products can be classified as object/relational.
Some RDBMSs, such as Microsoft Access, automatically make the necessary
conversions to eliminate case sensitivity.
Having a computerized DBMS guarantees that the data will be properly used to provide
the best solutions required by managers.
Describe the DBA’s managerial role.
What do specialization hierarchies do?
Whether you purchase online or by standing in line, the system-level transaction details
are essentially the same and they require the same basic database structures and
relationships.
____________________ is a process to help reduce the likelihood of data anomalies.
The end user must provide testing and evaluation services for all the database and DBA
applications.
DATE() and SYSDATE are special functions that return today’s date in MS Access and
____________________, respectively.
Information implies familiarity, awareness, and understanding knowledge as it applies
to an environment.
The ANSI prescribes a standard SQL”the current fully approved version is known as
SQL-07.
If one department chaira professorcan chair only one department and one department
can have only one department chair, then the entities PROFESSOR and
DEPARTMENT exhibit a(n) ____________________ relationship.
String comparisons are made from left to right.
One CASE tool, ____________________ Data Modeler by Computer Associates,
produces fully documented ER diagrams that can be displayed at different abstraction
levels.
The requirement that a password must have a maximum of 12 characters is an example
of a(n) ____________________.
____________________-level locks are less restrictive than database-level locks, but
they create traffic jams when many transactions are waiting to access the same table.