Question 1

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

Accepted Answer

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

Question 2

It is not possible to extract analytical data from operational databases.​

Accepted Answer

A) True 
 B)False

Question 3

A key element of __________ databases is their ability to support OLAP queries that make it possible to combine data, drill down to specifics, or slice and dice the data to view it from different perspectives.​

Accepted Answer

The answer of  A key element of __________ databases is...

Question 4

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 5

​In a database, a(n) __________ contains the smallest unit of meaningful information

Accepted Answer

A)  ​record 
B)  field​ 
C)  ​table 
D)  ​model 
A)  ​record 
B)  field​ 
C)  ​table 
D)  ​model

Question 6

In a key-value database, each data item has a key that is a unique identifier similar to a relational database key​

Accepted Answer

A) True 
 B)False

Question 7

Which database data type is a collection of binary data stored in a single field of a database?​

Accepted Answer

A)  ​Memo 
B)  ​Integer 
C)  ​BLOB 
D)  ​Logical 
A)  ​Memo 
B)  ​Integer 
C)  ​BLOB 
D)  ​Logical

Question 8

SQL is banned from the NoSQL technology collection.​

Accepted Answer

A) True 
 B)False

Question 9

__________ are the most commonly used database clients.​​

Accepted Answer

A)  ​Local software 
B)  ​Apps 
C)  ​Browsers 
D)  ​none of the above 
A)  ​Local software 
B)  ​Apps 
C)  ​Browsers 
D)  ​none of the above

Question 10

FileMaker Pro and Microsoft Access are DBMSs.​

Accepted Answer

A) True 
 B)False

Question 11

A(n) __________ is the column of data in a database that is used as the basis for rearranging the data.​

Accepted Answer

A)  ​primary key 
B)  ​sort key 
C)  ​data type 
D)  ​key-value 
A)  ​primary key 
B)  ​sort key 
C)  ​data type 
D)  ​key-value

Question 12

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 13

Which database tool is best for simple flat files that involve calculations?​

Accepted Answer

A)  ​Database software 
B)  Spreadsheet software​ 
C)  ​Word processing software 
D)  ​DBMS 
A)  ​Database software 
B)  Spreadsheet software​ 
C)  ​Word processing software 
D)  ​DBMS

Question 14

The goal of ______________ is to minimize data redundancy.​

Accepted Answer

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

Question 15

SQL ____________ are detailed specifications for a command.​

Accepted Answer

The answer of  SQL ____________ are detailed specifications for a...

Question 16

An emerging computing platform that is likely to drive innovation and disruption through the next decade called __________ has massive scale, not only in cloud-based hardware technology, but also in the vast amount of data that will be generated, consumed, and analyzed.​

Accepted Answer

A)  ​The 3rd platform 
B)  ​NoSQL 
C)  ​SQL 
D)  ​BLOB 
A)  ​The 3rd platform 
B)  ​NoSQL 
C)  ​SQL 
D)  ​BLOB

Question 17

In a __________ database, processing logic for the query is performed on the device that holds each database shard and if necessary, results are consolidated by the DBMS.​

Accepted Answer

A)  ​SQL 
B)  ​NoSQL 
C)  ​relational 
D)  ​OLAP 
A)  ​SQL 
B)  ​NoSQL 
C)  ​relational 
D)  ​OLAP

Question 18

The process of dividing a database into distributed subsets is called ________.​

Accepted Answer

The answer of  The process of dividing a database into...

Question 19

A(n) ___________ file uses a uniform format to store data for each person or thing in the file.​

Accepted Answer

The answer of  A(n) ___________ file uses a uniform format...

Question 20

Dedicated enterprise database applications may allow cosmetic changes, but they do not encourage modifications of core data structures.​

Accepted Answer

A) True 
 B)False

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

It is not possible to extract analytical data from operational databases.

A key element of __________ databases is their ability to support OLAP queries that make it possible to combine data, drill down to specifics, or slice and dice the data to view it from different perspectives.

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

In a database, a(n) __________ contains the smallest unit of meaningful information

In a key-value database, each data item has a key that is a unique identifier similar to a relational database key

