Un-Answered Questions { DB Administration }

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

1791


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

2401


How to start SQL Server in minimal configuration mode?

6905


Where would you look for errors from the database engine?

2325


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?

1979


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1824


Explain materialized views and how they are used.

1865


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?

2943


. 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?

1958


what is the last version,the release date of that version and fix pack of ibm db2 udb?

1497


what are the differences of where and if in SAS?

1643


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

3774


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.

2031


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

1848


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2174