MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

To remove a record from a table which SQL statement would you use?

A	Remove
B	Cancel
C	Delete
D	Eradicate

Explanation:

Detailed explanation-1: -The DELETE statement is used to delete existing records in a table.

Detailed explanation-2: -The DROP TABLE statement is used to drop an existing table in a database.

Detailed explanation-3: -The SQL DELETE Query is used to delete the existing records from a table. You can use the WHERE clause with a DELETE query to delete the selected rows, otherwise all the records would be deleted.

Detailed explanation-4: -Using SQL Server Management Studio Right-click the table and choose Delete from the shortcut menu. A message box prompts you to confirm the deletion. Click Yes. Deleting a table automatically removes any relationships to it.

Detailed explanation-5: -We can also use the TRUNCATE command to delete all the records from a table.

There is 1 question to complete.