Question 1

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 
A)  lists 
B)  the hierarchical model 
C)  the linked-list model 
D)  the relational model 
E)  the object-oriented model

Question 2

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 3

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 
A)  No SQL used 
B)  NortonOS Query Language 
C)  Notational Query Language 
D)  Non-Blocking Query Language 
E)  Non-Relational Database

Question 4

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 5

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 6

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

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 8

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 9

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

Accepted Answer

Metadata is data about the structure of

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

A relational database stores data in the form of lists.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

The DBMS creates the database and the ta

Question 14

What components are included in a database?

Accepted Answer

The database contains user data,metadata

Question 15

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 
A)  Users 
B)  Application 
C)  DBMS 
D)  Database 
E)  Web server

Question 16

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

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

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 19

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 20

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

Today almost every commercial database is based on ________.

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

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

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

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.

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

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

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.

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

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

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

A relational database stores data in the form of lists.

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

What components are included in a database?

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

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

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

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

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

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.

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

Exam 1: Getting Started

Today almost every commercial database is based on ________.

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

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

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

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.

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

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

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.

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

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

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

A relational database stores data in the form of lists.

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

What components are included in a database?

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

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

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

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

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

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.

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters