Question 1

The DBMS is used to create the database itself.

Accepted Answer

A) True 
 B)False  True

Question 2

Personal DBMS products,such as Microsoft Access,create a clear distinction between the DBMS and the database application.

Accepted Answer

A) True 
 B)False  False

Question 3

What components are included in a database?

Accepted Answer

The database contains user data,metadata,indexes and other overhead data,and application metadata.User data is the data from the users' environment that they want to track.Metadata is data about the structure of the database.Indexes and other overhead data are structures that the database uses to improve performance.Finally,the application metadata is data about forms,reports,and other application components that some databases,particularly those created with desktop DBMS products,store with the database.

Question 4

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

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 7

Usually,a database table containing both rows and columns is designed to store data for exactly two themes.

Accepted Answer

A) True 
 B)False

Question 8

A relational database stores data in the form of:

Accepted Answer

A) lists. 
B) forms. 
C) columns. 
D) tables. 
E) spreadsheets. 
A) lists. 
B) forms. 
C) columns. 
D) tables. 
E) spreadsheets.

Question 9

A relational database stores data in the form of ________.

Accepted Answer

The answer of A relational database stores data in the...

Question 10

The Microsoft Access 2013 data type of AutoNumber is used when there is a specific need for a:

Accepted Answer

A) foreign key. 
B) primary key. 
C) surrogate key. 
D) spare key. 
E) secondary key. 
A) foreign key. 
B) primary key. 
C) surrogate key. 
D) spare key. 
E) secondary key.

Question 11

By default,Microsoft Access 2013 saves data files in the ________ file format.

Accepted Answer

The answer of By default,Microsoft Access 2013 saves data files...

Question 12

In the general division of labor between database applications and the DBMS,the processing of forms is considered a DBMS task.

Accepted Answer

A) True 
 B)False

Question 13

A relational database stores data in the form of lists.

Accepted Answer

A) True 
 B)False

Question 14

Microsoft SQL Server is an example of a:

Accepted Answer

A) database. 
B) database management system. 
C) data manipulation system. 
D) table. 
E) list manager. 
A) database. 
B) database management system. 
C) data manipulation system. 
D) table. 
E) list manager.

Question 15

Which of the following is not a function of the database application in a database system?

Accepted Answer

A) Execute application logic 
B) Control concurrency 
C) Create and process forms 
D) Create and transmit queries 
E) Create and process reports 
A) Execute application logic 
B) Control concurrency 
C) Create and process forms 
D) Create and transmit queries 
E) Create and process reports

Question 16

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

Accepted Answer

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

Question 17

Although users use database systems,they are not considered part of a database system.

Accepted Answer

A) True 
 B)False

Question 18

Briefly describe the four components of a database system.

Accepted Answer

The components of a database system are:

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

What are "referential integrity constraints"? Give an example.

Accepted Answer

A referential integrity constraint is a

The DBMS is used to create the database itself.

Personal DBMS products,such as Microsoft Access,create a clear distinction between the DBMS and the database application.

What components are included in a database?

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.

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.

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

Usually,a database table containing both rows and columns is designed to store data for exactly two themes.

A relational database stores data in the form of:

A relational database stores data in the form of ________.

The Microsoft Access 2013 data type of AutoNumber is used when there is a specific need for a:

By default,Microsoft Access 2013 saves data files in the ________ file format.

In the general division of labor between database applications and the DBMS,the processing of forms is considered a DBMS task.

A relational database stores data in the form of lists.

Microsoft SQL Server is an example of a:

Which of the following is not a function of the database application in a database system?

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

Although users use database systems,they are not considered part of a database system.

Briefly describe the four components of a database system.

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

What are "referential integrity constraints"? Give an example.

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

Exam 1: Getting Started

The DBMS is used to create the database itself.

Personal DBMS products,such as Microsoft Access,create a clear distinction between the DBMS and the database application.

What components are included in a database?

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.

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.

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

Usually,a database table containing both rows and columns is designed to store data for exactly two themes.

A relational database stores data in the form of:

A relational database stores data in the form of ________.

The Microsoft Access 2013 data type of AutoNumber is used when there is a specific need for a:

By default,Microsoft Access 2013 saves data files in the ________ file format.

In the general division of labor between database applications and the DBMS,the processing of forms is considered a DBMS task.

A relational database stores data in the form of lists.

Microsoft SQL Server is an example of a:

Which of the following is not a function of the database application in a database system?

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

Although users use database systems,they are not considered part of a database system.

Briefly describe the four components of a database system.

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

What are "referential integrity constraints"? Give an example.

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters