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
Explanation: DCL stands for Data Control Language.
2. TCL stands for:
a) Transaction control languages
b) Transaction command languages
c) Transaction connect languages
d) None of the Mentioned
View Answer
Explanation: TCL for Transaction control languages.
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
Explanation: Data control is used for the controlling the access to database.
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
Explanation: In an SQL statement where clause states the conditions for row selection.
5. A transaction completes its execution is said to be
a) Committed
b) Aborted
c) Rolled back
d) Failed
View Answer
Explanation: A transaction the completes its execution is said to be Committed.
6. Which of the following keyword is used with Data Control Language (DCL) statements?
a) SELECT
b) INSERT
c) DELETE
d) GRANT
View Answer
Explanation: GRANT is the keyword which is used with Data Control Language statements.
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
Explanation: DCL is used to perform the action like authorization, Access and other control over database.
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
Explanation: DCL command like Grant and Revoke is used for to give access on the database.
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
Explanation: Data Definition Language is used for the to define the data structure of the Table.
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
Explanation: DESCRIBE command is used to get the structure of the Oracle Table.
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]
- Practice Programming MCQs
- Check Information Technology Books
- Apply for Programming Internship
- Check Oracle Database Books