[Views/Security/Transactions – Chap 9 & Chap 10] select * from Companies where s
ID: 3716524 • Letter: #
Question
[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 Can’t 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 Customer’s 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.
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
Explanation / Answer
Hi Friend,
I have answered first 4 Question.
Please repost others in separate post.
1. A Table
2. DROP VIEW NewEmployees;
3. C The data is still in the underlying tables and has not been deleted
4. D DDL
View is an object that is created using DDL command.View is a virtual table which exists just in memory.So you have to used DDL commands to create a view.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.