Question 1

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

Accepted Answer

A)  ​ERP 
B)  SQL​ 
C)  ​OLAP 
D)  ​DBMS 
A)  ​ERP 
B)  SQL​ 
C)  ​OLAP 
D)  ​DBMS

Question 2

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 3

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 4

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

Accepted Answer

A)  ​Real 
B)  SELECT​ 
C)  ​BLOB 
D)  Memo​ 
A)  ​Real 
B)  SELECT​ 
C)  ​BLOB 
D)  Memo​

Question 5

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, NoSQL 
A)  ​single-level, multi-level 
B)  ​multi-level, single-level 
C)  structured, unstructured​ 
D)  ​SQL, NoSQL

Question 6

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 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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)  ​parameter 
A)  ​field format 
B)  ​primary key 
C)  ​database structure 
D)  ​parameter

Question 10

Relational databases store unstructured data.​

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

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

The goal of ______________ is to minimize data redundancy.​

Accepted Answer

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

Question 14

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

Accepted Answer

A)  ​data archive 
B)  executive dashboard​ 
C)  ​OLAP 
D)  ​ERD 
A)  ​data archive 
B)  executive dashboard​ 
C)  ​OLAP 
D)  ​ERD

Question 15

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 16

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 makers 
A)  ​Collect, store, and view data 
B)  ​Update and find data 
C)  ​organizing and distributing data 
D)  ​providing an executive dashboard for decision makers

Question 17

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)  ​UPDATE 
A)  ​MERGE 
B)  ​JOIN 
C)  ​SELECT 
D)  ​UPDATE

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

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

Accepted Answer

A) True 
 B)False

Question 20

​Which SQL keyword is used to search for records?

Accepted Answer

A)  ​FIND 
B)  ​SEARCH 
C)  ​SELECT 
D)  ​UPDATE 
A)  ​FIND 
B)  ​SEARCH 
C)  ​SELECT 
D)  ​UPDATE

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

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

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

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

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

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.

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

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

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.

Relational databases store unstructured data.

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

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

The goal of ______________ is to minimize data redundancy.

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

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

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

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

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

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

Which SQL keyword is used to search for records?

Digital Content

Digital Devices

Networks

The Web

Social Media

Software

Digital Security

The Ict Industry

Information Systems

Programming

Step-By-Step Programming With Python

Filters

Exam 10: Databases

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

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

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

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

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

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.​

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

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

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.​

Relational databases store unstructured data.​

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

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

The goal of ______________ is to minimize data redundancy.​

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

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

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

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

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

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

​Which SQL keyword is used to search for records?

Digital Content

Digital Devices

Networks

The Web

Social Media

Software

Digital Security

The Ict Industry

Information Systems

Programming

Step-By-Step Programming With Python

Filters

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

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

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

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

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

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.

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

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

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.

Relational databases store unstructured data.

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

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

The goal of ______________ is to minimize data redundancy.

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

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

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

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

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

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

Which SQL keyword is used to search for records?