Chapter 7 DB

Ace your homework & exams now with Quizwiz!

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


Related study sets

chapter 13, 14, 16, & 17 study guide

View Set

Test Out Linux Pro 4.3.7 Practice Questions

View Set

Skills Lesson: Proposing Logical Alternatives

View Set

IDS 3138 Cannabis and its impact - Cannabis and the Body Quiz 3 study guide

View Set