Chapter 7 DB
1) Which of the following is a function performed by the driver manager in ODBC?
Both B and C
8) The first PHP element to be created is the ________.
Connection
14) 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
15) XML allows a programmer to ________.
Define elements
2) The intermediary between the application and the DBMS drivers in the ODBC architecture is the ________.
Driver manager
3) XML stands for ________.
Extensible Markup Language
20) 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.
21) If the computer hosting the Web server is running a Windows operating system, the Web server is probably ________.
Internet Information Services (ISS)
12) If the computer hosting the Web server is running a UNIX or Linux operating system, the Web server is probably ________.
Internet information services (IIS)
5) When working with Microsoft Access on a Windows operating system, a simple but usable ASCII text editor is ________.
Notepad
19) Before running Web pages in Internet Information Server (IIS) against a Microsoft Access database, we need to create a(n) ________.
OBDC data source
17) ODBC stands for ________.
Open Database Connectivity
6) When using Microsoft Access and IIS, we can create Web pages that access the database using the popular ________ scripting language.
PHP
4) Which of the following is not a type of trigger that can be invoked before DBMS insert, update, or delete actions?
Previous triggers
11) After getting data from a database, a PHP program needs to ________.
Process the query results
23) Which of the following SQL commands cannot be used with a trigger?
SELECT
24) Which of the following is true about stored procedures?
Stored procedures are stored in the database.
27) Every DBMS product has an application programming interface (API).
T
28) ODBC stands for Open Database Connectivity.
T
29) If a server is using a Microsoft Windows operating system, it is usually running Internet Information Services (IIS) as its Web server.
T
30) With ODBC, the driver manager serves as an intermediary between the application and the DBMS drivers.
T
31) With ODBC, a database and the DBMS that processes it are identified by the data source.
T
32) Basic Web pages are created using Hypertext Markup Language (HTML).
T
33) Extensible Markup Language (XML) is becoming a standard means for defining the structure of documents and for transmitting documents from one computer to another.
T
36) A trigger is an event stored in a database that is invoked by the DBMS when specified events occur.
T
42) ODBC is an industry standard interface between programming code and DBMS APIs.
T
44) HTML standards are defined by the World Wide Web Consortium (W3C).
T
46) When using Microsoft Access and IIS, the basic Web home page can be named index.html.
T
49) When using Microsoft Access and IIS, the ODBC data source should be a system data source.
T
54) With ODBC, only a single driver is needed to handle all data source types, such as SQL Server, Oracle Database, MySQL, and Microsoft Access.
T
56) In general, the best type of ODBC data source that can be defined for a Web application is a system data source.
T
9) After trying to open a connection, a PHP connection to a DBMS needs to ________.
Test the connection
13) According to the ODBC standard, which of the following is not part of the specification of a data source?
The driver
7) In PHP, any programming language statements that are to be processed on the server must be enclosed in ________.
<?php and ?>.
25) When using an ODBC data source with IIS and Microsoft Access, we should use ________.
A system data source.
22) The ODBC standard defines a way to ________.
All of the above
16) Every DBMS product has an API, which stands for ________.
Application Programming Interface