Question 1

Which of the following is NOT considered a part of file maintenance?

Accepted Answer

A) adding a record to a database 
B) modifying data in a record 
C) the creation of a new database 
D) deleting records from a database 
A) adding a record to a database 
B) modifying data in a record 
C) the creation of a new database 
D) deleting records from a database

Question 2

Big Data refers to large-scale data sets that require advanced technologies.

Accepted Answer

A) True 
 B)False

Question 3

Like a form, a report generator is used to maintain and retrieve data.

Accepted Answer

A) True 
 B)False

Question 4

Data integrity is important because computers and people use information to make decisions and take actions.

Accepted Answer

A) True 
 B)False

Question 5

An application generator is a program that creates source code or machine code from a specification of the required functionality.

Accepted Answer

A) True 
 B)False

Question 6

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?

Accepted Answer

A) group 
B) numeric 
C) range 
D) integer 
A) group 
B) numeric 
C) range 
D) integer

Question 7

Which of the following is NOT a way that a DBMS deals with deleting records from a database?

Accepted Answer

A) remove the record from the file immediately 
B) records cannot be deleted from a DBMS 
C) flags the record so that the DBMS will not process it again 
D) running a program to remove records that have been marked as deleted 
A) remove the record from the file immediately 
B) records cannot be deleted from a DBMS 
C) flags the record so that the DBMS will not process it again 
D) running a program to remove records that have been marked as deleted

Question 8

Which of the following is true about the database approach?

Accepted Answer

A) Data in a database is less vulnerable than data in file processing systems. 
B) Unauthorized users are unable under any circumstances to gain access to a single database file that contains personal and confidential data. 
C) Business and home users often work with databases because of their numerous advantages. 
D) A database is never more complex than a file processing system. 
A) Data in a database is less vulnerable than data in file processing systems. 
B) Unauthorized users are unable under any circumstances to gain access to a single database file that contains personal and confidential data. 
C) Business and home users often work with databases because of their numerous advantages. 
D) A database is never more complex than a file processing system.

Question 9

Identify the letter of the choice that best matches the phrase or definition.
-Eight bits grouped together in a unit comprise this.

Accepted Answer

A) proof of concept 
B) unit test 
C) systems test 
D) integration test 
E) acceptance test
F)useful
G)documentation
H)character
I)record
J)primary key
K)SQL
L)flagged
M)inaccurate
N)byte
O)DBMS
P)validation
Q)data relationships
R)querying
S)functions
T)integrity 
A) proof of concept 
B) unit test 
C) systems test 
D) integration test 
E) acceptance test
F)useful
G)documentation
H)character
I)record
J)primary key
K)SQL
L)flagged
M)inaccurate
N)byte
O)DBMS
P)validation
Q)data relationships
R)querying
S)functions
T)integrity

Question 10

A web database for an organization usually resides on a(n) ____________________.

Accepted Answer

The answer of A web database for an organization usually...

Question 11

Which of the following does a back end interact with?

Accepted Answer

A) DBNS 
B) DBMS 
C) BDNS 
D) BDMS 
A) DBNS 
B) DBMS 
C) BDNS 
D) BDMS

Question 12

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

Accepted Answer

A) alphabetic 
B) numeric 
C) range 
D) consistency 
A) alphabetic 
B) numeric 
C) range 
D) consistency

Question 13

Which term describes a huge database that stores and manages data required to analyze historical and current transactions?

Accepted Answer

A) data mine 
B) data archive 
C) data market 
D) data warehouse 
A) data mine 
B) data archive 
C) data market 
D) data warehouse

Question 14

Identify the letter of the choice that best matches the phrase or definition.
-Verifies that an application works with other applications.

Accepted Answer

A) proof of concept 
B) unit test 
C) systems test 
D) integration test 
E) acceptance test
F)useful
G)documentation
H)character
I)record
J)primary key
K)SQL
L)flagged
M)inaccurate
N)byte
O)DBMS
P)validation
Q)data relationships
R)querying
S)functions
T)integrity 
A) proof of concept 
B) unit test 
C) systems test 
D) integration test 
E) acceptance test
F)useful
G)documentation
H)character
I)record
J)primary key
K)SQL
L)flagged
M)inaccurate
N)byte
O)DBMS
P)validation
Q)data relationships
R)querying
S)functions
T)integrity

