• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DROP or UPDATE

 
sam liya
Ranch Hand
Posts: 1243
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

To which one of the following do you need to add only the words "TABLE employees" in order for the statement to execute correctly on the employees table?

(a) DROP (b) SELECT

(c) INSERT INTO (d) UPDATE

(e) ALTER


the answer is d.but it can't be d.
 
Balu Sadhasivam
Ranch Hand
Posts: 874
Android Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

It cant be UPDATE
 
sam liya
Ranch Hand
Posts: 1243
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
but if we use update we have to use SET and WHERE part
isn't?
 
John Bengler
Ranch Hand
Posts: 133
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Aruna,

just give it a try..

If you're away from a db like I'm at the moment:

I think it must be a) DROP

Every other statement would need something to complete it:

b) at least a FROM
c) the data which should be inserted
d) at least SET, a column and its new value
e) information what should be altered


John
 
satishbsk kumar
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Your right john,
My choice is also a) DROP
Satish
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic