Question 1

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 2

Most spreadsheet software also includes basic data management features.​

Accepted Answer

A) True 
 B)False

Question 3

SQL ____________ are detailed specifications for a command.​

Accepted Answer

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

Question 4

Exploits that use malicious SQL statements to gain unauthorized access to a database are called SQL _____________.​

Accepted Answer

The answer of Exploits that use malicious SQL statements to...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

A process called ____________ helps database designers create a database structure that minimizes storage space and increases processing efficiency.

Accepted Answer

The answer of A process called ____________ helps database designers...

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

A(n) _____________ is a specification that the database designer sets up to filter data entered into a particular field.​

Accepted Answer

A)  ​database structure 
B)  ​computed field 
C)  ​field format 
D)  ​field validation rule 
A)  ​database structure 
B)  ​computed field 
C)  ​field format 
D)  ​field validation rule

Question 9

SQL works behind the scenes as an intermediary between the database client software provided to users and the database itself.​

Accepted Answer

A) True 
 B)False

Question 10

Unlike a sort order, an index has no bearing on the physical sequence of records on a storage device.​

Accepted Answer

A) True 
 B)False

Question 11

A computed ___________ is a calculation that a DBMS performs, similar to the way a spreadsheet computes a formula.​​

Accepted Answer

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

Question 12

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 13

____________ scaling (or autoscaling) ensures acceptable database throughput by scaling out as necessary to handle peak loads.​

Accepted Answer

The answer of ____________ scaling (or autoscaling) ensures acceptable database...

Question 14

FileMaker Pro and Microsoft Access are DBMSs.​

Accepted Answer

A) True 
 B)False

Question 15

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

A database ____________ contains a list of keys, and each key provides a pointer to the record that contains the rest of the fields related to that key.​

Accepted Answer

The answer of A database ____________ contains a list of...

Question 17

In SQL terminology, creating a relationship between tables is referred to as _______ tables.​

Accepted Answer

The answer of In SQL terminology, creating a relationship between...

Question 18

A(n) _________ database is used to collect data that will be used for spotting trends that offer insights for tactical and strategic business decisions.​

Accepted Answer

A)  ​relational 
B)  ​operational 
C)  ​analytical 
D)  ​non relational 
A)  ​relational 
B)  ​operational 
C)  ​analytical 
D)  ​non relational

Question 19

Dynamic scaling for database servers can be a challenge because the additional sharding has to be handled on the fly by the DBMS.​

Accepted Answer

A) True 
 B)False

Question 20

Access to databases is usually open to anyone within an organization or business.​

Accepted Answer

A) True 
 B)False

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.

Most spreadsheet software also includes basic data management features.

SQL ____________ are detailed specifications for a command.

Exploits that use malicious SQL statements to gain unauthorized access to a database are called SQL _____________.

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

A process called ____________ helps database designers create a database structure that minimizes storage space and increases processing efficiency.

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

A(n) _____________ is a specification that the database designer sets up to filter data entered into a particular field.

SQL works behind the scenes as an intermediary between the database client software provided to users and the database itself.

Unlike a sort order, an index has no bearing on the physical sequence of records on a storage device.

A computed ___________ is a calculation that a DBMS performs, similar to the way a spreadsheet computes a formula.

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

____________ scaling (or autoscaling) ensures acceptable database throughput by scaling out as necessary to handle peak loads.

FileMaker Pro and Microsoft Access are DBMSs.

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

A database ____________ contains a list of keys, and each key provides a pointer to the record that contains the rest of the fields related to that key.

In SQL terminology, creating a relationship between tables is referred to as _______ tables.

A(n) _________ database is used to collect data that will be used for spotting trends that offer insights for tactical and strategic business decisions.

Dynamic scaling for database servers can be a challenge because the additional sharding has to be handled on the fly by the DBMS.

Access to databases is usually open to anyone within an organization or business.

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

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

Most spreadsheet software also includes basic data management features.​

SQL ____________ are detailed specifications for a command.​

Exploits that use malicious SQL statements to gain unauthorized access to a database are called SQL _____________.​

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

A process called ____________ helps database designers create a database structure that minimizes storage space and increases processing efficiency.

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

A(n) _____________ is a specification that the database designer sets up to filter data entered into a particular field.​

SQL works behind the scenes as an intermediary between the database client software provided to users and the database itself.​

Unlike a sort order, an index has no bearing on the physical sequence of records on a storage device.​

A computed ___________ is a calculation that a DBMS performs, similar to the way a spreadsheet computes a formula.​​

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

____________ scaling (or autoscaling) ensures acceptable database throughput by scaling out as necessary to handle peak loads.​

FileMaker Pro and Microsoft Access are DBMSs.​

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

A database ____________ contains a list of keys, and each key provides a pointer to the record that contains the rest of the fields related to that key.​

In SQL terminology, creating a relationship between tables is referred to as _______ tables.​

A(n) _________ database is used to collect data that will be used for spotting trends that offer insights for tactical and strategic business decisions.​

Dynamic scaling for database servers can be a challenge because the additional sharding has to be handled on the fly by the DBMS.​

Access to databases is usually open to anyone within an organization or business.​

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

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.

Most spreadsheet software also includes basic data management features.

SQL ____________ are detailed specifications for a command.

Exploits that use malicious SQL statements to gain unauthorized access to a database are called SQL _____________.

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

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

A(n) _____________ is a specification that the database designer sets up to filter data entered into a particular field.

SQL works behind the scenes as an intermediary between the database client software provided to users and the database itself.

Unlike a sort order, an index has no bearing on the physical sequence of records on a storage device.

A computed ___________ is a calculation that a DBMS performs, similar to the way a spreadsheet computes a formula.

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

____________ scaling (or autoscaling) ensures acceptable database throughput by scaling out as necessary to handle peak loads.

FileMaker Pro and Microsoft Access are DBMSs.

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

A database ____________ contains a list of keys, and each key provides a pointer to the record that contains the rest of the fields related to that key.

In SQL terminology, creating a relationship between tables is referred to as _______ tables.

A(n) _________ database is used to collect data that will be used for spotting trends that offer insights for tactical and strategic business decisions.

Dynamic scaling for database servers can be a challenge because the additional sharding has to be handled on the fly by the DBMS.

Access to databases is usually open to anyone within an organization or business.