Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Describe the use of nulls in a database.
Describe query optimization and the modes that an optimizer can operate in.
If your integer values are relatively small, use ____________________ instead of INT.
List and briefly describe the three types of system maintenance activities.
How can queries be written to perform the fastest when equality and inequality
comparisons are needed?
The ____________________ table space is the most frequently accessed table space
and should be stored in its own volume.
An API (application programming interface) is defined as a set of routines, protocols,
and tools for building software applications.
Database performance is one of the least important factors in all database
implementations.
ROLAP and MOLAP vendors are working toward the integration of their respective
solutions within a unified decision support framework.
What is a schema? How many schemas can be used in one database?
What are SQL functions and when are they used? Provide a couple of examples of
situations in which they are necessary.
Stored procedures help reduce code duplication by means of code isolation and code
sharing.
When using an optimistic approach, a transaction reads the database, executes the
needed computations, and makes the updates to a private copy of the database values.
A weak relationship exists if the primary key of the related entity contains at least one
primary key component of the parent entity.
What are the three basic techniques to control deadlocks?
OLAP systems share three main characteristics. What are they?
In an SQL-based relational database, each table is dependent on another.
A(n) ____________________ is a brief, precise, and unambiguous description of a
policy, procedure, or principle within a specific organization.
