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

1. What is PO rate variance gain and loss?

Oracle,

2924

3. Steps in UAT?

Oracle,

2438

8. Supporting AP, AR and GL?

Oracle,

2314

What is supporting issues GL AP and AR?

Oracle,

2563

is database gud carrier option??

1 3604

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2525

how to retrive xml data for using sql query?

IBM, TCS,

3 7022

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

IBM,

1 4688

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2215

Without giving condition how to retrieve the unmatched records from table.

TCS,

1 4975

what is difference between inner join & nested query or subqueries

3046

Can anybody tell which is the best training institute for learning Oracle in chennai...? And i also i want placement assurance

1 4062

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2289

when i run my query on yesterday it is fast but today it is slow why?

1 7596

Un-Answered Questions { Oracle }

How to drop a tablespace?

1053

How to run the anonymous block again?

1135

What is analyze command used for?

1080

What are the parameters that we can pass through a stored procedure?

1069

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?

1957

Give the various rollback segment states.

1055

How to view all columns in an existing table?

937

Explain view?

1044

Give the constructs of a package, function or a procedure.

1053

How many dba can you have?

546

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2957

Do you need a commit after ddl statements?

565

How to run queries on external tables?

1051

How to avoid duplicate entries in the forms?

Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?

For More Un-Answered { Oracle } Questions Click Here