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