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 35709

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

BeBo Technologies, Wipro,

7 73972

What are inner join and outer join?

3 25465

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

Amdocs, CSC, TCS,

29 97059

what are Triggers?

TCS,

7 28434

what are stored procedures?

TCS, Wells Fargo,

7 26875

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

Green Info Solutions, TCS,

7 31484

what are views?

TCS,

8 34972

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

i2, Oracle,

2 30967

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

CA,

1 17708

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

2 6733

For web applications from which version of Oracle is suitable?

1 6152

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

1 5619

What is Statement Auditing ?

2 5533

What are the use of Roles ?

3 6291

Un-Answered Questions { Oracle }

How to create sequence in odi?

649

What is the use of the drop option in the alter table command?

596

What is the difference between media recovery & crash recovery?

What is a nested table and how is it different from a normal table?

1049

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3198

What is an oracle?

1018

How to use "if" statements on multiple conditions?

1174

Who is dba in dbms?

581

How to get a list of all user accounts in the database?

1087

Explain an index segment?

1118

Explain the various modes of normalization?

540

Can you remove an open file under unix?

694

Is oracle the best database?

963

Explain the oracle grid infrastructure?

How to empty your oracle recycle bin?

1020

For More Un-Answered { Oracle } Questions Click Here