Question 1

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 digitE) B) and D)
F) A) and B)

Question 2

What is a data type? List the data types commonly found in a database.

Accepted Answer

Student responses will vary, but should ...

Question 3

Explain a multidimensional database, its applications, and its main advantage.

Accepted Answer

Student responses will vary, but should ...

Question 4

What is a more user-friendly interface some users use instead of interacting directly with a DBMS?

Accepted Answer

A)  front end
B)  user environment
C)  home page
D)  data fileE) B) and C)
F) None of the above

Question 5

Which of the following statements is NOT true about the database approach?

Accepted Answer

A)  The database approach allows nontechnical users to access and maintain data.
B)  Databases require more memory, storage, and processing power than file processing systems.
C)  A disadvantage to the database approach is isolated data.
D)  The database approach increases the data's integrity.E) A) and B)
F) B) and C)

Question 6

ASP.NET is a web application framework that provides the tools necessary for the creation of dynamic websites.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following statements best describes a form?

Accepted Answer

A)  a window on the screen that provides areas for entering or modifying data in a database
B)  a formatted, printable retrieval of specific data
C)  a screen that enables a database user to add or delete tables
D)  the opening screen in a DBMS in which the user logs in to achieve authorization to modify or retrieve dataE) A) and C)
F) All of the above

Question 8

Which of the following stores data in objects?

Accepted Answer

A)  ADB
B)  OTDB
C)  EDB
D)  OODBE) B) and C)
F) C) and D)

Question 9

In a database, the data ____________________ specifies the kind of data a field can contain and how the field is used.

Accepted Answer

The answer of In a database, the data ____________________ specifies...

Question 10

In the ASCII coding scheme, each byte represents a single ____________________, which can be a number, letter, blank space, punctuation mark, or other symbol.

Accepted Answer

The answer of In the ASCII coding scheme, each byte...

Question 11

The purpose of the ____________________ is to construct, or build, the new or modified system and then deliver it to the users.

Accepted Answer

implemen...

Question 12

Who was the inventor of the relational database model?

Accepted Answer

A)  E. L. Coff
B)  E. G. Cott
C)  E. F. Codd
D)  E. L. Codd​E) None of the above
F) B) and D)

Question 13

Which of the following statements about data types is FALSE?

Accepted Answer

A)  Yes/No fields can be used to create a field with True or False options.
B)  AutoNumber data types assign numbers automatically to each record.
C)  Text data types are used for lengthy memos.
D)  Object data types are used for photos, audio, or video.E) A) and C)
F) All of the above

Question 14

Many organizations use relational databases for payroll, accounts receivable, accounts payable, general ledger, inventory, order entry, invoicing, and other business-related functions.

Accepted Answer

A) True 
 B)False

Question 15

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)  acceptanceE) A) and D)
F) A) and B)

Question 16

Identify the letter of the choice that best matches the phrase or definition.
-While a user is working with the database, this resides in the memory of the computer.

Accepted Answer

A)  proof of concept
B)  unit test
C)  systems test
D)  integration test
E)  acceptance testF) usefulG) documentationH) characterI) recordJ) primary keyK) SQLL) flaggedM) inaccurateN) byteO) DBMSP) validationQ) data relationshipsR) queryingS) functionsT) integrityU) C) and I)
V) A) and L)

Question 17

Analysts often refer to the three ____'s when describing characteristics of Big Data.

Accepted Answer

A)  C
B)  G
C)  D
D)  VE) A) and B)
F) A) and C)

Question 18

You create a database that stores data in tables that consist of rows and columns. Each row has a primary key, and each column has a unique name. Which data model did you use?

Accepted Answer

A)  object-oriented
B)  object-relational
C)  relational
D)  multidimensionalE) A) and B)
F) A) and C)

Question 19

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

Accepted Answer

A)  form
B)  report
C)  change screen
D)  recovery screenE) B) and D)
F) A) and B)

Question 20

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 accessE) A) and D)
F) B) and C)

Exam 11: Building Solutions

In a database, the data ____________________ specifies the kind of data a field can contain and how the field is used.

Correct AnswerverifiedShow Answer

Analysts often refer to the three ____'s when describing characteristics of Big Data.

Correct AnswerverifiedShow Answer

Which of the following stores data in objects?

Correct AnswerverifiedShow Answer

Which of the following statements best describes a form?

Correct AnswerverifiedShow Answer

Who was the inventor of the relational database model?

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition. -While a user is working with the database, this resides in the memory of the computer.

Correct AnswerverifiedShow Answer

Which of the following statements about data types is FALSE?

Correct AnswerverifiedShow Answer

ASP.NET is a web application framework that provides the tools necessary for the creation of dynamic websites.

Correct AnswerverifiedShow Answer

Many organizations use relational databases for payroll, accounts receivable, accounts payable, general ledger, inventory, order entry, invoicing, and other business-related functions.

Correct AnswerverifiedShow Answer

The purpose of the ____________________ is to construct, or build, the new or modified system and then deliver it to the users.

Correct Answerverified​implemen...View AnswerShow Answer

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?

Correct AnswerverifiedShow Answer

In the ASCII coding scheme, each byte represents a single ____________________, which can be a number, letter, blank space, punctuation mark, or other symbol.

Correct AnswerverifiedShow Answer

You create a database that stores data in tables that consist of rows and columns. Each row has a primary key, and each column has a unique name. Which data model did you use?

Correct AnswerverifiedShow Answer

What is a data type? List the data types commonly found in a database.

Correct AnswerverifiedStudent responses will vary, but should ...View AnswerShow Answer

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?

Correct AnswerverifiedShow Answer

Explain a multidimensional database, its applications, and its main advantage.

Correct AnswerverifiedStudent responses will vary, but should ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

What is a more user-friendly interface some users use instead of interacting directly with a DBMS?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following statements is NOT true about the database approach?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

implemen...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Student responses will vary, but should ...
View Answer

Correct Answer
verified

Correct Answer
verified
Student responses will vary, but should ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified