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

Oracle General (1803)
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,

3017

3. Steps in UAT?

Oracle,

2482

8. Supporting AP, AR and GL?

Oracle,

2362

What is supporting issues GL AP and AR?

Oracle,

2621

is database gud carrier option??

1 3684

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

2201

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

2574

how to retrive xml data for using sql query?

IBM, TCS,

3 7111

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 4753

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

2267

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

TCS,

1 5029

what is difference between inner join & nested query or subqueries

3115

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

1 4152

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

2351

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

1 7693

Un-Answered Questions { Oracle }

Difference between negative and positive adjustments : oracle accounts receivable

1166

if some data is not transfered where it will get stored

1996

Which function is used to find the largest integer less than or equal to aspecific value?

600

How to add a new column to an existing table in oracle?

1192

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2339

How to create an oracle database?

1104

What are the different windows events activated at runtime ?

2948

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2148

When system tablespace is created?

1094

How many types of km's?

628

Can the query output be sorted by multiple columns in oracle?

1061

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

2391

How to convert a date to char in oracle? Give one example.

1109

How to shutdown your 10g xe server?

1208

Name the different triggers associated with oracle forms having a master-detail relationship.

1060

For More Un-Answered { Oracle } Questions Click Here