PL/SQL MCQ

Below PL/SQL quiz are Multiple Choice Questions (MCQs) type Quiz. These PL/SQL MCQ Questions helps you to refresh your PL/SQL, you can see the correct option by clicking on it. .
  • 1. With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

    • DELETE ROW FirstName='Peter' FROM Persons
    • DELETE FirstName='Peter' FROM Persons
    • DELETE FROM Persons WHERE FirstName = 'Peter'
    • None of these
  • 2. With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

    • INSERT INTO Persons ('Olsen') INTO LastName
    • INSERT INTO Persons (LastName) VALUES ('Olsen')
    • INSERT ('Olsen') INTO Persons (LastName)
  • 3. Which of the following is NOT a SQL command?

    • SELECT
    • FROM
    • LIKE
    • SIMILAR
    • DISTINCT
  • 4. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

    • SELECT * FROM Persons WHERE FirstName='Peter'
    • SELECT [all] FROM Persons WHERE FirstName='Peter'
    • SELECT * FROM Persons WHERE FirstName<>'Peter'
    • SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
  • 5. With SQL, how can you insert a new record into the "Persons" table?

    • INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
    • INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
    • INSERT ('Jimmy', 'Jackson') INTO Persons
    • All Of above
  • 6. Which of the following is true about the execution section of a PL/SQL block

    • It is enclosed between the keywords BEGIN and END.
    • It is a mandatory section.
    • It consists of the executable PL/SQL statements.
    • All of the above.
  • 7. _____cursor is declared by ORACLE for each UPDATE, DELETE and INSERT SQL commands.

    • Internal
    • External
    • Implicit
    • Explicit
  • 8. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

    • UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
    • UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
    • MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
    • MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
  • 9. What is the most common type of join?

    • JOINED
    • INNER JOIN
    • INSIDE JOIN
    • JOINED TABLE
  • 10. Which SQL statement is used to create a table in a database?

    • CREATE DATABASE TABLE
    • CREATE DB
    • CREATE TABLE
    • CREATE DATABASE TAB
  • 11. DBMS is an Interface between?

    • Database and developer
    • Database and Administrator
    • Database and End User
    • Database and Software
  • 12. What are the Different Types of Keys?

    • Primary Key and Secondary Key
    • Foreign Key and Secondary Key
    • Indian Key and Foreign Key
    • Primary Key and Foreign Key
  • 13. What are the characteristics of DBMS?

    • Real-world entity
    • Less Redundancy
    • Relation based Tables
    • All of the above