Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

In a(n) __________ 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 3

Enterprise database applications tend to have some flexibility for customization.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The answer of A primary key is a(n) ____________ that...

Question 5

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 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Accepted Answer

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

Question 10

A hierarchical database allows one-to-many relationships but not one-to-one relationships.

Accepted Answer

A) True 
 B)False

Question 11

In the context of database security, user ______ management allows access to data on an as-needed basis.

Accepted Answer

The answer of In the context of database security, user...

Question 12

Decision makers can access analytical databases using an executive __________.

Accepted Answer

The answer of Decision makers can access analytical databases using...

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

The goal of normalization is to minimize data redundancy.

Accepted Answer

A) True 
 B)False

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

Which database data type is used for fields that contain whole numbers, such as quantities, repetitions, and rankings?

Accepted Answer

A)  Logical 
B)  Real 
C)  Integer 
D)  Memo 
A)  Logical 
B)  Real 
C)  Integer 
D)  Memo

Question 20

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

SQL statements contain command words but do not contain data.

In a(n) __________ 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.

Enterprise database applications tend to have some flexibility for customization.

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

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

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

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

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

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

A hierarchical database allows one-to-many relationships but not one-to-one relationships.

In the context of database security, user ______ management allows access to data on an as-needed basis.

Decision makers can access analytical databases using an executive __________.

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

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

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

The goal of normalization is to minimize data redundancy.

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

A ____________ 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.

Which database data type is used for fields that contain whole numbers, such as quantities, repetitions, and rankings?

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.

Digital Content

Digital Devices

Networks

The Web

Social Media

Software

Digital Security

The ICT Industry

Information Systems

Programming

Module Py: Coding With Python

Filters

Exam 10: Databases

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

In a(n) __________ 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.

Enterprise database applications tend to have some flexibility for customization.

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

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

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

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

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

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

A hierarchical database allows one-to-many relationships but not one-to-one relationships.

In the context of database security, user ______ management allows access to data on an as-needed basis.

Decision makers can access analytical databases using an executive __________.

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

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

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

The goal of normalization is to minimize data redundancy.

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

A ____________ 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.

Which database data type is used for fields that contain whole numbers, such as quantities, repetitions, and rankings?

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

Digital Content

Digital Devices

Networks

The Web

Social Media

Software

Digital Security

The ICT Industry

Information Systems

Programming

Module Py: Coding With Python

Filters

SQL statements contain command words but do not contain data.

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

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

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

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

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

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.