| Interview questions... please help answer [message #116935] |
Sat, 23 April 2005 11:55  |
vgs2005
Messages: 123
Registered: April 2005
|
Senior Member |
|
|
Hi,
I'm preparing for an interview. I found these from some of the topic questions. The last time I used Oracle Forms/Reports was more than 2 years ago. My computer does not have a Personal Oracle so I can at least see the Help file, nor do I have yet the books to refer to.
It will be very helpful in my preparation if you can provide the answers for any the following questions.
1. How to use single data block to query multiple tables
2. How to see the select statement when we issue execute_query
3. How do you trap default forms processing ( DML)
4. What is purpose and order of firing the following triggers
- on fetch
- on select
5. What is the number of records buffered and Query array size properties of data block
6. What is the difference between object libraries and object groups
7. What is the difference between PL/SQL library and object library
8. What is the difference between pre-text-item and when-new-item-instance triggers
9. What is the order of firing the following triggers
- when-new-form-instance
- pre-text-item
(Both are in form-level)
10. What is the default validation unit of form module
11. What is the order of checking for a program unit from form module(local program unit, library, stored procedure)
13. what is the use of pre text/pre record/pre form
14. what is id_null function
15. what is the difference between call_form , open_form, new_form
- Which is restricted built-in and why?
- Which can't issue savepoint
16. which are the triggers will fire in the following situation:
I have three text items
1. Text-item1
1.key-next-item
Go_item (:text_item2);
Go_item (:text_item3);
2. Text-item2
1. Pre-text-item
2. When-validate-item
3. When-new-item-instance
4. Key-next-item
5. Post-text-item
6. Post-change
3. Text-item3
1. Pre-text-item
2. When-validate-item
3. When-new-item-instance
4. Key-next-item
5. Post-text-item
6. Post-change
If I press tab or enter key at text-item1 what are the triggers will fire and order of firing during the entire navigation.
If I change key-next-item trigger of text-item1
Go_item (:text_item2);
: Text_item2: ='Nagendra';
Go_item (:text_item3);
Then what are the triggers will fire and order of firing
17. How do you suppress the logon screen while running the form for the first time
18. What is primary canvas property of window and where it will be useful
19. I have when-button-pressed trigger at form , block and item level
If I want to execute first block, form then item level trigger what changes I have to make.
20. what is data parameter and text parameter
21. Can we re-generate a library that is currently accessing by some other session
22. Can we re-generate and save a library that has been attached with some forms but they are running currently.
23. Can we re-generate a library that has been attached with some forms , will the changes will reflect in the referenced forms
24. What is the use of transactional triggers
25. Can we modify a sub classed object ( from object group and from object libraries)
26. How to set forms default directory
27. What is the return data type of populate_group built-in
28. What is the difference between OLE object created at design time and runtime
29. Will the timer will expire during large query executing
30. What is the built-in package available to manipulate text files( forms)
31. Can we define a relation between two control blocks
32. If we change relation property from non-isolated to cascading what changes will occur
33. If we delete on-clear-details trigger in a relation what happens
34. What is the first trigger fires when we run a form
35. What is the use of enforce primary key property of data block
36. Can we put items other than buttons in the toolbars
37. Which object relates content and stacked canvases(window)
38. How to navigate from one form to other form(built-in)
39. How to copy values from list item to record group
40. In a non-isolated relation what is the order of firing the following triggers
1. on-populate-details
2. on-clear-details
3. pre-query
4. pre-select
41. How to find out the previous form id in multi form application(it's system variable)
42. How to use single LOV for multiple items
Multiple choice:
1. What is the size of Varchar in Oracle 8.0 ?
a. 2000
b. 4000
c. 254
d. none of the above
2. What is the size of Varchar in Oracle 7.0 ?
a. 2000
b. 4000
c. 254
d. none of the above
3. The default value the lpad function takes is
a. a space (' ')
b. an asterisk
c. The default value is not optional
d. None of the above
4. The no. of columns that may be used as composite primary key in oracle 8
a. 8
b. 16
c. 32
d. none of the above
5. which of the following is true about add_months
a. we can pass a numerical value in first parameter
b. we can pass a negative value in second parameter
c. Both a & b
d. None of the above
6. The latest date that can be stored in oracle 8
a. 31st Dec 4012 A.D
b. 31st Dec 4011 A.D
c. Dec 31st ,9999
d. None of the above.
7. What happens when the first date is greater than the second date that is passed to the months_between function in oracle 8.
a. It gives an error
b. It gives a negative value
c. None of the above
8. Regarding the Summary query which of the following is true
a. The order of the base column list in the select statement should be same in the Group by clause.
b. The order of the base column list in the select statement need not be same in the Group by clause.
c. None of the above
9. Regarding the Summary query which of the following is true
a. All the base table columns selected in the select list should be specified in the Group by clause.
b. All the base table columns selected in the select list need not be specified in the Group by clause.
c. None of the above.
10. How do u mask the user from entering irrelevant data ?
a. Synonym
b. View
c. Index
d. sequence
11. What does the length function returns when applied to column of char datatype ?
16. If you want to restrict the user, to enter the same values that has been stored in other table then what constraint do u use?
a. Entity integrity
b. Referential Integrity
c. Both a & b
d. None of the above
17. Which of the following is true about NULL?
a. when an arithmetic operation is performed on NULL, u will get the result as NULL
b. NULL is same as 0.
c. NULL is same as blank date.
d. None of the above
18. For a DDL statement, which of the following is true
a. A DDL statement is preceded and followed by commit.
b. All the DML statements gets committed even when u get an error after writing DDL statement.
c. Both a & b
d. None of the above.
19. Which of the following is true for update clause?
a. We can update two base tables simultaneously
b. U can use a subquery in SET clause of the UPDATE statement.
c. Both a & b
d. None of the above
20. Which of the following is true for delete?
a. Delete statement can be given without writing where clause.
b. We can delete two tables simultaneously
c. Both a & b
d. None of the above
22. In oracle 7 which of the following is true about manipulating the view
a. View based on two base tables can be manipulated
b. View having a column which contain operation can be manipulated
c. Both a & b
d. None of the above
23. In oracle 8 which of the following is true about manipulating the view
a. View based on two base tables can be manipulated
b. View having a column which contain operation can be manipulated
c. Both a & b
d. None of the above
24. Which of the following is true about packages
a. We can write a procedure in package body which has not been specified in package specification.
b. We cannot write a procedure in package body which has not been specified in package specification.
c. Both a & b
d. None of the above.
25. Which of the following is true about outer joins
a. The outer join symbol should be present on any one side of the join.
b. The outer join symbol may be present on both the sides of the join
c. The outer join return the rows from the two tables that donot have matching records in other table.
d. None of the above
27. What does OFA stands for ?
a. Oracle Flexible Architecture
b. Oracle Financials Applications
c. Optimal Flexible Architecture
d. None of the above
thanks in advance...
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
