logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

How do you handle null values in PL/SQL?

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

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

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 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 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

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 of the following is a composite data type in PL/SQL?

  • NUMBER
  • BOOLEAN
  • RECORD
  • CHAR
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 of the following is a scalar data type in PL/SQL?

  • RECORD
  • BOOLEAN
  • TABLE
  • CURSOR
Mark for review

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

  • THROW
  • RAISE
  • EXCEPTION
  • SIGNAL
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 keyword is used to declare a constant in PL/SQL?

  • CONSTANT
  • FIXED
  • STATIC
  • IMMUTABLE
Mark for review

What does the RAISE_APPLICATION_ERROR procedure do?

  • Stops the PL/SQL block
  • Returns a system error
  • Logs an error in the database
  • Raises a user-defined error
Mark for review

Which PL/SQL function returns the current user?

  • USER()
  • CURRENT_USER()
  • SYS_CONTEXT('USERENV', 'SESSION_USER')
  • SESSION_USER()
Mark for review

Which of the following is a valid PL/SQL identifier?

  • 123var
  • var_123
  • var-123
  • var$123
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

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 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

Which command is used to remove a package from the database?

  • DELETE PACKAGE
  • DROP PACKAGE
  • REMOVE PACKAGE
  • TRUNCATE PACKAGE
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

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

  • TRUE
  • FALSE
  • NULL
  • 0
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 not a PL/SQL cursor attribute?

  • %FOUND
  • %ROWCOUNT
  • %NOTFOUND
  • %EXISTS
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 valid PL/SQL loop?

  • FOR loop
  • WHILE loop
  • DO-WHILE loop
  • LOOP loop
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

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

  • 12
  • 16
  • 20
  • No limit
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

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

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