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

Oracle General (1789)
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 18596

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

BeBo Technologies, Wipro,

7 65271

What are inner join and outer join?

3 9671

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

Amdocs, CSC, TCS,

29 66902

what are Triggers?

TCS,

6 10537

what are stored procedures?

TCS, Wells Fargo,

7 8880

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

Green Info Solutions, TCS,

7 13762

what are views?

TCS,

8 15616

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

i2, Oracle,

2 15948

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

CA,

1 3351

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

2 3951

For web applications from which version of Oracle is suitable?

1 3736

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

1 3612

What is Statement Auditing ?

2 3081

What are the use of Roles ?

3 3549

Un-Answered Questions { Oracle }

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

How to write date and time literals in oracle?

159

What are nested tables?

204

Explain constraining triggers.

140

Explain an integrity constrains?

180

What is the purpose of a staging area?

What is a trace file and how is it created in oracle?

157

How to export your connection information to a file?

169

What is a trigger oracle?

128

What is difference between truncate and delete?

154

What is the importance of batch source set up in ar? : oracle accounts receivable

187

How to rename a column in an existing table?

166

What is the difference between 10g OEM and 11g OEM?

169

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1259

What is a database instance?

For More Un-Answered { Oracle } Questions Click Here