Chapter 7

Three types of triggers

Common types of triggers include BEFORE triggers, AFTER triggers, and INSTEAD OF triggers

The first PHP element to be created is the ________.

Connection

Which of the following is a task performed by the driver according to the ODBC standard?

Converts data source error codes into ODBC standard error codes

XML stands for ________.

Extensible Markup Language

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

FALSE

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

FALSE

A common default Web page name recognized by most Web servers is FirstPage.html.

FALSE

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

FALSE

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

FALSE

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

FALSE

Every DBMS product uses the same API.

FALSE

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

FALSE

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

FALSE

ODBC only works with Microsoft products.

FALSE

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

FALSE

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

FALSE

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

FALSE

When using Microsoft Access and IIS, there is no need for an ODBC data source.

FALSE

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

FALSE

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

FALSE

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

FALSE

XML designers created a system that allows document structure, data content, and materialization to be mixed.

FALSE

XML provides a standardized, non-customizable way to describe the content of a document.

FALSE

NetBeans is a(n) ________.

Integrated Development Environment (IDE)

If the computer hosting the Web server is running a Windows operating system, the Web server is probably ________.

Internet Information Services (IIS)

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

Notepad

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

ODBC data source

When using Microsoft Access and IIS, the connection to the Access database must be provided by using a(n) ________.

ODBC data source

How can XML be used with a DBMS?

One example is the use of XML with SQL Server. Here we use the SQL FOR XML clause to retrieve XML data from the database. The query results are returned to a single cell. This output can be expanded and copied to other documents.

ODBC stands for ________.

Open Database Connectivity

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

PHP

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

PHP

Which of the following is not a type of trigger that can be invoked before DBMS insert, update, or delete actions?

PREVIOUS triggers

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

SELECT

Which is true about stored procedures?

Stored procedures are stored in the database.

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

TRUE

Basic Web pages are created using Hypertext Markup Language (HTML).

TRUE

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

TRUE

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

TRUE

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

TRUE

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

TRUE

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

TRUE

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

TRUE

ODBC stands for Open Database Connectivity.

TRUE

When using Microsoft Access and IIS, the ODBC data source should be a system data source.

TRUE

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

TRUE

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

TRUE

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

TRUE

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

The driver

Three-tier architecture

The term tier refers to each different computer that runs a portion of a Web database processing environment. The user's browser running on the user's own computer is one tier, and a Web server running on another computer is another tier. If the DBMS supporting the Web application runs on yet another computer, there is a third tier, and the computer environment is referred to as a three-tier architecture.

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

a system data source

Every DBMS product has a(n) ________ that allows DBMS functions to be executed from application program code.

application programming interface (API)

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

close the connection

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

data source

XML allows a programmer to ________.

define elements

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

driver manager

When using Microsoft Access and IIS, a basic Web home page name that we should use even if we need to change IIS settings is ________.

index.html

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

process the query results

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

query the database

The ODBC standard defines a way to ________.

start transactions

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

stored procedure

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

system data source

After trying to open a connection, a PHP connection to a DBMS needs to ________.

test the connection

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

three-tier

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

trigger

Different ways databases can be processed

1. Active server pages .NET (ASPN.NET) 2. Java server pages (JSP) 3. Java 4. C# 5. Visual Basic.Net

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

1. Determine the type of DBMS that processes a given ODBC data source. 2. Load the appropriate ODBC driver into memory.

In PHP, any programming language statements that are to be processed on the server must be enclosed in ________.

<?php and ?>

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

<?php, ?>; < ; >

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

Apache

Every DBMS product has an API, which stands for ________.

Application Programming Interface