A company has closed down its advertisement dept and is now getting all advertisement done by an Ad-Agency. All 20 people working in the dept has quit the job. The dept to which an employee belonged was stored in the "cdept" attribute of "emp" table. Which of the following statement would be used to do the changes in the "emp" tableA. Alter TableB. Drop TableC. Delete TableD. Truncate Table

  • Interview Candidate
  • 1
  • 2239

Showing Answers 1 - 1 of 1 Answers

Divakala

  • Nov 22nd, 2005
 

Here in this scenario the data related to that particular department must be deleted. so a DML must be used for this case along with a WHERE clause.

Alter, Drop and Truncate are DDL Commands and we cant use the Where clause with  these Commands.

So, Delete is the appropriate Command to be used .

Sree

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions