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 35689

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

BeBo Technologies, Wipro,

7 73944

What are inner join and outer join?

3 25453

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

Amdocs, CSC, TCS,

29 96968

what are Triggers?

TCS,

7 28420

what are stored procedures?

TCS, Wells Fargo,

7 26841

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

Green Info Solutions, TCS,

7 31459

what are views?

TCS,

8 34942

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

i2, Oracle,

2 30964

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

CA,

1 17706

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

2 6723

For web applications from which version of Oracle is suitable?

1 6149

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

1 5614

What is Statement Auditing ?

2 5521

What are the use of Roles ?

3 6286

Un-Answered Questions { Oracle }

Explain the use of inctype option in exp command.

1030

What is the difference between pre-select and pre-query?

1210

What flow of MSExcel in odi?

585

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1104

How will you differentiate between varchar & varchar2?

1039

How to enter a new row into a table interactively?

1008

What is the oracle implicit cursor?

1057

What does the no logging option do? Why would we use it? Why would we be careful of using it?

548

How to speed up webrick?

1071

What are elements of administration?

590

What is set operator oracle?

971

What is the function of having virtual internet protocol address (vip) in oracle rac?

Explain an index?

1129

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2041

What is SQL access advisor in Oracle?

1185

For More Un-Answered { Oracle } Questions Click Here