Question 1

What is a three-tier architecture?

Accepted Answer

The term tier refers to each different c

Question 2

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

Accepted Answer

A) INSERT 
B) SELECT 
C) UPDATE 
D) DELETE 
E) Both B and D 
A) INSERT 
B) SELECT 
C) UPDATE 
D) DELETE 
E) Both B and D

Question 3

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

Accepted Answer

The answer of A commonly used Web server on servers...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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?

Accepted Answer

If a Web server is running the Windows o

Question 7

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

Accepted Answer

applicatio

Question 8

After trying to open a connection,a PHP connection to a DBMS needs to:

Accepted Answer

A) open the connection. 
B) test the connection. 
C) query the database. 
D) process the query results. 
E) close the connection. 
A) open the connection. 
B) test the connection. 
C) query the database. 
D) process the query results. 
E) close the connection.

Question 9

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

Accepted Answer

The answer of Even when using Microsoft Access and IIS,we...

Question 10

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

Accepted Answer

The answer of A(n)________ is similar to a computer program...

Question 11

ODBC stands for ________.

Accepted Answer

Open Datab

Question 12

Every DBMS product uses the same API.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

The answer of A(n)________ is a program stored within the...

Question 14

Which of the following is true about stored procedures?

Accepted Answer

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

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

Accepted Answer

A) The associated DBMS 
B) The database 
C) The driver 
D) The operating system 
E) The network platform 
A) The associated DBMS 
B) The database 
C) The driver 
D) The operating system 
E) The network platform

Question 16

Every DBMS product has an API,which stands for:

Accepted Answer

A) All Program Interpreter. 
B) All Program Interface. 
C) Application Programming Interpreter. 
D) Application Programming Interface. 
E) None of the above 
A) All Program Interpreter. 
B) All Program Interface. 
C) Application Programming Interpreter. 
D) Application Programming Interface. 
E) None of the above

Question 17

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

Accepted Answer

A) PHP 
B) DSN 
C) DSP 
D) JSN 
E) PSJ 
A) PHP 
B) DSN 
C) DSP 
D) JSN 
E) PSJ

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

The answer of When using Microsoft Access and IIS,a good...

Question 20

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

Accepted Answer

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

What is a three-tier architecture?

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

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

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

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

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?

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

After trying to open a connection,a PHP connection to a DBMS needs to:

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

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

ODBC stands for ________.

Every DBMS product uses the same API.

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

Which of the following is true about stored procedures?

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

Every DBMS product has an API,which stands for:

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

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

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

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

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

Exam 7: Database Processing Applications

What is a three-tier architecture?

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

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

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

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

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?

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

After trying to open a connection,a PHP connection to a DBMS needs to:

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

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

ODBC stands for ________.

Every DBMS product uses the same API.

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

Which of the following is true about stored procedures?

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

Every DBMS product has an API,which stands for:

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

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

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

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

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters