OraQA

Hi,

I have an interview next wednesday, still i didnt get any guidance for interview. plz help me
I have some questions plz send me the answer as early as possible. plz

Here’s the question

4. Reports - what did you set in report to be able to print the report in pre-printed stationery ?
5. What did you set in report to generate report in Character Mode ?Is there anything in report
properties or data model etc ?
6. What are the common problems you faced while doing report ?
7. Why does frequency error come ?
8. How do you rectify it ?
10. How do you create a new field in the layout ? How do you get into the repeating frame ? What
changes do you make in the property of that field ?
11. How many groups are needed in Matrix report ?
13. What are the disadvantages of Matrix Report ?
14. How many types of reports are there ?
15. Define drill down report ?
16. Can you create a table from report ? If yes then how ?
17. What is a placeholder column ?
18. What are the triggers in report and their sequence of firing ?
19. How do you design a report so that it takes less time to run ? whether you have less number of
queries or more ?
20. What is an anonymous Block ? How do you use it ?
21. What is the difference between Union and Union All? Eg. Table A has 1,2,3, and Table B has
1,2,3,4,5 what will be the output in both cases ?
22. What is the difference between Open Form, New Form and Call form ? What is the difference in
terms of database ?
23. If I make changes to the detail form and say commit , will the master form data also get
committed ?
24. What are the transactions in Inventory ?
25. Did you use OE_Query in Order Entry ?
26. Can a ‘record type’ parameter be passed in concurrent program which is having a procedure?
27. How to disable an Index ?
28. What are the types of exception ? give eg
29. How do you call raise_application_error ? give syntax
30. How do you call a concurrent program from a PL/SQL code ? give syntax
31. How do you use Format trigger ? A- to diplay or not to display . Can it be used in anyother way ?
32. What is anchoring ? Have you used it ?
33. Item No is their in Item Flexfield. How can you display it your report ?
34. What are the Validation Types in a Value Set ?What is NONE type and What is TABLE type ?
35. In TABLE type Value Set 3 things are there Value,Value ID and Meaning ? which of them is
important ?
36. In printer driver what do you mean by escape sequence ? (this was related to my report page
length,width, number of chars in a line etc) What is there at the Unix side ?
37. Did you try to print the logo in your report ?
38. What is a difference between Procedure in Forms and Stored Procedure in Database ? which
one you recommed to use ?
39. Can you create a library file in forms ?
40. Did you create any bitmap report ?
41. How to register a form ?
42. How is Oracle apps handling the security ?
43. What is Multi- Org ? Tell its heirarchy ? where is currency defined ? How do you call it in report ?
44. What is the difference between _ALL table and other ?
45. Which are the Modules which are Multi Org ?
46. What is Lexical Parameter ?
47. Can complete query be passed as lexical parameter in the report ?
48. What is Mutating table ? why do we get error..they gave an eg. They have table A. now they
have written a pre-insert trigger on A for each row.. in that we say select count(*) from A;.. Is this
mutation error. Yes/No. How to recitfy it ?
49. How do you encrypt your code ? Thru Unix ?
50. How do you debug your PL/SQL code, report and form?
51. Even if your PL/SQL is correctly coded no errors then also you are not able to see any output.
Why?
52. What are backgroup processes ?
53. What is PL?SQL table ? What are the max columns you can have in the table ?
54. We have got a stored function eg. func_A . If we say , select func_A from dual; will it run ?
55. What are the various version of Oracle Apps you have worked on?
56. Overview of AR Autoinvoice Interface (Interface Tables and API used )
57. What do you mean by multi-org ?
58. What is the procedure used in pl/sql procedures to set up multi-org in SQL session ?
59. If you have one company in USA and one in UK will you use different set of books ?
60. If you have one company in France and one in Germany using the same currency will you use
different set of books ?
61. If these companies have different calendar can you use the same set of books ?
62. Define the hierarchy of organizations i.e relationships between business groups, SOB, OU, legal
entities, inventory org.
63. From which profile value will you get the value of org_id ?
64. How do you write to a file from a PL/SQL block ?
65. How will you write into an Oracle Applications output file from a PL/SQL procedure ?
66. What is an anonymous block ?
67. What is an exception ? How do you raise user defined exceptions ?
68. How do you use the tkprof utility ?
69. What are the types of optimizers ? Which optimizer is used in Oracle 8I ?
70. While writing a query how can you suppress the use of indexes ?
Write any filter in the where clause in the column on which the index is based; Eg write : where
emp_id > 0 or where emp_id is not null
71. What should be the order of tables while writing the where clause ? i.e. what steps would you
take keeping tuning in mind ?
72. What is the difference between primary key and unique key ?
73. Can unique key / primary keys have not null values ?
74. If you have to create a custom procedure in apps, where will you do it ? Who will be the owner of
the procedure, how will apps schema execute it ?
75. In forms, what do you mean by libraries ? Do libraries need to be compiled ?
76. What do you mean by object groups ?
77. What are the different types of master-detail relationships ?
78. What are the different types of block co-ordinations ?
79. Where will you write customized code in the report triggers ?
80. How will you register a form/report/concurrent program
81. What are the different types of pl/sql tables ?what is the best interns of performance and why ?
82. How do you hide a cursor definition in the package spec.?
83. How do u get the number of row affected by a dml statement? should the count be taken after commit or before commit..?
84. what is mutating trigger..?
85. How do u call the shell script from the pl/sql.?
86. Exception handling: can u skip exception handling for just one record for a specific exception .. if so .. how ?
87.can db link used in the dynamic sql.?
88.What is the difference between passing by reference & passing by value? How do you pass by
ref & value in a PL/SQL proc/function?
89.What are the new triggers introduced in 8i?
90.How do you make use of UTL Files?
91.Is it possible to raise pre defined oracle errors in PL/SQL?
92.What are Hints? How do you use them to tune?
93.What are the different optimizers? What is the best?
94.What is the sequence of execution of Form triggers?
95.What is the sequence of execution of report triggers?
96.Reports: Explain lexical and bind parameters
97.How do you find out the name of the OS user in PL/SQL?
98.What is a save point?
99.How do you call dynamic SQL statements in 8i?
100.How do you store return value in a bind variable in dynamic SQL statements?
101.Can you use substring function on an indexed column?
102.What are the different ways of tuning SQL statement

Awaiting………….
Jaleel Mohamed F

Filed under General. Follow any responses to this entry through this RSS 2.0 feed.