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 : 1
Which of the following is TRUE about SQL Auto Increment?

It increments the unique number automatically.

It decrements the unique number automatically.

It keeps the unique number constant

None of the above

Question No : 2
Which of the following is the feature(s) of SQL Auto Increment?

In some cases you may not have any unique identifying characteristics in data; therefore, it makes sense to create a Primary Key.

Explicitly initializing and modifying the auto-increment value is possible at any time.

Record identifiers can easily be created that are unique to each record.

All of the above

Question No : 3
Which keyword is used in SQL Server to implement the auto increment?

UNIQUE

IDENTITY

INCREMENT

ADD

Question No : 4
In SQL, Like is a ____ operator.

Relational

Logical

Additional

Unique

Question No : 5
SQL Like is NOT used with which of the following statement(s)?

DELETE

SELECT

UPDATE

ALTER

Question No : 6
The character(s) which are used independently or in conjunction with SQL Like Operator:

Both A. and B.

None of the above

Question No : 7
Which of the following is/are transaction control commands in SQL?

Commit

Rollback

Both A. and B.

None of the above