Database Concepts, 8e (Kroenke)
Chapter 7 Database Processing Applications
1) When using Microsoft Access and IIS, the Web pages that access the database cannot be
written using PHP.
2) In PHP, any programming language statements that are to be processed on the server must be
enclosed in ________.
A) <!— and —!>
B) [php and php]
C) (php and php)
D) <?php and ?>
E) <server> and </server>
3) The first PHP element to be created is the ________.
A) Command object
B) Connection
C) Errors collection
D) Parameters collection
E) RecordSet object
4) After trying to open a connection, a PHP connection to a DBMS needs to ________.
A) open the connection
B) test the connection
C) query the database
D) process the query results
E) close the connection
5) To get data after opening a connection, a PHP program needs to ________.
A) open the connection
B) test the connection
C) query the database
D) process the query results
E) close the connection
6) After getting data from a database, a PHP program needs to ________.
A) open the connection
B) test the connection
C) query the database
D) process the query results
E) close the connection
7) NetBeans is a(n) ________.
8) When using Microsoft Access and IIS, the Web pages that access the database can be written
using the ________ scripting language.
9) Briefly describe PHP.
10) What is the NetBeans IDE?
11) A SELECT … FOR XML statement produces output in HTML5 format.
12) How can XML be used with a DBMS?
13) Every DBMS product has an application programming interface (API).
14) Every DBMS product uses the same API.
15) ODBC stands for Open Database Connectivity.
16) If a server is using a Microsoft Windows operating system, it is usually running Internet
Information Services (IIS) as its Web server.
17) The most commonly used Web server on servers running the UNIX or Linux operating
system is Internet Information Services (IIS).
18) ODBC is an industry standard interface between programming code and DBMS APIs.
19) ODBC only works with Microsoft products.
20) With ODBC, the driver manager serves as an intermediary between the application and the
DBMS drivers.
21) With ODBC, only a single driver is needed to handle all data source types, such as SQL
Server, Oracle Database, MySQL, and Microsoft Access.
22) With ODBC, a database and the DBMS that processes it are identified by the data source.
23) With ODBC, a file data source is available only to the user that created it.
24) In general, the best type of ODBC data source that can be defined for a Web application is a
system data source.
25) If the computer hosting the Web server is running a Windows operating system, the Web
server is probably ________.
A) Apache
B) Tomcat
C) Internet Information Services (IIS)
D) Internet Interpreter Server (IIS)
E) Information Interpreter Server (IIS)
26) If the computer hosting the Web server is running a UNIX or Linux operating system, the
Web server is probably ________.
A) Apache
B) Tomcat
C) Internet Information Server (IIS)
D) Internet Interpreter Server (IIS)
E) Information Interpreter Server (IIS)
27) According to the ODBC standard, which of the following is not part of the specification of a
data source?
A) The associated DBMS
B) The database
C) The driver
D) The operating system
E) The network platform
28) The ODBC standard defines a way to ________.
A) start transactions
B) develop E-R diagrams
C) normalize relations
D) insert attributes into table schemas
E) use wildcards in SQL statements
29) Which of the following is a function performed by the driver manager in ODBC?
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
30) The intermediary between the application and the DBMS drivers in the ODBC architecture is
the ________.
A) driver manager
B) OLE DB interface
C) ODBC driver
D) data source
E) database connector
31) Which of the following is a task performed by the driver according to the ODBC standard?
A) Determines the appropriate DBMS
B) Validates the format of the ODBC command received from the application
C) Converts data source error codes into ODBC standard error codes
D) Verifies the application to the data source
E) Converts the data source into an SQL-compliant data structure
32) Every DBMS product has a(n) ________ that allows DBMS functions to be executed from
application program code.
33) ODBC stands for ________.
34) A commonly used Web server on servers running the Linux operating system is ________.
35) If the Web server and the DBMS are running on different servers, the system has a(n)
________ architecture.
36) According to the ODBC standard, a(n) ________ is a database and its associated DBMS,
operating system, and network platform.
37) When using Microsoft Access and IIS, the connection to the Access database must be
provided by using a(n) ________.
38) When using Microsoft Access and IIS with an ODBC data source, the ODBC data source
should be a(n) ________.
39) 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?
40) Define and briefly describe the function of ODBC.
41) Basic Web pages are created using Hypertext Markup Language (HTML).
42) HTML standards are defined by the World Wide Web Consortium (W3C).
43) A common default Web page name recognized by most Web servers is FirstPage.html.
44) Extensible Markup Language (XML) is becoming a standard means for defining the
structure of documents and for transmitting documents from one computer to another.
45) When using Microsoft Access and IIS, the basic Web home page can be named index.html.
46) When using Microsoft Access and IIS, a good basic ASCII text editor for producing HTML
is FrontPage.
47) When using Microsoft Access and IIS, there is no need for an ODBC data source.
48) When using Microsoft Access and IIS, the ODBC data source should be a system data
source.
49) With PHP, we enclose PHP commands in between the ________ and ________ symbols.
50) As a data description language, JSON is much more complex than XML.
51) In XML, a document author can only use the predefined XML tags.
52) XML provides a standardized, non-customizable way to describe the content of a document.
53) XML designers created a system that allows document structure, data content, and
materialization to be mixed.
54) XML Web Services is a means for protecting and hiding elements of program functionality
that otherwise would be available for misuse over the Web.
55) XML stands for ________.
A) Experimental Markup Language
B) Existential Markup Language
C) Extendable Markup Language
D) Extensible Markup Language
E) Extensible Marketing Language
56) XML allows a programmer to ________.
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
57) XML stands for ________.
58) What is XML, and why is it useful?
59) What are XML Web Services?
60) A trigger is an event stored in a database that is invoked by the DBMS when specified events
occur.
61) A BEFORE trigger can be combined with an INSERT, UPDATE, or READ statement.
62) A stored procedure is a module of logic normally written in a traditional programming
language like C++ and stored in the application program.
63) A stored procedure is invoked automatically by the DBMS whenever certain events occur.
64) If the Web server and the DBMS are running on the same server, the system has a three-tier
architecture.
65) Which of the following is not a type of trigger that can be invoked before DBMS insert,
update, or delete actions?
A) BEFORE triggers
B) PREVIOUS triggers
C) AFTER triggers
D) INSTEAD OF triggers
E) None of the above
66) Which of the following SQL commands cannot be used with a trigger?
A) INSERT
B) SELECT
C) UPDATE
D) DELETE
E) Both B and D
67) Which of the following is true about stored procedures?
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.
68) Every DBMS product has an API, which stands for ________.
A) All Program Interpreter
B) All Program Interface
C) Application Programming Interpreter
D) Application Programming Interface
E) None of the above
69) ODBC stands for ________.
A) Open Database Compatibility
B) Open Database Connectivity
C) Open-source Database Compatibility
D) Open-source Database Connectivity
E) None of the above
70) The final step of using a PHP connection to a DBMS is to ________.
A) open the connection
B) test the connection
C) query the database
D) process the query results
E) close the connection
71) When working with Microsoft Access on a Windows operating system, a simple but usable
ASCII text editor is ________.
A) Microsoft Word
B) Notepad
C) Wordpad
D) Microsoft Frontpage
E) Microsoft Visual Studio .NET
72) Before running Web pages in Internet Information Server (IIS) against a Microsoft Access
database, we need to create a(n) ________.
A) ODBC data source
B) JBDC data source
C) OLE DB data source
D) LAMP data source
E) WAMP data source
73) When using an ODBC data source with IIS and Microsoft Access, we should use ________.
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
74) 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 ________.
A) AWebPage.htm
B) index.html
C) MyWebPage.htm
D) MyWeb.htm
E) MyPage.htm
75) When using Microsoft Access and IIS, we can create Web pages that access the database
using the popular ________ scripting language.
A) PHP
B) DSN
C) DSP
D) JSN
E) PSJ
76) A(n) ________ is a program stored within the DBMS that is invoked by the DBMS when a
specified event occurs.
77) A(n) ________ is similar to a computer program subroutine or function, but it is stored
within the database.
78) Even when using Microsoft Access and IIS, we should still use a basic Web home page
named ________.
79) When using Microsoft Access and IIS, a good basic ASCII text editor for producing HTML
is ________.
80) What is a stored procedure?
81) What is a trigger?
82) Briefly describe three types of triggers.
83) What is a three-tier architecture?
84) Describe how to use Microsoft Access and IIS in Web database processing applications.