PL/SQL Interview Question and Answers

17. What are Oracle Supplied Packages?
  Oracle server provides the Oracle Supplied Packages to allow Procedural Language/Structured Query Language (PL/SQL) to access certain features of SQL, which are not available in PL/SQL. They also help in extending the functionality of the database.
18. When an execution raised by the DBMS_JOB package?
  An exception is raised if the time specified for the job does not evaluate to a job in future.
19. Which Oracle package is used to check the status of a schema and analyze the objects of the schema?
  The DBMS_UTILITY package is used to check the status of a schema and analyze the objects of the schema.
20. Which schema objects can be referenced directly or indirectly?
  Any procedure or function can be referenced directly or indirectly using the following objects:
  • Tables
  • Views
  • Procedures
  • Functions
  • Sequences
  • Package procedures or functions
Page 5 of 10 1234 5678910