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 4779

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

1 3869

what are different types of locks?

6 8611

master table and child table performances and comparisons in Oracle ?

2138

what are the different types of cursors? explain?

4 10236

what are different types of deletes?

1 3770

can a view be updated?

3 9785

what is pragma?

2 6783

can you write commit in triggers?

4 10894

can u call user defined functions in select statements

2 5353

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

2 7000

After update how do u know how many records got updated

TCS,

4 8411

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

2 5687

how many columns can a plsql table have

NIIT,

13 21524

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

3 6069

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to export data with a field delimiter?

1044

What are the ways tablespaces can be managed and how do they differ?

2373

What are the differences between blob and clob in oracle?

1089

What is the difference between count (*), count (expression), count (distinct expression)?

1013

How to convert csv to table in oracle?

994

How to use values from other tables in update statements using oracle?

1085

What are the different types of database objects?

1067

What are the attributes of the cursor?

1004

What is archive log in Oracle?

1134

What is a read write transaction in oracle?

1093

Is oracle an operator?

932

What is the relationship among database, tablespace and data file?

992

How are extents allocated to a segment?

1130

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1867

Explain coalesce function?

1209

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