PL/SQL MCQ Question with Answer

PL/SQL MCQ with detailed explanation for interview, entrance and competitive exams. Explanation are given for understanding.

Question No : 8
A single unit of work for all commands executed consecutively is known as-

Transaction

Commit

Rollback

Control

Question No : 9
To get the table's previous permanent status, use the ____ command.

Commit

Transaction

Rollback

None of the above

Question No : 10
In order to start the transaction, the command used is

Mysql > START COMMIT;

Mysql > START TRANSACTION;

Mysql > START ROLLBACK;

None of the above

Question No : 11
What does SQL is used to perform operations on?

Update Records

Insert Records

Both A and B

None of the above

Question No : 12
What does SQL stand for?

SQL stands for Sample Query Language

SQL stands for Structured Query List

SQL stands for Structured Query Language

SQL stands for Sample Query List

Question No : 13
What does this SQL database language design to?

Maintain the data in hierarchal database management systems.

Maintain the data in relational database management systems.

Maintain the data in network database management systems.

Maintain the data in object-oriented database management systems.

Question No : 14
SQL became the standard of?

ASCII

ANSI

ISO

Both B and C