Question 1

What are XML Web Services?

Accepted Answer

XML Web Services is a means for sharing

Question 2

With ODBC,the driver manager serves as an intermediary between the application and the DBMS drivers.

Accepted Answer

A) True 
 B)False

Question 3

A(n)________ is a program stored within the DBMS that is invoked by the DBMS when a specified event occurs.

Accepted Answer

The answer of A(n)________ is a program stored within the...

Question 4

According to the ODBC standard,which of the following is not part of the specification of a data source?

Accepted Answer

A)  The associated DBMS 
B)  The database 
C)  The driver 
D)  The operating system 
E)  The network platform 
A)  The associated DBMS 
B)  The database 
C)  The driver 
D)  The operating system 
E)  The network platform

Question 5

Which of the following is true about stored procedures?

Accepted Answer

A)  Stored procedures cannot be passed parameters like a regular application function. 
B)  Stored procedures are stored as an embedded function in the application program. 
C)  Stored procedures are stored in the database. 
D)  Stored procedures are invoked automatically by the DBMS when specific events occur. 
E)  Stored procedures are always written in PHP. 
A)  Stored procedures cannot be passed parameters like a regular application function. 
B)  Stored procedures are stored as an embedded function in the application program. 
C)  Stored procedures are stored in the database. 
D)  Stored procedures are invoked automatically by the DBMS when specific events occur. 
E)  Stored procedures are always written in PHP.

Question 6

With ODBC,a database and the DBMS that processes it are identified by the data source.

Accepted Answer

A) True 
 B)False

Question 7

When using Microsoft Access and IIS,a good basic ASCII text editor for producing HTML is FrontPage.

Accepted Answer

A) True 
 B)False

Question 8

Even when using Microsoft Access and IIS,we should still use a basic Web home page named ________.

Accepted Answer

The answer of Even when using Microsoft Access and IIS,we...

Question 9

HTML standards are defined by the World Wide Web Consortium (W3C).

Accepted Answer

A) True 
 B)False

Question 10

When using Microsoft Access and IIS,the Web pages that access the database can be written using the ________ scripting language.

Accepted Answer

The answer of When using Microsoft Access and IIS,the Web...

Question 11

XML Web Services is a means for protecting and hiding elements of program functionality that otherwise would be available for misuse over the Web.

Accepted Answer

A) True 
 B)False

Question 12

To get data after opening a connection,a PHP program needs to ________.

Accepted Answer

A)  open the connection 
B)  test the connection 
C)  query the database 
D)  process the query results 
E)  close the connection 
A)  open the connection 
B)  test the connection 
C)  query the database 
D)  process the query results 
E)  close the connection

Question 13

If a server is using a Microsoft Windows operating system,it is usually running Internet Information Services (IIS)as its Web server.

Accepted Answer

A) True 
 B)False

Question 14

The ODBC standard defines a way to ________.

Accepted Answer

A)  start transactions 
B)  develop E-R diagrams 
C)  normalize relations 
D)  insert attributes into table schemas 
E)  use wildcards in SQL statements 
A)  start transactions 
B)  develop E-R diagrams 
C)  normalize relations 
D)  insert attributes into table schemas 
E)  use wildcards in SQL statements

Question 15

If the Web server and the DBMS are running on different servers,the system has a(n)________ architecture.

Accepted Answer

The answer of If the Web server and the DBMS...

Question 16

A(n)________ is similar to a computer program subroutine or function,but it is stored within the database.

Accepted Answer

The answer of A(n)________ is similar to a computer program...

Question 17

The final step of using a PHP connection to a DBMS is to ________.

Accepted Answer

A)  open the connection 
B)  test the connection 
C)  query the database 
D)  process the query results 
E)  close the connection 
A)  open the connection 
B)  test the connection 
C)  query the database 
D)  process the query results 
E)  close the connection

Question 18

NetBeans is a(n)________.

Accepted Answer

Integrated

Question 19

What is XML,and why is it useful?

Accepted Answer

XML stands for Extensible Markup Languag

Question 20

In general,the best type of ODBC data source that can be defined for a Web application is a system data source.

Accepted Answer

A) True 
 B)False

What are XML Web Services?

With ODBC,the driver manager serves as an intermediary between the application and the DBMS drivers.

A(n)________ is a program stored within the DBMS that is invoked by the DBMS when a specified event occurs.

According to the ODBC standard,which of the following is not part of the specification of a data source?

Which of the following is true about stored procedures?

With ODBC,a database and the DBMS that processes it are identified by the data source.

When using Microsoft Access and IIS,a good basic ASCII text editor for producing HTML is FrontPage.

Even when using Microsoft Access and IIS,we should still use a basic Web home page named ________.

HTML standards are defined by the World Wide Web Consortium (W3C).

When using Microsoft Access and IIS,the Web pages that access the database can be written using the ________ scripting language.

XML Web Services is a means for protecting and hiding elements of program functionality that otherwise would be available for misuse over the Web.

To get data after opening a connection,a PHP program needs to ________.

If a server is using a Microsoft Windows operating system,it is usually running Internet Information Services (IIS)as its Web server.

The ODBC standard defines a way to ________.

If the Web server and the DBMS are running on different servers,the system has a(n)________ architecture.

A(n)________ is similar to a computer program subroutine or function,but it is stored within the database.

The final step of using a PHP connection to a DBMS is to ________.

NetBeans is a(n)________.

What is XML,and why is it useful?

In general,the best type of ODBC data source that can be defined for a Web application is a system data source.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

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 7: Database Processing Applications

What are XML Web Services?

With ODBC,the driver manager serves as an intermediary between the application and the DBMS drivers.

A(n)________ is a program stored within the DBMS that is invoked by the DBMS when a specified event occurs.

According to the ODBC standard,which of the following is not part of the specification of a data source?

Which of the following is true about stored procedures?

With ODBC,a database and the DBMS that processes it are identified by the data source.

When using Microsoft Access and IIS,a good basic ASCII text editor for producing HTML is FrontPage.

Even when using Microsoft Access and IIS,we should still use a basic Web home page named ________.

HTML standards are defined by the World Wide Web Consortium (W3C).

When using Microsoft Access and IIS,the Web pages that access the database can be written using the ________ scripting language.

XML Web Services is a means for protecting and hiding elements of program functionality that otherwise would be available for misuse over the Web.

To get data after opening a connection,a PHP program needs to ________.

If a server is using a Microsoft Windows operating system,it is usually running Internet Information Services (IIS)as its Web server.

The ODBC standard defines a way to ________.

If the Web server and the DBMS are running on different servers,the system has a(n)________ architecture.

A(n)________ is similar to a computer program subroutine or function,but it is stored within the database.

The final step of using a PHP connection to a DBMS is to ________.

NetBeans is a(n)________.

What is XML,and why is it useful?

In general,the best type of ODBC data source that can be defined for a Web application is a system data source.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

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