a2zinterviews

29.	What is the difference between TO_BLOB and TO_CLOB functions?
	The TO_CLOB function is used to convert the LONG, VARCHAR2, and CHAR datatypes to the CLOB datatype; whereas, the TO_BLOB function is used to convert the LONG RAW and RAW datatype to the BLOB datatype.

30.	What is the difference between referenced object and dependent object?
	If the definition of an object A references object B, then A is the dependent object and B is the referenced object. If a table is being queried in a procedure then the table is the referenced object and the procedure is the dependent object. However, if the definition of the table is modified, the procedure may or may not execute correctly.

31.	Which data dictionary view is used to see the status of currently running jobs?
	The DBA_JOBS RUNNING data dictionary view is used to display the status of the jobs currently running.

32.	What is the utility of the DBMS_LOGMNR_D package?
	This package queries the dictionary tables of the current database and creates text based file with their contents.