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 6768

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

1 3133

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 6187

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

Satyam,

1 6780

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 5679

What is lexical parameter ?

Zensar,

2 11419

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

Convergys,

2104

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

GE, Satyam,

1 5578

What are all the system Parameters available in ORACLE Reports

GE,

1 19224

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

FCS, GE,

1 13729

Where we can use the placeholder columns?

GE,

1 4875

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

GE,

2289

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

GE, SVSS,

1 6201

What is summary column in Oracle Reports ?

GE,

5 17351

What is the use of Validation triggers in Reports?

GE,

2 12086

Un-Answered Questions { Oracle }

How to connect ms access to oracle servers?

1012

What is pct free/pct used/pct increase parameter in segment? What is growth factor?

556

How to create a new view in oracle?

1079

How to pass parameters to procedures?

1039

What is oracle in java?

978

What is path setting for dll?

Explain overloading. Can functions be overloaded?

1003

How to invoke the data pump export utility?

1193

what is Single Byte Overhead...?

2561

What is the difference between sharding and replication?

1060

How to move objects from DEV to QA and QA to PROD Environments?

719

where the dff data will be stored

2450

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

628

How to revoke create session privilege from a user in oracle?

1021

What is tkprof and how is it used?

613

For More Un-Answered { Oracle } Questions Click Here