Oracle Interview Questions - An Interviewhelper.org blog

What are three panes that appear in the run time pl/sql interpreter

2009-01-28T05:43:00.000-08:00

Question :What are three panes that appear in the run time pl/sql interpreter?
Answer : 1. Source pane. 2. interpreter pane. 3. Navigator pane.

What is a combo box

2009-01-28T05:42:00.000-08:00

Question :What is a combo box?
Answer : A combo box style list item combines the features found in list and text item. Unlike the pop list or the text list style list items, the combo box style list item will both display fixed values and accept one operator entered value.

What is the frame & repeating frame

2009-01-28T05:41:00.000-08:00

Question :What is the frame & repeating frame?
Answer : A frame is a holder for a group of fields. A repeating frame is used to display a set of records when the no. of records that are to displayed is not known before.

How can a group in a cross products be visually distinguished from a group that does not form a cross product

2009-01-28T05:39:00.000-08:00

Question : How can a group in a cross products be visually distinguished from a group that does not form a cross product?
Answer : A group that forms part of a cross product will have a thicker border.

How does one create a RMAN recovery catalog (for DBA)

2009-01-28T05:36:00.000-08:00

Question :How does one create a RMAN recovery catalog? (for DBA)
Answer : Start by creating a database schema (usually called rman). Assign an appropriate tablespace to it and grant it the recovery_catalog_owner role. Look at this example: sqlplus sys SQL>create user rman identified by rman; SQL> alter user rman default tablespace tools temporary tablespace temp; SQL> alter user rman quota unlimited on tools; SQL> grant connect, resource, recovery_catalog_owner to rman; SQL> exit; Next, log in to rman and create the catalog schema. Prior to Oracle 8i this was done by running the catrman.sql script. rman catalog rman/rman RMAN>create catalog tablespace tools; RMAN> exit; You can now continue by registering your databases in the catalog. Look at this example: rman catalog rman/rman target backdba/backdba RMAN> register database;

What are the differences between EBU and RMAN (for DBA)

2009-01-28T05:27:00.000-08:00

Question :What are the differences between EBU and RMAN? (for DBA)
Answer : Enterprise Backup Utility (EBU) is a functionally rich, high performance interface for backing up Oracle7 databases. It is sometimes referred to as OEBU for Oracle Enterprise Backup Utility. The Oracle Recovery Manager (RMAN) utility that ships with Oracle8 and above is similar to Oracle7's EBU utility. However, there is no direct upgrade path from EBU to RMAN.

I've lost some Rollback Segments, how can I get my DB back (for DBA)

2009-01-28T05:26:00.000-08:00

Question :I've lost some Rollback Segments, how can I get my DB back? (for DBA)
Answer : Re-start your database with the following INIT.ORA parameter if one of your rollback segments is corrupted. You can then drop the corrupted rollback segments and create it from scratch. Caution is advised when enabling this parameter, as uncommitted transactions will be marked as committed. One can very well end up with lost or inconsistent data!!! Please contact Oracle Support before using it. _Corrupted_rollback_segments = (rbs01, rbs01, rbs03, rbs04)

What is a physical page ? & What is a logical page

2009-01-28T05:25:00.000-08:00

Question :What is a physical page ? & What is a logical page ?
Answer : A physical page is a size of a page. That is output by the printer. The logical page is the size of one page of the actual report as seen in the Previewer.

What is a property clause

2009-01-28T05:23:00.000-08:00

Question :What is a property clause?
Answer : A property clause is a named object that contains a list of properties and their settings. Once you create a property clause you can base other object on it. An object based on a property can inherit the setting of any property in the clause that makes sense for that object.

I've lost my REDOLOG files, how can I get my DB back (for DBA)

2009-01-28T05:18:00.000-08:00

Question :I've lost my REDOLOG files, how can I get my DB back? (for DBA)
Answer : The following INIT.ORA parameter may be required if your current redo logs are corrupted or blown away. Caution is advised when enabling this parameter as you might end-up losing your entire database. Please contact Oracle Support before using it. _allow_resetlogs_corruption = true

My database is down and I cannot restore. What now (for DBA )

2009-01-28T04:30:00.000-08:00

Question :My database is down and I cannot restore. What now? (for DBA )
Answer : Recovery without any backup is normally not supported, however, Oracle Consulting can sometimes extract data from an offline database using a utility called DUL (Disk UnLoad). This utility reads data in the data files and unloads it into SQL*Loader or export dump files. DUL does not care about rollback segments, corrupted blocks, etc, and can thus not guarantee that the data is not logically corrupt. It is intended as an absolute last resort and will most likely cost your company a lot of money!!!

What is a record group

2009-01-28T04:29:00.000-08:00

Question :What is a record group?
Answer : A record group is an internal Oracle Forms that structure that has a column/row framework similar to a database table. However, unlike database tables, record groups are separate objects that belong to the form module which they are defined.

What is a Static Record Group

2009-01-28T04:28:00.000-08:00

Question :What is a Static Record Group?
Answer : A static record group is not associated with a query, rather, you define its structure and row values at design time, and they remain fixed at runtime.

My database was terminated while in BACKUP MODE, do I need to recover (for DBA)

2009-01-28T04:26:00.000-08:00

Question :My database was terminated while in BACKUP MODE, do I need to recover? (for DBA)
Answer : If a database was terminated while one of its tablespaces was in BACKUP MODE (ALTER TABLESPACE xyz BEGIN BACKUP;), it will tell you that media recovery is required when you try to restart the database. The DBA is then required to recover the database and apply all archived logs to the database. However, from Oracle7.2, you can simply take the individual datafiles out of backup mode and restart the database. ALTER DATABASE DATAFILE '/path/filename' END BACKUP; One can select from V$BACKUP to see which datafiles are in backup mode. This normally saves a significant amount of database down time. Thiru Vadivelu contributed the following: From Oracle9i onwards, the following command can be used to take all of the datafiles out of hot backup mode: ALTER DATABASE END BACKUP; The above commands need to be issued when the database is mounted.

What is the User-Named Editor

2009-01-28T04:25:00.000-08:00

Question :What is the User-Named Editor?
Answer : A user named editor has the same text editing functionality as the default editor, but, because it is a named object, you can specify editor attributes such as windows display size, position, and title.

What is an user exit used for

2009-01-28T04:22:00.000-08:00

Question :What is an user exit used for?
Answer : A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL and then return control ( and ) back to Oracle reports.

What are the built -ins used for Modifying a groups structure

2009-01-28T04:21:00.000-08:00

Question :What are the built -ins used for Modifying a groups structure?
Answer : ADD-GROUP_COLUMN (function) ADD_GROUP_ROW (procedure) DELETE_GROUP_ROW(procedure)

At what point of report execution is the before Report trigger fired

2009-01-28T04:20:00.000-08:00

Question :At what point of report execution is the before Report trigger fired?
Answer : After the query is executed but before the report is executed and the records are displayed.

What is an LOV

2009-01-28T04:19:00.000-08:00

Question :What is an LOV?
Answer : An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.

What is an object group

2009-01-28T04:17:00.000-08:00

Question :What is an object group?
Answer : An object group is a container for a group of objects; you define an object group when you want to package related objects, so that you copy or reference them in other modules.

What is the difference between OLE Server & Ole Container

2009-01-28T04:16:00.000-08:00

Question :What is the difference between OLE Server & Ole Container?
Answer : An Ole server application creates ole Objects that are embedded or linked in ole Containers ex. Ole servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate objects that are created by ole server applications. Ex. oracle forms is an example of an ole Container.

What is coordination Event

2009-01-28T04:11:00.000-08:00

Question :What is coordination Event?
Answer : Any event that makes a different record in the master block the current record is a coordination causing event.

Where is the external query executed at the client or the server

2009-01-28T04:09:00.002-08:00

Question :Where is the external query executed at the client or the server?
Answer : At the server.

Why is it preferable to create a fewer no. of queries in the data mode

2009-01-28T04:09:00.001-08:00

Question :Why is it preferable to create a fewer no. of queries in the data mode?
Answer : Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.

What are the common Import/ Export problems (for DBA )

2009-01-28T04:08:00.000-08:00

