Exam 7: Database Processing Applications

A trigger is an event stored in a database that is invoked by the DBMS when specified events occur.

If the computer hosting the Web server is running a UNIX or Linux operating system,the Web server is probably ________.

Extensible Markup Language (XML)is becoming a standard means for defining the structure of documents and for transmitting documents from one computer to another.

The first PHP element to be created is the ________.

A SELECT … FOR XML statement produces output in HTML5 format.

As a data description language,JSON is much more complex than XML.

When using Microsoft Access and IIS,we can create Web pages that access the database using the popular ________ scripting language.

When using Microsoft Access and IIS,the basic Web home page can be named index.html.

With ODBC,a file data source is available only to the user that created it.

When using Microsoft Access and IIS,the Web pages that access the database cannot be written using PHP.

What is a three-tier architecture?

According to the ODBC standard,a(n)________ is a database and its associated DBMS,operating system,and network platform.

Define and briefly describe the function of ODBC.

A commonly used Web server on servers running the Linux operating system is ________.

What are the common differences between a Web database processing system running on the Windows operating system and one running on a Linux operating system?

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

Which of the following SQL commands cannot be used with a trigger?

With PHP,we enclose PHP commands in between the ________ and ________ symbols.

If the Web server and the DBMS are running on the same server,the system has a three-tier architecture.

With ODBC,only a single driver is needed to handle all data source types,such as SQL Server,Oracle Database,MySQL,and Microsoft Access.