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? How to Create the 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.What are the System Variables?
61. Restricted and UnRestriced Build –in
62.System.Message_Level := 5 and 20
63. System.Current_Item vs System.Trigger_ITem
64. Insert Sequence of the Trigger
65. How to Pass the Parameter one Form to Another Form?
66. Do_Key?
67. Two Text Item and Not Required Field. If I Move Cursor through Mouse from one item
To another item (Without Entering). What are the Trigger has Fired? When_validate_item Only
68. How to Populated data in the Control Block?
69.diff between text item and display item?
70)(i)When not null field value is changed to another value.
(ii);; ;; is changed to Null value.
What is the trigger sequence for above two senarios?
71) What is raise on entry property in Canvases?
72) what is block buffered property? If we set that as <10 how many records it will fetch?
73) how u will execute OS commands in forms?
74) how u will implement file operations in forms?
75)what is the diff. between post_change and when_validate _item?
76)what is diff between Pre Form and When new form instance?
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)
21 How to Call No Report to another Report?
22 DrillerDown Report?
23 Matrix Report Use?
24 Standard Procedure in SRW Package
25 What is use of Between Pages Trigger?
26 What is mean by Action Trigger?
27 Srw.Run_Report
28
Oracle:
1. what are the types of cursors?
1)implicit cursor 2)explicit cursor
2. What are cursor attributes?
1)%ISOPEN
2)%NOTFOUND
3)%FOUND
4)ROWCOUNT
3. what is the difference between cursor and pl/sql table?
4. what is parameterized cursor?
We can pass a variable as a parameter to the select statement used in the 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,count(*) from emp group by c1
85. Bulk Collection Exception?
86. Bulk Collection Variable?
87. Not Given Commit in side of the Pragma Autonomous Transactions? What will be happen?
88. No Data is available in Table—Select Count(*) from Table_Name, Select Sum(eno) from
table_name
89. Exit and Return Difference
Exit Is Used To Exit From A Loop Within A Block
Return Is Used To Return Back To The Calling Pl/Sql Block
SQL:
1. No Data is available in the Table.. That Time…
Select Count(*) from MPN
Answer: 0
Select Sum(Empno) From MPN
Answer : Nil
2.
