ISE 224 Chapter 11

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

c

ADO.NET in-memory databases are called ________. A) adoBases B) adoDatabases C) DataSets D) dotNetDatabases

c

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

a

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

c

How does an application determine the level of ODBC conformance available from a driver? A) The application makes a call to the driver manager. B) The application makes a call to the data source. C) The application makes a call to the driver. D) The developer must determine the level of conformance before the application is written.

b

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

d

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

Support for a scrollable cursor is a sign of what type of conformance in a DBMS driver? A) Level 1 API B) Extended SQL Grammar C) Core API D) Level 2 API

c

Support for subqueries and creating indexes is a sign of what type of SQL grammar conformance in a DBMS driver? A) Level 2 API Grammar B) Minimum SQL Grammar C) Core SQL Grammar D) Extended SQL Grammar

c

The ________ processes ODBC requests and submits specific SQL statements to a given type of data source. A) driver manager B) ADO C) driver D) source converter

c

The actions that an object can perform are called ________. A) procedures B) collections C) methods D) properties

d

The characteristics of an object are called ________. A) classes B) collections C) methods D) properties

a

The intermediary between the application and the DBMS drivers in the ODBC architecture is the ________. A) driver manager B) DBMS C) ODBC driver D) data source

false

True or false, ADO is accessible for languages such as C++ and C#, but not Visual Basic or scripting languages

true

True or false, ADO provides access to OLE functionally to programming languages that ordinarily could not access OLE functions

true

True or false, ADO was (and still is) frequently used for database applicaitons

false

True or false, ADO.NET is a completely new product, with no connection to ADO except the similar name

true

True or false, ADO.NET provides the capability to create and process in-memory databases called DataSets

true

True or false, HTML is an application of a document markup language called Standard Generalized Markup Language (SGML)

true

True or false, HTML is defined by the World Wide Web Consortium (W3C)

false

True or false, JDBC drivers only exist for a limited number of DBMS products at this time

true

True or false, JDBC-ODBC bridge drivers resolve inconsistencies between Java and C/C++ to allow Java access to ODBC data sources

true

True or false, JSP pages are automatically re-compiled if the uncompiled JSP page is newer than the compiled version of the page

false

True or false, Java Server Pages (JSP) can run only on Linux or Unix servers

true

True or false, Java programs are compiled into machine-independent bytecode

false

True or false, Java programs that access a database from an applet must use a Type 2 JDBC driver

false

True or false, MySQL does not have facilities for generating XML documents from database data

false

True or false, ODBC has not had practical success, but has shown great potential for future development

true

True or false, ODBC stands for Open Database Connectivity

true

True or false, ODBC works with table-like data sources such as relational databases and spreadsheets

true

True or false, OLE DB can act as a wrapper for (covers) database native libraries so that the functionality can be provided by OLE

true

True or false, OLE DB can be used to access ODBC data sources

true

True or false, OLE DB is an object-oriented interface

true

True or false, OLE DB objects are COM objects

true

True or false, Oracle requires the use of Java for generating XML documents from database data

true

True or false, PHP code is executed on a server and can generate HTML code that is sent to the client computer

true

True or false, SOAP was originally an XML-based standard for providing remote procedure calls over the Internet

true

True or false, XML documents can be automatically generate from database data

false

True or false, XML provides a standardized, non-customizable way to describe the content of a document

false

True or false, a common default Web page name recognized by most Web servers is FirstPage.html

true

True or false, a multiple-tier ODBC driver may reformat an SQL request, but it does not actually process the SQL statement

true

True or false, an ADO.NET DataSet has all the characteristics, features, and functions of a regular database

false

True or false, an ADO.NET DataSet is connected to databases

false

True or false, an ADO.NET dataset can have primary and foreign keys, but ADO.NET does not support referential integrity

true

True or false, an ADO.NET dataset can only be used with optimistic locking

true

True or false, an OLE DB service provider accepts data from an OLE DB tabular data provider

false

True or false, an applet is a Java bytecode program that executes on the Web server

true

True or false, applet bytecode is sent to the user's computer and is invoked using the HTTP protocol

true

