COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What will be the result If you will execute the following command:DELETE FROM emp;
|
|
The table will be deleted.
|
|
|
All the records will be deleted.
|
|
|
The structure of the table will be displayed.
|
|
|
The statement will not execute.
|
Explanation:
Detailed explanation-1: -We can also use the TRUNCATE command to delete all the records from a table.
Detailed explanation-2: -If you run a DELETE statement with no conditions in the WHERE clause, all of the records from the table will be deleted.
Detailed explanation-3: -The DELETE Statement in SQL is used to delete existing records from a table.
Detailed explanation-4: -The DELETE command is used to delete existing records in a table.
There is 1 question to complete.