What is the advantage of a stored procedure over a database trigger ?
We have control over the firing of a stored procedure but we have no control over the firing of a trigger.
What is the maximum no. of statements that can be specified in a trigger statement ?
One.
Can views be specified in a trigger statement [...]
Explain UNION,MINUS,UNION ALL, INTERSECT ?
INTERSECT returns all distinct rows selected by both queries.MINUS – returns all distinct rows selected by the first query but not by the second.UNION – returns all distinct rows selected by either queryUNION ALL – returns all rows selected by either query, including all duplicates.
Should the OEM Console be displayed at [...]
If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
Only for 10 records.
What are the different objects that you cannot copy or reference in object groups?
Objects of different modules
Another object groups
Individual block dependent items
Program units.
What is an OLE?
Object Linking & Embedding provides you with the [...]
What is the function of Optimizer ?
The goal of the optimizer is to choose the most efficient way to execute a SQL statement.
What is Execution Plan ?
The combinations of the steps the optimizer chooses to execute a statement is called an execution plan.
Can one resize tablespaces and data files? (for DBA)
One can manually increase or [...]
What are the different types of segments?
Data segment, index segment, rollback segment and temporary segment.
What is a data segment?
Each non-clustered table has a data segment. All of the table’s data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored [...]
Does user exits supports DLL on MSWINDOWS ?
YES .
What is path setting for DLL?
Make sure you include the name of the DLL in the FORMS45_USEREXIT variable of the ORACLE.INI file, or rename the DLL to F45XTB.DLL. If you rename the DLL to F45XTB.DLL, replace the existing F45XTB.DLL in the ORAWINBIN directory with the new F45XTB.DLL.
How [...]
What are snap shots and views
Snapshots are mirror or replicas of tables. Views are built using the columns from one or more tables. The Single Table View can be updated but the view with multi table cannot be updated
What are the OOPS concepts in Oracle.
Oracle does implement the OOPS concepts. The best example is the [...]
How does one stop and start the OMS? (for DBA)
Use the following command sequence to stop and start the OMS (Oracle Management Server):
oemctl start oms
oemctl status oms sysman/oem_temp
oemctl stop oms sysman/oem_temp
Windows NT/2000 users can just stop and start the required services. The default OEM administrator is “sysman” with a password of “oem_temp”.
NOTE: Use command oemctrl [...]
What should be the return type for a cursor variable. Can we use a scalar data type as return type?
The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE
What are different Oracle database objects?
-TABLES
-VIEWS
-INDEXES
-SYNONYMS
-SEQUENCES
-TABLESPACES [...]
What is a Check Box?
A Check Box is a two state control that indicates whether a certain condition or value is on or off, true or false. The display state of a check box is always either “checked” or “unchecked”.
What is a canvas-view?
A canvas-view is the background object on which you layout the interface items [...]
Latest Jobs