Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

What are the steps you will take to improve performance of a poor performing query?

0 Answers  


What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  


what do you understand by fine-grained auditing?

0 Answers   Oracle,


Give two examples of how you might determine the structure of the table DEPT.

2 Answers  


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  


Explain the use of table functions.

1 Answers  


How would you go about verifying the network name that the local_listener is currently using?

0 Answers  


How can we see the database version in os level

6 Answers   Oracle,


Hot backup procedure?

2 Answers  


What's the benefit of "dbms_stats" over "analyze"?

1 Answers  


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  


How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  


Categories