Question 1

Which of the following is not a SQL keyword?​

Accepted Answer

A)  ​DELETE 
B)  ​REMOVE 
C)  ​CREATE 
D)  ​SELECT 
A)  ​DELETE 
B)  ​REMOVE 
C)  ​CREATE 
D)  ​SELECT B

Question 2

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

Accepted Answer

relational​

Question 3

A(n) __________ file consists of a single, two-dimensional table of data elements.​

Accepted Answer

flat​

Question 4

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 5

​The goal of normalization is to minimize data redundancy.

Accepted Answer

A) True 
 B)False

Question 6

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 7

A record that contains data is referred to as a record ________.​

Accepted Answer

A)  ​occurrence 
B)  type​ 
C)  ​template 
D)  file​ 
A)  ​occurrence 
B)  type​ 
C)  ​template 
D)  file​

Question 8

Which of the following is not considered to be type of database client?​

Accepted Answer

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

Question 9

A(n) _________ database is used to collect, modify, and maintain data on a daily basis.​

Accepted Answer

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

Question 10

A primary key is a ____________ that contains data unique to a record.​

Accepted Answer

The answer of A primary key is a ____________ that...

Question 11

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 12

The entire Internet contains about a zettabyte of data.​

Accepted Answer

A) True 
 B)False

Question 13

__________ is a file system developed in 2005 that handles millions of files distributed across multiple server nodes.​

Accepted Answer

The answer of __________ is a file system developed in...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Modern database tools support ________________, which entails separating data from the programs that manipulate data.​

Accepted Answer

A)  ​Predictive analytics 
B)  ​Cardinality 
C)  ​data independence 
D)  data dependence​ 
A)  ​Predictive analytics 
B)  ​Cardinality 
C)  ​data independence 
D)  data dependence​

Question 16

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 17

One of the ways that databases are classified is by their structure.​

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

In a(n) __________ database, data for a query is fetched from one or more shards of a distributed database, and then it is processed by the DBMS to produce the query result.​

Accepted Answer

The answer of In a(n) __________ database, data for a...

Question 20

A(n) _______________ is a field that contains data unique to a record.​

Accepted Answer

A)  ​query 
B)  ​parameter 
C)  ​primary key 
D)  ​key-value 
A)  ​query 
B)  ​parameter 
C)  ​primary key 
D)  ​key-value

Which of the following is not a SQL keyword?

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

A(n) __________ file consists of a single, two-dimensional table of data elements.

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

The goal of normalization is to minimize data redundancy.

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.

A record that contains data is referred to as a record ________.

Which of the following is not considered to be type of database client?

A(n) _________ database is used to collect, modify, and maintain data on a daily basis.

A primary key is a ____________ that contains data unique to a record.

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

The entire Internet contains about a zettabyte of data.

__________ is a file system developed in 2005 that handles millions of files distributed across multiple server nodes.

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

Modern database tools support ________________, which entails separating data from the programs that manipulate data.

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

One of the ways that databases are classified is by their structure.

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

In a(n) __________ database, data for a query is fetched from one or more shards of a distributed database, and then it is processed by the DBMS to produce the query result.

A(n) _______________ is a field that contains data unique to a record.

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

Which of the following is not a SQL keyword?​

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

A(n) __________ file consists of a single, two-dimensional table of data elements.​

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

​The goal of normalization is to minimize data redundancy.

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

A record that contains data is referred to as a record ________.​

Which of the following is not considered to be type of database client?​

A(n) _________ database is used to collect, modify, and maintain data on a daily basis.​

A primary key is a ____________ that contains data unique to a record.​

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

The entire Internet contains about a zettabyte of data.​

__________ is a file system developed in 2005 that handles millions of files distributed across multiple server nodes.​

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

Modern database tools support ________________, which entails separating data from the programs that manipulate data.​

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

One of the ways that databases are classified is by their structure.​

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

In a(n) __________ database, data for a query is fetched from one or more shards of a distributed database, and then it is processed by the DBMS to produce the query result.​

A(n) _______________ is a field that contains data unique to a record.​

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

Which of the following is not a SQL keyword?

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

A(n) __________ file consists of a single, two-dimensional table of data elements.

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

The goal of normalization is to minimize data redundancy.

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.

A record that contains data is referred to as a record ________.

Which of the following is not considered to be type of database client?

A(n) _________ database is used to collect, modify, and maintain data on a daily basis.

A primary key is a ____________ that contains data unique to a record.

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

The entire Internet contains about a zettabyte of data.

__________ is a file system developed in 2005 that handles millions of files distributed across multiple server nodes.

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

Modern database tools support ________________, which entails separating data from the programs that manipulate data.

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

One of the ways that databases are classified is by their structure.

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

In a(n) __________ database, data for a query is fetched from one or more shards of a distributed database, and then it is processed by the DBMS to produce the query result.

A(n) _______________ is a field that contains data unique to a record.