Un-Answered Questions { DB Administration }

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

1155


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

1611


How to start SQL Server in minimal configuration mode?

5232


Where would you look for errors from the database engine?

1709


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?

1235





Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1137


Explain materialized views and how they are used.

1105


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?

2306


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

1215


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

941





what are the differences of where and if in SAS?

976


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

3065


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.

1335


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

1221


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

1542