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 35524

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

BeBo Technologies, Wipro,

7 73642

What are inner join and outer join?

3 25283

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

Amdocs, CSC, TCS,

29 96035

what are Triggers?

TCS,

7 28187

what are stored procedures?

TCS, Wells Fargo,

7 26587

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

Green Info Solutions, TCS,

7 31184

what are views?

TCS,

8 34678

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

i2, Oracle,

2 30781

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

CA,

1 17562

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

2 6603

For web applications from which version of Oracle is suitable?

1 6062

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

1 5501

What is Statement Auditing ?

2 5392

What are the use of Roles ?

3 6148

Un-Answered Questions { Oracle }

What is truncate oracle?

922

can we use lexical perameter in oracle plsql if yes how

2272

What is the usage of merge statement?

1099

how to reverse engineer views(how to load the data from views)?

507

How I can use srw.run_report in reports6i?

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2276

How to define a cusotmer as a supplier in ORACLE R12

2182

How to change system global area (sga) in oracle?

964

What is integrity and what is constraint??Explain with example

2223

What is an Oracle SYSTEM tablespace and when is it Created?

1071

What flow of MSExcel in odi?

547

What is merge in oracle?

1002

How to view existing locks on the database?

1004

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1224

How to create a single index for multiple columns?

985

For More Un-Answered { Oracle } Questions Click Here