Question
a.
Begin transaction and end transaction
b.
Start transaction and stop transaction
c.
Get transaction and post transaction
d.
Read transaction and write transaction
Posted under Transactions DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. A transaction is delimited by statements (or function calls) of the form __________
Similar Questions
Discover Related MCQs
Q. Identify the characteristics of transactions
View solution
Q. Which of the following has “all-or-none” property ?
View solution
Q. The database system must take special actions to ensure that transactions operate properly without interference from concurrently executing database statements. This property is referred to as
View solution
Q. The property of transaction that persists all the crashes is
View solution
Q. __________ states that only valid data will be written to the database.
View solution
Q. The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties.
View solution
Q. ____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
View solution
Q. In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
View solution
Q. Which character function can be used to return a specified portion of a character string?
View solution
Q. Which of the following is TRUE for the System Variable $date$?
View solution
Q. What are the different events in Triggers?
View solution
Q. The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’), 4) FROM EMP; prints
View solution
Q. Which of the following SQL command can be used to modify existing data in a database table?
View solution
Q. When SQL statements are embedded inside 3GL, we call such a program as
View solution
Q. _______________ provides option for entering SQL queries as execution time, rather than at the development stage.
View solution
Q. Each modification done in database transaction are first recorded into the
View solution
Q. _______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
View solution
Q. Which of the following is not a state in transaction ?
View solution
Q. _______________ joins are SQL server default
View solution
Q. The ________________ is essentially used to search for patterns in target string.
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
.png)
