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

Oracle General (1803)
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 35863

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

BeBo Technologies, Wipro,

7 74300

What are inner join and outer join?

3 25656

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

Amdocs, CSC, TCS,

29 98137

what are Triggers?

TCS,

7 28686

what are stored procedures?

TCS, Wells Fargo,

7 27158

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

Green Info Solutions, TCS,

7 31772

what are views?

TCS,

8 35241

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

i2, Oracle,

2 31119

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

CA,

1 17847

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

2 6850

For web applications from which version of Oracle is suitable?

1 6241

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

1 5714

What is Statement Auditing ?

2 5669

What are the use of Roles ?

3 6413

Un-Answered Questions { Oracle }

Explain enable novalidate constraint.

1135

What is the relation between database and instance?

702

why dont we assign not null constraint as table level constraint.

2800

How to determine what records to extract?

What are nested tables?

1227

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1091

What is proxy method?

1026

What is SKM and when we will use this SKM?

721

How to delete all rows a table in oracle?

1119

What is a user account in oracle?

1173

What is a read write transaction in oracle?

1135

What is hot backup and logical backup?

1116

What is path setting for dll?

What is a table index?

1172

What is different type of rman backup?

721

For More Un-Answered { Oracle } Questions Click Here