Question 1

A field identified in a record as holding the unique identifier for that record is called the

Accepted Answer

The answer of A field identified in a record as...

Question 2

In a relational database,the three basic operations used to develop useful sets of data are

Accepted Answer

Select allows for filtering of data based on certain criteria, project allows for selecting only specific columns of data, and join allows for combining data from multiple tables based on a common column. These three operations are the basis of creating useful sets of data in a relational database.

Question 3

The join operation

Accepted Answer

The join operation combines relational tables to provide the user with more information than is otherwise available by linking two or more tables based on a related column.

Question 4

A schematic of the entire database that describes the relationships in a database is called a(n)

Accepted Answer

A schematic of the entire database that describes the relationships in a database is called an Entity-Relationship Diagram (ERD). A data dictionary is a repository of information about the data in a database, an intersection relationship diagram and a data definition diagram are not commonly used terms in database design, and a data analysis table is a tool used in data analysis, rather than database design.

Question 5

NoSQL technologies are used to manage sets of data that don't require the flexibility of tables and relations.

Accepted Answer

NoSQL databases use a non-relational database model that avoids the rigid structure of tables and relations in favor of more flexible document or key-value pairs. This makes NoSQL databases suitable for managing unstructured or semi-structured data, such as social media content, logs, or sensor data.

Question 6

The most prominent data manipulation language today is

Accepted Answer

SQL (Structured Query Language) is the most commonly used data manipulation language today. It is used to communicate with and manipulate relational databases. Other options like Access and DB2 are specific database management systems that utilize SQL, but SQL itself is not tied to any one particular system. While Crystal Reports is a popular reporting software, it is not a data manipulation language. NoSQL is a category of databases that does not use SQL as its primary language.

Question 7

A field identified in a table as holding the unique identifier of the table's records is called the

Accepted Answer

The field that holds the unique identifier of the table's records is called the primary key. This is a crucial field that is used to uniquely identify each record in the table, and it serves as a reference point for other tables that may need to link their records to this table's records. The other choices in the question (B, C, D, and E) do not accurately describe this concept.

Question 8

The specialized language programmers use to add and change data in the database is called

Accepted Answer

The specialized language programmers use to add and change data in the database is called data manipulation language (DML). DML is a subset of SQL that deals with inserting, updating, and deleting data in the database. Therefore, option B, "a data manipulation language," is the correct answer. Option A, "a data access language," is incorrect because it refers to the language used to retrieve data from the database. Option C, "structured query language," is incorrect because while SQL is a query language, there are other types of query languages as well. Option D, "a data definition language," refers to the language used to define the structure of the database, not manipulate the data. Option E, "a DBMS," is incorrect because it refers to the software used to manage the database, not the language used to manipulate the data.

Question 9

The DBMS programming language that end users and programmers use to manipulate data in the database is called CGI.

Accepted Answer

The programming language used to manipulate data in a database is not CGI, but rather SQL (Structured Query Language). CGI stands for Common Gateway Interface and refers to a standard protocol for web servers to interface with external programs.

Question 10

The project operation

Accepted Answer

The answer of The project operation
...

Question 11

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with

Accepted Answer

The answer of A one-to-many relationship between two entities is...

Question 12

The logical and physical views of data are separated in a DBMS.

Accepted Answer

In a DBMS, the logical view of data refers to how the data is perceived by users, while the physical view refers to how the data is stored on disk. These two views are separated in a DBMS to provide flexibility and to allow for changes in the physical storage without affecting the logical view.

Question 13

The select operation

Accepted Answer

The answer of The select operation
...

Question 14

In a relational database,a record is referred to in technical terms as a(n)

Accepted Answer

A record in a relational database is referred to as a tuple, which is a collection of related data values.

Question 15

DBMSs typically include report-generating tools in order to

Accepted Answer

DBMSs include report-generating tools to display data in an easier-to-read format for users. While some tools may offer options for displaying data in graphs or performing predictive analysis, these are not the primary functions of report-generating tools in DBMSs. Similarly, tools for analyzing database performance may be included, but they would be distinct from report-generating tools.

Question 16

The data dictionary serves as an important data management tool by

Accepted Answer

The data dictionary creates an inventory of the data elements contained in the database, providing a comprehensive list of data elements and their descriptions. It is not focused on assigning attributes to the data, presenting data to end users, maintaining data in updated form, or providing a guide to database terms and settings, although it may include some of this information as well.

Question 17

An automated or manual file that stores information about data elements and data characteristics such as usage,physical representation,ownership,authorization,and security is the

Accepted Answer

A data dictionary is specifically designed to store information about data elements and their characteristics. The other options focus on different aspects of data modeling and do not necessarily include this level of detail.

Question 18

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called

Accepted Answer

The process of minimizing redundancy and many-to-many relationships in data is known as normalization. This involves dividing larger tables into smaller ones and defining relationships between them to create a more efficient and effective database structure. Data scrubbing and cleansing refer to the process of identifying and correcting errors or inconsistencies in the data. Data defining and optimization are not specific processes related to streamlining data.

Question 19

You are creating a database to store temperature and wind data from national airport locations.Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

Accepted Answer

The airport code is the unique identifier for each airport and is unlikely to change, making it a strong candidate for a primary key. The other fields (address, city, state, day) are not likely to be unique and could change over time.

Question 20

Every record in a file should contain at least one key field.

Accepted Answer

A key field is used to uniquely identify each record in a file. At least one key field is necessary for effective organization and retrieval of data.

Quiz 6: Foundations of Business Intelligence: Databases and Information Management