Question 1

Which of the following is a window on the screen that provides areas for entering or modifying data in a database?
A)form
B)report
C)change screen
D)recovery screen

Accepted Answer

A form is a graphical user interface (GUI) element that allows users to enter or modify data in a database. A form typically contains fields that the user can fill in with data, buttons to submit or cancel the form, and other elements to enhance the user experience. A report is a window that displays data from a database, but it does not allow the user to modify the data. A change screen and a recovery screen are not common terms in database technology.

Question 2

Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?
A)check digit
B)index
C)insertion ordinal
D)integer

Accepted Answer

A check digit is a number appended to a primary key field to ensure its accuracy and validity. It is calculated based on the other digits in the field using a predetermined algorithm. This helps prevent errors and inconsistencies in the data. Indexes, insertion ordinals, and integers may be used in primary keys for other purposes, but not specifically to ensure data accuracy.

Question 3

What is the process of comparing data with a set of rules or values to determine if the data meets certain criteria?
A)concatenation
B)validation
C)digit checking
D)integration

Accepted Answer

The process being described is validation, which involves comparing data to a set of rules or values to determine if it meets certain criteria. Concatenation refers to combining two or more strings or values into a single entity. Digit checking typically involves verifying that numeric data is entered correctly, such as ensuring that credit card numbers are valid. Integration involves combining different systems or applications to work together seamlessly. None of these options describe the process of comparing data to a set of rules or criteria. Therefore, the correct answer is B) validation.

Question 4

Which of the following refers to the procedures that keep data current?
A)file maintenance
B)authentication integrity
C)data validation
D)information checking

Accepted Answer

File maintenance refers to the procedures that keep data current by updating, adding, or deleting information. Authentication integrity refers to the process of ensuring the identity of the user or entity accessing the data. Data validation refers to the process of checking data for accuracy and completeness. Information checking is a vague term and does not specifically refer to procedures that keep data current.

Question 5

Which of the following kind of checks is a validity check on data, which determines whether a number is within a specified group of numbers?
A)group
B)numeric
C)range
D)integer

Accepted Answer

A range check determines whether a number is within a specified group or range of numbers, making option C the correct choice. Group checks (option A) refer to whether the entered data belongs to a particular category or group, numeric checks (option B) refer to whether the entered data is a number or not and integer checks (option D) refer to whether the entered data is a whole number or not.

Question 6

A DBMS uses which of the following to perform validation checks?
A)data server
B)data mart
C)data warehouse
D)data dictionary

Accepted Answer

A data dictionary is a centralized repository of information about data such as its meaning, relationships to other data, origin, usage, and format. It is used by a DBMS to enforce validation rules and referential integrity constraints. A data server, data mart, or data warehouse are not specifically designed for performing validation checks in a DBMS.

Question 7

An application that supports a front-end program sometimes is called which of the following?
A)back end
B)RDBMS
C)GUI
D)collaborative database

Accepted Answer

The back end refers to the server-side of an application and includes the database and server that support the front-end program.

Question 8

Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?
A)information confirmation
B)integration
C)validity check
D)integrity valuation

Accepted Answer

Many database programs perform validity checks to analyze entered data to help ensure that it is correct. A validity check is a type of computer check that verifies that the data entered by a user is reasonable and acceptable. It ensures that the entered data is within a certain range of acceptable values or conforms to a specific format, thereby improving the quality and accuracy of the data.

Question 9

-Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?
A)QBA
B)SQL
C)QBE
D)schema

Accepted Answer

QBE, or Query By Example, is a feature in many DBMSs that provides a graphical user interface to help users retrieve data by allowing them to construct queries visually.

Question 10

-In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?
A)field
B)member
C)record
D)identifier

Accepted Answer

A field is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses in a database.

Question 11

-Which of the following is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard drive or on cloud storage?
A)validator
B)rubric
C)set
D)file

Accepted Answer

A file is a collection of related records stored on storage media like a hard drive or cloud storage.

Question 12

Which of the following is a request for specific data from a database?
A)query
B)index
C)ask
D)inquiry

Accepted Answer

