How can we specify the Archived log file name fo

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

(Continued from previous question...)

221. How can we specify the Archived log file name format and destination?

By setting the following values in init.ora file. LOG_ARCHIVE_FORMAT = arch %S/s/T/tarc (%S - Log sequence number and is zero left padded, %s - Log sequence number not padded. %T - Thread number left-zero- padded and %t - Thread number not padded). The file name created is arch 0001 are if %S is used. LOG_ARCHIVE_DEST = path.

(Continued on next question...)

Other Job Interview Questions

• How do you call other Oracle Products from Oracle Forms?
• What are the different file extensions that are created by oracle reports?
• Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
• What is term?
• What is a database link?
• What is the proper method for disabling and re-enabling a primary key constraint?
• What does coalescing a tablespace do?
• How can you enable automatic archiving?
• What are the various methods of performing a calculation in a report?
• What is the effect of setting the value “CHOOSE” for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?
• More...