Play and learn 300 000+ tabs online

Sunday, January 24, 2010

Oracle Interview Questions

1)    What are the multithreaded server  and how it is different from dedicated server .
2)    What are the new features incorporated in ORACLE 7.2 version.
3)    What are the various difference between ORACLE 6.0 ORCALE7.0.
4)    How many types of triggers U have used in your application.
5)    What are the difference between WHEN-VALIDATE-ITEM and POST-CHANGE trigger.
6)    What is Record group and what are the advantages of having it.
7)    What is the differences between Tlist,ComboBox and PopList properties of list items.
8)    What are the differences between copying and referencing an object.
9)    What is MDI Window.
10)    What is the procedure to call a Microsoft Application from forms 4.5.
11)    What is VBX controls and how it helps to build an application in Forms 4.5.
12)    How Parameters will be passed to other Oracle tools.
13)    What kind of quality management Sonata is having.
14)    What is meant by ISO9000 an dwhat are the advantage to have it.
15)    What  do you mean by debugger in Forms 4.5
16)    While debugging we can change the script or not.
17)    Can We have an OLE server for Oracle application.
18)     are the various variables in Proc and how we are declaring it.
19)    What is meant by Indicator variable in Pro*C
20)    What is difference between SQLCA and ORACA.
21)    How You are trapping errors in Pro*C program
22)    What is meant by UserExits and how we You will call it from your forms 4.5 application.
23)    What is difference between UserExits and Pro*C program
24)    What are the various triggers that Reports 2.5 supports.
25)    What is icon.
26)    How many(minimum) groups are required to prepare a Matrix Report.
27)    What do you mean by bind parameter and lexical parameter.
28)    What are the various difference in UNIX and WINDOWS95 Operating systems.
29)    What are the various differences in Forms 3.0 and Forms 4.5
30)    Can I have a HTML document from Forms 45 application.
31)    What do you mean by activation style property of an OLE object.
32)    What is difference in Object embedding and object Linking.
33)    What are the situations in which we can go for embedding and in which we can go for Linking.
34)    How You are connecting to Oracle database and what is meant by connect string.
35)    What are the difference between Post-fetch and Post-Query trigger and when they will fire.
36)    What is meant by partition view.
37)    What are various triggers that You have extensively used in your application.
38)    What is difference between following built-ins
39)    Create_group_with_query and Populate_group_with_query.
40)    What is Dynamic SQL.

41)    How you can change menu type property
42)    what are the backup procedures for oracle.
43)    What is meant by 2 phase commit.
44)    Which case designer you have used and what was the version of it.
45)    what is SQL loader.
46)    What are the various security provided by oracle.
47)    What is difference between content and stacked canvas
48)    Can you tell something about TOOLBAR.
49)    What are the sequence of commit processing triggers
50)    can you create dynamic LOV.
51)    How you will control transaction in MDI.
52)    what do you mean by session in MDI.
53)    Database triggers call database procedures and vice versa.
54)     do you use global variables and parameters.
55)    you will define and raise  your own exceptions.
56)    many error codes you  can use to have your own error messages.
57)    Can you change the retrieved value of reports.
58)    What is an anchor in Reports 2.5.
59)    What is the trigger that fires while navigating between the form.
60)    Can you tell something about window based triggers.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.