Sams Teach Yourself SQL in 21 Days, Fourth Edition

Day 14

Quiz

1:	Can a row of data be deleted from a view that was created from multiple tables?
A1:	No, data can only be manipulated using a view if the view is comprised of only one base table.
2:	When creating a table, the owner is automatically granted all privileges on the table. Is this true when a view is created?
A2:	Yes, the owner of the view automatically has all permissions on the view.
3:	What clause can be used to sort data in a CREATE VIEW statement?
A3:	The GROUP BY clause must sort data in order to break data into groups.
4:	Is the following CREATE statement correct? SQL> create view credit_debts as (select all from debts where account_id = 4);
A4:	Yes, it is correct although the parentheses are not required.
5:	Is the following CREATE ...