Sams Teach Yourself SQL in 21 Days, Fourth Edition

Day 17

Quiz

1:	What is wrong with the following statement? SQL> GRANT CONNECTION TO DAVID;
A1:	There is no CONNECTION role. The proper syntax is SQL> GRANT CONNECT TO DAVID;
2:	True or false (and why): Dropping a user will cause all objects owned by that user to be dropped as well.
A2:	This statement is true only if the DROP USER user name CASCADE statement is executed. The CASCADE option tells the system to drop the user and all objects owned by the user.
3:	What would happen if you created a table and granted SELECT privileges on the table to PUBLIC?
A3:	Everyone could select from your table, even users you might not want to be able to view your data.
4:	Is the following SQL statement correct? SQL> create user RON identified by RON;
A4:	Yes. This ...