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

how do u run sql loader

1 6756

i don't want to give the path of .Dat file in .Ctl file dynamically i want to give how

1 3124

What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

CTS,

2 6175

how we can validate the run-time parameters in reports 6i

Satyam,

1 6773

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 5669

What is lexical parameter ?

Zensar,

2 11403

what is a package n what r the packages availbla in report

Convergys,

2096

how can u store a picture file in oracle database? explain the path/command?

GE, Satyam,

1 5569

What are all the system Parameters available in ORACLE Reports

GE,

1 19220

What is the sequence the Report triggers will fires while running a report ?

FCS, GE,

1 13722

Where we can use the placeholder columns?

GE,

1 4870

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

GE,

2287

How can you create Lexical parameter n Bind parameter in Reports ?

GE, SVSS,

1 6192

What is summary column in Oracle Reports ?

GE,

5 17333

What is the use of Validation triggers in Reports?

GE,

2 12078

Un-Answered Questions { Oracle }

What are the differences between blob and clob in oracle?

1089

While taking hot backup (begin end backup) what will happens back end?

559

How to speed up webrick?

1076

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2131

What is data store? How to create data store?

638

Can you remove an open file under unix?

694

What is columnar storage what is the advantage?

1062

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1109

how to join query for one source type is oracle another source type is sql server ?

2425

How to best split csv strings in oracle 9i?

1041

What is the maximum number of triggers that can be applied to a single table?

1024

Which is the best option used to move database from one server to another serve on same network and why?

547

Explain the use of control file?

1113

What is the quickest way to export a table to a flat file?

968

What is the difference between postgresql and oracle?

1048

For More Un-Answered { Oracle } Questions Click Here