What Do You Know About Transaction Control Language?
10 Questions
| Total Attempts: 182
Transaction control language, or TCL, is a language used in managing different transactions occurring within a database. Transaction control commands are primarily used for managing changes affecting the SQL data. Take this quiz to find out more.
Questions and Answers
- 1.
![In which of the following events can a transaction event occur? - ProProfs]( "In which of the following events can a transaction event occur?")
In which of the following events can a transaction event occur?- A.
When making payments
- B.
Using credit cards
- C.
Connecting to Oracle
- D.
Account opening
- 2.
![What statement marks and save the current transaction points? - ProProfs]( "What statement marks and save the current transaction points?")
What statement marks and save the current transaction points?- A.
Save as
- B.
Savepoint
- C.
Save
- D.
Commit
- 3.
![A transaction can be closed either by a commit or ____ statement? - ProProfs]( "A transaction can be closed either by a commit or ____ statement?")
A transaction can be closed either by a commit or ____ statement?- A.
Rastar
- B.
HTML
- C.
Rollback
- D.
Save as
- 4.
![Which of these transactions control statement makes all changes permanent? - ProProfs]( "Which of these transactions control statement makes all changes permanent?")
Which of these transactions control statement makes all changes permanent?- A.
SAVEPOINT
- B.
COMMIT
- C.
ROLLBACK
- D.
All of the above
- 5.
![The use of certain forms of the COMMIT and ___ commands are restricted in PL/SQL. - ProProfs]( "The use of certain forms of the COMMIT and ___ commands are restricted in PL/SQL.")
The use of certain forms of the COMMIT and ___ commands are restricted in PL/SQL.- A.
ROLLBACK
- B.
SAVEPOINT
- C.
SETTRANSACTION
- D.
None
- 6.
![Transaction control language is a/an ___ command. - ProProfs]( "Transaction control language is a/an ___ command.")
Transaction control language is a/an ___ command.- A.
HTML
- B.
COBOL
- C.
Java
- D.
SQL
- 7.
![Which of these TCL commands save the work done? - ProProfs]( "Which of these TCL commands save the work done?")
Which of these TCL commands save the work done?- A.
Save
- B.
Commit
- C.
Set
- D.
None
- 8.
![Transaction control language manages changes made by... - ProProfs]( "Transaction control language manages changes made by...")
Transaction control language manages changes made by...- A.
DCL
- B.
DDL
- C.
DML
- D.
HTML
- 9.
![Once we commit, we cannot rollback. - ProProfs]( "Once we commit, we cannot rollback.")
Once we commit, we cannot rollback.- A.
True
- B.
False
- C.
Particularly depends
- D.
None
- 10.
![All of these are transaction control language statements except one. - ProProfs]( "All of these are transaction control language statements except one.")
All of these are transaction control language statements except one.- A.
Save
- B.
Commit
- C.
Rollback
- D.
Savepoint
Questions: 11 | Attempts: 9711 | Last updated: Jul 12, 2021
-
Sample QuestionWhat is the range of numbers you can store in a variable of type byte?
Are you applying for a job, and they have required you to take essential computer skills exam when you show up for the interview? The quiz below covers the basics of what you are most likely to be asked. Give it a try and all the...
Questions: 8 | Attempts: 141404 | Last updated: Apr 30, 2021
-
Sample QuestionHow do you open a program such as Microsoft Word when there are no icons on the desktop?
Computers have been evolving in makeup and design ever since they were first introduced. Most people nowadays are expected to have at least basic knowledge of how to use one. How conversant are you with the basic components of a...
Questions: 15 | Attempts: 39427 | Last updated: Jun 11, 2020
-
Sample QuestionLet's start with an easy one. What does CPU stand for?
Hunter x Hunter Nen Test: What is Your Nen Personality?
Hunter x Hunter Nen Test: What is Your Nen Personality?
What is The Perfect Gift for Your Best Friend Quiz
What is The Perfect Gift for Your Best Friend Quiz
Are You Really Best Friends? Take The Quiz & Prove It
Are You Really Best Friends? Take The Quiz & Prove It
Back to top