Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals Design

Authors: Marion Donnie Dutton Don F. Seaman

14th Edition Globel Edition

1292107634, 978-1292107639

More Books

Students also viewed these Databases questions

Question

2. Are there more men or women? (find statistics)

Answered: 1 week ago