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

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  


Can you redefine a table online?

0 Answers   Oracle,


what is the role of dip user in our database?

0 Answers  


How would you extract DDL of a table without using a GUI tool?

0 Answers  


Datapump backup steps?

1 Answers  


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  


What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  


An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  


why Datapump is faster than traditional export and import

4 Answers   Mphasis,


You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  


What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,


what is the difference between db2start command and start database manager command?

1 Answers  


Categories