Q&A Hero

Q: Operational databases contain a fact table.

Q: Dimensional databases use the star schema.

Q: Dimensional databases are used for analytical data processing.

Q: Operational databases store historical data.

Q: A data mart is a collection of data that addresses a particular component of a functional area of a business.

Q: Problematic data are called dirty data.

Q: Metadata about the data's source, format, assumptions, and constraints are kept in a data warehouse metadata database.

Q: Data warehouses often include data purchased from outside vendors.

Q: Data warehouses also store the data warehouse metadata.

Q: Data warehouse data are frequently denormalized.

Q: Data warehouses are populated with data prepared by data extraction, transformation, and load (ETL) programs.

Q: A data warehouse is a database system that has data, programs, and personnel specialized in Business Intelligence (BI) processing.

Q: Report delivery is more important for data mining than it is for reporting systems.

Q: Business Intelligence (BI) reporting systems summarize the current status of business activities and compare that status with past events, but not with predicted future activities.

Q: Business Intelligence (BI) systems obtain data in three different ways.

Q: Big Data is the name given to the enormous datasets generated by Web 2.0 applications.

Q: The coding for Java Server Pages must be written in ________. A) Java B) JavaScript C) C++ D) Both A and B are correct

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

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

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

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

Q: 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.

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

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

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

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

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

Q: 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.

Q: 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.

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

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

Q: 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.

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

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

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

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

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

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

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

Q: 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.

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

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

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

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

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

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

Q: 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.

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

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

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

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

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

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

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

Q: 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.

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

Q: The SQL Server statement SELECT ...FOR XML RAW tells SQL Server to place the data values from the columns in the table into XML elements.

Q: PHP code is executed on a server and can generate HTML code that is sent to the client computer.

Q: MySQL does not have facilities for generating XML documents from database data.

Q: Oracle requires the use of Java for generating XML documents from database data.

Q: XML documents can be automatically generated from database data.

Q: In the 1990s the database community and the document processing community created a standard called Expandable Markup Language (XML).

Q: HTML is an application of a document markup language called Standard Generalized Markup Language (SGML).

Q: Database processing and document processing are unrelated to one another.

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

Q: HTML is defined by the World Wide Web Consortium (W3C).

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

Q: JSP pages are automatically re-compiled if the uncompiled JSP page is newer than the compiled version of the page.

Q: Java Server Pages (JSP) can run only on Linux or Unix servers.

Q: The first step in using a JDBC driver is to establish a connection.

Q: Java programs that access a database from an applet must use a Type 2 JDBC driver.

Q: Applet bytecode is sent to the user's computer and is invoked using the HTTP protocol.

Q: An applet is a Java bytecode program that executes on the Web server.

Q: Java programs tend to execute faster than programs compiled into machine-dependent code because the Java virtual machine only has to interpret the bytecode.

Q: Java programs are compiled into machine-independent bytecode.

Q: Type 4 JDBC drivers translate JDBC calls into a DBMS-independent network protocol.

Q: Type 2 JDBC drivers access ODBC data sources over a network.

Q: JDBC-ODBC bridge drivers resolve inconsistencies between Java and C/C++ to allow Java access to ODBC data sources.

Q: JDBC drivers only exist for a limited number of DBMS products at this time.

Q: To use JDBC, programs must be written in Java.