Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
Section 1
1. A view can contain group functions. True or False?Mark for Review
(1) Points
True (*)
False
2. Given the following CREATE VIEW statement, what data will be returned? CREATE OR REPLACE VIEW emp_dept
AS SELECT SUBSTR(e.first_name,1,1) ||' '||e.last_name emp_name,
e.salary,
e.hire_date,
d.department_name
FROM employees e, departments d
WHERE e.department_id = d.department_id
AND d.department_id >=50;Mark for Review
(1) Points
First character from employee first_name concatenated to the last_name, the salary, the hire_date and department_id of all employees working in department number 50 or higher.
First character from employee first_name concatenated to the last_name, the salary, the hire_date and department_id of all employees working in department number 50.
First character from employee first_name concatenated to the last_name, the salary, the hire_date and department_name of all employees working in department number 50.
First character from employee first_name concatenated to the last_name, the salary, the hire_date and department_name of all employees working in department number 50 or higher. (*)
3. A view can contain a select statement with a subquery. True or False?Mark for Review
(1) Points
True (*)
False
4. What is one advantage of using views?Mark for Review
(1) Points
To provide data dependence
To be able to store the same data in more than one place
To provide restricted data access (*)
5. Views contain no data of their own. True or False?Mark for Review
(1) Points
True (*)
False
6. Any select statement can be stored in the database as a view. True or FalseMark for Review
(1) Points
True (*)
False
