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

Oracle General (1658)
Oracle DBA (Database Administration) (188)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 17511

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

Wipro, BeBo Technologies,

7 63175

What are inner join and outer join?

3 8979

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

CSC, TCS, Amdocs,

29 63827

what are Triggers?

TCS,

6 9442

what are stored procedures?

TCS, Wells Fargo,

7 7693

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

TCS, Green Info Solutions,

7 12727

what are views?

TCS,

8 14305

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

Oracle, i2,

2 15285

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

CA,

1 2908

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

2 3472

For web applications from which version of Oracle is suitable?

1 3424

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

1 3271

What is Statement Auditing ?

2 2740

What are the use of Roles ?

3 3108

Un-Answered Questions { Oracle }

What happens to the indexes if a table is recovered?

Which flexfields you have customized?

Explain the use of compress option in exp command.

what are archived logs?

1159

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

2839

How to drop an existing table in oracle?

How to delete a user account in oracle?

how may join possible between (requisition with purchase order)

1086

How to create Drill down report?

1102

definition of cluster and non-clustered index?

1844

What are the various benefits of using rac architecture?

How to use fetch statement in a loop?

How to grant create session privilege to a user in oracle?

How to connect to a remote server?

What is a nested table and how is it different from a normal table?

For More Un-Answered { Oracle } Questions Click Here