Question 1

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 B

Question 2

In the context of database security, database ______ identifies sensitive data and database vulnerabilities in order to secure them.​

Accepted Answer

assessment​

Question 3

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

Question 4

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

Question 5

One of the most common database operations is to query for a particular record or group of records by using the ________ command.​

Accepted Answer

The answer of  One of the most common database operations...

Question 6

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 7

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

Accepted Answer

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

Question 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

The term __________ refers to huge collections of data that are difficult to process, analyze, and manage using conventional database tools.​

Accepted Answer

The answer of  The term __________ refers to huge collections...

Question 11

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

Accepted Answer

A)   ​data archive 
B)   executive dashboard​ 
C)   ​OLAP 
D)   ​ERD

Question 12

A lookup routine validates an entry by checking data in an in-house or third-party database.​

Accepted Answer

A) True 
 B)False

Question 13

​An efficiently designed database uses computed fields whenever possible because they do not require manual data entry.

Accepted Answer

A) True 
 B)False

Question 14

The term __________ is used to refer to a group of technologies for managing databases that do not adhere to the relational model and standard SQL query language.​

Accepted Answer

The answer of  The term __________ is used to refer...

Question 15

​Which SQL keyword is used to search for records?

Accepted Answer

A)   ​FIND 
B)   ​SEARCH 
C)   ​SELECT 
D)   ​UPDATE

Question 16

Rather than deleting old data, it can be moved to a data __________.​

Accepted Answer

The answer of  Rather than deleting old data, it can...

Question 17

_________ refers to the number of associations that can exist between two record types.​

Accepted Answer

The answer of  _________ refers to the number of associations...

Question 18

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

Question 19

SQL keywords must be entered in all uppercase letters because they are case-sensitive.​

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 10: Databases Database Basics

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

In the context of database security, database ______ identifies sensitive data and database vulnerabilities in order to secure them.​

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

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

One of the most common database operations is to query for a particular record or group of records by using the ________ command.​

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

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

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

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

The term __________ refers to huge collections of data that are difficult to process, analyze, and manage using conventional database tools.​

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

A lookup routine validates an entry by checking data in an in-house or third-party database.​

​An efficiently designed database uses computed fields whenever possible because they do not require manual data entry.

The term __________ is used to refer to a group of technologies for managing databases that do not adhere to the relational model and standard SQL query language.​

​Which SQL keyword is used to search for records?

Rather than deleting old data, it can be moved to a data __________.​

_________ refers to the number of associations that can exist between two record types.​

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

SQL keywords must be entered in all uppercase letters because they are case-sensitive.​

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

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

In the context of database security, database ______ identifies sensitive data and database vulnerabilities in order to secure them.

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

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

One of the most common database operations is to query for a particular record or group of records by using the ________ command.

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

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

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.

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

The term __________ refers to huge collections of data that are difficult to process, analyze, and manage using conventional database tools.

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

A lookup routine validates an entry by checking data in an in-house or third-party database.

An efficiently designed database uses computed fields whenever possible because they do not require manual data entry.

The term __________ is used to refer to a group of technologies for managing databases that do not adhere to the relational model and standard SQL query language.

Which SQL keyword is used to search for records?

Rather than deleting old data, it can be moved to a data __________.

_________ refers to the number of associations that can exist between two record types.

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

SQL keywords must be entered in all uppercase letters because they are case-sensitive.

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