Oracle Concepts Interview Questions

Global Index : A single index covering all partitions. Local Index : Separate indexes for each partition. A local index can be unique. However, in order for a local index to be unique, the par...

I think you can pass parameters to a form

You also have AWRSQRPT that collects statistics and tracks SQL statements as well.

Automatic Workload Repository (AWR) is the enhanced version of statspack and is used as performance gathering and reporting tool. AWR is basically used to gather performance related statistic such as ...

10 G supports grid computing, ASM (Automatic storage management) and Memory management. Oralce 10g is higher version of 9i , Oracle 10g has added a follwoing features Transparent Data Encryption A...

i is for Internet
g is for Grid Computing

Check for Buffer Cache Size
Check For Poor SQL Query

Remove unnecessary joins,  too much normalization can effect query to perform slow, excess use of cursors, indexes, procedures or temporary tables may effect on query to perform slow. If my answer is wrong please correct me

1. Database server is not up.
2. User not aware of the correct credentials.
3. TNS entry is not proper.
4. Some network problem.

Static Record groups
Query Based Record Groups
Non-Query Based Record Groups

When some procedures, function are frequently used in your applications, you can create a library containing these functions or procedures, and call them from anyform, to avoid redundancy or writing t...

That time use Abstract Data Type i.e.,first step create type.SQL>create type full_addSQL>( addr1 varchar2(15), addr2 varchar2(15),addr3 varchar2(15)); Second stepNow full_add is abstract type, then a...

can any body explain the concept here

Right click on SQLPLUS icon on desktop and place username/password in target box after existing path  e.g
C:oracleora92binsqlplusw.exe username/password

Good tip.  working great.. thanks

Object group can be used within same form but Object library can be used through out the data base connectivity in any form.

when object library is attached to a form, complete object library are compile/used in compilation, assume that object library has some objects like 1, 2,3. But my form don't use 1,2 & 3 all, it u...

For example, if tables Emp1 and Emp2 both have identical structure, and some changes were applied in them, then MINUS can show the difference. Like
select *
from Emp1
MINUS
select *
from Emp2
UNION
select *
from Emp2
MINUS
select *
from Emp1

with triiger we can do this......but in sql there is no such thingbut we can do it by viewfor example emp1 is a table and emp2 is view .if you iinsert rows into view tht may maynot reflect in the base table

Oracle should satisfy 13 rules of codd

Are you talking about EF Codd's 12 rules?

I seem to recall that Oracle
has satisfied 11 of 12,

with the exception being that the empty string
is treated as a NULL.

You can use a SRW.message() built-in

At first configure webconfig file that have in server folder.

hi,   I am a new member in this forum, I tried your ans for attaching a calendar to an LOV field. But when i write a code in key-listval trigger it is giving me an error saying calendar.show...

B-Tree indexes are usually associated with the index that stores a list of ROWIDs for each key.While Bitmap is also organized as B tree , but the leaf node stores a bitmap for each value instead of a list of ROWIDs. B tree can be used for OLTP while bitmap is used for data warehousing system.

Conventional wisdom holds that bitmap indexes are most appropriate for columns having low distinct values—such as GENDER, MARITAL_STATUS, and RELATION. This assumption is not completely accurate, howe...

nvl2 function is the upgraded form of nvl function.In nvl function we need to pass two parameters.i.e. nvl(interest_rate ,returned_value) if the value of interest_rate is null then the nvl function r...

nvl2(exp1,exp2,exp3)
if exp1 is null it manipulate exp3,if exp1 is not null it manipulates exp2
eg:select ename,nvl2(comm,comm+sal,sal) net from emp;

Try thisCREATE OR REPLACE FUNCTION FIN2008.rowtocol( p_slct IN VARCHAR2,p_dlmtr IN VARCHAR2 DEFAULT ',' ) RETURN VARCHAR2AUTHID CURRENT_USER ASTYPE c_refcur IS REF CURSOR;lc_str VARCHAR2(4000)...

we can also do this by insert all statement.....INSERT ALLINTO sales_info VALUES (employee_id,week_id,sales_MON)INTO sales_info VALUES (employee_id,week_id,sales_TUE)INTO sales_info VALUES (employee_i...

Dude Remember!when its your first job you should say"It doesnt matter if you pay me less or more i believe with my good work I would get a handsome salary today or tomorrow and I am sure organisation ...

Well,

It depends upon your company policies.I liked this figure 10000 so i demanded if ur company wants to pay more u r welcomed.

and it depends on year exp.

if ur exp then alwaz ask >  30% hike