COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
All records will be updated.
|
|
|
Only specific record will be updated.
|
|
|
None of the records will be updated.
|
|
|
None of the above
|
Detailed explanation-1: -Without WHERE clauses, DELETE drops all the data from the table, and UPDATE overwrites values for all the table rows.
Detailed explanation-2: -Notice the WHERE clause in the UPDATE statement. The WHERE clause specifies which record(s) that should be updated. If you omit the WHERE clause, all records in the table will be updated!
Detailed explanation-3: -The UPDATE command in SQL is used to modify or change the existing records in a table. If we want to update a particular value, we use the WHERE clause along with the UPDATE clause. If you do not use the WHERE clause, all the rows will be affected.
Detailed explanation-4: -If you do not use where clause in UPDATE statement, all the records in the table will be updated with the specified values.
Detailed explanation-5: -Using SELECT without a WHERE clause is useful for browsing data from tables. In a WHERE clause, you can specify a search condition (logical expression) that has one or more conditions. When the condition (logical expression) evaluates to true the WHERE clause filter unwanted rows from the result. Name of the table.