ACC 366

which of the following statements would be used to change a value in a record of a table

UPDATE

Which of the following statements would be used to drop a column from the table?

ALTER TABLE

Which of the following is part of a DDL statement

CREATE

which of the following is part of a DML statement

SELECT

which of the following is an invalid SQL statement

SELECT *, FROM employee;

which of the following is an invalid SQL keyword

SE_LECT

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

which of the following is not true

data marts typically have broader focus than data warehouses

data warehouse requirements can be refined and/or expanded following

data warehouse use data warehouse employment creating ETL infrastructure

What is the result of the following SQL query: SELECT ename, esalary * 1.1 FROM employee;

for each employee, the query will display the name and the salary increased by 10%

implicit changes of data warehouse requirements are permitted during

implicit changes of requirements are not permitted

which of the following is not a part of the data warehouse requirements step

logical modeling

operational queries are typically issued

more often than analytical queries

operational queries typically process

small amounts of data than analytical queries

What is the result of the following SQL query: SELECT ename FROM employee WHERE esalary = (SELECT MAX(salary) FROM employee);

the query displays the name of the employee or employees with the highest salary

What is the result of the following SQL statement: UPDATE employee SET salary = 50000 WHERE salary < 50000;

the statement increases salary to 50,000 for each employee whose salary is below 50,000

creating ETL infrastructure includes creating necessary procedures and code for

transformation of the extracted data, so that its quality is assured and its structure conforms to the structure of the modeled and implemented data warehouse

Data time-horizon is

typically shorter in operational systems than in analytical systems