Question 1

With a(n) ____________________, only one location in the organization uses the new system - so that it can be tested.

Accepted Answer

The answer of With a(n) ____________________, only one location in...

Question 2

A checkout clerk with this level of privileges to the email addresses in a discount warehouse database could view the addresses but not change them. What is this level of privileges called?

Accepted Answer

A)  read-only 
B)  write-only 
C)  full-update 
D)  no access 
A)  read-only 
B)  write-only 
C)  full-update 
D)  no access

Question 3

The graphical interface, called a fourth-generation language, allows system developers to drag and drop objects to build programs and apps.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is a nonprocedural language that enables users and software developers to access data in a database?

Accepted Answer

A)  4SL 
B)  4DB 
C)  4GL 
D)  4AE 
A)  4SL 
B)  4DB 
C)  4GL 
D)  4AE

Question 5

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

Accepted Answer

A)  file maintenance 
B)  authentication integrity 
C)  data validation 
D)  information checking 
A)  file maintenance 
B)  authentication integrity 
C)  data validation 
D)  information checking

Question 6

SQL stands for which of the following?

Accepted Answer

A)  Structured Query Language 
B)  Statement Query Language 
C)  Standard Query Language 
D)  Student Query Language 
A)  Structured Query Language 
B)  Statement Query Language 
C)  Standard Query Language 
D)  Student Query Language

Question 7

A data mart defines how users view the organization of the data.

Accepted Answer

A) True 
 B)False

Question 8

If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Accepted Answer

A)  completeness 
B)  alphabetic 
C)  range 
D)  check digit 
A)  completeness 
B)  alphabetic 
C)  range 
D)  check digit

Question 9

Query by example uses a graphical user interface that assists users with retrieving data.

Accepted Answer

A) True 
 B)False

Question 10

What is a feature that has a graphical user interface to assist users with retrieving data?

Accepted Answer

A)  QBE 
B)  DBE 
C)  SQL 
D)  NoSQL 
A)  QBE 
B)  DBE 
C)  SQL 
D)  NoSQL

Question 11

Discuss the four conversion strategies.

Accepted Answer

Student responses will vary, but should

Question 12

Which of the following statements is FALSE about relational databases?

Accepted Answer

A)  A relationship is a link within the data. 
B)  The data is often is distributed. 
C)  Many organizations use relational databases for payroll, accounts receivable, order entry, and invoicing. 
D)  Applications best suited for relational databases are those whose data can be organized into a three-dimensional table. 
A)  A relationship is a link within the data. 
B)  The data is often is distributed. 
C)  Many organizations use relational databases for payroll, accounts receivable, order entry, and invoicing. 
D)  Applications best suited for relational databases are those whose data can be organized into a three-dimensional table.

Question 13

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?

Accepted Answer

A)  dynamic 
B)  interactive 
C)  collaborative 
D)  continuous 
A)  dynamic 
B)  interactive 
C)  collaborative 
D)  continuous

Question 14

Discuss at least four strengths of the database approach.

Accepted Answer

Student responses will vary, but should

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?

Accepted Answer

A)  report 
B)  query 
C)  specification 
D)  inquiry 
A)  report 
B)  query 
C)  specification 
D)  inquiry

Question 16

Which of the following refers to the different formats to represent or store data for use by humans and computer applications?

Accepted Answer

A)  accurate 
B)  verifiable 
C)  useful 
D)  variety 
A)  accurate 
B)  verifiable 
C)  useful 
D)  variety

Question 17

In your school's database, in which of the following is all of the information about a particular student stored?

Accepted Answer

A)  a field 
B)  a character 
C)  a record 
D)  a report 
A)  a field 
B)  a character 
C)  a record 
D)  a report

Question 18

Which of the following is an advantage of a multidimensional database?

Accepted Answer

A)  There is a common query language. 
B)  The content of all dimensions is the same regardless of the subject. 
C)  It can store data in two dimensions. 
D)  All multidimensional databases have a dimension of time. 
A)  There is a common query language. 
B)  The content of all dimensions is the same regardless of the subject. 
C)  It can store data in two dimensions. 
D)  All multidimensional databases have a dimension of time.

Question 19

A macro is a series of statements that instructs a program or app how to complete a task.

Accepted Answer

A) True 
 B)False

Question 20

What involves showing users exactly how they will use the new hardware and software in the system?

Accepted Answer

A)  converting 
B)  training 
C)  testing 
D)  acceptance 
A)  converting 
B)  training 
C)  testing 
D)  acceptance

With a(n) ____________________, only one location in the organization uses the new system - so that it can be tested.

A checkout clerk with this level of privileges to the email addresses in a discount warehouse database could view the addresses but not change them. What is this level of privileges called?

The graphical interface, called a fourth-generation language, allows system developers to drag and drop objects to build programs and apps.

Which of the following is a nonprocedural language that enables users and software developers to access data in a database?

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

SQL stands for which of the following?

A data mart defines how users view the organization of the data.

If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Query by example uses a graphical user interface that assists users with retrieving data.

What is a feature that has a graphical user interface to assist users with retrieving data?

Discuss the four conversion strategies.

Which of the following statements is FALSE about relational databases?

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?

Discuss at least four strengths of the database approach.

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 refers to the different formats to represent or store data for use by humans and computer applications?

In your school's database, in which of the following is all of the information about a particular student stored?

Which of the following is an advantage of a multidimensional database?

A macro is a series of statements that instructs a program or app how to complete a task.

What involves showing users exactly how they will use the new hardware and software in the system?

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

Focus on Web Development

Practice Test for Mindtap

Filters

Exam 11: Building Solutions

With a(n) ____________________, only one location in the organization uses the new system - so that it can be tested.

A checkout clerk with this level of privileges to the email addresses in a discount warehouse database could view the addresses but not change them. What is this level of privileges called?

The graphical interface, called a fourth-generation language, allows system developers to drag and drop objects to build programs and apps.

Which of the following is a nonprocedural language that enables users and software developers to access data in a database?

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

SQL stands for which of the following?

A data mart defines how users view the organization of the data.

If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Query by example uses a graphical user interface that assists users with retrieving data.

What is a feature that has a graphical user interface to assist users with retrieving data?

Discuss the four conversion strategies.

Which of the following statements is FALSE about relational databases?

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?

Discuss at least four strengths of the database approach.

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 refers to the different formats to represent or store data for use by humans and computer applications?

In your school's database, in which of the following is all of the information about a particular student stored?

Which of the following is an advantage of a multidimensional database?

A macro is a series of statements that instructs a program or app how to complete a task.

What involves showing users exactly how they will use the new hardware and software in the system?

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

Focus on Web Development

Practice Test for Mindtap

Filters