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 to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 35533

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

BeBo Technologies, Wipro,

7 73658

What are inner join and outer join?

3 25286

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

Amdocs, CSC, TCS,

29 96076

what are Triggers?

TCS,

7 28200

what are stored procedures?

TCS, Wells Fargo,

7 26595

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

Green Info Solutions, TCS,

7 31208

what are views?

TCS,

8 34699

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

i2, Oracle,

2 30786

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

CA,

1 17572

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

2 6613

For web applications from which version of Oracle is suitable?

1 6068

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

1 5505

What is Statement Auditing ?

2 5396

What are the use of Roles ?

3 6152

Un-Answered Questions { Oracle }

What are roles in oracle?

527

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

516

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

949

How to use "out" parameter properly?

1032

Explain the use of Merge statement in oracle 11g

981

What is a package in oracle?

1040

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1145

How to update values on multiple rows in oracle?

986

What is table partitioning and why is it required?

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2146

How to use fetch statement in a loop?

982

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

532

Explain table?

1073

What is procedure overloading in oracle?

1000

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1950

For More Un-Answered { Oracle } Questions Click Here