Question 1

The most commonly used Web server on servers running the UNIX or Linux operating system is Internet Information Services (IIS).

Accepted Answer

A) True 
 B)False

Question 2

XML stands for ________.

Accepted Answer

Extensible

Question 3

XML allows a programmer to ________.

Accepted Answer

A)  define elements 
B)  use only predefined elements 
C)  use only "shrink-warped," purchased programs 
D)  loosely define the structure of a document 
E)  Both A and B 
A)  define elements 
B)  use only predefined elements 
C)  use only "shrink-warped," purchased programs 
D)  loosely define the structure of a document 
E)  Both A and B

Question 4

Every DBMS product has an application programming interface (API).

Accepted Answer

A) True 
 B)False

Question 5

The intermediary between the application and the DBMS drivers in the ODBC architecture is the ________.

Accepted Answer

A)  driver manager 
B)  OLE DB interface 
C)  ODBC driver 
D)  data source 
E)  database connector 
A)  driver manager 
B)  OLE DB interface 
C)  ODBC driver 
D)  data source 
E)  database connector

Question 6

A BEFORE trigger can be combined with an INSERT,UPDATE,or READ statement.

Accepted Answer

A) True 
 B)False

Question 7

In XML,a document author can only use the predefined XML tags.

Accepted Answer

A) True 
 B)False

Question 8

Every DBMS product uses the same API.

Accepted Answer

A) True 
 B)False

Question 9

When using an ODBC data source with IIS and Microsoft Access,we should use ________.

Accepted Answer

A)  a file data source 
B)  a system data source 
C)  a user data source 
D)  a LAMP data source 
E)  a WAMP data source 
A)  a file data source 
B)  a system data source 
C)  a user data source 
D)  a LAMP data source 
E)  a WAMP data source

Question 10

How can XML be used with a DBMS?

Accepted Answer

One example is the use of XML with SQL S

Question 11

ODBC is an industry standard interface between programming code and DBMS APIs.

Accepted Answer

A) True 
 B)False

Question 12

After getting data from a database,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

A stored procedure is a module of logic normally written in a traditional programming language like C++ and stored in the application program.

Accepted Answer

A) True 
 B)False

Question 14

When using Microsoft Access and IIS with an ODBC data source,the ODBC data source should be a(n)________.

Accepted Answer

The answer of When using Microsoft Access and IIS with...

Question 15

When working with Microsoft Access on a Windows operating system,a simple but usable ASCII text editor is ________.

Accepted Answer

A)  Microsoft Word 
B)  Notepad 
C)  Wordpad 
D)  Microsoft Frontpage 
E)  Microsoft Visual Studio .NET 
A)  Microsoft Word 
B)  Notepad 
C)  Wordpad 
D)  Microsoft Frontpage 
E)  Microsoft Visual Studio .NET

Question 16

ODBC stands for Open Database Connectivity.

Accepted Answer

A) True 
 B)False

Question 17

A stored procedure is invoked automatically by the DBMS whenever certain events occur.

Accepted Answer

A) True 
 B)False

Question 18

Before running Web pages in Internet Information Server (IIS)against a Microsoft Access database,we need to create a(n)________.

Accepted Answer

A)  ODBC data source 
B)  JBDC data source 
C)  OLE DB data source 
D)  LAMP data source 
E)  WAMP data source 
A)  ODBC data source 
B)  JBDC data source 
C)  OLE DB data source 
D)  LAMP data source 
E)  WAMP data source

Question 19

Which of the following is a function performed by the driver manager in ODBC?

Accepted Answer

A)  Submit SQL statements to the data source. 
B)  Determine the type of DBMS that processes a given ODBC data source. 
C)  Load the appropriate ODBC driver into memory. 
D)  Convert data source error codes into ODBC error codes. 
E)  Both B and C 
A)  Submit SQL statements to the data source. 
B)  Determine the type of DBMS that processes a given ODBC data source. 
C)  Load the appropriate ODBC driver into memory. 
D)  Convert data source error codes into ODBC error codes. 
E)  Both B and C

Question 20

Briefly describe three types of triggers.

Accepted Answer

Common types of triggers include BEFORE

The most commonly used Web server on servers running the UNIX or Linux operating system is Internet Information Services (IIS).

XML stands for ________.

XML allows a programmer to ________.

Every DBMS product has an application programming interface (API).

The intermediary between the application and the DBMS drivers in the ODBC architecture is the ________.

A BEFORE trigger can be combined with an INSERT,UPDATE,or READ statement.

In XML,a document author can only use the predefined XML tags.

Every DBMS product uses the same API.

When using an ODBC data source with IIS and Microsoft Access,we should use ________.

How can XML be used with a DBMS?

ODBC is an industry standard interface between programming code and DBMS APIs.

After getting data from a database,a PHP program needs to ________.

A stored procedure is a module of logic normally written in a traditional programming language like C++ and stored in the application program.

When using Microsoft Access and IIS with an ODBC data source,the ODBC data source should be a(n)________.

When working with Microsoft Access on a Windows operating system,a simple but usable ASCII text editor is ________.

ODBC stands for Open Database Connectivity.

A stored procedure is invoked automatically by the DBMS whenever certain events occur.

Before running Web pages in Internet Information Server (IIS)against a Microsoft Access database,we need to create a(n)________.

Which of the following is a function performed by the driver manager in ODBC?

Briefly describe three types of triggers.

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

The most commonly used Web server on servers running the UNIX or Linux operating system is Internet Information Services (IIS).

XML stands for ________.

XML allows a programmer to ________.

Every DBMS product has an application programming interface (API).

The intermediary between the application and the DBMS drivers in the ODBC architecture is the ________.

A BEFORE trigger can be combined with an INSERT,UPDATE,or READ statement.

In XML,a document author can only use the predefined XML tags.

Every DBMS product uses the same API.

When using an ODBC data source with IIS and Microsoft Access,we should use ________.

How can XML be used with a DBMS?

ODBC is an industry standard interface between programming code and DBMS APIs.

After getting data from a database,a PHP program needs to ________.

A stored procedure is a module of logic normally written in a traditional programming language like C++ and stored in the application program.

When using Microsoft Access and IIS with an ODBC data source,the ODBC data source should be a(n)________.

When working with Microsoft Access on a Windows operating system,a simple but usable ASCII text editor is ________.

ODBC stands for Open Database Connectivity.

A stored procedure is invoked automatically by the DBMS whenever certain events occur.

Before running Web pages in Internet Information Server (IIS)against a Microsoft Access database,we need to create a(n)________.

Which of the following is a function performed by the driver manager in ODBC?

Briefly describe three types of triggers.

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