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. How to Control the Dupliate Record in Multiple Record Block?
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)
How to Call No Report to another Report?
DrillerDown Report?
Matrix Report Use?
Standard Procedure in SRW Package
What is use of Between Pages Trigger?
What is mean by Action Trigger?
Srw.Run_Report
21
Oracle:
1. what are the types of cursors?
2. What are cursor attributes?
3. what is the difference between cursor and 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,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. Primary Key Vs Unique Key
90. What are the Constrains available?
91. Ref Cursor Vs Cursor?
92. How to tune the Sql Query? What are the things you are following?
93. How to Analyze the table? explain with Syntax?
94. What are the types we can analyze the given object explain with syntax?
95. Where we have to see statistics after analysing the Object?
96. What are the frequent errors you are getting in your Product? How you are fixing those?
97. If suppose your junior have written some pkg, How you review that pkg? What are the
suggestions you will give to your junior?
98. If suppose, you have more than 20 indexes on table which is having more than 1 lakh records?
Which performance will go down?
99. How to select the Other users data?
100. If suppose in the data base Schemas A,B are there. Schema A is having DBA rights those are
giving to B and if we drop the schema A then schema B is having DBA rights on all objects in that database?
101. If suppose in the data base Schemas A,B,C are there. Schema A is having Emp table. He is giving all rights on Emp table to B and B is giving all rights on Emp table, Whether C Schema can drop the Emp table in A?
102. If suppose in the data base Schemas A,B are there. Schema A is having Emp table. He is giving
all rights on Emp table to B and A is deleting records from Emp table at the same time B is
truncating the Emp table in A. What will Happen?
103. If suppose in the data base Schemas A,B are there. Schema A is having Emp table. He is giving
all rights on Emp table to B and A is deleting records from Emp table based on condition.
after one minute B is Updating same records in the Emp table in A. What will Happen?
104. If suppose in the data base Schemas A,B are there. Schema A is having Emp table. He is giving
all rights on Emp table to B. and created one index with 2 columns on Emp table
B can add third column for the index which is created by A? What is the right he have to take from A?
105. There are so many Q''s on DCL commands. If I remwmber I will send to you others?
106. What is Locking mechanism? How you are handling those?
107. Varchar2 Vs Varchar
108. Logging Vs No Logging.
109. No Copy Hint and Bulk Collection.
110. Explicit Cursor Vs Implicit Cursor
SQL:
No Data is available in the Table.. That Time…
Select Count(*) from MPN
Answer: 0
Select Sum(Empno) From MPN
Answer : Nil
2.
