Question 1

Which of the following is a DBMS product from Microsoft?
A) MySQL
B) SQL Server
C) DB2
D) Sybase ASE

Accepted Answer

SQL Server is a database management system software from Microsoft. MySQL is an open-source relational database management system that is not a product from Microsoft. DB2 is a database management system product from IBM. Sybase ASE is a product from SAP.

Question 2

Which of the following best describes a byte in a database?
A) It is a character of data.
B) It is a group of rows.
C) It is a collection of data.
D) It is a group of columns.

Accepted Answer

A byte in a database is typically used to represent a single character of data. It is the smallest unit of data that can be stored in a database and is often used to represent letters, numbers, and symbols. Bytes are grouped together to form larger units of data, such as fields, records, and tables.

Question 3

In a database,columns are also called ________.
A) records
B) tables
C) files
D) fields

Accepted Answer

Columns in a database are also called fields. Records refer to the rows of data within a table, tables refer to the entire collection of data within a database, and files typically refer to the physical storage of the data on a computer or server.

Question 4

A ________ is a self-describing collection of integrated records.
A) datasheet
B) spreadmart
C) database
D) dataspace

Accepted Answer

A database is a self-describing collection of integrated records. A datasheet is a specific type of document within a database, and a spreadmart is not a commonly used term in database terminology. A dataspace may refer to a virtual space for storing data, but it is not a widely recognized term in database management.

Question 5

The DBMS provides applications for processing operations such as ________.
A) sending and receiving emails
B) writing software programs
C) inserting or deleting data
D) automating business processes

Accepted Answer

DBMS is a software system that stores and manages data. It provides applications specifically for processing operations such as inserting, updating, and deleting data in a database. It does not provide applications for sending and receiving emails, writing software programs, or automating business processes.

Question 6

The purpose of a database is to ________.
A) test and troubleshoot newly installed software
B) design the source code for computer programs
C) describe and build computer architectures
D) store lists of data involving multiple themes

Accepted Answer

The purpose of a database is to store lists of data involving multiple themes. It is a collection of data that is organized in a way that allows users to retrieve and manage that data with ease. Databases are widely used in businesses, organizations, and other areas for various purposes ranging from storing customer information to financial data to inventory management.

Question 7

In a database,a ________ is a column or group of columns that identifies a unique row in a table.
A) field
B) record
C) file
D) key

Accepted Answer

A key is used in a database to uniquely identify each row or record in a table. This allows for efficient searching and sorting of data.

Question 8

In a database,a group of similar rows is called a ________.
A) table
B) record
C) field
D) matrix

Accepted Answer

In a database, a group of similar rows is organized into a table, which contains records (rows) of data. Fields (columns) within the records hold specific pieces of information. A matrix is a grid of data arranged in rows and columns, but it does not necessarily refer to a group of similar rows in a database.

Question 9

Databases that carry their data in the form of tables and represent relationships using foreign keys are called ________ databases.
A) foreign
B) continuous
C) relational
D) discrete

Accepted Answer

Databases that carry their data in the form of tables and represent relationships using foreign keys are called relational databases. This is because they maintain relationships between tables through the use of keys, rather than storing data in a continuous or discrete manner. Foreign keys are used to link tables together, allowing for more complex queries to be run on the data.

Question 10

In a database,rows are also called ________.
A) records
B) fields
C) tables
D) files

Accepted Answer

Rows in a database are known as records, which contain a collection of fields or columns with specific data values. Tables are a collection of records in a database, while files represent a collection of related data stored as text, binary, or other formats.

Question 11

In a database,columns that are keys of a different table than the one in which they reside are known as ________ keys.
A) foreign
B) discrete
C) relational
D) continuous

Accepted Answer

Keys that are references to a different table are known as foreign keys, as they create a relationship between two tables in a database. Discrete, relational, and continuous are not relevant terms in this context.

Question 12

In a database,a table is formally referred to as a ________.
A) matrix
B) field
C) record
D) relation

Accepted Answer

