Answer Posted / chandra mohan
LIBRARY CACHE,DATA DICTIONARY CACHE
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the difference between dropping a database and taking a database offline? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
How to start SQL Server in minimal configuration mode?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the steps you will take to improve performance of a poor performing query?
internal architecture
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
. 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 the different types of replication and why are they used? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
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?
What the different components in replication and what is their use? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?