in which cases a dml statement is not executed
Answers
Answered by
0
when a table is deleted.
Answered by
0
A Data Manipulation Language (DML) statement may not be executed in the following cases:
- Syntax errors: If the DML statement contains syntax errors, it will not be executed by the database management system.
- Insufficient privileges: If the user does not have the necessary privileges to execute the DML statement, it will not be executed.
- Invalid data: If the DML statement contains invalid data or data that does not conform to the constraints set on the table, it will not be executed.
- Deadlocks: If a deadlock occurs while the DML statement is being executed, it will not be executed and an error will be generated.
- Concurrent access: If multiple users are trying to access and modify the same data at the same time, the DML statement may not be executed.
- Trigger failure: If a DML trigger associated with the table fails, the DML statement will not be executed.
- Network issues: If there are network issues that prevent the DML statement from being executed, it will not be executed.
- Connection issues: If the connection to the database is lost or the DML statement is executed on a closed connection, the statement will not be executed.
- Rollback: If a transaction is rolled back, any DML statement that was executed as part of that transaction will not be executed.
To learn more about Data Manipulation Language from the given link.
https://brainly.in/question/14123894
#SPJ3
Similar questions