Question 1

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.

Accepted Answer

characters"

Question 2

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

Accepted Answer

This statement is true. While composite primary keys can be used in some databases, single primary keys are more common in simpler databases.

Question 3

In determining the location where specific data is to be stored in a(n)centralized DBMS,factors such as communications cost,response time,storage cost,and security are key considerations.

Accepted Answer

distributed DBMS"

Question 4

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

Accepted Answer

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

Question 5

One emerging data security risk is the exploitation of known but unpatched vulnerabilities by hackers.

Accepted Answer

Hackers can exploit known vulnerabilities in order to gain access to systems and networks, making it important for organizations to promptly apply security patches and updates to prevent such attacks.

Question 6

A ____ holds a single category of data (such as customer names or employee telephone numbers)that will be stored in a database.
A)cell
B)field
C)table
D)record

Accepted Answer

A field is a single category of data that will be stored in a database. A cell is a specific intersection of a row and column in a table, a table is a collection of related data organized in rows and columns, and a record is a collection of related fields that represent a complete set of information about a specific entity.

Question 7

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

Accepted Answer

With MOLAP, the multidimensional information is not stored in an existing relational database using tables. Rather, it is stored in a specialized multidimensional database optimized for OLAP operations.

Question 8

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

Accepted Answer

table structure"

Question 9

Software that connects two otherwise separate applications-such as a Web server and a DBMS-is referred to as interware

Accepted Answer

middleware"

Question 10

A ____ is a collection of related fields.
A)table
B)field
C)column
D)record

Accepted Answer

A record is a collection of related fields, representing a single data item. For example, in a database of employees, a record might contain fields for an employee's name, address, and phone number.

Question 11

Web databases allow Web pages to be static Web pages; that is, Web pages in which the appearance or content of the pages change based on the user’s input.

Accepted Answer

dynamic"

Question 12

A record is also called a ____.
A)field
B)report
C)row
D)table

Accepted Answer

A record is a single unit of data that contains information about a particular entity, and is typically represented as a row in a table. Fields are the individual data elements that make up a record, while a report is a formatted display of data from one or more records. A table is a collection of related records stored in a database.

Question 13

After all the tables in a database application have been created and their primary keys designated,the tables can be related to one another via their primary key so that a primary key for one table can be used to extract data from other tables as needed.

Accepted Answer

This statement is true. Primary keys are used as a means to link tables together in a database application. By designating a primary key in a table, the values in that column can be used to extract data from other tables that have a relationship to it. This is a key feature of relational databases.

Question 14

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.

Accepted Answer

This describes a flat-file database system, which is a type of file management system.

Question 15

As part of its disaster-recovery plan,some firms maintain a(n)hot site-an alternate location equipped with identical hardware and software that can be used to resume operations quickly in case of a major disaster.

Accepted Answer

This statement accurately describes a hot site as part of a disaster-recovery plan.

Question 16

One advantage of the n-tier architecture is that it allows the program code used to access the database to be separate from the database,and the code can be divided into any number of logical components.

Accepted Answer

This is a correct advantage of the n-tier architecture. Separating the program code used to access the database from the database itself allows for greater flexibility, scalability, and maintainability of the system. Additionally, dividing the code into logical components allows for easier testing and debugging.

Question 17

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

Accepted Answer

This statement is true, as object queries can be used to retrieve objects from an OODBMS, and OQL is a language specifically designed for querying object-oriented databases.

Question 18

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.
A)query wizards
B)programming languages
C)report generators
D)form screens

Accepted Answer

The sentence mentions "interfacing with programming languages" as one of the tasks that DBMSs come bundled with tools for. The other options (A) query wizards, (C) report generators, and (D) form screens are not explicitly mentioned as necessary tasks that the bundled tools can perform.

Question 19

Database developers are the people responsible for managing the databases within an organization.

Accepted Answer

Database administrators"

Question 20

A field is also called a ____.
A)column
B)row
C)table
D)record

Accepted Answer

A field is a column in a database table that represents a particular type of data, such as a name, date, or number. It is not a row, which represents a single record or instance of data, or a table, which is a collection of related data.

Quiz 14: Databases and Database Management Systems