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