Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
29 Cards in this Set
- Front
- Back
|
The Same database is typically used for OLTP and OLAP applications? True/False
|
False
|
|
|
Which statement best describes the organization of a database used as a data warehouse?
a. All data is stored as raw data from the source b. All warehouse data is static c. Data storage is optimized for entering and modifying data. d. Data storage is optimized for retrieving and analyzing data. |
Data storage is optimized for retrieving and analyzing data.
|
|
|
You need to analyze regional sales for a set of products over time. How should the data be organized in the data warehouse?
a. As multiple two-dimensional tables b. As three-dimensional cube c. As four-dimensional hypercube d. As a raw data heap |
b. As a three-dimensional cube.
|
|
|
A data warehouse is most commonly used to support what type of applications?
a. Decision support systems b. Retail point-of-sale applications c. Website data store d. Data Mining |
a. Decision support systems
or d. Data mining |
|
|
Data mining information that a consumer who buys a computer is also likely to buy one or more applications at the same time is an example of ___?
a. association rules b. sequential patterns c. classification hierarchies d. clustering |
a. association rules
|
|
|
Using data mining to analyze Web usage data to identify categories of users is an example of ____.
a. association rules b. sequential patterns c. classification hierarchies d. clustering |
d. clustering
|
|
|
Data mining relies on analysis of large amounts of data to discover previously unsuspected patterns or rules.
a. True b. False |
a. True
|
|
|
Most data mining tools use Open Database connectivity (ODBC) as an access interface to the data store, limiting them to Oracle, SQL Server, and MySQL only.
a. True b. False |
b. False
|
|
|
How might data mining benefit a national retailer with multiple physical locations?
a. Quickly locate and identify duplicate data for normalization b. Improve performance during onsite customer checkout c. Develop targeted marketing strategies by region d. Calculate sales representative commisions |
c. Develop targeted marketing strategies by region.
|
|
|
What does SQL stand for?
|
Structured Query Language
|
|
|
Which SQL statement is used to extract data from a database?
a. Extract b. GET c. OPEN d. SELECT |
d. SELECT
|
|
|
Which SQL statement is used to update data in a database?
a. SAVE b. SAVE AS c. MODIFY d. UPDATE |
d. UPDATE
|
|
|
Which SQL statement is used to remove data from a database?
a. DELETE b. REMOVE c. COLLAPSE |
a. DELETE
|
|
|
Which SQL statement is used to insert new data in a database?
a. ADD NEW b. ADD RECORD c. INSERT INTO d. INSERT NEW |
c. INSERT INTO
|
|
|
With SQL how do you select a column from "FirstName" from a table named "Persons"?
a. SELECT FirstName FROM Persons b. EXTRACT FirstName FROM Persons c. SELECT Persons.FirstName |
a. SELECT FirstName FROM Persons
|
|
|
With SQL how do you select all the columns from a table named "Persons"?
a. Select [all] FROM Persons b. SELET * FROM Persons c. SELECT Persons d. SELECT *.Persons |
b. SELECT * FROM Persons
|
|
|
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
a. SELECT [all] FROM Persons WHERE FirstName='Peter' b. SELECT * FROM Persons WHERE FirstName<>'Peter' c. SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter' d. SELECT * FROM Persons WHERE FirstName='Peter' |
d. SELECT * FROM Persons WHERE FirstName='Peter'
|
|
|
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
a. SELECT * FROM Persons WHERE FirstName='%a%' b. SLECT * FROM Persons WHERE FirstName LIKE '%a' c. SELECT * FROM Persons WHERE FirstName='a' d. SELECT * FROM Persons WHERE FirstName LIKE 'a%' |
d. SELECT * FROM Persons WHERE FirstName LIKE 'a%'
|
|
|
The OR operator displays a record if ANY conditions listed are true. The AND operator displays record if ALL of the conditions listed are true...
a. True b. False |
a. True
|
|
|
With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
a. SELECT FirstName='Peter', LastName='Jackson' FROM Persons b. SELECT * FROM Persons WHERE FirstName='Peter' AND Lastname='Jackson' c. SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson' |
b. SELECT * FROM Persons WHERE FirstName='Peter' AND Lastname='Jackson'
|
|
|
With SQL, how do you select all the records from a table named "Persons" where the "Last Name" is alphabetically between (and including) "Hansen" and "Petersen"?
a. SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Petersen' b. SELECT * FROM Persons WHERE LastName BETWEEN 'Hensen' AND 'Petersen' c. SELECT LastName>'Hansen' AND LastName<'Petersen' FROM Persons |
b. SELECT * FROM Persons WHERE LastName BETWEEN 'Hensen' AND 'Petersen'
|
|
|
Which SQL statement is used to return only different values?
a. SELECT DIFFERENT b. SELECT DISTINCT c. SELECT UNIQUE |
b. SELECT DISTINCT
|
|
|
Which SQL keyword is used to sort the result-set?
a. SORT b. ORDER c. ORDER BY d. SORT BY |
c. ORDER BY
|
|
|
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
a. SELECT * FROM Persons SORT 'FirstName' DESC b. SELECT * FROM Persons SORT BY 'FirstName' DESC c. SELECT * FROM Persons ORDER BY FirstName DESC d. SELECT * FROM Persons ORDER FirstName DESC |
c. SELECT * FROM Persons ORDER BY FirstName DESC
|
|
|
With SQL, how can you insert a new record into the "Persons" table?
a. INSERT INTO Persons VALUES ('Jimmy', 'Jackson') b. INSERT ('Jimmy', 'Jackson') INTO Persons c. INSERT VALUES ('Jimmy', 'Jackson') INTO Persons |
a. INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
|
|
|
With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
a. INSERT INTO Persons (LastName) VALUES ('Olsen') b. INSERT ('Olsen') INTO Persons c. INSERT INTO Persons ('Olsen') INTO LastName |
a. INSERT INTO Persons (LastName) VALUES ('Olsen')
|
|
|
How can you change "Hansen" into "Nilsen" in the "LastName" in the "Persons" table?
a. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen' b. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen' c. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen' d. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen' |
d. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
|
|
|
With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
a. DELETE FROM Persons WHERE FirstName = 'Peter' b. DELETE FirstName='Peter' FROM Persons c. DELETE ROW FirstName='Peter' FROM Persons |
a. DELETE FROM Persons WHERE FirstName = 'Peter'
|
|
|
With SQL, how can you return the number of records in the "Persons" table?
a. SELECT COUNT() FROM Persons b. SELECT COLUMNS() FROM Persons c. SELECT COLUMNS(*) FROM Persons d. SELECT COUNT(*) FROM Persons |
d. SELECT COUNT(*) FROM Persons
|
