What is SYNCHRONIZE?
Synchronizes the terminal screen with the internal state of the form. That is SYNCHRONIZE updates the screen display to reflect the information that Oracle Forms... Read more »
Archive for May, 2008
What is the difference between Object Embedding and Linking in Oracle Forms
Linking in Oracle Forms? An Ole server applications creates OLE objects that are embedded or linked in OLE containers. Examples of OLE servers are MS Word and MS... Read more »
How do you create a new session while opening a new form?
Using OPEN_FORM built-in setting the SESSION option. Ex: OPEN_FORM(??STOCKS??,ACTIVE,SESSION); When you invoke multiple forms with OPEN_FORM and CALL_FORM in the Same... Read more »
What are the built-ins used for finding Object ID functions?
FIND_GROUP(function) FIND_COLUMN(function) Read more »
What are the built-ins used for processing rows?
GET_GROUP_ROW_COUNT(function) GET_GROUP_SELECTION(function) GET_GROUP_SELECTION(function) RESET_GROUP_SELECTION(Procedure) SET_GROUP_SELECTION(Procedure) UNSET_GROUP_SELECTION(Procedure) Read more »
What are the built-ins used for getting cell values?
GET_GROUP_CHAR_CELL(function) GET_GROUP_DATE_CELL(function) GET_GROUP_NUMBER_CELL(function) Read more »
List the factors that can affect the accuracy of the estimations?
The space used transaction entries and deleted records does not become free immediately after completion due to delayed cleanout. Trailing nulls and length bytes... Read more »
What are disadvantages of having raw devices?
We should depend on export/import utility for backup/recovery (fully reliable) The tar command cannot be used for physical file backup, instead we can use dd command... Read more »
What a hit ratio?
When Segment is dropped. When Shrink (RBS only) When truncated (TRUNCATE used with drop storage option) Read more »
What is a Rollback segment entry?
It is the set of before image data blocks that contain rows that are modified by a transaction. Each Rollback Segment entry must be completed within one rollback... Read more »
What is meant by Redo Log file mirroring ? How it can be achieved?
Process of having a copy of redo log files is called mirroring. This can be achieved by creating group of log files together, so that LGWR will automatically writes... Read more »
How to implement the multiple control files for an existing database?
Shutdown the database Copy one of the existing control file to new location’ Edit config.ora file by adding new control file name Restart the database Read more »
What is a control file?
Database’s overall physical architecture is maintained in a file called control file. It will be used to maintain internal consistency and guide recovery operations.... Read more »
Is it possible to use raw devices as data file and what is the advantages over file system files?
Yes.The advantages over file system files : I/O will be improved because Oracle is bye-passing the kernal while writing into disk. Disk Corruption will be very less. Read more »
How will you estimate the space required by non-clustered tables?
Calculate the total block header size Calculate the available data space per block Calculate the combined column length of the average row Calculate the total average... Read more »