Friday 6 February 2015

ORACLE SQL PL/SQL Interview Questions and Answers pdf (Page3)

21. How would you determine the time zone under which a database was operating? | PL/SQL Questions
select DBTIMEZONE from dual;

22. 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 are linking.

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

24. 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 will return a single value. A package on the other hand is a collection of functions and procedures that are grouped together based on their commonality to a business function or application.

25. 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.

26. Name three advisory statistics you can collect. | PL/SQL Questions
Buffer Cache Advice, Segment Level Statistics, & Timed Statistics

27. 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

28. 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.

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

30. What background process refreshes materialized views? | PL/SQL Questions
The Job Queue Processes.
More Questions & Answers :-
Page1  Page2  Page3  Page4  Page5

No comments:

Post a Comment