A query is a request for specific data from a database. It is used to retrieve data based on certain criteria or conditions. An index is a data structure used to optimize database queries, but it is not a request for specific data. "Ask" and "inquiry" are not specific database-related terms.

Question 13

Which of the following kind of checks is a validity check performed on data, which ensures users enter only numeric data into a field?
A)range
B)numeric
C)completeness
D)consistency

Accepted Answer

A numeric check ensures that only numerical data is entered into a field. Range checks verify whether the data entered falls within a specific range. Completeness checks verify if all required fields are filled, while consistency checks ensure that the data entered follows a set of specific rules.

Question 14

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?
A)database
B)server
C)spreadsheet
D)webbase

Accepted Answer

A database is specifically designed to organize and manage large amounts of data in a way that allows efficient access, retrieval, and use of that data. Servers and web-based platforms can host databases, but they are not the same thing as a database themselves. Spreadsheets are better suited for small to medium amounts of data and are not designed for efficient retrieval and manipulation of large amounts of data.

Question 15

Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?
A)report
B)query
C)specification
D)inquiry

Accepted Answer

The language described in the question is a query language, which allows users to specify the data they want to retrieve or manipulate. A report language is used to create formatted reports, while a specification language is used to define standards or requirements. An inquiry language is a type of query language, but it typically refers to a specific language used in a particular system or database. Therefore, the best choice is B (query).

Question 16

Which of the following kind of checks is a validity check performed on data, which ensures users enter only alphabetic data into a field?
A)alphabetic
B)numeric
C)range
D)consistency

Accepted Answer

A validity check is performed to ensure that the data entered into a field is valid according to certain criteria. In this case, the criteria is that the data should only contain alphabetic characters. Therefore, the best choice is option A, alphabetic.

Question 17

Which of the following kinds of values is the one that a DBMS initially displays in a field?
A)query
B)start
C)initial
D)default

Accepted Answer

The default value is the one that a DBMS initially displays in a field. This value is set by the database designer and can be overwritten by the user if needed.

Question 18

Which of the following identifies the quality of data in a database?
A)file resolution
B)authenticated access
C)information dimensionality
D)data integrity

Accepted Answer

Data integrity refers to the accuracy, completeness, and consistency of data stored in a database. It is important for ensuring the quality of the data and minimizing errors or inconsistencies in the system. File resolution, authenticated access, and information dimensionality are not directly related to the quality of data in a database.

Question 19

Which of the following does a back end interact with?
A)DBNS
B)DBMS
C)BDNS
D)BDMS

Accepted Answer

Back end typically interacts with a DBMS (Database Management System) to manage and store data. DBNS and BDNS are not standard programming terms, and BDMS does not exist as a commonly used system.

Question 20

Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?
A)back end
B)RDBMS
C)SQL
D)front end

Accepted Answer

Front end refers to the user interface of a software application, which is designed to provide users with an easy-to-use and intuitive interface. A front end interacts with the user and communicates with a back end, which contains the application's logic and database. In contrast, a DBMS is a software system designed primarily for managing and querying large databases and generally lacks a user-friendly interface. Therefore, a front end is likely to be a more user-friendly program with which users interact.

Quiz 11: Building Solutions

Which of the following is a window on the screen that provides areas for entering or modifying data in a database?

Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?

What is the process of comparing data with a set of rules or values to determine if the data meets certain criteria?

Which of the following refers to the procedures that keep data current?

Which of the following kind of checks is a validity check on data, which determines whether a number is within a specified group of numbers?

A DBMS uses which of the following to perform validation checks?

An application that supports a front-end program sometimes is called which of the following?

Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?

-Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

-In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

-Which of the following is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard drive or on cloud storage?

Which of the following is a request for specific data from a database?

Which of the following kind of checks is a validity check performed on data, which ensures users enter only numeric data into a field?

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?

Which of the following kind of checks is a validity check performed on data, which ensures users enter only alphabetic data into a field?

Which of the following kinds of values is the one that a DBMS initially displays in a field?

Which of the following identifies the quality of data in a database?

Which of the following does a back end interact with?

Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?