FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 12: Databases and Database Management Systems

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Short Answer

Review LaterAdd Note

Review Later

____________________ usually includes the programs used with the database and the programs needed to connect the client and server components of the database system.

Correct Answer

verified

Show Answer

Question 52

Essay

Review LaterAdd Note

Review Later

What are the major roles and responsibilities of database administrators?

Correct Answer

verified

Database administrators (DBAs) are the p...

View Answer

Show Answer

Question 53

Essay

Review LaterAdd Note

What is a NoSQL database?

With indexed organization, a(n) ____________________ is used to keep track of where data is stored in a database.

The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called ____.

A key component of a DBMS is the ____________________ , the part of the program that actually stores and retrieves data.

Virtually all DBMSs include a ____ for easy data input, modification, and retrieval.

Middleware for cloud database applications is commonly written as ____-short sections of code written in a programming or scripting language that are executed by another program.

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.

Views need to be designed to extract the requested information from a relational database, as efficiently as possible.

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

____ create the actual database based on the design generated by the database designer and get it ready for data entry.

Case-Based Critical Thinking Questions Case 14-2 The JL Group is a political think tank that is incorporating new media into their analyses. The JL Group has gathered data on voting habits. In order to make sure that respondents cannot claim to have voted in more elections than is possible given their age, ____ rules can be assigned to the database tables.

A ____ is a collection of related fields.

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

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. _________________________

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.

In the third normal form (3NF), a table has no ____________________ dependencies; that is, two fields that are not primary keys and are dependent on one another.

Data definition involves describing the properties of the data that go into each database table, specifically the ____ that make up the database.

In ASPs, the code to tie the database to the Web site is typically written in JavaScript or ____.