CIS463 Chapter 4 and Quiz 1

How many tables are involved in a self-join?

1

Which of the following abbreviations are most directly associated with the concept of data integration? NLP ETL BPM SSAS

ETL

data manipulation

powerful SQL operations for retrieving and modifying data

data structure

tables (relations), rows, columns

what do columns correspond with?

with attributes

The query language used for querying XML documents by specifying path expressions is called _________.

xPath

In which of the following situations would one have to use an outer join in order to obtain the desired results? A report is desired that lists all customers and the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero). A report is desired that lists all customers and the total of their orders. A report is desired that lists all customers who placed an order. There is never a situation that requires only an outer join.

A report is desired that lists all customers and the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero).

requirements for a table to qualify as a relation

It must have a unique name. Every attribute value must be atomic (not multivalued, not composite). Every row must be unique (can't have two rows with exactly the same values for all their fields). Attributes (columns) in tables must have unique names. The order of the columns must be irrelevant. The order of the rows must be irrelevant.

The standard language for querying OLAP cubes is called _______. MDX NLP XML SQL

MDX

In the AdventureWorks database structure, all of the following are types of business entities EXCEPT: a bike store a person a product a vendor

a product

The following code would include: Select Customer_T.CustomerID, CustomerName, OrderID From Customer_T LEFT OUTER JOIN Order_T ON Customer_T.CustomerID = Order_T.CustomerID; only rows that don't match both Customer_T and Order_T Tables. all rows of the Customer_T Table regardless of matches with the Order_T Table. only rows that match both Customer_T and Order_T Tables. all rows of the Order_T Table regardless of matches with the Customer_T Table.

all rows of the Customer_T Table regardless of matches with the Order_T Table.

The following code would include: Select Customer_T.CustomerID, CustomerName, OrderID From Customer_T RIGHT OUTER JOIN Order_T ON Customer_T.CustomerID = Order_T.CustomerID; only rows that match both Customer_T and Order_T Tables. all rows of the Order_T Table regardless of matches with the Customer_T Table. only rows that don't match both Customer_T and Order_T Tables. all rows of the Customer_T Table regardless of matches with the Order_T Table.

all rows of the Order_T Table regardless of matches with the Customer_T Table.

domain constraints

allowable values for an attribute

As opposed to the typical transaction/operational processing of traditional information systems, DSS and BI technologies are more concerned with _________ processing.

analytical

A join in which the joining condition is based on equality between values in the common columns is called a(n): unilateral join. equi-join. both equi-join and natural join. natural join.

both equi-join and natural join

A join operation: brings together data from two different fields. is used to combine indexing operations. causes two tables with a common domain to be combined into a single table or view. causes two disparate tables to be combined into a single table or view.

causes two tables with a common domain to be combined into a single table or view.

Which of the following is NOT included in this query? SELECT Production.Product.Name, pi1.LocationID, pi1.Quantity FROM Production.ProductInventory pi1 INNER JOIN Production.Product ON pi1.ProductID = Production.Product.ProductID Where Quantity = (select max(quantity) from Production.ProductInventory pi2) correlated subquery multi-table join aggregate function uncorrelated subquery

correlated subquery

A(n) _____________ is a user interface composed of data visualizations that illustrate metrics and measures of business performance as well as key performance indicators..

dashboard

Which of the following involves the process of searching for unknown relationships or information in large databases or data warehouses, using neural computing, predictive analytics, or advanced statistical methods? OLAP data mining scorecards and dashboards ETL

data mining

components of relational model

data structure data manipulation data integrity

Fact and Dimension tables are most associated with ____________. relational databases data warehouses cubes big data

data warehouses

Suppose you create an aggregate query that shows product sales data across sales regions apply? Which of the three major business analytics problem areas are you addressing?

descriptive

In the AdventureWorks data model, a saplesperson is a type of: manager store contact employee vendor contact

employee

what do rows correspond with?

entity instances and with many-to-many relationship instances

what do relations (tables) correspond with?

entity types and with many-to-many relationship types

the following code is an example of a(n): SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T.CustomerID; Full Outer JOIN. subquery. equi-join. Right Outer JOIN.

equi-join

A student can attend five classes, each with a single professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship. one-to-many one-to-one many-to-many strong

many-to-many

date integrity

mechanisms for implementing business rules that maintain integrity of manipulated data

One major advantage of the outer join is that: information is easily accessible. more information is retrieved. the query is easier to write. information's data type changes.

more information is retrieved

entity integrity

no primary key attribute may be null. all primary keys must contain data values

Two different entities have the same primary key. For one of these, the primary key is also a foreign key to the other. What is the cardinality of this relationship? many to one many to many one to many one to one

one to one

The following code would include: SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T.CustomerID; only rows that match both Customer_T and Order_T Tables. all rows of the Order_T Table regardless of matches with the Customer_T Table. all rows of the Customer_T Table regardless of matches with the Order_T Table. only rows that don't match both Customer_T and Order_T Tables.

only rows that match both Customer_T and Order_T Tables.

Which branch of analytics is most concerned with the types of problems that are analyzed using data mining algorithms? descriptive prescriptive predictive preventive

predictive

____________ analytics is the branch that is involved with recommending the "best" choice for a decision maker.

prescriptive

Online Transaction Processing (OLTP) systems handle a company's ______________________. social media presence strategic decision-making processes analytical data warehousing needs routine on-going business

routine on-going business

referential integrity

rules that maintain consistency between the rows of two related tables

The "bag of words" approach to text analytics is based on __________ approaches.

statistical

Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by: using the immediate if statement. using the CASE keyword in a statement. using the IF-THEN-ELSE construct. using a subquery.

using the CASE keyword in a statement