Question 1

The relationship between record types can be depicted graphically with a(n)  _________.​

Accepted Answer

A)   ​data archive
B)   executive dashboard​
C)   ​OLAP
D)   ​ERDE) A) and D)
F) A) and C)

Question 2

A lookup routine validates an entry by checking data in an in-house or third-party database.​

Accepted Answer

A) True 
 B)False

Question 3

In its broadest definition, a ____________ is a collection of information.​

Accepted Answer

The answer of In its broadest definition, a ____________ is...

Question 4

​Which SQL keyword is used to search for records?

Accepted Answer

A)   ​FIND
B)   ​SEARCH
C)   ​SELECT
D)   ​UPDATEE) A) and B)
F) B) and D)

Question 5

A filing cabinet full of folders and papers would be classified as a structured file because every document has a unique structure.​

Accepted Answer

A) True 
 B)False

Question 6

A(n)  _________ sort uses one field, to arrange records. A(n)  _________ sort arranges information by more than one field.​

Accepted Answer

A)   ​single-level, multi-level
B)   ​multi-level, single-level
C)   structured, unstructured​
D)   ​SQL, NoSQLE) B) and D)
F) None of the above

Question 7

Which of the following is not one of the main activities associated with operational databases?​

Accepted Answer

A)   ​Collect, store, and view data
B)   ​Update and find data
C)   ​organizing and distributing data
D)   ​providing an executive dashboard for decision makersE) A) and B)
F) A) and C)

Question 8

The acronym ____________ refers to software that manages data stored in a database.​​

Accepted Answer

A)   ​ERP
B)   SQL​
C)   ​OLAP
D)   ​DBMSE) A) and B)
F) A) and D)

Question 9

The goal of ______________ is to minimize data redundancy.​

Accepted Answer

The answer of The goal of ______________ is to minimize...

Question 10

The term __________ is used to refer to a group of technologies for managing databases that do not adhere to the relational model and standard SQL query language.​

Accepted Answer

The answer of The term __________ is used to refer...

Question 11

The SQL ________ command allows you to temporarily join and simultaneously access the data in more than one table.​

Accepted Answer

A)   ​MERGE
B)   ​JOIN
C)   ​SELECT
D)   ​UPDATEE) A) and C)
F) C) and D)

Question 12

​An efficiently designed database uses computed fields whenever possible because they do not require manual data entry.

Accepted Answer

A) True 
 B)False

Question 13

A(n)  ____________ is a template that adds the correct formatting as data is entered. If someone attempts to enter data in the wrong format, the database can be set up to reject that entry or correct it.​

Accepted Answer

A)   ​field format
B)   ​primary key
C)   ​database structure
D)   ​parameterE) C) and D)
F) A) and B)

Question 14

Data independence is a term that refers to data and program modules being so tightly interrelated that they become difficult to modify.​

Accepted Answer

A) True 
 B)False

Question 15

Which of the following would not be considered a database data type?​​

Accepted Answer

A)   ​Real
B)   SELECT​
C)   ​BLOB
D)   Memo​E) B) and C)
F) A) and D)

Question 16

There are three core elements in a relational database: fields, ________, and relationships.​

Accepted Answer

The answer of There are three core elements in a...

Question 17

In the context of database security, intermediary servers allow users to directly access the database.​

Accepted Answer

A) True 
 B)False

Question 18

From a technical perspective, a data __________ specifies the way data is represented on physical storage media and in RAM.​

Accepted Answer

The answer of From a technical perspective, a data __________...

Question 19

Relational databases store unstructured data.​

Accepted Answer

A) True 
 B)False

Question 20

Ten terabytes offer enough storage capacity to hold the printed collection of the Library of Congress.​

Accepted Answer

A) True 
 B)False

Exam 10: Databases

The relationship between record types can be depicted graphically with a(n) _________.​

Correct AnswerverifiedShow Answer

The term __________ is used to refer to a group of technologies for managing databases that do not adhere to the relational model and standard SQL query language.​

Correct AnswerverifiedShow Answer

