[Views/Security/Transactions Chap 9 & Chap 10]

select * from Companies

where state in (GA, FL);

1. Given the above code, what is Companies?

A Table

B View

C Both

D Cant Tell

2. If I asked you to get rid of the View NewEmployees, how would you do this? Show the code.

3. Since you just removed the NewEmployees View, what happened to the data in this View?

A It has been deleted along with the View

B Some data was deleted and some other data is still in the underlying tables

C The data is still in the underlying tables and has not been deleted

D None of the above

4. The Create View command is part of which SQL Sub Language set?

A DCL

B DML

C DSL

D DDL

Accounts
acctNo	owner	userid	password	balance
365556	Tony Jones	tjones	456	819.37
499872	Frank Smith	fsmith	123	590.81
761112	George Powers	gpowers	geo	239.41
765552	Betty Davis	bdavis	atl	356.21
872221	Suzanne Austin	suze	suze	622.22
899900	Mary Wilson	mwilson	mary	772.12

Customers
cid	cName	cAddr	cPhone	cEmail
tjones	Tony Jones	Miami, Fl	514-999-2131	tjones@yahoo.com
fsmith	Frank Smith	Dallas, Tx	616-423-1717	fsmith@haotmail.com
gpowers	George Powers	Chicago, Il	612-901-2312	gpowers@bellsouth.net
bdavis	Betty Davis	Nashville, Tn	909-367-9485	bdavis@yahoo.com
suze	Suzzane Austin	San Diego, Ca	201-565-1902	suze@yahoo.com
mwilson	Mary Wilson	Atlanta, Ga	405-787-2911	mwilson@hotmail.com

5. Given the above 2 tables, please create a View called CustAccounts that will include the Customers Name, Address and Phone, as well as their AccountNo and balance.(You will need to do a Join to get all this info.)

6. Did you notice a mistake in the database above. Suzanne Powers name is different in the second table. What changes could you make to prevent an error like this from occurring again?

7. Write an Update statement that will change the Name for suze in the Customers table to match the owner in the Accounts table(Use a SubQuery)

grant all

on students

to public

8. What does the above code do?

9. To take away permissions you would

A Drop permissions

B Delete permissions

C Revoke permissions

D None of the above

10. What does the Transaction Log do? Explain

11. Which of the following are true?

A Constraints help with data Integrity

B Indexes help with performance

C Both a. and b.

D Neither a. nor b.