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

Oracle General (1789)
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 5996

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

1 2397

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 5070

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

Satyam,

1 5902

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 4803

What is lexical parameter ?

Zensar,

2 9620

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

Convergys,

1606

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

GE, Satyam,

1 4744

What are all the system Parameters available in ORACLE Reports

GE,

1 18309

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

FCS, GE,

1 12929

Where we can use the placeholder columns?

GE,

1 4099

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

GE,

1856

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

GE, SVSS,

1 5361

What is summary column in Oracle Reports ?

GE,

5 15180

What is the use of Validation triggers in Reports?

GE,

2 11003

Un-Answered Questions { Oracle }

What are the attributes of cursor?

587

What is the function of grid naming service used in oracle rac

What is transaction control statement and how many types of transaction control statement in Oracle?

562

What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

302

How to use regular expression in pattern match conditions in oracle?

573

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1656

Which rman command is used to create an exact replica of a database innew host?

261

Please explain joins in oracle?

547

List out the types of joins.

591

How do I uninstall oracle 11g?

554

Can we connect to ORACLE db using Windows Authentication?

720

What is ADDM Advisor in Oracle?

657

How to display row numbers with the records?

584

What is the disadvantage of User defind function?

1833

What's dateware house and what's clustor with practicle example

1633

For More Un-Answered { Oracle } Questions Click Here