How to compile an Oracle Reports file ?

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

(Continued from previous question...)

How to compile an Oracle Reports file ?

Utility adrepgen is used to compile Reports. Synatx is given below adrepgen userid=apps\<psswd> source = $PRODUCT_TOP\srw\filename.rdf dest=$PRODUCT_TOP\srw\filename.rdf stype=rdffile dtype=rdffile logfile=x.log overwrite=yes batch=yes dunit=character

(Continued on next question...)

Other Job Interview Questions

• When do you use WHERE clause and when do you use HAVING clause?
• Which data type is used for storing graphics and images?
• There are lot of DBC file under $FND_SECURE, How its determined that which dbc file to use from $FND_SECURE ?
• What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
• Where is Jserv configuration files stored ?
• What is difference between UNIQUE and PRIMARY KEY constraints?
• What is difference between .xml file and AutoConfig ?
• How to retrieve SYSADMIN password ?
• Can you use a commit statement within a database trigger?
• How to start Applications listener ?
• More...