Un-Answered Questions { Oracle DBA (Database Administration) }

What is the use of the drop option in the alter table command?

325


How do you use automatic pga memory management with oracle 9i and above?

300


Which function is used to find the largest integer less than or equal to aspecific value?

317


Explain procedure to change characterset of a database.

347


What is oracle archived redo log?

309


what does the no logging option do? Why would we use it?

289


What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

304


List five most important parameter in 9i affecting performance?

297


How can you tell if an index on particular table is used or not used in 9i?

293


You see a wait on lms process in statspack, what does that mean?

304


What does the no logging option do? Why would we be careful of using it?

292


Tell me about standby database? What are some of the configurations of it?

285


When using oracle export/import what character set concerns might come up? How do you handle them?

317


Which date function is used to find the difference between two dates?

285


How do you install statspack?

411