Question
(4 Points) If I asked you to get rid of the View NewEmployees, how would you do this? Show the code (4 Points) Since you
(4 Points) If I asked you to get rid of the View NewEmployees, how would you do this? Show the code
(4 Points) 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 Points) 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 |
(10 Points) Given the above 2 tables, please create a Viewcalled 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.)
(4 Points) 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?
(10 Points) Write an Update statement that will change the cName for suze in the Customers table to match the owner in the Accounts table(Use a SubQuery)
grant all
on students
to public
(3 Points) What does the above code do?
(2 Points) To take away permissions you would
A. Drop permissions
B. Delete permissions
C. Revoke permissions
D. None of the above
(3 Points) What does the Transaction Log do? Explain
(2 Points) 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started