How to retrieve SYSADMIN password ?

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

(Continued from previous question...)

How to retrieve SYSADMIN password ?

If forgot password link is enabled and SYSADMIN account is configured with mail id user forget password link else you can reset sSYSADMIN password via FNDCPASS.

(Continued on next question...)

Other Job Interview Questions

• What are various options available with adpatch ?
• How to compile JSP in Oracle Applications ?
• How you will avoid your query from using indexes?
• What is FNDSM ?
• What is GSM in Oracle application E-Business Suite ?
• How do you find the number of rows in a Table ?
• When do you use WHERE clause and when do you use HAVING clause?
• What is difference between an implicit and an explicit cursor.
• What is different between TRUNCATE and DELETE?
• What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
• More...