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 4757

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

1 3858

what are different types of locks?

6 8588

master table and child table performances and comparisons in Oracle ?

2136

what are the different types of cursors? explain?

4 10204

what are different types of deletes?

1 3751

can a view be updated?

3 9766

what is pragma?

2 6768

can you write commit in triggers?

4 10869

can u call user defined functions in select statements

2 5338

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

2 6990

After update how do u know how many records got updated

TCS,

4 8380

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

2 5672

how many columns can a plsql table have

NIIT,

13 21459

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

3 6053

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the maximum limit on the number of columns in a table?

1082

Why packages are used in oracle?

1066

What is hash cluster in oracle?

1169

What is the difference between substr & instr functions?

1223

How to start instance with a minimal initialization parameter file?

1037

How to define a procedure inside another procedure?

1016

Explain a synonym?

1024

How to view the data files in the current database?

1094

how the indexes are stored in the Oracle Database?

2269

What is varray?

1130

How to rename a tablespace in oracle?

1085

What is an anonymous block?

1236

What is a system tablespace?

1067

What is index in Oracle?

1070

Explain the use of analyse option in exp command.

1124

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