If records in the view are deleted, the corresponding records in the original table will also be deleted.???
Answers
Deleting All Records from a Table
Problem
You want to delete all the records from a table.
Solution
Use the DELETE command to delete records from a table. For example, to delete all records from EMP
Discussion
When using the DELETE command without a WHERE clause, you will delete all rows from the table specified.
Deleting Specific Records
Problem
You wish to delete records meeting a specific criterion from a table.
Solution
Use the DELETE command with a WHERE clause specifying which rows to delete. For example, to delete all employees in department 10:
Discussion
By using a WHERE clause with the DELETE command, you can delete a subset of rows in a table rather than all the rows.
Deleting a Single Record
Problem
You wish to delete a single record from a table.
Solution
This is a special case of “Deleting Specific Records.” The key is to ensure that your selection criterion is narrow enough to specify only the one record that you wish to delete. Often you will want to delete based on the primary key. For example, to delete employee CLARK (EMPNO 7782)
Discussion
Deleting is always about identifying the rows to be deleted, and the impact of a DELETE always comes down to its WHERE clause. Omit the WHERE clause and the scope of a DELETE is the entire table. By writing conditions in the WHERE clause, you can narrow the scope to a group of records, or to a single record. When deleting a single record, you should typically be identifying that record based on its primary key or on one of its unique keys.
Mark it as the brainliest answer.