Question

0.3 Write the function of the following commands.
1. Truncate
2. Update
3. Insert
4. Save point
5. Roll back​

Answer 1

Answer:

1)The TRUNCATE() function truncates a number to the specified number of decimal places.

2)The update command can be used to update a single field or multiple fields at the same time. It can also be used to update a MySQL table with values from another table.

3)The insert command is used for inserting one or more rows into a database table with specified table column values. The first DML command executed immediately after a table creation is the insert statement.

4)A savepoint is a way of implementing subtransactions (also known as nested transactions) within a relational database management system by indicating a point within a transaction that can be "rolled back to" without affecting any work done in the transaction before the savepoint was created.

5)ROLLBACK is a command that causes all data changes since the last BEGIN WORK , or START TRANSACTION to be discarded by the relational database management systems (RDBMS), so that the state of the data is "rolled back" to the way it was before those changes were made.

Hope it helps.

Mark me as brainliest