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

Oracle General Interview Questions

Questions Answers Views Company eMail

what are the database links ?

2 4767

does the query needs a hint to access a materialized view?

1 3865

what are different types of locks?

6 8602

master table and child table performances and comparisons in Oracle ?

2138

what are the different types of cursors? explain?

4 10226

what are different types of deletes?

1 3765

can a view be updated?

3 9775

what is pragma?

2 6773

can you write commit in triggers?

4 10881

can u call user defined functions in select statements

2 5343

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

2 6995

After update how do u know how many records got updated

TCS,

4 8404

select statement does not retrieve any records. what exception is raised?

2 5678

how many columns can a plsql table have

NIIT,

13 21492

what is load balancing and what u have used to do this?(sql loader)

3 6058

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain the use of grant option in exp command.

1063

How to manage transaction isolation level?

1006

What is difference between cartesian join and cross join?

1088

How can you merge two tables in oracle?

1001

How to generate query output in html format?

1119

How to assign values to data fields in record variables?

1035

How will you identify oracle database software release?

1010

How to insert a record into a table?

1070

What is the difference between substr & instr functions?

1228

How to Truncate Table in Oracle

1156

What happens to indexes if you drop a table?

1171

What are the varoius components of physical database structure of oracle database?

1006

How to empty your oracle recycle bin?

1021

What is materialized view in Oracle?

1074

How will you differentiate between varchar & varchar2?

1044

For More Un-Answered { Oracle General } Questions Click Here