Question 1

A PC configured to handle user interface with little or no local storage is called a:

Accepted Answer

A)   server.
B)   fat client.
C)   thin client.
D)   workstation.E) All of the above
F) None of the above

Question 2

Discuss some of the key benefits of three-tier applications.

Accepted Answer

Three-tier applications can lead to seve...

Question 3

Which of the following is an advantage of stored procedures?

Accepted Answer

A)   Data integrity improves when fewer applications access the procedure.
B)   The layers get cleaner.
C)   Stored procedures result in fatter clients.
D)   Performance improves for compiled SQL statements.E) All of the above
F) A) and B) D

Question 4

Business rules logic includes such activities as data validation and identification of processing errors.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is true about three-tier architectures?

Accepted Answer

A)   Less scalable than two-tier
B)   Increased risk
C)   More technological flexibility
D)   All of the aboveE) A) and B)
F) All of the above

Question 6

A(n)________ is a language used for defining XML databases.

Accepted Answer

XML Schema...

Question 7

________ is an XML transformation language for querying relational data as well as XML databases.

Accepted Answer

The answer of ________ is an XML transformation language for...

Question 8

Extensible Markup Language (XML) is:

Accepted Answer

A)   a scripting language that allows the creation of customized tags to enable easier sharing of data across organizations.
B)   a database language.
C)   a product used for database middleware.
D)   none of the above.E) A) and D)
F) B) and C)

Question 9

ODBC is an application programming interface that provides a common language for application programs to access and process an SQL database independent of the particular RDBMS that is accessed.

Accepted Answer

A) True 
 B)False

Question 10

All of the following are common Web server interfaces EXCEPT:

Accepted Answer

A)   Common Gateway Interface (CGI) .
B)   Hypertext Markup Language.
C)   Application Program Interface (API) .
D)   Java servlets.E) A) and B)
F) B) and C)

Question 11

A Web server:

Accepted Answer

A)   is used only to host Web pages.
B)   processes client requests and returns HTML pages to the client.
C)   always contains a database.
D)   is considered to be part of the firewall.E) A) and B)
F) A) and C) B

Question 12

A ________ is a language used for defining XML databases.

Accepted Answer

The answer of A ________ is a language used for...

Question 13

Java servlets execute from within another program and reside on the server.

Accepted Answer

A) True 
 B)False

Question 14

________ is a language used to transform complex XML documents and also to create HTML pages from XML documents.

Accepted Answer

A)   HTML
B)   XSLT
C)   SGI
D)   WSLE) All of the above
F) C) and D)

Question 15

An API is a set of routines that a database server uses to access database objects.

Accepted Answer

A) True 
 B)False

Question 16

PHP is a popular API for MySQL because of all of the following EXCEPT:

Accepted Answer

A)   Microsoft integration.
B)   high performance.
C)   easy to use.
D)   MySQL connectivity built-in.E) C) and D)
F) A) and C)

Question 17

Strippimg an XML document means storing each element of an XML schema in a relational table and using other tables to store the elements.

Accepted Answer

A) True 
 B)False

Question 18

Which if the following is NOT a method for storing XML documents?

Accepted Answer

A)   shredding
B)   use a BLOB or CLOB to store the entire XML file
C)   use an XML native database
D)   convert to textE) A) and B)
F) All of the above

Question 19

Application partitioning gives developers the opportunity to write application code that can later be placed on either a client workstation or a server,depending upon which location will give the best performance.

Accepted Answer

A) True 
 B)False  True

Question 20

SOAP is an insignificant Web standard.

Accepted Answer

A) True 
 B)False

Exam 8: Database Application Development

A PC configured to handle user interface with little or no local storage is called a:

Correct AnswerverifiedShow Answer

Discuss some of the key benefits of three-tier applications.

Correct AnswerverifiedThree-tier applications can lead to seve...View AnswerShow Answer

Which of the following is an advantage of stored procedures?

Correct AnswerverifiedD

Business rules logic includes such activities as data validation and identification of processing errors.

Correct AnswerverifiedShow Answer

Which of the following is true about three-tier architectures?

Correct AnswerverifiedShow Answer

A(n)________ is a language used for defining XML databases.

Correct AnswerverifiedXML Schema...View AnswerShow Answer

________ is an XML transformation language for querying relational data as well as XML databases.

Correct AnswerverifiedShow Answer

Extensible Markup Language (XML) is:

Correct AnswerverifiedShow Answer

ODBC is an application programming interface that provides a common language for application programs to access and process an SQL database independent of the particular RDBMS that is accessed.

Correct AnswerverifiedShow Answer

All of the following are common Web server interfaces EXCEPT:

Correct AnswerverifiedShow Answer

A Web server:

Correct AnswerverifiedB

A ________ is a language used for defining XML databases.

Correct AnswerverifiedShow Answer

Java servlets execute from within another program and reside on the server.

Correct AnswerverifiedShow Answer

________ is a language used to transform complex XML documents and also to create HTML pages from XML documents.

Correct AnswerverifiedShow Answer

An API is a set of routines that a database server uses to access database objects.

Correct AnswerverifiedShow Answer

PHP is a popular API for MySQL because of all of the following EXCEPT:

Correct AnswerverifiedShow Answer

Strippimg an XML document means storing each element of an XML schema in a relational table and using other tables to store the elements.

Correct AnswerverifiedShow Answer

Which if the following is NOT a method for storing XML documents?

Correct AnswerverifiedShow Answer

Application partitioning gives developers the opportunity to write application code that can later be placed on either a client workstation or a server,depending upon which location will give the best performance.

Correct AnswerverifiedTrue

SOAP is an insignificant Web standard.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
Three-tier applications can lead to seve...
View Answer

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
XML Schema...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified