Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
What are the steps you will take to improve performance of a poor performing query?
What are statistics, under what circumstances they go out of date, how do you update them?
what do you understand by fine-grained auditing?
Give two examples of how you might determine the structure of the table DEPT.
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Explain the use of table functions.
How would you go about verifying the network name that the local_listener is currently using?
How can we see the database version in os level
Hot backup procedure?
What's the benefit of "dbms_stats" over "analyze"?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
How do you troubleshoot errors in a sql server agent job? : sql server DBA