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?

14


Which flexfields you have customized?

1


Explain the use of compress option in exp command.

33


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?

18


How to delete a user account in oracle?

13


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?

1


How to use fetch statement in a loop?

16


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

16


How to connect to a remote server?

21


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

13