Question :What are the common Import/ Export problems? (for DBA )
Answer : ORA-00001: Unique constraint (...) violated - You are importing duplicate rows. Use IGNORE=NO to skip tables that already exist (imp will give an error if the object is re-created). ORA-01555: Snapshot too old - Ask your users to STOP working while you are exporting or use parameter CONSISTENT=NO ORA-01562: Failed to extend rollback segment - Create bigger rollback segments or set parameter COMMIT=Y while importing IMP-00015: Statement failed ... object already exists... - Use the IGNORE=Y import parameter to ignore these errors, but be careful as you might end up with duplicate rows.

Give the sequence of execution of the various report triggers

2009-01-28T04:06:00.000-08:00

Question :Give the sequence of execution of the various report triggers?
Answer : Before form , After form , Before report, Between page, After report.

How can one improve Import/ Export performance (for DBA)

2009-01-28T04:04:00.000-08:00

Question :How can one improve Import/ Export performance? (for DBA)
Answer : EXPORT: . Set the BUFFER parameter to a high value (e.g. 2M) . Set the RECORDLENGTH parameter to a high value (e.g. 64K) . Stop unnecessary applications to free-up resources for your job. . If you run multiple export sessions, ensure they write to different physical disks. . DO NOT export to an NFS mounted filesystem. It will take forever. IMPORT: . Create an indexfile so that you can create indexes AFTER you have imported data. Do this by setting INDEXFILE to a filename and then import. No data will be imported but a file containing index definitions will be created. You must edit this file afterwards and supply the passwords for the schemas on all CONNECT statements. . Place the file to be imported on a separate physical disk from the oracle data files . Increase DB_CACHE_SIZE (DB_BLOCK_BUFFERS prior to 9i) considerably in the init$SID.ora file . Set the LOG_BUFFER to a big value and restart oracle. . Stop redo log archiving if it is running (ALTER DATABASE NOARCHIVELOG;) . Create a BIG tablespace with a BIG rollback segment inside. Set all other rollback segments offline (except the SYSTEM rollback segment of course). The rollback segment must be as big as your biggest table (I think?) . Use COMMIT=N in the import parameter file if you can afford it . Use ANALYZE=N in the import parameter file to avoid time consuming ANALYZE statements . Remember to run the indexfile previously created

What is bind reference and how can it be created

2009-01-28T03:54:00.000-08:00

Question :What is bind reference and how can it be created?
Answer : Bind reference are used to replace the single value in sql, pl/sql statements a bind reference can be created using a (:) before a column or a parameter name.

Can one export to multiple files?/ Can one beat the Unix 2 Gig limit (for DBA)

2009-01-28T03:52:00.000-08:00

Question :Can one export to multiple files?/ Can one beat the Unix 2 Gig limit? (for DBA)
Answer : From Oracle8i, the export utility supports multiple output files. This feature enables large exports to be divided into files whose sizes will not exceed any operating system limits (FILESIZE= parameter). When importing from multi-file export you must provide the same filenames in the same sequence in the FILE= parameter. Look at this example: exp SCOTT/TIGER FILE=D:\F1.dmp,E:\F2.dmp FILESIZE=10m LOG=scott.log Use the following technique if you use an Oracle version prior to 8i: Create a compressed export on the fly. Depending on the type of data, you probably can export up to 10 gigabytes to a single file. This example uses gzip. It offers the best compression I know of, but you can also substitute it with zip, compress or whatever. # create a named pipe mknod exp.pipe p # read the pipe - output to zip file in the background gzip <> scott.exp.gz & # feed the pipe exp userid=scott/tiger file=exp.pipe ...

What are different types of images

2009-01-28T03:50:00.000-08:00

Question :What are different types of images?
Answer : Boiler plate imagesImage Items

Can one import/export between different versions of Oracle (for DBA)

2009-01-28T03:48:00.001-08:00

