Practice Pl/Sql Multiple Choice Questions with Answers Quiz-1

Q.1.

I write the following block of code:

WHEN PROGRAM_ERRORTHEN DBMS_OUTPUT.put_line ('PL/SQL is fantastic!');
WHEN PROGRAM_ERRORTHEN DECLARE l_fact VARCHAR2 (100) := 'PL/SQL is fantastic!'; BEGIN DBMS_OUTPUT.put_line (l_fact); END;
WHEN OTHERS THEN DBMS_OUTPUT.put_line ('PL/SQL is fantastic!');
All Of above

Q.2.

_________ Block are optional Blocks.

Exception Handling
Declaration
Both A & B
None of the above

Q.3.

______ block are obligatory block

Declaration
Execution
Exception Handling
None of the above

Q.4.

PL/SQL stands for

procedural Language extension to SQL
procedural extension of SQL
programming language of sql
None

Q.5.

PL/SQL has these advantages:

Tight Integration with SQL
High Performance
Tight Security
all

Q.6.

What is the full form of SQL?

Structured Query Language
Simple Query Language
Structured Question Language
Structure Quality Language

Q.7.

What is the Full form of DBMS

Data Base Management Studies
Data Base Mein se
Data Base Management System
Data Byte Management System

Q.8.

Which operator is used to select values within a range?

RANGE
WITHIN
BETWEEN
None of these

Q.9.

DBMS is an Interface between?

Database and developer
Database and Administrator
Database and End User
Database and Software

Q.10.

Which SQL statement is used to create a table in a database?

CREATE DATABASE TABLE
CREATE DB
CREATE TABLE
CREATE DATABASE TAB

Q.11.

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

Q.12.

What is the most common type of join?

JOINED
INNER JOIN
INSIDE JOIN
JOINED TABLE

Q.13.

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

Q.14.

_____cursor is declared by ORACLE for each UPDATE, DELETE and INSERT SQL commands.

Internal
External
Implicit
Explicit

Q.15.

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'

Q.16.

What are the characteristics of DBMS?

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

Q.17.

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

Q.18.

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.

Q.19.

Which SQL statement is used to delete data from a database?

DELETE
COLLAPSE
REMOVE
Both A & B

Q.20.

Which SQL statement is used to extract data from a database?

SELECT
OPEN
GET
EXTRACT

Support mcqgeeks.com by disabling your adblocker.