Deck 7: Database Processing Applications

Question 1

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

Answer 1

True

Question 2

A BEFORE trigger is called by the DBMS before reading data.

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

Every DBMS product uses the same API.

Question 8

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

Question 9

ODBC stands for Open Database Connectivity.

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

ODBC only works with Microsoft products.

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

Question 22

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

Question 23

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).

Question 24

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

Question 25

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

Question 26

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

Question 27

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).

Question 28

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

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

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) All of the above are true about stored procedures.

Question 34

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

Question 35

The ODBC standard defines a way to:

A) start transactions.
B) rollback transactions.
C) create a connection.
D) issue SQL commands.
E) All of the above

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

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

A) .
B) [php and php].
C) (php and php).
D) .
E) and .

Question 42

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.

Question 43

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.

Question 44

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

A) OBDC data source.
B) JBDC data source.
C) OLE DB data source.
D) LAMP data source.
E) WAMP data source.

Question 45

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.

Question 46

XML stands for:

A) Experimental Markup Language.
B) Existential Markup Language.
C) Extendable Markup Language.
D) Extensible Markup Language.
E) Extensible Marketing Language.

Question 47

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

Question 48

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.

Question 49

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

Question 50

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.

Question 51

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

Question 52

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.

Question 53

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.

Question 54

XML allows a programmer to:

A) define elements.
B) use only predefined elements.
C) use only "shrink-warped," purchased programs.
D) Both A and B
E) All of the above

Question 55

ODBC stands for ________.

Question 56

The first PHP element to be created is the:

A) Command object.
B) Connection.
C) Errors collection.
D) Parameters collection.
E) RecordSet object.

Question 57

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

Question 58

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

Question 59

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

Question 60

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.

Question 61

Briefly describe PHP.

Question 62

What is the NetBeans IDE?

Question 63

What is a trigger?

Question 64

What is XML,and why is it useful?

Question 65

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

Question 66

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

Question 67

XML stands for ________.

Question 68

What is a stored procedure?

Question 69

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

Question 70

Briefly describe three types of triggers.

Question 71

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

Question 72

What is a three-tier architecture?

Question 73

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

Question 74

NetBeans is a(n)________.

Question 75

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?

Question 76

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

Question 77

How can XML be used with a DBMS?

Question 78

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

Question 79

Even when using Microsoft Access and IIS,we should still use a basic Web home page named ________.

Question 80

Define and briefly describe the function of ODBC.