Quiz | Croma Campus

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 command is used to remove a package from the database?

DELETE PACKAGE
DROP PACKAGE
REMOVE PACKAGE
TRUNCATE PACKAGE

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

Which of the following is true about PL/SQL triggers?

They cannot call procedures
They cannot have parameters
They cannot be nested
They cannot be enabled

Mark for review

How do you exit a loop prematurely in PL/SQL?

EXIT
LEAVE
BREAK
CONTINUE

Mark for review

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

RECORD
BOOLEAN
TABLE
CURSOR

Mark for review

What is the use of the FETCH statement in PL/SQL?

To retrieve the next row
To open a cursor
To close a cursor
To declare a cursor

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

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

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

Mark for review

Which PL/SQL construct is used for handling exceptions?

RAISE
EXCEPTION
DECLARE
BEGIN

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

How do you terminate a PL/SQL block?

WITH;
;
END;
/

Mark for review

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

WHEN OTHERS
WHEN
EXCEPTION
RAISE

Mark for review

In PL/SQL, what does the %TYPE attribute provide?

Data type of a variable
Data type of a column
Data type of a table
Data type of a function

Mark for review

How do you handle null values in PL/SQL?

Using IS NULL
Using = NULL
Using NULL
Using NULLIF

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 difference between %ROWTYPE and %TYPE attributes in PL/SQL?

%ROWTYPE is for rows, %TYPE is for columns
%ROWTYPE is for columns, %TYPE is for rows
%ROWTYPE is for tables, %TYPE is for records
%ROWTYPE is for records, %TYPE is for variables

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

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

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

Which data type is used to store large binary objects in PL/SQL?

BLOB
CLOB
BFILE
LOB

Mark for review

Which of the following is a PL/SQL block?

Anonymous Block
Named Block
Both
None

Mark for review

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

THROW
RAISE
EXCEPTION
SIGNAL

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 purpose of the %TYPE attribute in PL/SQL?

To declare a column type
To declare a row type
To declare a variable type
To declare a table type

Mark for review

Which operator is used to concatenate strings in PL/SQL?

Mark for review

How can you handle exceptions in PL/SQL?

Using TRY-CATCH block
Using BEGIN-END block
Using EXCEPTION block
Using RAISE block

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

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 PL/SQL feature is used to repeat a statement or group of statements multiple times?

IF-THEN
LOOP
EXCEPTION
DECLARE

Mark for review

Online Exam Quiz

Online

Did you like this Question

Get a 1:1 Mentorship call with our Career Advisor