Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What are various constraints used in SQL?

Polaris,

1 3838

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 3878

Difference between NO DATA FOUND and %NOTFOUND?

1 4468

Can you use a commit statement within a database trigger?

4 5442

What WHERE CURRENT OF clause does in a cursor?

2 4221

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

Oracle,

1938

which institute and which faculty is providing best training for oracle sql, plsql in hyderabad

4 5498

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

Oracle,

1 3135

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

MasterCard,

1 3847

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

MasterCard,

1 3366

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

MasterCard,

2 3584

how to we delete a row using varray

CTC,

3 4629

if i am using dml statement in function. then i am writing select statement what was the output

MasterCard,

2 4350

difference between bind variable and variable

Attra,

1 3092

how to i write the query 'NISHI' TO N I S H I

Attra, Metric Stream,

4 7344

Un-Answered Questions { Oracle }

what is the use of system.effective.date variable in oracle?

1105

What is an oracle table?

981

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

588

How can you find dead processes?

534

What is ceil and floor in oracle?

1067

What are the types of locks in database?

611

What is oracle update statement with inner join ?

1049

When you use CKM?

573

What is an oracle database?

1032

How to invoke the data pump export utility?

1177

What are the new features in release 11i?

What is instant client oracle?

1017

How to delete an existing row from a table in oracle?

1065

What are the different windows events activated at runtime ?

2894

What are active transformation / passive transformations?

For More Un-Answered { Oracle } Questions Click Here