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,

2909

3. Steps in UAT?

Oracle,

2429

8. Supporting AP, AR and GL?

Oracle,

2301

What is supporting issues GL AP and AR?

Oracle,

2532

is database gud carrier option??

1 3587

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

2118

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

2519

how to retrive xml data for using sql query?

IBM, TCS,

3 7000

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 4671

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

2199

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

TCS,

1 4962

what is difference between inner join & nested query or subqueries

3029

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

1 4049

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

2281

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

1 7582

Un-Answered Questions { Oracle }

Who developed oracle & when?

997

How do I find the database name in oracle?

1033

What is table partitioning and why is it required?

How is mapping of name of dll and function done?

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4519

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2289

What is supporting issues GL AP and AR?

2532

What are the components of logical database structure in oracle database?

1082

What is temporary Interface( Yellow Interface) ?

552

How to define a sub function?

1126

What privilege is needed for a user to create indexes in oracle?

1023

State the various uses of dbcc command?

1053

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2003

How to sort output in descending order in oracle?

1039

Explain what are the type of synonyms?

1104

For More Un-Answered { Oracle } Questions Click Here