Category Archives: PL/SQL Interview Questions

What background process refreshes materialized views? | PL/SQL Questions

The Job Queue Processes.

Posted in PL/SQL Interview Questions | Leave a comment

When a user process fails, what background process cleans up after it? | PL/SQL Questions

PMON

Posted in PL/SQL Interview Questions | Leave a comment

Explain materialized views and how they are used. | PL/SQL Questions

Materialized views are objects that are reduced sets of information that have been summarized, grouped, or aggregated from base tables. They are typically used in data warehouse or decision support systems.

Posted in PL/SQL Interview Questions | Leave a comment

Where in the Oracle directory tree structure are audit traces placed? | PL/SQL Questions

In unix $ORACLE_HOME/rdbms/audit, in Windows the event viewer.

Posted in PL/SQL Interview Questions | Leave a comment

Name three advisory statistics you can collect. | PL/SQL Questions

Buffer Cache Advice, Segment Level Statistics, & Timed Statistics.

Posted in PL/SQL Interview Questions | Leave a comment

Explain the use of table functions. | PL/SQL Questions

Table functions are designed to return a set of rows through PL/SQL logic but are intended to be used as a normal table or view in a SQL statement. They are also used to pipeline information in an ETL process.

Posted in PL/SQL Interview Questions | Leave a comment

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE. | PL/SQL Questions

A function and procedure are the same in that they are intended to be a collection of PL/SQL code that carries a single task. While a procedure does not have to return any values to the calling application, a function … Continue reading

Posted in PL/SQL Interview Questions | Leave a comment

What command would you use to encrypt a PL/SQL application? | PL/SQL Questions

WRAP.

Posted in PL/SQL Interview Questions | Leave a comment

Explain the use of setting GLOBAL_NAMES equal to TRUE. | PL/SQL Questions

Setting GLOBAL_NAMES dictates how you might connect to a database. This variable is either TRUE or FALSE and if it is set to TRUE it enforces database links to have the same name as the remote database to which they … Continue reading

Posted in PL/SQL Interview Questions | Leave a comment

How would you determine the time zone under which a database was operating? | PL/SQL Questions

select DBTIMEZONE from dual;

Posted in PL/SQL Interview Questions | Leave a comment