What Do You Know About Transaction Control Language?
10 Questions
| Total Attempts: 207
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?- 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?
- A.
Save as
- B.
Savepoint
- C.
Save
- D.
Commit
- 3.
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?
- 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.
- A.
ROLLBACK
- B.
SAVEPOINT
- C.
SETTRANSACTION
- D.
None
- 6.
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?
- A.
Save
- B.
Commit
- C.
Set
- D.
None
- 8.
Transaction control language manages changes made by...
- A.
DCL
- B.
DDL
- C.
DML
- D.
HTML
- 9.
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.
- A.
Save
- B.
Commit
- C.
Rollback
- D.
Savepoint
Many programmers and web developers alike will agree that when deciding to enter the field of computing, learning one of the essential coding languages out there, HTML will give you a good starting point. In this quiz,...
Questions: 15 | Attempts: 37718 | Last updated: Mar 22, 2022
-
Sample QuestionWhat does HTML stand for?
Here is an interesting quiz with informative questions and answers about Arduino and its related concepts. Arduino is an open-source hardware and software company, that deals in designing and...
Questions: 11 | Attempts: 13587 | Last updated: May 12, 2022
-
Sample QuestionWhat is the range of numbers you can store in a variable of type byte?
If you are very new to computers, or just want to test your knowledge, then it's a very basic computer skills test is for you. Even if you are applying for a job, and they have required you to take the basic computer skills...
Questions: 10 | Attempts: 242102 | Last updated: Apr 18, 2022
-
Sample QuestionWhen you see no icons on the desktop, how can you open programs such as Microsoft Word?