Midterm Exam - MIS430

Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query?

DISTINCT

Which of the following is NOT true:

Data marts typically have more subjects of analysis than data warehouse

A data mart differs from a data warehouse in these ways except ____

Data warehouses receive their data from the data marts

Which of the following cannot be done using the CONSTRAINT phrase?

Define an attribute to be NOT NULL

_____ contain descriptions of business, organization, or enterprise to which the subject of analysis belongs

Dimension Tables

Data warehouses use a(n) _____

Dimensional database

Which of the following is not a standard data type used in SQL?

Text

Given the relations: STUDENT (SID, StudentName, Major, AdvisorID) ADVISOR (AdvisorID, AdvisorName, Office, Phone) Such that each student is assigned to one advisor, which of the following is true?

AdvisorID is a foreign key

Which of the following is likely to be a user of a bank's data warehouse

Bank's CEO

The purpose of the source system is:

Both the original operational purpose and as a source system for the data warehouse

Operational queries are typically issued:

By more users than analytical queries

A composite primary key can be defined using the CONSTRAINT phrase in which SQL command?

CREATE TABLE

Conditions after the WHERE keyword require single quotes around the values for columns that have which data type?

Char

INSERT INTO VALUES requires single quotes around the values for columns that have which data type?

Char

Which of the following data types used in SQL would define a fixed-length text field of 10 characters?

Char(10)

Given the tables STUDENT (StudentID, StudentName, AdvisorID) ADVISOR (AdvisorID, AdvisorName, Office, Phone) Which of the following SQL statements would be used to implant a join between the 2 tables?

FROM STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID

Star schemas have a _____ at the center of the star

Fact table

_____ contain measures related to the subject of analysis

Fact tables

Given the table STUDENT(StudentName, Name, Advisor), which of the following SQL statements would be used to add new student data to the STUDENT table?

INSERT INTO STUDENT VALUES (123, 'Jones', 'Smith');

In SQL Server, the starting value of a surrogate key is called ____

Identity Seed

Operational queries are typically issued:

More often than analytical queries

Typically, in a star schema all _____ are given a simple, non-composite system-generated primary key, also called a surrogate key

Dimension tables

Which of the following is not true about primary keys?

Primary keys must be a single attribute.

Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), what is the standard SQL query phrase to retrieve the Name and Phone Number of customers?

SELECT Name, PhoneNum

Operational queries typically process:

Smaller amounts of data than analytical queries

In a typically properly-designed star schema, the number of records/rows in any of the dimension tables is:

Smaller than in the fact table

The dimensional schema is often referred to as the

Star schema

If students lost internet connection during a quiz or exam, or got kicked out of BB before completing the quiz or exam

Student may NOT request a second attempt or extra grades.

If student's laptop started malfunctioning, stopped working, or was slow

Students may NOT request any make-up or extensions

Which of the following is NOT true of surrogate keys?

They are meaningful to the users.

Data time-horizon is:

Typically, shorter in operational systems than in analytical systems

In a relational database design, all relationships are expressed by ____

creating a foreign key

A data warehouse database differs from an operational database because _____

data warehouse data are often stored in a dimensional database

Which of the following data types used in SQL would define a numeric field of the pattern 99.99?

Numeric (4,2)

A Business Intelligence (BI) reporting system that uses extensions to SQL is _____

OLAP

OLAP stands for _____

Online Analytical Processing

The order of columns returned by a SQL SELECT statement is determined by ___

Order they are listed in following SELECT

A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called _____

referential integrity constraint