COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
delete * from employee;
|
|
Deletes all tuples.
|
|
|
updates the table emp with null.
|
|
|
Destroys the table.
|
|
|
select all the record
|
Explanation:
Detailed explanation-1: -Syntax: DELETE FROM table name [WHERE Condition]; Here we will delete the data in the Employee table shown below. You can delete the specific record(s) from the table using the WHERE clause.
Detailed explanation-2: -The DELETE Statement in SQL is used to delete existing records from a table.
Detailed explanation-3: -TRUNCATE TABLE Employee; This will delete entire Employee table from database.
There is 1 question to complete.