In a database, a table is formally referred to as a relation. This is because a table is essentially a set of related data, and in the context of a database management system (DBMS), a relation refers to a set of data that is organized in a specific way. The other options, matrix, field, and record, all refer to individual components within a table or database, but do not encompass the entire table.

Question 13

Which of the following best describes the metadata in a database?
A) data that cannot be used as an information resource
B) special data that describes the structure of a database
C) data that describes a Web page
D) special data that is unique to a specific user

Accepted Answer

Metadata in a database refers to the special data that describes the structure of a database, including the names and types of fields, relationships between tables, and data constraints. It provides information on the data contained in a database and how it’s organized, making it an essential resource for effective database management. Options A, C, and D do not accurately describe metadata in a database.

Question 14

In a database,the collection of data for all columns is called a ________.
A) record
B) field
C) file
D) table

Accepted Answer

The answer of In a database,the collection of data for...

Question 15

In a database,a table,which is a group of similar rows,is also called a ________.
A) record
B) matrix
C) file
D) field

Accepted Answer

A table is a collection of data organized in rows and columns, similar to a file in a file system. Records, fields, and matrices are components of a table, but do not refer to the entire group of similar rows.

Question 16

Which of the following is a function of the DBMS?
A) analyzing business data to predict future performance
B) eliminating bottlenecks in business processes
C) automating workflows in companies
D) processing a database by inserting or modifying data

Accepted Answer

Processing a database by inserting or modifying data is a primary function of the DBMS. The other options mentioned are related to the use of the database or the information derived from it, but not to the function of the DBMS itself.

Question 17

________ is a popular enterprise DBMS product from IBM.
A) DB2
B) Access
C) SQL Server
D) MySQL

Accepted Answer

DB2 is an enterprise DBMS product from IBM, and it is widely used in large organizations and businesses. Access, SQL Server, and MySQL are also popular DBMS products, but they are not specifically targeted towards enterprise-level use cases.

Question 18

A(n)________ is a program that is used to create,process,and administer a collection of self-describing integrated records.
A) decision support system (DSS)
B) knowledge management system (KMS)
C) database management system (DBMS)
D) enterprise planning system (EPS)

Accepted Answer

A database management system (DBMS) is designed to create, process, and manage a collection of integrated records. It provides tools for organizing, querying, and updating data in a structured format. Other options such as decision support systems (DSS), knowledge management systems (KMS), and enterprise planning systems (EPS) serve different functions and are not specifically designed for managing data in a structured way.

Question 19

Special data that describe the data contained in a database are called ________.
A) open matrices
B) primary data
C) metadata
D) closed matrices

Accepted Answer

Metadata refers to data that describe other data, such as the structure, organization, resources, and usage of a database. It provides important information that allows users and systems to effectively manage and manipulate the data in a database. Open and closed matrices do not have a clear definition in the context of databases, while primary data refers to the original data that is being collected or analyzed.

Question 20

In a database,bytes are grouped into ________.
A) tables
B) columns
C) rows
D) records

Accepted Answer

Bytes in a database are not usually grouped into tables, rows, or records. Instead, they are typically organized into columns, which represent individual data fields within a table.

Quiz 5: Database Processing

Which of the following is a DBMS product from Microsoft?

Which of the following best describes a byte in a database?

In a database,columns are also called ________.

A ________ is a self-describing collection of integrated records.

The DBMS provides applications for processing operations such as ________.

The purpose of a database is to ________.

In a database,a ________ is a column or group of columns that identifies a unique row in a table.

In a database,a group of similar rows is called a ________.

Databases that carry their data in the form of tables and represent relationships using foreign keys are called ________ databases.

In a database,rows are also called ________.

In a database,columns that are keys of a different table than the one in which they reside are known as ________ keys.

In a database,a table is formally referred to as a ________.

Which of the following best describes the metadata in a database?

In a database,the collection of data for all columns is called a ________.

In a database,a table,which is a group of similar rows,is also called a ________.

Which of the following is a function of the DBMS?

________ is a popular enterprise DBMS product from IBM.

A(n) ________ is a program that is used to create,process,and administer a collection of self-describing integrated records.

Special data that describe the data contained in a database are called ________.

In a database,bytes are grouped into ________.