Quiz | Croma Campus

How do you declare a record type in PL/SQL?

TYPE record_name IS RECORD
RECORD record_name IS
DECLARE record_name RECORD
TYPE record_name RECORD IS

Mark for review

How can you create a PL/SQL subprogram?

Using CREATE PROCEDURE
Using CREATE FUNCTION
Using CREATE PACKAGE
All of the above

Mark for review

How do you handle null values in PL/SQL?

Using IS NULL
Using = NULL
Using NULL
Using NULLIF

Mark for review

Which PL/SQL keyword is used to raise an exception explicitly?

THROW
RAISE
EXCEPTION
SIGNAL

Mark for review

How do you enable a previously disabled trigger in PL/SQL?

ENABLE TRIGGER trigger_name;
ALTER TRIGGER trigger_name ENABLE;
ENABLE trigger_name;
ALTER TRIGGER trigger_name ENABLED;

Mark for review

Which PL/SQL feature is used to repeat a statement or group of statements multiple times?

IF-THEN
LOOP
EXCEPTION
DECLARE

Mark for review

Which of the following is a PL/SQL block?

Anonymous Block
Named Block
Both
None

Mark for review

How can you pass parameters to PL/SQL procedures?

By Value
By Reference
Both
None

Mark for review

What is the function of the INTO clause in a SELECT statement in PL/SQL?

To specify the table
To specify the columns
To specify the variables
To specify the conditions

Mark for review

What is a pragma in PL/SQL?

A compiler directive
A data type
A loop control
An exception handler

Mark for review

Which of the following is not a valid PL/SQL control structure?

IF-THEN
FOR-LOOP
WHILE-LOOP
DO-UNTIL-LOOP

Mark for review

Which of the following is a composite data type in PL/SQL?

NUMBER
BOOLEAN
RECORD
CHAR

Mark for review

What is the scope of a variable declared in a PL/SQL block?

Global
Local
Package-level
Schema-level

Mark for review

What is the purpose of a PL/SQL package?

To store procedures only
To store functions only
To group related procedures
To create database connections

Mark for review

Which of the following is a scalar data type in PL/SQL?

RECORD
BOOLEAN
TABLE
CURSOR

Mark for review

How can you call a function from a PL/SQL block?

function_name(params);
CALL function_name(params);
EXEC function_name(params);
BEGIN function_name(params);

Mark for review

What is the default mode for parameters in PL/SQL procedures?

IN
OUT
IN OUT
DEFAULT

Mark for review

Which of the following is not a PL/SQL cursor attribute?

%FOUND
%ROWCOUNT
%NOTFOUND
%EXISTS

Mark for review

Which PL/SQL construct is used to iterate over a set of rows returned by a query?

FOR loop
CURSOR loop
WHILE loop
REPEAT loop

Mark for review

How do you declare a cursor in PL/SQL?

DECLARE cursor CURSOR
CURSOR cursor IS
OPEN cursor
CREATE cursor

Mark for review

How do you terminate a PL/SQL block?

WITH;
;
END;
/

Mark for review

What is the maximum number of triggers that can be applied to a table in Oracle?

12
16
20
No limit

Mark for review

What is the extension for a PL/SQL package body file?

.sql
.plb
.pls
.pks

Mark for review

Which of the following is not a valid way to comment in PL/SQL?

-- comment
/* comment */
/** comment **/
REM comment

Mark for review

How do you open an explicit cursor in PL/SQL?

OPEN cursor_name;
cursor_name OPEN;
cursor_name OPEN;
OPEN cursor_name; BEGIN

Mark for review

What is the purpose of a sequence in PL/SQL?

To generate unique numbers
To define data types
To create tables
To create indexes

Mark for review

Which PL/SQL function returns the current user?

USER()
CURRENT_USER()
SYS_CONTEXT('USERENV', 'SESSION_USER')
SESSION_USER()

Mark for review

What is the function of the ROLLBACK statement in PL/SQL?

To save changes permanently
To undo changes
To begin a transaction
To end a transaction

Mark for review

Which clause is used to handle multiple exceptions in PL/SQL?

WHEN OTHERS
WHEN
EXCEPTION
RAISE

Mark for review

Which of the following is not a valid PL/SQL loop?

FOR loop
WHILE loop
DO-WHILE loop
LOOP loop

Mark for review

Online Exam Quiz

Online

Did you like this Question

Get a 1:1 Mentorship call with our Career Advisor