PL/SQL Interview Question and Answers

25. What is the use of DBMS_OUTPUT package?
  The DBMS_OUTPUT package is used to display output messages from the PL/SQL block.
26. What is the UTL_FILE package?
 
  • The UTL_FILE package provides text files input/output functionality within PL/SQL.
  • The security on client side is handled using normal operating system file permissions; whereas, server side security is handled through restrictions on the directories that are accessed
27. Is it possible to access SQL session information?
  Yes, it is possible to access the SQL sessions using the DBMS_SESSION package.
28. What is the meaning of granting system privilege WITH ADMIN OPTION?
  Granting system privilege WITH ADMIN OPTION means that the schema can in turn grant the same privilege to any other schema.
Page 7 of 10 123456 78910