What is the cache hit ratio, what impact does it have on
performance of an Oracle database and what is involved in
tuning it?
How would you go about verifying the network name that the local_listener is currently using?
How does Oracle guarantee data integrity of data changes?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What background process refreshes materialized views?
2 Answers Accenture, FLSmidth,
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What view would you use to determine free space in a tablespace?
What are the operating modes in which database mirroring runs? : sql server DBA
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?
deleted of control file how will u recover control file?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What would you use to improve performance on an insert statement that places millions of rows into that table?