Exam 12: Databases and Database Management Systems

____ are made up of related records.

Case-Based Critical Thinking Questions Case 14-1 James is a recent college graduate and has six months of IT experience. He is thinking about pursuing a certification program in order to demonstrate that he is serious about IT. James learns that database designers work with systems analysts and other individuals involved in the ____.

The finished specifications for a table are commonly referred to as the table format . _________________________

Most databases created today do not use the hierarchical or network models; however, these models, which are generally used with legacy mainframe systems, are still operational and so must be maintained.

A ____ extracts specific information from a database by specifying particular conditions (called criteria) about the data you would like to retrieve.

In Microsoft Access, tables can be created in either Datasheet view or ____________________ view.

Objects stored in an OODBMS can be retrieved using queries, such as with queries written in object query language (OQL) -an object-oriented version of SQL. _________________________

A(n) ____________________ in a database table must uniquely identify each record in that table.

At the lowest level, words are entered into database fields (columns), which hold single pieces of data in the database, such as product names or quantities. _________________________

A ____ displays table information with a more formal, businesslike appearance.

The term ____ refers to a wide variety of different database technologies that were developed in order to overcome some of the limitations of relational databases.

One of the properties that can be assigned to a field is a(n) ____ to specify the format (such as letters, numbers, or symbols) that must be entered into a field.

IBM's DB2 program contains a hybrid XML/relational database server.

A record is also called a ____.

Data accessibility refers to protecting data against destruction and misuse-both intentional and accidental.

Software that connects two otherwise separate applications (such as a Web server and a DBMS) is referred to as interware . _________________________

Data integrity refers to the accuracy of data.

____________________ databases are located on a single computer and are designed to be accessed by one user.

In a typical client-server database application, the client is called the ____.

____ is a growing concern because of the vast amounts of personal data stored in databases today and the many data privacy breaches that are occurring.