Question 1

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 2

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

A file management system 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.

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

A field is the smallest unit of data that can be stored in a database and represents a single piece of information, such as a name, phone number, or date. Fields are grouped together to form records, and records are stored in tables. Therefore, a field holds a single category of data.

Question 5

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

Accepted Answer

In a centralized DBMS, data is stored in a single location, so factors like communication cost and storage location are not relevant. However, response time, storage cost, and security are still important considerations.

Question 6

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 separation of code and database allows for easier maintenance, updates, and scalability of the software system.

Question 7

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

Accepted Answer

The finished specifications for a table are commonly referred to as a table schema, not a table format.

Question 8

The field in a table that is used to relate that table to other tables is called the ____.
A) composite key
B) secondary key
C) primary key
D) primary field

Accepted Answer

The primary key uniquely identifies each record in a table and is used to relate that table to other tables. A composite key is made up of two or more fields that together uniquely identify a record, a secondary key is an alternate field or set of fields that can be used to identify records in addition to the primary key, and a primary field is not a commonly recognized term in database design.

Question 9

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

Accepted Answer

Software that connects two otherwise separate applications is referred to as middleware, not interware.

Question 10

NoSQL databases are organized differently than relational databases are organized and therefore, they do not usually use tables and SQL. _________________________

Accepted Answer

NoSQL databases use different data models and structures than relational databases, such as document model, graph model, key-value model, or column-family model, and they do not require SQL for querying and manipulating data.

Question 11

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

The answer of At the lowest level, words are entered...

Question 12

To protect against data loss due to disasters, some firms maintain a redundant copy of the database on a(n) mirrored ​drive , backing up the data at very frequent intervals to an off-site location. _________________________

Accepted Answer

Maintaining a redundant copy of the database on a mirrored drive and backing up the data at frequent intervals to an off-site location is a common method employed by firms to protect against data loss due to disasters.

Question 13

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

Accepted Answer

Database administrators, not developers, are primarily responsible for managing databases within an organization. Developers focus on designing and developing database applications.

Question 14

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

Accepted Answer

A record is a single instance or row in a table, containing all the information related to a particular entity or object. Therefore, the best choice in this scenario is C) row. A field is a single piece of information within a record, a report is a document that presents information from a table in a summarized format, and a table is a collection of records.

Question 15

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 keys so that a primary key for one table can be used to extract data from other tables as needed. _________________________

Accepted Answer

This is true. By using the primary keys of related tables, data can be joined and extracted in a database application.

Question 16

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

Accepted Answer

Hackers can target known vulnerabilities in software or systems that have not yet been patched or updated, leaving them open to attack. This underscores the importance of timely software updates and patches to mitigate potential security risks.

Question 17

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

Accepted Answer

A field is a vertical column in a table that holds a specific type of data. It is not a row, which is a horizontal entity, nor a table, which is the entire collection of data. A record is a complete set of data that includes multiple fields.

Question 18

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

Accepted Answer

This statement is true. Objects stored in an OODBMS can be retrieved using queries, including OQL. OQL is a language specifically designed for querying object-oriented databases.

Question 19

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

Accepted Answer

Cloud databases do provide dynamic content to web pages, but they do not make the pages static. Static Web pages are pages that do not change based on user input.

Question 20

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

Accepted Answer

While query wizards, report generators, and form screens are included in many DBMSs, not all of them come bundled with these tools. However, most DBMSs do include support for interfacing with programming languages like SQL or Python, which are indispensable for complex applications. Therefore, the best choice is B) programming languages.

Quiz 12: Databases and Database Management Systems

A ____ is a collection of related fields.

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

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

A ____ holds a single category of data (such as customer names or employee phone numbers) that will be stored in a database.

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

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

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

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

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

NoSQL databases are organized differently than relational databases are organized and therefore, they do not usually use tables and SQL. _________________________

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

To protect against data loss due to disasters, some firms maintain a redundant copy of the database on a(n) mirrored drive , backing up the data at very frequent intervals to an off-site location. _________________________

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

A record is also called a ____.

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 keys so that a primary key for one table can be used to extract data from other tables as needed. _________________________

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

A field is also called a ____.

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

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

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.

Quiz 12: Databases and Database Management Systems

A ____ is a collection of related fields.

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

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

A ____ holds a single category of data (such as customer names or employee phone numbers) that will be stored in a database.

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

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

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

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

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

NoSQL databases are organized differently than relational databases are organized and therefore, they do not usually use tables and SQL. _________________________

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

To protect against data loss due to disasters, some firms maintain a redundant copy of the database on a(n) mirrored ​drive , backing up the data at very frequent intervals to an off-site location. _________________________

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

A record is also called a ____.

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 keys so that a primary key for one table can be used to extract data from other tables as needed. _________________________

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

A field is also called a ____.

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

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

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.

To protect against data loss due to disasters, some firms maintain a redundant copy of the database on a(n) mirrored drive , backing up the data at very frequent intervals to an off-site location. _________________________