Question 1

Briefly describe the function of an application program in a database system.

Accepted Answer

The application program is responsible f

Question 2

In the general division of labor between database applications and the DBMS,the application program determines which tables need to be modified.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A referential integrity constraint is a

Question 4

A relational database is ________.

Accepted Answer

A)  a self-describing collection of related tables 
B)  a collection of forms and reports that support a given purpose 
C)  a library of queries and data files for querying 
D)  a set of applications and the data sets for those applications 
E)  a set of metadata 
A)  a self-describing collection of related tables 
B)  a collection of forms and reports that support a given purpose 
C)  a library of queries and data files for querying 
D)  a set of applications and the data sets for those applications 
E)  a set of metadata

Question 5

Metadata is the user data stored in the database.

Accepted Answer

A) True 
 B)False

Question 6

What Microsoft Access file format is used by default in Microsoft Access 2016?

Accepted Answer

By default,Microsoft Access 20

Question 7

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 8

The Microsoft Access 2016 application generator provides the ability to create and store forms,reports,and queries.

Accepted Answer

A) True 
 B)False

Question 9

Relational database tables are commonly combined,queried,and processed using Structured Query Language (SQL).

Accepted Answer

A) True 
 B)False

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

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 12

The default file format for Microsoft Access 2016 database files is the ________.

Accepted Answer

A)  Access 2007 format 
B)  Access 2003 format 
C)  Access XP format 
D)  SQL Server format 
E)  XBD format 
A)  Access 2007 format 
B)  Access 2003 format 
C)  Access XP format 
D)  SQL Server format 
E)  XBD format

Question 13

Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for database files.

Accepted Answer

A) True 
 B)False

Question 14

It is almost always best to design a table in a database so that it contains data on ________ theme.

Accepted Answer

The answer of It is almost always best to design...

Question 15

The DBMS is used to create the database itself.

Accepted Answer

A) True 
 B)False

Question 16

Application programs are responsible for creating,maintaining,and supporting database backup and recovery systems.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Microsoft Access is a(n)________,which combines a DBMS and an application generator.

Accepted Answer

The answer of Microsoft Access is a(n)________,which combines a DBMS...

Question 19

The statement
SELECT STUDENT.StudentNumber,STUDENT.StudentName,
FROM STUDENT
WHERE STUDENT.StudentNumber = S12345678;
Is an example of ________.

Accepted Answer

A)  QBE 
B)  SQL 
C)  QLE 
D)  C++ 
E)  Java 
A)  QBE 
B)  SQL 
C)  QLE 
D)  C++ 
E)  Java

Question 20

The component of a database that makes it self-describing is the ________.

Accepted Answer

A)  related tables 
B)  applications 
C)  library 
D)  data set 
E)  metadata 
A)  related tables 
B)  applications 
C)  library 
D)  data set 
E)  metadata

Briefly describe the function of an application program in a database system.

In the general division of labor between database applications and the DBMS,the application program determines which tables need to be modified.

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

A relational database is ________.

Metadata is the user data stored in the database.

What Microsoft Access file format is used by default in Microsoft Access 2016?

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

The Microsoft Access 2016 application generator provides the ability to create and store forms,reports,and queries.

Relational database tables are commonly combined,queried,and processed using Structured Query Language (SQL).

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

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

The default file format for Microsoft Access 2016 database files is the ________.

Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for database files.

It is almost always best to design a table in a database so that it contains data on ________ theme.

The DBMS is used to create the database itself.

Application programs are responsible for creating,maintaining,and supporting database backup and recovery systems.

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

Microsoft Access is a(n)________,which combines a DBMS and an application generator.

The statement SELECT STUDENT.StudentNumber,STUDENT.StudentName, FROM STUDENT WHERE STUDENT.StudentNumber = S12345678; Is an example of ________.

The component of a database that makes it self-describing is the ________.

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

Briefly describe the function of an application program in a database system.

In the general division of labor between database applications and the DBMS,the application program determines which tables need to be modified.

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

A relational database is ________.

Metadata is the user data stored in the database.

What Microsoft Access file format is used by default in Microsoft Access 2016?

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

The Microsoft Access 2016 application generator provides the ability to create and store forms,reports,and queries.

Relational database tables are commonly combined,queried,and processed using Structured Query Language (SQL).

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

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

The default file format for Microsoft Access 2016 database files is the ________.

Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for database files.

It is almost always best to design a table in a database so that it contains data on ________ theme.

The DBMS is used to create the database itself.

Application programs are responsible for creating,maintaining,and supporting database backup and recovery systems.

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

Microsoft Access is a(n)________,which combines a DBMS and an application generator.

The statement SELECT STUDENT.StudentNumber,STUDENT.StudentName, FROM STUDENT WHERE STUDENT.StudentNumber = S12345678; Is an example of ________.

The component of a database that makes it self-describing is the ________.

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