77) In general, for Web applications it is best to create what type of data source on the Web
server?
A) File
B) User
C) Shared
D) System
78) OLE DB breaks the features and functions of a DBMS into what type of objects?
A) COM
B) JSP
C) MTS
D) ODBC
79) Which of the following is not true about OLE DB?
A) Scripting languages can access OLE DB.
B) OLE DB is object-oriented.
C) OLE DB can access ODBC data sources.
D) OLE DB can access non-relational data sources.
80) The characteristics of an object are called ________.
A) classes
B) collections
C) methods
D) properties
81) The actions that an object can perform are called ________.
A) procedures
B) collections
C) methods
D) properties
82) An important method of a collection is a(n) ________, which can be used to pass through or
otherwise identify the items in the collection.
A) iterator
B) identifier
C) converter
D) transformer
83) A set of objects and the properties and methods that they expose are known as a(n)
________.
A) provider
B) interface
C) implementation
D) instantiation
84) Which of the following is a type of OLE DB data provider?
A) Relational data provider
B) Method provider
C) Sequential data provider
D) Tabular data provider
85) Which standard interface in OLE DB is invoked to declare a forward-only cursor?
A) IRowSet
B) IAccessor
C) IColumnsInfo
D) adXact
86) Which of the following is not true of ADO?
A) ADO is a simple object model for OLE DB data consumers.
B) ADO can be used from VBScript and JavaScript.
C) ADO is harder to understand than OLE DB.
D) ADO can be called from languages such as Visual Basic.NET, Java and C#.
87) Which of the following is not true about ADO.NET?
A) It is an improved and expanded version of ADO.
B) It facilitates the transformation of XML documents to and from relational database constructs.
C) It provides the ability to create and process in-memory databases.
D) Microsoft does not supply a data provider for Oracle database.
88) ADO.NET in-memory databases are called ________.
A) adoBases
B) adoDatabases
C) DataSets
D) dotNetDatabases
89) An ADO.NET Data Provider is a(n) ________ that provides ADO.NET services.
A) class library
B) windows application
C) Web application
D) XML service
90) Which of the following is not true about ADO.NET DataSets?
A) They can have multiple tables and relationships.
B) They can have foreign keys and surrogate keys.
C) They can support referential integrity actions.
D) Operations performed on DataSets are also performed on the data on disk.
91) Which of the following is true of JDBC?
A) Programs must be written in Java.
B) JDBC only works with open-source products.
C) JDBC is only available for Unix-like operating systems, such as Linux.
D) JDBC is actually a DBMS.
92) What type of JDBC driver is known as a JDBC-ODBC bridge?
A) Type 1 driver
B) Type 2 driver
C) Type 3 driver
D) Type 4 driver
93) What type of JDBC driver translates JDBC calls into DBMS-independent network protocols?
A) Type 1 driver
B) Type 2 driver
C) Type 3 driver
D) Type 4 driver
94) What type of JDBC driver connects to the native API of the DBMS?
A) Type 1 driver
B) Type 2 driver
C) Type 3 driver
D) Type 4 driver
95) What type of JDBC driver translates JDBC calls into DBMS-specific network protocols?
A) Type 1 driver
B) Type 2 driver
C) Type 3 driver
D) Type 4 driver
96) A Java virtual machine is actually a ________.
A) program compiler
B) JDBC data source
C) bytecode interpreter
D) JDBC driver
97) Which of the following is not true about bytecode interpretation?
A) It may be performed on the client or the server.
B) Only one bytecode interpreter is needed for all machine architectures.
C) It is slower than running a program compiled into machine code.
D) It increases portability.
98) Applet bytecode is transmitted to the user’s computer via ________.
A) the JDBC driver
B) the Java virtual machine
C) HTTP
D) the bytecode interpreter
99) A(n) ________ is a Java program that is interpreted and executed by a bytecode interpreter
on the Web server.
A) applet
B) Java virtual machine
C) servlet
D) JDBC translator
100) In a three-tier or n-tier architecture, which type of JDBC driver can be used if the DBMS
and the Web server are running on the same computer?
A) Only Type 1 and Type 2
B) All four Types
C) Only Type 3 and Type 4
D) Only Type 2 and Type 3
101) The first step in using a JDBC driver is to ________.
A) establish a connection to the database
B) load the driver
C) create a statement
D) call the DriverManager object
102) The coding for Java Server Pages must be written in ________.
A) Java
B) JavaScript
C) C++
D) Both A and B are correct
103) Which of the following is true about JSP code?
A) It must be written in Java or JavaScript.
B) It does not have access to HTTP functionality.
C) It must be coded as complete Java classes and methods.
D) It is automatically converted into Java servlets.
104) Which of the following is not true about Tomcat?
A) It is a servlet processor.
B) It can be used as a standalone Web server.
C) It is often used in conjunction with Apache.
D) It is an applet processor.
105) JSP pages ________.
A) are automatically compiled by the servlet processor as needed
B) are required to be compiled by the developer before being made public
C) are automatically checked for syntax errors by the servlet as they are written
D) uses more memory than CGI files
106) As compared to CGI files, JSP pages ________.
A) are less memory efficient
B) require more processor time
C) execute faster
D) keep more copies of a given page in memory
107) 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 ?>
108) The first PHP element to be created is the ________.
A) Command object
B) Connection object
C) Errors collection
D) Parameters collection
109) The final step of using a PHP connection to a DBMS is to ________.
A) open the connection
B) test the connection
C) close the connection
D) process the query results
110) PDO stands for ________.
A) PHP Data Objects
B) PHP Design Objects
C) Personal Data Objects
D) Personal Design Objects
111) HTML is an application of ________.
A) SGML
B) XML
C) SOAP
D) XSLT
112) XML stands for ________.
A) Experimental Markup Language
B) Extendable Markup Language
C) Extensible Markup Language
D) Active X-control Markup Language
113) Which of the following is not true about XML?
A) It is a subset of SGML.
B) Additional standards and capabilities have been added to XML processing.
C) It is a hybrid of document processing and database processing.
D) It is a subset of HTML.
114) SOAP originally stood for ________.
A) Simple Operational Application Protocol
B) Standard Operational Application Protocol
C) Simple Object Application Protocol
D) Simple Object Access Protocol
115) SOAP has become ________.
A) just a name, not an acronym
B) a standard protocol for sending any type of message
C) an old technology replaced by XML
D) Both A and B are correct
116) The SQL Server statement
SELECT *
FROM Table01
FOR XML RAW
tells SQL Server to place the data values from the columns in the table into XML ________.
A) elements
B) attributes
C) elements or attributes, as chosen by SQL Server
D) elements or attributes, as designated by the XML Schema
117) Explain the relationships among native DBMS libraries, ODBC, OLE DB, ADO, and
ADO.NET and why each led to the development of the next.
118) Briefly describe the components of the ODBC architecture.
119) What are the different types of conformance levels within the ODBC standard, and why do
they exist?
120) Why is the decomposition of the features and functions of a DBMS into different objects an
advantage for OLE DB?
121) What is ADO.NET and what is an ADO.NET DataSet?
122) Distinguish among the four types of JDBC drivers.
123) Compare and contrast servlets and applets.
124) Explain the process by which JSP pages are compiled.
125) Briefly describe PHP.
126) Briefly describe NetBeans.
127) What is XML, and why is it significantly better than HTML?
29
128) Give an example of how XML can be used with a DBMS.