Question :Can one import/export between different versions of Oracle? (for DBA) ?
Answer : Different versions of the import utility is upwards compatible. This means that one can take an export file created from an old export version, and import it using a later version of the import utility. This is quite an effective way of upgrading a database from one release of Oracle to the next. Oracle also ships some previous catexpX.sql scripts that can be executed as user SYS enabling older imp/exp versions to work (for backwards compatibility). For example, one can run $ORACLE_HOME/rdbms/admin/catexp7.sql on an Oracle 8 database to allow the Oracle 7.3 exp/imp utilities to run against an Oracle 8 database.

Can one import/export between different versions of Oracle (for DBA)

2009-01-28T03:48:00.000-08:00

How can a button be used in a report to give a drill down facility

2009-01-28T03:47:00.000-08:00

Question :How can a button be used in a report to give a drill down facility?
Answer : By setting the action associated with button to Execute pl/sql option and using the SRW.Run_report function.

Does one need to drop/ truncate objects before importing (for DBA)

2009-01-28T03:45:00.000-08:00

Question :Does one need to drop/ truncate objects before importing? (for DBA)
Answer : Before one import rows into already populated tables, one needs to truncate or drop these tables to get rid of the old data. If not, the new data will be appended to the existing tables. One must always DROP existing Sequences before re-importing. If the sequences are not dropped, they will generate numbers inconsistent with the rest of the database. Note: It is also advisable to drop indexes before importing to speed up the import process. Indexes can easily be recreated after the data was successfully imported.

How can I message to passed to the user from reports

2009-01-28T03:44:00.000-08:00

Question :How can I message to passed to the user from reports?
Answer : By using SRW.MESSAGE function.

How can a text file be attached to a report while creating in the report writer

2009-01-28T03:43:00.000-08:00

Question :How can a text file be attached to a report while creating in the report writer?
Answer : By using the link file property in the layout boiler plate property sheet.

How can a square be drawn in the layout editor of the report writer

2009-01-28T03:42:00.000-08:00

Question :How can a square be drawn in the layout editor of the report writer?
Answer : By using the rectangle tool while pressing the (Constraint) key.

How can values be passed bet. precompiler exits & Oracle call interface

2009-01-28T03:40:00.000-08:00

Question :How can values be passed bet. precompiler exits & Oracle call interface?
Answer : By using the statement EXECIAFGET & EXECIAFPUT.

How is it possible to select generate a select set for the query in the query property sheet

2009-01-28T03:39:00.000-08:00

Question :How is it possible to select generate a select set for the query in the query property sheet?
Answer : By using the tables/columns button and then specifying the table and the column names.

What is a User_exit

2009-01-28T03:38:00.000-08:00

Question :What is a User_exit?
Answer : Calls the user exit named in the user_exit_string. Invokes a 3Gl program by name which has been properly linked into your current oracle forms executable.

What is relation between the window and canvas views

2009-01-28T03:37:00.000-08:00

Question :What is relation between the window and canvas views?
Answer : Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc.,) and boilerplate objects (boxes, lines, images etc.,) that operators interact with us they run your form . Each canvas views displayed in a window.

What are the different types of Delete details we can establish in Master-Details

2009-01-28T03:33:00.002-08:00

Question :What are the different types of Delete details we can establish in Master-Details?
Answer : Cascade Isolate Non-isolate

What are different types of canvas views

2009-01-28T03:33:00.001-08:00

Question :What are different types of canvas views?
Answer :

What are the built-ins used for Creating and deleting groups

2009-01-28T03:32:00.001-08:00

Question :What are the built-ins used for Creating and deleting groups?
Answer : CREATE-GROUP (function) CREATE_GROUP_FROM_QUERY(function) DELETE_GROUP(procedure)

What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves

2009-01-28T03:21:00.000-08:00

Question :What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?
Answer : Destype and Desname.

What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves

2009-01-28T03:19:00.000-08:00

Question :What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?
Answer : Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.

Where should the tuning effort be directed (for DBA)

2009-01-28T03:17:00.000-08:00

