Home
Home >> Database Management System>> PL/SQL

PL/SQL MCQ Question with Answer

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

Download PL/SQL MCQ Question Answer PDF

Question No : 15
Which statement is not true about SQL?

Using SQL in relational databases is all about inserting, updating, and deleting data.
Sample data can also be described with the aid of this tool.
It helps develop relational database functions, events, and views.
A SQL user can also set restrictions and permissions for a table column, a view, and a stored procedure.
View Answer   Discuss

Question No : 16
SQL contains which component in its process?

Optimization Engines
SQL Query Engines
Query Dispatchers
All of the above
View Answer   Discuss

Question No : 17
Determine the correct SQL command?

CREATE
UPDATE
DELETE
All of the above
View Answer   Discuss

Question No : 18
What is the work of CREATE command?

Using this command, you can remove or erase recorded information from a database table.
It enables you to create new databases, tables, table views, and other objects using this command.
Inserting records or data into the database tables is accomplished with this command. In addition to inserting records in single rows, we can insert records in multiple rows as well.
A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
View Answer   Discuss

Question No : 19
What is the work of UPDATE command?

A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
Using this command, you can remove or erase recorded information from a database table.
Database data can be updated or changed using this command.
It enables you to create new databases, tables, table views, and other objects using this command.
View Answer   Discuss

Question No : 20
What is the work of DELETE command?

A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
Database data can be updated or changed using this command.
Database objects such as tables, table views, and other objects can be deleted using this command.
Using this command, you can remove or erase recorded information from a database table.
View Answer   Discuss

Question No : 21
What is the work of SELECT command?

Database objects such as tables, table views, and other objects can be deleted using this command.
Database objects such as tables, table views, and other objects can be deleted using this command.
One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.
It enables you to create new databases, tables, table views, and other objects using this command.
View Answer   Discuss