Question 1

Data that the database keeps about its own structure is called ________.

Accepted Answer

The answer of Data that the database keeps about its...

Question 2

Regarding Big Data,what does the term NoSQL really mean?

Accepted Answer

A)   No SQL used
B)   NortonOS Query Language
C)   Notational Query Language
D)   Non-Blocking Query Language
E)   Non-Relational Database

Question 3

What are the advantages and disadvantages of personal DBMS products hiding the complexity of database systems?

Accepted Answer

The advantage of hiding the complexity o...

Question 4

An advantage of keeping data in lists is that if you update a data value in one row of data in a list,other occurrences of the same data item in other rows will be automatically updated as well.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following problems associated with storing data in a list is avoided by storing data in a relational database?

Accepted Answer

A)   CPU processing inefficiencies
B)   Lack of necessary bandwidth
C)   Running out of memory storage
D)   Duplication of data items
E)   Incorrect data typing

Question 6

Today almost every commercial database is based on ________.

Accepted Answer

A)   lists
B)   the hierarchical model
C)   the linked-list model
D)   the relational model
E)   the object-oriented model

Question 7

The purpose of the ________ in a database system is to receive requests from applications and to translate those requests into reads and writes on the database files.

Accepted Answer

The answer of The purpose of the ________ in a...

Question 8

What components are included in a database?

Accepted Answer

The database contains user data,metadata...

Question 9

A database may be used to help people with all of the following except ________.

Accepted Answer

A)   track which student is assigned to a particular advisor
B)   know the current inventory levels of products their company sells
C)   check on the estimated arrival time of an incoming flight at an airport
D)   look up their checking account balance over the Internet
E)   debug existing program code

Question 10

Which of the following would not be an example of database metadata?

Accepted Answer

A)   Names of tables in a database
B)   Properties of tables in a database
C)   Names of columns in a database and their associated tables
D)   Properties of columns
E)   Queries against records in the database tables

Question 11

Microsoft Access 2016 databases are stored using the file extension .accdb.

Accepted Answer

A) True 
 B)False

Question 12

Briefly describe the function of the DBMS in a database system.

Accepted Answer

The DBMS creates the database and the ta...

Question 13

What is "metadata," and how does it relate to the definition of a database?

Accepted Answer

Metadata is data about the structure of ...

Question 14

A relational database stores data in the form of lists.

Accepted Answer

A) True 
 B)False

Question 15

An advantage of keeping data in lists is that if you add a new row of data to the list,you will never have null values occurring for any data item in the row.

Accepted Answer

A) True 
 B)False

Question 16

A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS).

Accepted Answer

A) True 
 B)False

Question 17

What problems with storing data on two themes in a list are addressed by database technology?

Accepted Answer

First,data updates are simplified becaus...

Question 18

By separating data into tables containing data on only one theme each,making changes to the data is simplified.

Accepted Answer

A) True 
 B)False

Question 19

Microsoft Access 2016 generates surrogate key values when the ________ data type is used.

Accepted Answer

The answer of Microsoft Access 2016 generates surrogate key values...

Question 20

The creation of a database and its tables is a function of which component of the database system?

Accepted Answer

A)   Users
B)   Application
C)   DBMS
D)   Database
E)   Web server

Exam 1: Getting Started

What are the advantages and disadvantages of personal DBMS products hiding the complexity of database systems?

Correct AnswerverifiedThe advantage of hiding the complexity o...View AnswerShow Answer

Microsoft Access 2016 databases are stored using the file extension .accdb.

Correct AnswerverifiedShow Answer

Regarding Big Data,what does the term NoSQL really mean?

Correct AnswerverifiedShow Answer

The purpose of the ________ in a database system is to receive requests from applications and to translate those requests into reads and writes on the database files.

Correct AnswerverifiedShow Answer

What is "metadata," and how does it relate to the definition of a database?

Correct AnswerverifiedMetadata is data about the structure of ...View AnswerShow Answer

A relational database stores data in the form of lists.

Correct AnswerverifiedShow Answer

Briefly describe the function of the DBMS in a database system.

Correct AnswerverifiedThe DBMS creates the database and the ta...View AnswerShow Answer

Which of the following problems associated with storing data in a list is avoided by storing data in a relational database?

Correct AnswerverifiedShow Answer

Data that the database keeps about its own structure is called ________.

Correct AnswerverifiedShow Answer

A database may be used to help people with all of the following except ________.

Correct AnswerverifiedShow Answer

Today almost every commercial database is based on ________.

Correct AnswerverifiedShow Answer

By separating data into tables containing data on only one theme each,making changes to the data is simplified.

Correct AnswerverifiedShow Answer

An advantage of keeping data in lists is that if you update a data value in one row of data in a list,other occurrences of the same data item in other rows will be automatically updated as well.

Correct AnswerverifiedShow Answer

A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS).

Correct AnswerverifiedShow Answer

An advantage of keeping data in lists is that if you add a new row of data to the list,you will never have null values occurring for any data item in the row.

Correct AnswerverifiedShow Answer

What problems with storing data on two themes in a list are addressed by database technology?

Correct AnswerverifiedFirst,data updates are simplified becaus...View AnswerShow Answer

What components are included in a database?

Correct AnswerverifiedThe database contains user data,metadata...View AnswerShow Answer

The creation of a database and its tables is a function of which component of the database system?

Correct AnswerverifiedShow Answer

Microsoft Access 2016 generates surrogate key values when the ________ data type is used.

Correct AnswerverifiedShow Answer

Which of the following would not be an example of database metadata?

Correct AnswerverifiedShow Answer

Correct Answer
verified
The advantage of hiding the complexity o...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Metadata is data about the structure of ...
View Answer

Correct Answer
verified

Correct Answer
verified
The DBMS creates the database and the ta...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
First,data updates are simplified becaus...
View Answer

Correct Answer
verified
The database contains user data,metadata...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified