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