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

Oracle General (1808)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 23236

What is the difference between SQL, DDL, and DML?

BeBo Technologies, Wipro,

7 72751

What are inner join and outer join?

3 12856

What are joins..how many types of joins are there?

Amdocs, CSC, TCS,

29 81609

what are Triggers?

TCS,

7 15528

what are stored procedures?

TCS, Wells Fargo,

7 14113

what are indexes..how many types of index's are there and what are they?

Green Info Solutions, TCS,

7 18601

what are views?

TCS,

8 21871

what is the difference between oracle 81,91,11i

i2, Oracle,

2 18612

How client makes connection with server in client/server architecture?

CA,

1 5378

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 6158

For web applications from which version of Oracle is suitable?

1 5532

What are the main diff. between oracle 7.3 and oracle 8i?

1 5066

What is Statement Auditing ?

2 4847

What are the use of Roles ?

3 5567

Un-Answered Questions { Oracle }

What is the difference between conversions and interfaces? : oracle accounts receivable

971

How translate command is different from replace?

856

Explain oracle 12c new features for developers?

864

You have taken a manual backup of a datafile using os. How rman will know about it?

451

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

473

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2386

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1279

Oracle Data Integrator Interview Questions and answers?

462

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

451

How to store pictures on to the database?

809

How to filter out duplications in the returning rows using oracle?

916

Explain the different types of queries created in reports?

How do I recompile a procedure in oracle?

807

What is dba training?

437

What is ceil and floor in oracle?

891

For More Un-Answered { Oracle } Questions Click Here