a2zinterviews

33.	Which data dictionary view is used to see the status of submitted jobs?
	The DBA_JOBS data dictionary view is used to display the status of the submitted jobs.

34.	Which Oracle package is used to manage the Oracle Lock Management services?
	The DBMS_LOCK package is used to manage the Oracle Lock Management services. This package is used to request, convert and release the locks using the Oracle Lock Management services.

35.	What is the advantage of using roles for system privilege?
	Roles are easy to manage and helpful in granting multiple system privilege to schemas. Any privilege can be added to a role or removed from a role. This would automatically affect all the schemas with that role.

36.	What is the benefit of storing the LOB datatype out of line?
	This allows the database to avoid scanning LOB data each time it reads rows from the table. The LOB data will be read only when it is required; however at other times, only the LOB locator values are read.