ORACLE PAPER - 28 NOV 2008
1. There is a string 120000 12 0 .125, how you will find the position of the decimal place?
INSTR ('120000 12 0 .125',1,'.')
output 13
2. What are different modes of parameters used in functions and procedures?
-IN
-OUT
-INOUT
3..
4...);
9....
34. If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?
It won't, Because SYSDATE format contains time attached with it.
35..
36. What is an Integrity Constraint ?
Integrity constraint is a rule that restricts values to a column in a table.
37..:
..
40. What is a database link ?
Database Link is a named path through which a remote database can be accessed.
41... commited... :: Databese Buffer of SGA stores the most recently used blocks of datatbase.
59.
60..
61..
62..
65. What are the Different Optimisation.;
68..
69.;
70....)
75. What is concurrency
Concurrency is allowing simultaneous access of same data by different users. Locks useful for accessing.
76..
77..
78.
79.
80. What is Row Chaining
The data of a row in a table may not be able to fit the same data block.Data for row is stored in a chain of data blocks .
81...
85...
102..
104. Is forms 4.5 object oriented tool ? why?
yes , partially. 1) PROPERTY CLASS - inheritance property 2) OVERLOADING : procedures and functions.
105.
106. What is SECURE property?
- Hides characters that the operator types into the text item. This setting is typically used for password protection.
107.
108. Can you store pictures in database? How?
Yes, in long Raw datatype.
109. .
110....
119. What are user-exits?
It invokes 3GL programs.
120...
129. cursur state across transaction Open/close.
130. What is transactional trigger property?
Identifies a block as transactional control block. i.e. non - database block that oracle forms should manage as transactional block.(NON-ORACLE datasource) default - FALSE.
131.)
132..
133....
138. Which trigger related to mouse?
When-Mouse-Click
When-Mouse-DoubleClick
When-Mouse-Down
When-Mouse-Enter
When-Mouse-Leave
When-Mouse-Move
When-Mouse-Up
138...