DBA > Job Interview Questions > DATABASE Administrator (DBA) Interview Questions and Answers

Where can you get a list of all initialization p

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

Level: Low
Expected answer: You can look in the init.ora file for an indication of manually set parameters. For all parameters, their value and whether or not the current value is the default value, look in the v$parameter view.

(Continued on next question...)

Other Job Interview Questions