Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
How would you determine what sessions are connected and what resources they are waiting for?
Can you redefine a table online?
what is the role of dip user in our database?
How would you extract DDL of a table without using a GUI tool?
Datapump backup steps?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is the difference between clustered and non-clustered index? : sql server DBA
An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
why Datapump is faster than traditional export and import
You're getting high "busy buffer waits" - how can you find what's causing it?
What background process refreshes materialized views?
2 Answers Accenture, FLSmidth,
what is the difference between db2start command and start database manager command?