What one is not a Transaction Control Statement?OptionsCommitSavepointCommitSet transactionRollback
Question
What one is not a Transaction Control Statement?OptionsCommitSavepointCommitSet transactionRollback
Solution
The option that is not a Transaction Control Statement is "CommitSet transaction". The Transaction Control Statements in SQL are "COMMIT", "SAVEPOINT", and "ROLLBACK".
Similar Questions
Select the correct answerWhat one is not a Transaction Control Statement?OptionsCommitSavepointCommitSet transactionRollback
Select the correct answerDuring transaction before commit which of the following statements is done automatically in case of shutdown?OptionsCommitRollbackViewFlashback
In case of any shut down during transaction before commit which of the following statement is done automatically?FlashbackViewRollbackCommit
Which of the following makes the transaction permanent in the database?FlashbackCommitViewRollback
Which of the given options define a transaction correctly?A transaction consists of COMMIT or ROLLBACK in a database session.A transaction consists of either a collection of DML statements or a DDL or DCL or TCL statement to form a logical unit of work in a database session.A transaction consists of DDL statements on the database schema.A transaction consists of collection of DML and DDL statements in different sessions of the database.
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.