True or false, basic web pages are created using Hypertext Markup Language (HTML)

false

True or false, database processing and document processing are unrelated to one another

true

True or false, every DBMS product has an application programming interface (AP)

false

True or false, every DBMS product uses the same API

true

True or false, if a server is using a Microsoft Windows operating system, it is usually running Internet Information Server (IIS) as its Web server

false

True or false, if the web server and the DBMS are running on the same server, the system has a three-tier architecture

true

True or false, in ODBC, the amount of work that the driver must do is largely determined by the degree of SQL-compliance of the data source

false

True or false, in OLE DB, a RecordSet is a more abstract representation of a rowset

false

True or false, in OLE DB, all of an object's properties must be exposed in all interfaces, but not all methods have to be exposed

true

True or false, in general, the best type of ODBC data source to define for a Web application is a system data source

false

True or false, in the 1990s, the database community and the document processing community created a standard called Expandable Markup Language (XML)

false

True or false, java programs tend to execute faster than programs compiled into machine-dependent code because the Java virtual machine only has to interpret the bytecode

true

True or false, object classes have properties that represent characteristics of the objects in the class

true

True or false, once an ADO.NET dataset is constructed, its contents can be formatted as an XML document with a single command

true

True or false, one important result of OLE DB is that data does not have to be moved or converted from one form to another

true

True or false, one of the properties of all the collections is Count, which is the number of objects in the collection

false

True or false, only open source products may be used in conjunction with JDBC

true

True or false, the SQL Server statement SELECT...FROM XML RAW tells SQL Server to place the data values from the columns in the table into XML elements

false

True or false, the first step in using a JDBC driver is to establish a connection

false

True or false, the most widely used Web server for all operating systems is Internet Information Services (IIS)

true

True or false, to use JDBC, programs must be written in Java

false

True or false, type 2 JDBC drivers access ODBC data sources over a network

false

True or false, type 4 JDBC drivers translate JDBC calls into a DBMS-independetn network protocol

true

True or false, with ODBC, a database and the DBMS that processes it are identified by the data source

false

True or false, with ODBC, a file data source is available only to the user that created it

false

True or false, with ODBC, only a single driver is needed to handle all data source types, such as Oracle, DB2, and Access

true

True or false, with ODBC, the driver manager serves as an intermediary between the application and the DBMS drivers

b

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

a

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

c

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

d

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

c

Which does the ODBC standard not define a means of doing? A) Start transactions B) Rollback transactions C) Read a Microsoft Word document D) Issue SQL commands

b

Which of the following can only interact with relational database and table-like data structures? A) OLE DB B) ODBC C) ASP D) ADO

d

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) Both B and C are correct

c

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) Converts the data source into an SQL-compliant data structure

d

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

d

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.

d

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.

a

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.

b

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.

c

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

c

Which of the following is true about ODBC? A) ODBC has experienced little practical success. B) ODBC requires developers to have a thorough knowledge of many DBMS native libraries. C) ODBC can be used to access data from spreadsheets. D) ODBC has an object-oriented interface.

a

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.

a

Which standard interface in OLE DB is invoked to declare a forward-only cursor? A) IRowSet B) IAccessor C) IColumnsInfo D) adXact

c

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

c

A Java virtual machine is actually a ________. A) program compiler B) JDBC data source C) bytecode interpreter D) JDBC driver

a

A ________ data source can be shared among database users as long as they have the same DBMS driver and privilege to access the database. A) file B) common C) user D) system

b

A data source that is fully SQL-compliant would use what type of DBMS driver? A) Single-tier B) Multiple-tier C) SQL transform D) Text-based

d

A data source that is local to a single computer and can be used by the operating system and any user on that computer is called a ________ data source. A) file B) user C) shared D) system

b

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

a

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

c

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

a

OLE DB breaks the features and functions of a DBMS into what type of objects? A) COM B) JSP C) MTS D) ODBC


Set pelajaran terkait

RNSG 1413 - exam 1 chapter review questions & case studies

View Set

ECON 206 Monopolisitic Competition

View Set

Chapter 3: The Big Five Personality Traits

View Set

Urinary Chapter 47-49 prep U questions

View Set