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 : 22
What is the work of DROP command?

Using this command, you can remove or erase recorded information from a database table.
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

Question No : 23
What is the work of INSERT 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.
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

Question No : 24
Which statement is not true?

SQL is rational whereas No-SQL is non-rational.
SQL follows BASE Model whereas No-SQL follows ACID Model.
SQL database are vertically scalable whereas No-SQL database are horizontally scalable.
No-SQL databases are preferable to store hierarchical data in comparison SQL databases.
View Answer   Discuss

Question No : 25
Which statement is true about the SQL?

SQL databases are vertically scalable.
SQL follows BASE Model.
SQL database cannot handle complex queries.
SQL database does not require object-relational mapping.
View Answer   Discuss

Question No : 26
Which statement is true about the No-SQL?

No-SQL follows ACID Model.
No-SQL does require object-relational mapping.
Dynamic schemas for unstructured data are used in No-SQL databases.
No-SQL databases are not preferable for storage of hierarchal data.
View Answer   Discuss

Question No : 27
SQL has the advantage of?

SQL require a lot of programming.
SQL provides High-Speed Query Processing.
SQL follows the standard languages of ANSI and ISO.
SQL is easily portable.
View Answer   Discuss

Question No : 28
SQL has the disadvantage of?

SQL is cheap.
SQL interface is simple.
Both A and B.
None of the above.
View Answer   Discuss