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 6748

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

1 3112

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 6162

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

Satyam,

1 6764

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 5663

What is lexical parameter ?

Zensar,

2 11395

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

Convergys,

2088

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

GE, Satyam,

1 5563

What are all the system Parameters available in ORACLE Reports

GE,

1 19207

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

FCS, GE,

1 13711

Where we can use the placeholder columns?

GE,

1 4862

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

GE,

2279

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

GE, SVSS,

1 6191

What is summary column in Oracle Reports ?

GE,

5 17306

What is the use of Validation triggers in Reports?

GE,

2 12062

Un-Answered Questions { Oracle }

Explain the difference between a procedure and a function?

1165

What is an oracle report?

1054

What are the various types of snapshots ?

1023

What is enter substitution variable in oracle?

1045

What is the difference between oracle media recovery and crash recovery?

1171

What are internal user account in oracle?

1000

What is Memos?

574

What is the use of the Service Knowledge module?

586

What is the difference between single instance environment and rac environment?

Will you be able to store pictures in the database?explain.

990

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1041

What is the usage of analyze command in oracle?

1089

What are a query and state the different types of queries and their uses?

1011

How do we get field detail of a table?

1073

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2459

For More Un-Answered { Oracle } Questions Click Here