Forms:
1. Pre – Query Vs Post- Query Vs Post- Delete
2. Set_Item_Instance_Property Vs Set_Item_Property Vs Display_Item
3. Post
4. Open Form Vs New Form Vs Call Form
5. Close Form Vs Exit Form
6. Relation Ship
7. Property Class Vs Visual Attributes
8. Type of Windows
9. Type of Canvas
10. Type of LOV
11. Type of Record Group
12. Type of Triggers
13. Copy Vs Name_In
14. Trigger Execution- Hierarchy
15. ParamType
16. Parameter Variable Vs Global Variable
17. Object Group Vs Object Library
18. Pll Procedure Vs Programm Unit Procedure Vs Back End Procedure
19. Example of Build In Packages
20. Type of Alerts
21. Trigger Sequences Item Level, Block Level & Form Level
22. When-Validate-Item Vs Post-Text-Item Vs Pre-Text-Item
23. Show-Window Vs Open-Window
24. Error-Code & Error-Text (Form) / SqlErrm & SqlCode (Back End)
25. I have a multi record block I want to highlight the record where my cursor is . which property will u use to set the above one?
26. what are the types of master detail relations?
27. what are the different types triggers created when u create master/detail relation? Explain
28. what is the trigger we will write when the tab page changed?
29. what are the procedures to call the reports from form?
30. How will u dynamically populate the values into a list item at runtime ?
31. To display the stacked canvas on a specific place which property will u set?
32. when will u use on-insert tigger?
33. How to Find the Which Item is Firing through Trigger ?
34. On-Error Trigger Use? When will this Trigger is fire?
35. Break
36. How to Debugging the Forms?
37. What is property class?
38. Text –Parameters Vs Data- Parameters
39. Recalculate Bulid In
40. How to find the record Status? Status Type?
41. System.Record_Status Vs Get_Record_Property
42. How to run the user defined Trigger?
43. Execute_Trigger Vs Execute_Query
44. What is Use of the Run_Product and Parameter Details?
45. Multi Record Block Unique Check ?
46. Forms_DDL
47. Post Vs Form_Commit
48. Post-Form-Commit Vs Post – Database- Commit
49. Global Variable Vs Parameter Variable
50. Run_Product Vs Run_Report_Object
51. Object Lib. Vs P/l sql Lib.
52. What is MDI Window?
53. What is Use of MDI Window?
54. If u calling one form to another form? How to Commit First Form?
55. What is the use of Record group and Lov?
56. How to Generate the record Dynamicaly using Lov?
57. How to pass the parameters to Reports and what is the methods available in Forms?
58. How to Call Reports from Form?
59. Synchronize Vs Asynchronize?
60.
Reports:
1 Type of Reports
2 Type of Triggers
3 Trigger Sequences.
4 Formula Column Vs Place Holder Column
5 Anchor
6 Type of Mode?
7 Flex Mode
8 Confine Mode
9 How many layout in Matix Report and Matrix With Group?
10 Lexical Parameter Use? Where we use?
11 Lexical Parameter Vs Bind Parameter Vs User Define Parameter
12 Srw.Do_Sql & Srw.Do_Sql_Failure
13 Srw.Get_Page_Num
14 Srw.Run_Report
15 Srw.Truncated_value
16 Vertical Elasticity and Horizontal Elasticity
17 Format Trigger
18 How to debugging in Reports?
19 Srw.Set_Format_Mask
20 Filter (First,Last and PL Sql)
Oracle:
1. what are the types of cursors?
2. What are cursor attributes?
3. what is the difference between cursor and pl/sql table? FETCH ROW BY ROW IN CURSOR,MOVE ANY WHERE IN PL/SQL TABLE
4. what is parameterized cursor?
5. write the syntax of pl/sql table?
6. what is the difference between pl/sql table and record group?
7. what is TKPROF ? for what purpose will u use it?
8. what is the difference between IN and EXISTS ?
9. what is bulk collect ? where will u use?
10. what is MERGE statement?
11. what is explain plan?
12. what is the difference between merge join ,hash join?
13. Dbms_FlashBack
14. Dbms_job
15. Dbms_Utility
16. Dbms_Output
17. Dbms_Sql
18. Dbms_Ddl
19. Dbms_Mview
20. Dbms_File
21. Dbms_Session
22. Dbms_Debug
23. Dbms_Types
24. Dbms_Pcofiler
25. Dbms_DataPump
26. Dbms_Metadata
27. Execute
28. OverLoading
29. Advantage of Package
30. Mutating Error and How to Solve this error?
31. Too Many Rows and No data Found
32. When Others
33. Data Type Triggers
34. Type of Pragma and what is the use of this Pargma
35. Type of Tables
36. Delete and Truncate Differences
37. Oracle 9i Vs Oracle 10G
38. Type of Locks and what is the use of this Locks
39. Type of Views
40. Type of Index
41. Bit Map Index and Hash Index
42. Materalised View
43. Raise Error
44. Bulk Collections and Bulk Collection Excpetions
45. Indices of Use in the Pl sql tables
46. Collections
47. Trunc and Trim Differences
48. To_Char vs To_Date
49. Tuning
50. P/L Sql Table Exception
51. What are the Exception has found in SQL Query?
52. Sql Loader?
53. If loading the Data through Sql Loader, How to avoid the exisiting Trigger Fire?
54. One Time Only Procedure?
55. Different Type of Constraints?
56. Outer Join Vs Inner Join
57. What is the use of the Save Exceptions?
58. Level of Constraints ( Column Level and Table Level)
59. Primary Key Vs Composite Primary Key
60. Roll Up and Cube
61. Tuning Hints
62.What is Trigger?
63.The table is available columns Qty,Price and Amount? Qty and Price is coming from Form
We insert the amount column (qty * amount) by the way of trigger.
64. What is the advantage of the Package and Procedure?
65. What are the hire Key Query? (Prior like)
66. How to use the variable across the procedure in the packages?
67. Set Serveroutput On (Backround Process Details)?
68 Entity Relationship diagram?
69. What is Entity?
70. How to Print the Bind Variable in Sql Prompt?
71. What is the different between Sql & Sql * Plus?
72. What is the different between Bind Variable Vs Lexcial Variable?
73. Entity Result Set?
74. How to select the data from the Nestle Table?
75 . What is mean by Nested Table?
75. Implicit Cursor Vs Explicit Cursor and Examples?
76. What are the Advantages of Packages?
77. Emp table having 10 Record, if u select 2 from emp?
78. Select count(2) from emp;
79. Select count(2) ,Count(*), Count(rowid) from emp?
80. Select sum(2) from emp;
81. Select rownum,.* from emp;
82. Select rownum,sal from emp;
83. Select rownum,sal from emp order by sal;
84. Select c1,c2,c3