Question 15

In a forward recovery, the DBMS uses the log to undo any changes made to a database during a certain period, such as an hour.

Accepted Answer

A) True 
 B)False

Question 16

A compiler is a separate program that converts the entire source program into machine language before executing it.

Accepted Answer

A) True 
 B)False

Question 17

The data in a database is independent of programs that access that data.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is a query language that allows users to manage, update, and retrieve data?

Accepted Answer

A) XML 
B) DBMS 
C) SQL 
D) QBE 
A) XML 
B) DBMS 
C) SQL 
D) QBE

Question 19

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

Accepted Answer

A) back end 
B) RDBMS 
C) GUI 
D) collaborative database 
A) back end 
B) RDBMS 
C) GUI 
D) collaborative database

Question 20

You are creating a database for your computer club. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?

Accepted Answer

A) make the field a maximum of size characters 
B) make it the default value 
C) use AutoComplete 
D) add a drop-down box 
A) make the field a maximum of size characters 
B) make it the default value 
C) use AutoComplete 
D) add a drop-down box

Which of the following is NOT considered a part of file maintenance?

Big Data refers to large-scale data sets that require advanced technologies.

Like a form, a report generator is used to maintain and retrieve data.

Data integrity is important because computers and people use information to make decisions and take actions.

An application generator is a program that creates source code or machine code from a specification of the required functionality.

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?

Which of the following is NOT a way that a DBMS deals with deleting records from a database?

Which of the following is true about the database approach?

Identify the letter of the choice that best matches the phrase or definition. -Eight bits grouped together in a unit comprise this.

A web database for an organization usually resides on a(n) ____________________.

Which of the following does a back end interact with?

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 term describes a huge database that stores and manages data required to analyze historical and current transactions?

Identify the letter of the choice that best matches the phrase or definition. -Verifies that an application works with other applications.

In a forward recovery, the DBMS uses the log to undo any changes made to a database during a certain period, such as an hour.

A compiler is a separate program that converts the entire source program into machine language before executing it.

The data in a database is independent of programs that access that data.

Which of the following is a query language that allows users to manage, update, and retrieve data?

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

You are creating a database for your computer club. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?

Introducing Todays Technologies

Connecting and Communicating Online

Computers and Mobile Devices

Programs and Apps

Digital Security, Ethics, and Privacy

Computing Components

Input and Output

Digital Storage

Operating Systems

Communicating Digital Content

Working in the Enterprise

Filters

Exam 11: Building Solutions

Which of the following is NOT considered a part of file maintenance?

Big Data refers to large-scale data sets that require advanced technologies.

Like a form, a report generator is used to maintain and retrieve data.

Data integrity is important because computers and people use information to make decisions and take actions.

An application generator is a program that creates source code or machine code from a specification of the required functionality.

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?

Which of the following is NOT a way that a DBMS deals with deleting records from a database?

Which of the following is true about the database approach?

Identify the letter of the choice that best matches the phrase or definition. -Eight bits grouped together in a unit comprise this.

A web database for an organization usually resides on a(n) ____________________.

Which of the following does a back end interact with?

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 term describes a huge database that stores and manages data required to analyze historical and current transactions?

Identify the letter of the choice that best matches the phrase or definition. -Verifies that an application works with other applications.

In a forward recovery, the DBMS uses the log to undo any changes made to a database during a certain period, such as an hour.

A compiler is a separate program that converts the entire source program into machine language before executing it.

The data in a database is independent of programs that access that data.

Which of the following is a query language that allows users to manage, update, and retrieve data?

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

You are creating a database for your computer club. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?

Introducing Todays Technologies

Connecting and Communicating Online

Computers and Mobile Devices

Programs and Apps

Digital Security, Ethics, and Privacy

Computing Components

Input and Output

Digital Storage

Operating Systems

Communicating Digital Content

Working in the Enterprise

Filters