FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 14: Databases and Database Management Systems

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

True/False

Review LaterAdd Note

Review Later

With MOLAP (Multidimensional OLAP),the multidimensional information is stored in an existing relational database using tables to store the summary information.

A) True
B) False

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

The ____ is the most widely used database model today.

A) hierarchical database management system
B) relational database management system (RDBMS)
C) network database management system
D) database management system (DBMS)

E) A) and D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

The field in a table that is used to relate that table to other tables is called the ____.

With ____,the computer uses each record's primary key field and a mathematical formula called a hashing algorithm to determine a unique address that identifies where the record is physically stored in the database file.

A ____ is a collection of related fields.

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

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

____________________ rules are used when the value of one field in the record needs to be checked against another field in that same record to be sure it is valid.

Hashing procedures usually result in two or more records being assigned the same storage address,an event known as a collision.

Primary keys can be a combination of two key fields (called composite primary keys),but single primary keys are more typical in simple databases.

-In Microsoft Access,tables can be created in either Datasheet view or ____________________ view,as shown in the figure above.

To protect against data loss caused by a database failure,accidental deletion,or other problem that renders the main copy of a database unusable,stringent backup procedures should be implemented.

If a new database is to be used with existing data,the data needs to be transferred from its existing form into the new system-a process called ____.

To create a query,users can either type a query using SQL or,more commonly,use the query tools built into the DBMS (such as a query design screen or query ____) to create a query object.

Structured query language (SQL)is recognized as the standard query language for relational databases.

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 is most interested in becoming a database designer.Another name for this career choice is database ____.

A(n)file management system is a program that allows the creation of individual database tables,each of which is stored in its own physical file and is not related to any other file.

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. -Database designers work with systems analysts and other individuals involved in ____.

Web-based database requests are received by the Web server,which then converts the request into a database query and passes it on to the database server with the help of software called ____.

Most DBMSs come bundled with a set of tools to perform a variety of necessary tasks,such as building user interfaces,creating forms and reports,and interfacing with query languages and ____ for complex applications.