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 35732

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

BeBo Technologies, Wipro,

7 74014

What are inner join and outer join?

3 25490

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

Amdocs, CSC, TCS,

29 97138

what are Triggers?

TCS,

7 28466

what are stored procedures?

TCS, Wells Fargo,

7 26898

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

Green Info Solutions, TCS,

7 31507

what are views?

TCS,

8 35001

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

i2, Oracle,

2 30983

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

CA,

1 17718

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

2 6743

For web applications from which version of Oracle is suitable?

1 6156

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

1 5627

What is Statement Auditing ?

2 5548

What are the use of Roles ?

3 6298

Un-Answered Questions { Oracle }

How to use in conditions in oracle?

1058

Explain for repository?

595

Which are the five query types available in oracle?

953

What are internal user account in oracle?

1011

What is meant by an index?

1146

How to define an oracle sub procedure?

1151

What are the five functions of a database?

611

How to export your connection information to a file?

1133

Which profile required to access Models in Designer tool?

710

Does oracle partitioning improve performance?

1004

How to create sequence in odi?

656

What are the benefits of oracle real application clusters (rac)?

Why does oracle 9i treat an empty string as null?

1063

How is clustered index different from non-clustered index?

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

979

For More Un-Answered { Oracle } Questions Click Here