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 : 29
What is meant by Partial Database Control?

Business rules are hidden.

Users or professionals can't have the full control over the database.

Both A and B

None of the above

Question No : 30
What is meant by 'SQL is an interactive language'?

Learning and understanding SQL is easy

It can also be used for communicating with the database.

In a few seconds, complex queries can also be answered using this language.

All of the above

Question No : 31
Which of the following statement is false?

There is no difference between a lower case and upper case keyword in SQL.

It is easier to read SQL queries when the keywords are in lowercase.

An SQL statement's syntax is determined by its text line.

One or more SQL statements can be placed on a single line of text.

Question No : 32
Which of the following statement is true?

SQL statements are used for most operations in a database.

Relational algebra and tuple relationship calculus are needed for SQL syntax.

All of the above

None of the above

Question No : 33
Which of the following is not an SQL Statement?

SELECT Statement

UPDATE Statement

TRUNCATE TABLE Statement

FROM Statement

Question No : 34
What does the SELECT Statement do?

Data is read from the SQL database by this statement and displayed to the database user.

The stored data in the SQL database is changed or modified by this SQL statement.

By deleting the stored data, this SQL statement deletes the database.

A new table in SQL is created using this SQL statement.

Question No : 35
What does the UPDATE Statement do?

By deleting the stored data, this SQL statement deletes the database.

A new table in SQL is created using this SQL statement.

The stored data in the SQL database is changed or modified by this SQL statement.

Columns in the SQL database can be created, deleted, or modified with this SQL statement.