Which of the following would not be considered a database data type?​​

Correct AnswerverifiedShow Answer

The acronym ____________ refers to software that manages data stored in a database.​​

Correct AnswerverifiedShow Answer

​An efficiently designed database uses computed fields whenever possible because they do not require manual data entry.

Correct AnswerverifiedShow Answer

Which of the following is not one of the main activities associated with operational databases?​

Correct AnswerverifiedShow Answer

There are three core elements in a relational database: fields, ________, and relationships.​

Correct AnswerverifiedShow Answer

A lookup routine validates an entry by checking data in an in-house or third-party database.​

Correct AnswerverifiedShow Answer

From a technical perspective, a data __________ specifies the way data is represented on physical storage media and in RAM.​

Correct AnswerverifiedShow Answer

Data independence is a term that refers to data and program modules being so tightly interrelated that they become difficult to modify.​

Correct AnswerverifiedShow Answer

​Which SQL keyword is used to search for records?

Correct AnswerverifiedShow Answer

The SQL ________ command allows you to temporarily join and simultaneously access the data in more than one table.​

Correct AnswerverifiedShow Answer

In its broadest definition, a ____________ is a collection of information.​

Correct AnswerverifiedShow Answer

A(n) ____________ is a template that adds the correct formatting as data is entered. If someone attempts to enter data in the wrong format, the database can be set up to reject that entry or correct it.​

Correct AnswerverifiedShow Answer

A filing cabinet full of folders and papers would be classified as a structured file because every document has a unique structure.​

Correct AnswerverifiedShow Answer

Ten terabytes offer enough storage capacity to hold the printed collection of the Library of Congress.​

Correct AnswerverifiedShow Answer

Relational databases store unstructured data.​

Correct AnswerverifiedShow Answer

A(n) _________ sort uses one field, to arrange records. A(n) _________ sort arranges information by more than one field.​

Correct AnswerverifiedShow Answer

The goal of ______________ is to minimize data redundancy.​

Correct AnswerverifiedShow Answer

In the context of database security, intermediary servers allow users to directly access the database.​

Correct AnswerverifiedShow Answer

The relationship between record types can be depicted graphically with a(n) _________.

Correct Answer
verified

The term __________ is used to refer to a group of technologies for managing databases that do not adhere to the relational model and standard SQL query language.

Correct Answer
verified

Which of the following would not be considered a database data type?

Correct Answer
verified

The acronym ____________ refers to software that manages data stored in a database.

Correct Answer
verified

An efficiently designed database uses computed fields whenever possible because they do not require manual data entry.

Correct Answer
verified

Which of the following is not one of the main activities associated with operational databases?

Correct Answer
verified

There are three core elements in a relational database: fields, ________, and relationships.

Correct Answer
verified

A lookup routine validates an entry by checking data in an in-house or third-party database.

Correct Answer
verified

From a technical perspective, a data __________ specifies the way data is represented on physical storage media and in RAM.

Correct Answer
verified

Data independence is a term that refers to data and program modules being so tightly interrelated that they become difficult to modify.

Correct Answer
verified

Which SQL keyword is used to search for records?

Correct Answer
verified

The SQL ________ command allows you to temporarily join and simultaneously access the data in more than one table.

Correct Answer
verified

In its broadest definition, a ____________ is a collection of information.

Correct Answer
verified

A(n) ____________ is a template that adds the correct formatting as data is entered. If someone attempts to enter data in the wrong format, the database can be set up to reject that entry or correct it.

Correct Answer
verified

A filing cabinet full of folders and papers would be classified as a structured file because every document has a unique structure.

Correct Answer
verified

Ten terabytes offer enough storage capacity to hold the printed collection of the Library of Congress.

Correct Answer
verified

Relational databases store unstructured data.

Correct Answer
verified

A(n) _ sort uses one field, to arrange records. A(n) _ sort arranges information by more than one field.

Correct Answer
verified

The goal of ______________ is to minimize data redundancy.

Correct Answer
verified

In the context of database security, intermediary servers allow users to directly access the database.

Correct Answer
verified