What are statistics, under what circumstances they go out of date, how do you update them?
What are the steps you will take to improve performance of a poor performing query?
How to start SQL Server in minimal configuration mode?
Where would you look for errors from the database engine?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Explain materialized views and how they are used.
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what are the differences of where and if in SAS?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?