DBMS 110 Final Exam - BCIS 4660

snowflake

A _____ schema is a type of star schema in which dimension tables can have their own dimension tables.

False

A client-side extension is a program that interacts directly with the web server to handle specific types of requests. True or False?

True

A document type definition (DTD) can be referenced by many Extensible Markup Language (XML) documents of the same type. True or False?

True

A good API makes it easy to develop a program by providing all of the building blocks. True or False?

True

A plug-in is an external application that is automatically invoked by a web browser when needed. True or False?

True

A star schema is designed to optimize data query operations rather than data update operations. True or False?

alias

A(n) _____ is an alternate name given to a column or table in any SQL statement.

False

An alias cannot be used when a table is required to be joined to itself in a recursive query. True or False?

False

An application programming interface (API) uses script files that perform specific functions based on the client's parameters that are passed to the web server. True or False?

web-to-database middleware

Another name for a database server-side extension program is _____.

False

By default, the fact table's primary key is always formed by combining the superkeys pointing to the dimension tables to which they are related. True or False?

True

Decision support data is a snapshot of the operational data at a given point in time. True or False?

JOIN ON

If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause.

facts

In a star schema, attributes are often used to search, filter, or classify _____.

fact

In a typical star schema, each dimension record is related to thousands of _____ records.

True

Multidimensional data analysis techniques include advanced computational functions. True or False?

False

Normalizing fact tables improves data access performance and saves data storage space. True or False?

True

Numeric functions take one numeric parameter and return one value. True or False?

False

Queries against operational data typically are broad in scope and high in complexity. True or False?

True

ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework. True or False?

True

Whether you purchase online or by standing in line, the system-level transaction details are essentially the same, and they require the same basic database structures and relationships. True or False?

API

A(n) _____ can use a shared connection to the database instead of creating a new one every time.

outer

A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.

natural

A(n) _____ join will select only the rows with matching values in the common attribute(s).

True

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. True or False?

Operations within parentheses

According to the rules of precedence, which of the following computations should be completed first?

True

Advanced OLAP feature become more useful when access to them is kept simple. True or False?

False

All SQL commands must be issued on a single line. True or False?

OLE-DB

Based on Microsoft's Component Object Model (COM), _____ is database middleware that adds object-oriented functionality for access to relational and nonrelational data.

data warehouse

Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) _____.

True

Business intelligence (BI) architecture is composed of data, people, processes, and technology working together to facilitate and enhance a business's management and governance. True or False?

True

Business intelligence is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom. True or False?

False

Comparison operators cannot be used to place restrictions on character-based attributes. True or False?

False

Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS. True or False?

True

Database connectivity software is also known as database middleware because it interfaces between the application program and the database. True or False?

HTTP GET

Each time an end user clicks a hyperlink, the browser generates a(n) _____ page request that is sent to the designated web server using the TCP/IP Internet protocol.

False

HTML is designed to facilitate the extraction and manipulation of data from structured documents over the Internet. True or False?

144

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

data warehouse

In business intelligence framework, data are captured from a production system and placed in _____ on a near real-time basis.

many-to-one (M:1)

In star schema representation, a fact table is related to each dimension table in a _____ relationship.

DataSet

In the ADO.NET framework, the _____ is a disconnected, memory-resident representation of the database.

driver manager

In the ODBC architecture, a(n) _____ is in charge of managing all database connections.

False

Master data management's main goal is to provide a partial and segmented definition of all data within an organization. True or False?

Windows

ODBC works on the _____ operating system.

JDBC

One of the advantages of _____ over other middleware is that it requires no configuration on the client side.

False

Operational data and decision support data serve the same purpose. True or False?

transaction

Operational data are commonly stored in many tables, and the stored data represents information about a given _____ only.

False

Oracle users can use the Access QBE (query by example) query generator. True or False?

True

Relational data warehouses use the star schema design technique to handle multidimensional data. True or False?

True

SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT. True or False?

True

String comparisons are made from left to right. True or False?

True

The ANSI SQL standards are also accepted by the ISO. True or False?

False

The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE. True or False?

True

The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause. True or False?

True

The CUBE extension enables you to get a subtotal for each column listed in the expression, in addition to a grand total for the last column listed. True or False?

Core

The ODBC API standard defines three levels of compliance: _____, Level-1, and Level-2, which provide increasing levels of functionality.

COUNT

The SQL aggregate function that gives the number of rows containing non-null values for a given column is _____.

COMMIT

The SQL command that allows a user to permanently save data changes is _____.

DEFAULT

The _____ command defines a default value for a column when no value is given.

decision support database

The _____ schema must support complex (non-normalized) data representations.

dimensions

The basic star schema has four components: facts, _____, attributes, and attribute hierarchies.

True

The benefits of the web as a data access platform arise from its cross-platform functionality and the simplicity of its interface. True or False?

True

The conditional LIKE must be used in conjunction with wildcard characters. True or False?

False

The effects of bad database design, implementation, and management are magnified in an environment in which the number of transactions is less than one hundred. True or False?

True

The first line of an XML document represents the document declaration, and it is mandatory. True or False?

they cause a resource bottleneck since they have to execute separately for each user request

The main disadvantage of using CGI scripts is that:

True

The only time the client and server computers communicate is when the client requests a page and the server sends the requested page to the client. True or False?

LIKE

The special operator used to check whether an attribute value matches a given string pattern is _____.

True

The use of HTML does not equip a web browser with computational abilities beyond formatting output text and accepting form field inputs. True or False?

display it in a standard formatted way

The web browser's job is to interpret the HTML code that it receives from a web server and to:

An API error can bring down the entire web server.

What is a disadvantage of using an API web-server interface?

old-style join

What type of command does this SQL statement use? SELECT P_CODE, P_DESCRIPT, P_PRICE_V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE=VENDOR. V_CODE

True

When an end user uses a web browser to dynamically query a database, the client browser actually requests a web page from the web server. True or False?

< >

Which comparison operator indicates a value is not equal?

MicroStrategy

Which of the following is a personal analytics vendor for BI applications?

Common Gateway Interface (CGI)

Which of the following is a well-defined web-server interface?

SELECT DISTINCT V_CODE FROM PRODUCT;

Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?

False

You cannot insert a row containing a null attribute value using SQL. True or False?

improve processing capabilities of a browser

You must use plug-ins and other client-side extensions to:

Data visualization tools

_____ are in charge of presenting data to the end user in a variety of ways.

Data marts

_____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses.

Java

_____ is an object-oriented programming language developed by Sun Microsystems that runs on top of web browser software.

Portals

_____ provide a unified, single point of entry for information distribution.

Business intelligence

_____ tools focus on the strategic and tactical use of information.