What are the minimum parameters should exist in

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

(Continued from previous question...)

221. What are the minimum parameters should exist in the parameter file (init.ora)?

DB NAME - Must set to a text string of no more than 8 characters and it will be stored inside the datafiles, redo log files and control files and control file while database creation. DB_DOMAIN - It is string that specifies the network domain where the database is created. The global database name is identified by setting these parameters (DB_NAME & DB_DOMAIN) CONTORL FILES - List of control filenames of the database. If name is not mentioned then default name will be used. DB_BLOCK_BUFFERS - To determine the no of buffers in the buffer cache in SGA. PROCESSES - To determine number of operating system processes that can be connected to ORACLE concurrently. The value should be 5 (background process) and additional 1 for each user. ROLLBACK_SEGMENTS - List of rollback segments an ORACLE instance acquires at database startup. Also optionally LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and LICENSE_MAX_USERS.

(Continued on next question...)

Other Job Interview Questions

• What are the different styles of activation of ole Objects?
• How can you determine if an index needs to be dropped and rebuilt?
• What cursor type do you use to retrieve multiple recordsets?
• Compare and contrast TRUNCATE and DELETE for a table.
• Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
• Talk about “Exception Handling” in PL/SQL?
• How do you execute a UNIX command in the background?
• What are the various sub events a mouse double click event involves?
• Which date function returns number value?
• A user is getting an ORA-00942 error yet you know you have granted them permission on the table, what else should you check?
• More...