Test: Quiz: Creating Views

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
				Correct
		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. (*)
				Correct
		3.	A view can contain a select statement with a subquery. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		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 (*)
				Correct
		5.	Views contain no data of their own. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		6.	Any select statement can be stored in the database as a view. True or False		Mark for Review (1) Points
			True (*)
			False
				Correct

( Vrei sa traduci ceva?Want to translate something? http://translate.google.ro/# )