Question 1

A(n) ________________ is a software tool for specifying the content and format for a database report. ​

Accepted Answer

A)  ​report generator 
B)  database index​ 
C)  ​sort key 
D)  ​primary key 
A)  ​report generator 
B)  database index​ 
C)  ​sort key 
D)  ​primary key

Question 2

In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.​

Accepted Answer

A) True 
 B)False

Question 3

From a database user perspective, the data type determines the way data can be manipulated.​

Accepted Answer

A) True 
 B)False

Question 4

Data _________ refers to computer algorithms that analyze information to discover previously unknown and useful information, including relationships and patterns.​

Accepted Answer

A)  ​analytics 
B)  OLAP​ 
C)  mining​ 
D)  ​model 
A)  ​analytics 
B)  OLAP​ 
C)  mining​ 
D)  ​model

Question 5

Relational databases are organized according to a(n) _________, which is simply the blueprint for its structure.​

Accepted Answer

The answer of  Relational databases are organized according to a(n)...

Question 6

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 7

Modifications to the contents of a database field are made by using the SQL _________ command.​

Accepted Answer

The answer of  Modifications to the contents of a database...

Question 8

​The goal of normalization is to minimize data redundancy.

Accepted Answer

A) True 
 B)False

Question 9

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 10

A report ____________ contains the outline or general specifications for a report.​

Accepted Answer

The answer of  A report ____________ contains the outline or...

Question 11

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 12

SQL statements contain command words but do not contain data.​

Accepted Answer

A) True 
 B)False

Question 13

Spreadsheet software offers database capabilities for establishing relationships between different record types.​

Accepted Answer

A) True 
 B)False

Question 14

____________ 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 15

In a relational database, relationships are specified by joining common data stored in records from different tables.

Accepted Answer

A) True 
 B)False

Question 16

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 17

In a database, the template for a record is referred to as a record ______.​

Accepted Answer

The answer of  In a database, the template for a...

Question 18

A table's physical sort order is the order in which records are arranged on storage devices.​

Accepted Answer

A) True 
 B)False

Question 19

Relational databases store unstructured data.​

Accepted Answer

A) True 
 B)False

Question 20

In a(n) _________ database, a table is a sequence of records, similar to a flat file.​

Accepted Answer

The answer of  In a(n) _________ database, a table is...

A(n) ________________ is a software tool for specifying the content and format for a database report.

In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.

From a database user perspective, the data type determines the way data can be manipulated.

Data _________ refers to computer algorithms that analyze information to discover previously unknown and useful information, including relationships and patterns.

Relational databases are organized according to a(n) _________, which is simply the blueprint for its structure.

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

Modifications to the contents of a database field are made by using the SQL _________ command.

The goal of normalization is to minimize data redundancy.

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

A report ____________ contains the outline or general specifications for a report.

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.

SQL statements contain command words but do not contain data.

Spreadsheet software offers database capabilities for establishing relationships between different record types.

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

In a relational database, relationships are specified by joining common data stored in records from different tables.

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

In a database, the template for a record is referred to as a record ______.

A table's physical sort order is the order in which records are arranged on storage devices.

Relational databases store unstructured data.

In a(n) _________ database, a table is a sequence of records, similar to a flat file.

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

A(n) ________________ is a software tool for specifying the content and format for a database report. ​

In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.​

From a database user perspective, the data type determines the way data can be manipulated.​

Data _________ refers to computer algorithms that analyze information to discover previously unknown and useful information, including relationships and patterns.​

Relational databases are organized according to a(n) _________, which is simply the blueprint for its structure.​

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

Modifications to the contents of a database field are made by using the SQL _________ command.​

​The goal of normalization is to minimize data redundancy.

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

A report ____________ contains the outline or general specifications for a report.​

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

SQL statements contain command words but do not contain data.​

Spreadsheet software offers database capabilities for establishing relationships between different record types.​

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

In a relational database, relationships are specified by joining common data stored in records from different tables.

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

In a database, the template for a record is referred to as a record ______.​

A table's physical sort order is the order in which records are arranged on storage devices.​

Relational databases store unstructured data.​

In a(n) _________ database, a table is a sequence of records, similar to a flat file.​

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

A(n) ________________ is a software tool for specifying the content and format for a database report.

In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.

From a database user perspective, the data type determines the way data can be manipulated.

Data _________ refers to computer algorithms that analyze information to discover previously unknown and useful information, including relationships and patterns.

Relational databases are organized according to a(n) _________, which is simply the blueprint for its structure.

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

Modifications to the contents of a database field are made by using the SQL _________ command.

The goal of normalization is to minimize data redundancy.

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

A report ____________ contains the outline or general specifications for a report.

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.

SQL statements contain command words but do not contain data.

Spreadsheet software offers database capabilities for establishing relationships between different record types.

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

In a database, the template for a record is referred to as a record ______.

A table's physical sort order is the order in which records are arranged on storage devices.

Relational databases store unstructured data.

In a(n) _________ database, a table is a sequence of records, similar to a flat file.