Question :Where should the tuning effort be directed? (for DBA)
Answer : Consider the following areas for tuning. The order in which steps are listed needs to be maintained to prevent tuning side effects. For example, it is no good increasing the buffer cache if you can reduce I/O by rewriting a SQL statement. Database Design (if it's not too late): Poor system performance usually results from a poor database design. One should generally normalize to the 3NF. Selective denormalization can provide valuable performance improvements. When designing, always keep the "data access path" in mind. Also look at proper data partitioning, data replication, aggregation tables for decision support systems, etc. Application Tuning: Experience showed that approximately 80% of all Oracle system performance problems are resolved by coding optimal SQL. Also consider proper scheduling of batch tasks after peak working hours. Memory Tuning: Properly size your database buffers (shared pool, buffer cache, log buffer, etc) by looking at your buffer hit ratios. Pin large objects into memory to prevent frequent reloads. Disk I/O Tuning: Database files needs to be properly sized and placed to provide maximum disk subsystem throughput. Also look for frequent disk sorts, full table scans, missing indexes, row chaining, data fragmentation, etc Eliminate Database Contention: Study database locks, latches and wait events carefully and eliminate where possible. Tune the Operating System: Monitor and tune operating system CPU, I/O and memory utilization. For more information, read the related Oracle FAQ dealing with your specific operating system.

What database aspects should be monitored (for DBA)

2009-01-28T03:16:00.000-08:00

Question :What database aspects should be monitored? (for DBA)
Answer : One should implement a monitoring system to constantly monitor the following aspects of a database. Writing custom scripts, implementing Oracle's Enterprise Manager, or buying a third-party monitoring product can achieve this. If an alarm is triggered, the system should automatically notify the DBA (e-mail, page, etc.) to take appropriate action. Infrastructure availability: . Is the database up and responding to requests . Are the listeners up and responding to requests . Are the Oracle Names and LDAP Servers up and responding to requests . Are the Web Listeners up and responding to requests Things that can cause service outages: . Is the archive log destination filling up? . Objects getting close to their max extents . User and process limits reached Things that can cause bad performance: See question "What tuning indicators can one use?".

What is the use of hidden column? What are the various sub events a mouse double click event involves

2009-01-28T03:12:00.000-08:00

Question :What is the use of hidden column? What are the various sub events a mouse double click event involves?
Answer : A hidden column is used to when a column has to embed into boilerplate text

What is the use of place holder column? What are the various sub events a mouse double click event involves

2009-01-28T03:11:00.000-08:00

Question :What is the use of place holder column? What are the various sub events a mouse double click event involves?
Answer : A placeholder column is used to hold calculated values at a specified place rather than allowing is to appear in the actual row where it has to appear.

How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves

2009-01-28T03:09:00.000-08:00

Question :How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?
Answer : By dragging the column outside the group.

Why and when should one tune (for DBA)

2009-01-28T03:05:00.000-08:00

Question :Why and when should one tune? (for DBA)
Answer : One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to be monitored and adjusted to increase its performance. One should do performance tuning for the following reasons: The speed of computing might be wasting valuable human time (users waiting for response); Enable your system to keep-up with the speed business is conducted; and Optimize hardware usage to save money (companies are spending millions on hardware). Although this FAQ is not overly concerned with hardware issues, one needs to remember than you cannot tune a Buick into a Ferrari.

What is an user exit used for

2009-01-28T02:59:00.000-08:00

What are the built -ins used for Modifying a groups structure

2009-01-28T02:57:00.000-08:00

Question :What are the built -ins used for Modifying a groups structure?
Answer : ADD-GROUP_COLUMN (function) ADD_GROUP_ROW (procedure) DELETE_GROUP_ROW(procedure)

At what point of report execution is the before Report trigger fired

2009-01-28T02:56:00.000-08:00

Question :At what point of report execution is the before Report trigger fired?
Answer : After the query is executed but before the report is executed and the records are displayed.

What is an LOV

2009-01-28T02:54:00.000-08:00

Question :What is an LOV?
Answer : An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.

What is an object group

2009-01-28T02:52:00.000-08:00

What is the difference between OLE Server & Ole Container

2009-01-28T02:51:00.000-08:00

What is coordination Event

2009-01-28T02:49:00.000-08:00

Question :What is coordination Event?
Answer : Any event that makes a different record in the master block the current record is a coordination causing event.

Where is a procedure return in an external pl/sql library executed at the client or at the server

2009-01-28T02:47:00.000-08:00

Question :Where is a procedure return in an external pl/sql library executed at the client or at the server?
Answer : at the client.

Where is the external query executed at the client or the server

2009-01-28T02:46:00.000-08:00

Question :Where is the external query executed at the client or the server?
Answer : At the server.

Why is it preferable to create a fewer no. of queries in the data model

2009-01-28T02:44:00.000-08:00

Question :Why is it preferable to create a fewer no. of queries in the data model?
Answer : Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.

What are the common Import/ Export problems (for DBA )

2009-01-28T02:42:00.000-08:00

Give the sequence of execution of the various report triggers

2009-01-28T02:40:00.000-08:00

Question :Give the sequence of execution of the various report triggers?
Answer : Before form , After form , Before report, Between page, After report.

How can one improve Import/ Export performance (for DBA)

2009-01-28T02:39:00.000-08:00

What is bind reference and how can it be created

2009-01-28T02:37:00.000-08:00

Can one export to multiple files / Can one beat the Unix 2 Gig limit (for DBA)

2009-01-28T02:32:00.000-08:00

What are different types of images

2009-01-28T02:28:00.000-08:00

Question :What are different types of images?
Answer : Boiler plate imagesImage Items

Can one import/export between different versions of Oracle (for DBA)

2009-01-28T02:27:00.000-08:00

Question :Can one import/export between different versions of Oracle? (for DBA)
Answer : Different versions of the import utility is upwards compatible. This means that one can take an export file created from an old export version, and import it using a later version of the import utility. This is quite an effective way of upgrading a database from one release of Oracle to the next. Oracle also ships some previous catexpX.sql scripts that can be executed as user SYS enabling older imp/exp versions to work (for backwards compatibility). For example, one can run $ORACLE_HOME/rdbms/admin/catexp7.sql on an Oracle 8 database to allow the Oracle 7.3 exp/imp utilities to run against an Oracle 8 database.

How can a button be used in a report to give a drill down facility

2009-01-28T02:25:00.000-08:00

Question :How can a button be used in a report to give a drill down facility?
Answer : By setting the action associated with button to Execute pl/sql option and using the SRW.Run_report function.

Does one need to drop/ truncate objects before importing (for DBA)

2009-01-28T02:24:00.000-08:00

How can I message to passed to the user from reports

2009-01-28T02:22:00.000-08:00

Question :How can I message to passed to the user from reports?
Answer : By using SRW.MESSAGE function.

How can a text file be attached to a report while creating in the report writer

2009-01-28T02:20:00.000-08:00

Question :How can a text file be attached to a report while creating in the report writer?
Answer : By using the link file property in the layout boiler plate property sheet.

How can a square be drawn in the layout editor of the report writer

2009-01-28T02:19:00.000-08:00

Question :How can a square be drawn in the layout editor of the report writer?
Answer : By using the rectangle tool while pressing the (Constraint) key.

How can values be passed bet. precompiler exits & Oracle call interface

2009-01-28T02:17:00.000-08:00

Question :How can values be passed bet. precompiler exits & Oracle call interface?
Answer : By using the statement EXECIAFGET & EXECIAFPUT.

How is it possible to select generate a select set for the query in the query property sheet

2009-01-28T02:16:00.000-08:00

What is a User_exit

2009-01-28T02:14:00.000-08:00

Question :What is a User_exit?
Answer : Calls the user exit named in the user_exit_string. Invokes a 3Gl program by name which has been properly linked into your current oracle forms executable.

What is relation between the window and canvas views

2009-01-28T02:13:00.000-08:00

What are the different types of Delete details we can establish in Master-Details

2009-01-28T02:12:00.000-08:00

Question :What are the different types of Delete details we can establish in Master-Details?
Answer : Cascade Isolate Non-isolate

What are different types of canvas views

2009-01-28T02:10:00.000-08:00

Question :What are different types of canvas views?
Answer : Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.

What are the built-ins used for Creating and deleting groups

2009-01-28T02:09:00.000-08:00

Question :What are the built-ins used for Creating and deleting groups?
Answer : CREATE-GROUP (function) CREATE_GROUP_FROM_QUERY(function) DELETE_GROUP(procedure)

What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves

2009-01-28T02:07:00.000-08:00

Question :What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?
Answer : Destype and Desname.

What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves

2009-01-28T02:05:00.000-08:00

Where should the tuning effort be directed (for DBA)

2009-01-28T02:03:00.000-08:00

What database aspects should be monitored (for DBA)

2009-01-28T02:02:00.000-08:00

What is the use of hidden column? What are the various sub events a mouse double click event involves

2009-01-28T02:00:00.000-08:00

What is the use of place holder column? What are the various sub events a mouse double click event involves

2009-01-28T01:59:00.000-08:00

How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves

2009-01-28T01:57:00.000-08:00

Why and when should one tune (for DBA)

2009-01-28T01:56:00.000-08:00

Question :Why and when should one tune? (for DBA)
Answer :One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to be monitored and adjusted to increase its performance. One should do performance tuning for the following reasons: The speed of computing might be wasting valuable human time (users waiting for response); Enable your system to keep-up with the speed business is conducted; and Optimize hardware usage to save money (companies are spending millions on hardware). Although this FAQ is not overly concerned with hardware issues, one needs to remember than you cannot tune a Buick into a Ferrari.

What third party tools can be used with Oracle EBU/ RMAN (for DBA)

2009-01-28T01:49:00.000-08:00

Question :What third party tools can be used with Oracle EBU/ RMAN? (for DBA)
Answer : The following Media Management Software Vendors have integrated their media management software packages with Oracle Recovery Manager and Oracle7 Enterprise Backup Utility. The Media Management Vendors will provide first line technical support for the integrated backup/recover solutions. Veritas NetBackup EMC Data Manager (EDM) HP OMNIBack II IBM's Tivoli Storage Manager - formerly ADSM Legato Networker ManageIT Backup and Recovery Sterling Software's SAMS:Alexandria - formerly from Spectralogic Sun Solstice Backup

Use the Add_group_row procedure to add a row to a static record group 1. true or false

2009-01-28T01:48:00.000-08:00

Question :Use the Add_group_row procedure to add a row to a static record group 1. true or false?
Answer : False.

What are the built-ins used for finding Object ID function

2009-01-28T01:44:00.000-08:00

Question :What are the built-ins used for finding Object ID function?
Answer : FIND_GROUP(function) FIND_COLUMN(function)

What are the built-ins used for finding object ID functions

2009-01-28T01:41:00.000-08:00

Question : What are the built-ins used for finding object ID functions?
Answer : Find_group(function) Find_column(function)

What are built-ins associated with timers

2009-01-28T01:40:00.000-08:00

Question :What are built-ins associated with timers?
Answer : find_timercreate_timerdelete_timer

What is a difference between pre-select and pre-query

2009-01-28T00:19:00.000-08:00

Question :What is a difference between pre-select and pre-query?
Answer : Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued. The pre-query trigger fires just before oracle forms issues the select statement to the database after the operator as define the example records by entering the query criteria in enter query mode.Pre-query trigger fires before pre-select trigger.

What is WHEN-Database-record trigger

2009-01-28T00:17:00.000-08:00

Question :What is WHEN-Database-record trigger?
Answer : Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update. c generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.

What is the remove on exit property

2009-01-28T00:10:00.000-08:00

Question :What is the remove on exit property?
Answer : For a modelless window, it determines whether oracle forms hides the window automatically when the operators navigates to an item in the another window.

What are different types of modules available in oracle form

2009-01-28T00:08:00.000-08:00

Question :What are different types of modules available in oracle form?
Answer : Form module - a collection of objects and code routines Menu modules - a collection of menus and menu item commands that together make up an application menu library module - a collection of user named procedures, functions and packages that can be called from other modules in the application

To execute row from being displayed that still use column in the row which property can be used

2009-01-28T00:06:00.000-08:00

Question :To execute row from being displayed that still use column in the row which property can be used?
Answer : Format trigger.

Atleast how many set of data must a data model have before a data model can be base on it

2009-01-28T00:05:00.000-08:00

Question :Atleast how many set of data must a data model have before a data model can be base on it?
Answer : Four.