logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

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

  • .sql
  • .plb
  • .pls
  • .pks
Mark for review

How do you declare a constant in PL/SQL?

  • CONSTANT var_name TYPE := value;
  • var_name CONSTANT TYPE := value;
  • var_name TYPE CONSTANT := value;
  • var_name TYPE := CONSTANT value;
Mark for review

How can you pass parameters to PL/SQL procedures?

  • By Value
  • By Reference
  • Both
  • None
Mark for review

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

  • %FOUND
  • %ROWCOUNT
  • %NOTFOUND
  • %EXISTS
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 not a valid PL/SQL control structure?

  • IF-THEN
  • FOR-LOOP
  • WHILE-LOOP
  • DO-UNTIL-LOOP
Mark for review

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

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

  • -- comment
  • /* comment */
  • /** comment **/
  • REM comment
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

Which of the following is true about PL/SQL procedures and functions?

  • Procedures cannot return values
  • Functions cannot have parameters
  • Functions must return a value
  • Procedures and functions are the same
Mark for review

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

  • NUMBER
  • BOOLEAN
  • RECORD
  • CHAR
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 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

How do you handle null values in PL/SQL?

  • Using IS NULL
  • Using = NULL
  • Using NULL
  • Using NULLIF
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 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

What is the default value of a boolean variable in PL/SQL?

  • TRUE
  • FALSE
  • NULL
  • 0
Mark for review

How do you terminate a PL/SQL block?

  • WITH;
  • ;
  • END;
  • /
Mark for review

Which PL/SQL construct is used for handling exceptions?

  • RAISE
  • EXCEPTION
  • DECLARE
  • BEGIN
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 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 do you declare a variable in PL/SQL?

  • var_name variable_type;
  • variable_type var_name;
  • var_name: variable_type;
  • var_name:= variable_type;
Mark for review

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

  • BLOB
  • CLOB
  • BFILE
  • LOB
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 keyword is used to declare a constant in PL/SQL?

  • CONSTANT
  • FIXED
  • STATIC
  • IMMUTABLE
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 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

How do you declare a cursor in PL/SQL?

  • DECLARE cursor CURSOR
  • CURSOR cursor IS
  • OPEN cursor
  • CREATE cursor
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

blinkerOnline

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • Answered
  • Not Answered
  • Marked for Review

Get a 1:1 Mentorship call with our Career Advisor

Book free session