Which database data type is a collection of binary data stored in a single field of a database?

SQL is banned from the NoSQL technology collection.

__________ are the most commonly used database clients.

FileMaker Pro and Microsoft Access are DBMSs.

A(n) __________ is the column of data in a database that is used as the basis for rearranging the data.

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

Which database tool is best for simple flat files that involve calculations?

The goal of ______________ is to minimize data redundancy.

SQL ____________ are detailed specifications for a command.

An emerging computing platform that is likely to drive innovation and disruption through the next decade called __________ has massive scale, not only in cloud-based hardware technology, but also in the vast amount of data that will be generated, consumed, and analyzed.

In a __________ database, processing logic for the query is performed on the device that holds each database shard and if necessary, results are consolidated by the DBMS.

The process of dividing a database into distributed subsets is called ________.

A(n) ___________ file uses a uniform format to store data for each person or thing in the file.

Dedicated enterprise database applications may allow cosmetic changes, but they do not encourage modifications of core data structures.

Digital Content

Digital Devices

Networks Network Basics

The Web Web Basics Browsers

Social Media

Software Software Basics

Digital Security

The Ict Industry

Information Systems

Programming

Programming

Filters

Exam 10: Databases Database Basics

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

It is not possible to extract analytical data from operational databases.​

A key element of __________ databases is their ability to support OLAP queries that make it possible to combine data, drill down to specifics, or slice and dice the data to view it from different perspectives.​

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

​In a database, a(n) __________ contains the smallest unit of meaningful information

In a key-value database, each data item has a key that is a unique identifier similar to a relational database key​

Which database data type is a collection of binary data stored in a single field of a database?​

SQL is banned from the NoSQL technology collection.​

__________ are the most commonly used database clients.​​

FileMaker Pro and Microsoft Access are DBMSs.​

A(n) __________ is the column of data in a database that is used as the basis for rearranging the data.​

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

Which database tool is best for simple flat files that involve calculations?​

The goal of ______________ is to minimize data redundancy.​

SQL ____________ are detailed specifications for a command.​

An emerging computing platform that is likely to drive innovation and disruption through the next decade called __________ has massive scale, not only in cloud-based hardware technology, but also in the vast amount of data that will be generated, consumed, and analyzed.​

In a __________ database, processing logic for the query is performed on the device that holds each database shard and if necessary, results are consolidated by the DBMS.​

The process of dividing a database into distributed subsets is called ________.​

A(n) ___________ file uses a uniform format to store data for each person or thing in the file.​

Dedicated enterprise database applications may allow cosmetic changes, but they do not encourage modifications of core data structures.​

Digital Content

Digital Devices

Networks Network Basics

The Web Web Basics Browsers

Social Media

Software Software Basics

Digital Security

The Ict Industry

Information Systems

Programming

Programming

Filters

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

It is not possible to extract analytical data from operational databases.

A key element of __________ databases is their ability to support OLAP queries that make it possible to combine data, drill down to specifics, or slice and dice the data to view it from different perspectives.

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

In a database, a(n) __________ contains the smallest unit of meaningful information

In a key-value database, each data item has a key that is a unique identifier similar to a relational database key

Which database data type is a collection of binary data stored in a single field of a database?

SQL is banned from the NoSQL technology collection.

__________ are the most commonly used database clients.

FileMaker Pro and Microsoft Access are DBMSs.

A(n) __________ is the column of data in a database that is used as the basis for rearranging the data.

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

Which database tool is best for simple flat files that involve calculations?

The goal of ______________ is to minimize data redundancy.

SQL ____________ are detailed specifications for a command.

An emerging computing platform that is likely to drive innovation and disruption through the next decade called __________ has massive scale, not only in cloud-based hardware technology, but also in the vast amount of data that will be generated, consumed, and analyzed.

In a __________ database, processing logic for the query is performed on the device that holds each database shard and if necessary, results are consolidated by the DBMS.

The process of dividing a database into distributed subsets is called ________.

A(n) ___________ file uses a uniform format to store data for each person or thing in the file.

Dedicated enterprise database applications may allow cosmetic changes, but they do not encourage modifications of core data structures.