Oracle SQL Questions and Answers – DCL,TCL Command

This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “DCL ,TCL Command”.

1. DCL stands for :
a) Data Control Language
b) Data Console Language
c) Data Console Level
d) Data Control Level
View Answer

2. TCL stands for:
a) Transaction control languages
b) Transaction command languages
c) Transaction connect languages
d) None of the Mentioned
View Answer

3. _________commands in SQL allow controlling access to data within database.
a) Database
b) Data
c) Data control
d) All of the Mentioned
View Answer

4. In an SQL statement, which of the following parts states the conditions for row selection?
a) Where
b) From
c) Order By
d) Group By
View Answer

5. A transaction completes its execution is said to be
a) Committed
b) Aborted
c) Rolled back
d) Failed
View Answer

6. Which of the following keyword is used with Data Control Language (DCL) statements?
a) SELECT
b) INSERT
c) DELETE
d) GRANT
View Answer

7. DCL Provides Commands To Perform Actions Like _____________
a) Change The Structure Of Tables
b) Insert, Update Or Delete Records And Data Values
c) Authorizing Access And Other Control Over Database
d) None of the Mentioned
View Answer

8. The Database Language That Allows You To Access Or Maintain Data In A Database
a) DCL
b) DML
c) DDL
d) All of the Mentioned
View Answer

9. A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________
a) DCL
b) DML
c) DDL
d) All of the Mentioned
View Answer

10. To obtain the structure of an Oracle table, the command to use is:
a) STRUCTURE [TableName].
b) DESCRIBE [TableName].
c) DESCRIBE STRUCTURE [TableName].
d) DESC TABLE [TableName].
View Answer

Sanfoundry Global Education & Learning Series – Oracle Database.

To practice all areas of Oracle Database, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]