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 35717

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

BeBo Technologies, Wipro,

7 73981

What are inner join and outer join?

3 25470

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

Amdocs, CSC, TCS,

29 97066

what are Triggers?

TCS,

7 28438

what are stored procedures?

TCS, Wells Fargo,

7 26877

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

Green Info Solutions, TCS,

7 31487

what are views?

TCS,

8 34975

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

i2, Oracle,

2 30970

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

CA,

1 17710

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

2 6735

For web applications from which version of Oracle is suitable?

1 6153

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

1 5619

What is Statement Auditing ?

2 5536

What are the use of Roles ?

3 6291

Un-Answered Questions { Oracle }

which one is currently in used software cmpanies.

2153

What is a snapshot log?

1003

How to write an inner join with the where clause in oracle?

1044

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5410

how to implement data validations?

590

What is a trigger oracle?

1085

How can a single instance environment be converted into rac environment and how will they be different?

What is a view and how is it different from a table?

1045

What are the attributes of the cursor?

1004

How to select all columns of all rows from a table in oracle?

1052

What command is used to type files to the screen?

594

What are the major difference between truncate and delete?

1058

Who is dba in dbms?

581

Can you tell me how to add new column in existing views?how?How is possible?

1446

Explain index?

1258

For More Un-Answered { Oracle } Questions Click Here