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

Oracle General Interview Questions

Questions Answers Views Company eMail

Explain about your project and its relation to the current job position you are applying to?

1075

What are privileges and grants?

1102

How to display row numbers with the records?

1132

What are the uses of linked server and explain it in detail?

1117

Why do you use stored procedures and state some of its disadvantages?

1071

How to convert a date to char in oracle? Give one example.

1106

What is the difference between translate and replace in oracle?

1214

What are the different types of synonyms?

1197

How do you store pictures in a database?

1057

What is the use of file param in imp command?

1212

What is a system tablespace?

1130

In the oracle version 9.3.0.5.0, what does each number shows?

1343

What are the different types of modules in oracle forms?

1045

What are the limitations of check constraint?

1071

How to convert a string to a date in oracle database?

1090

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the different types of database objects?

1114

How to initialize variables with default values?

1305

what is reindexing?

1727

What is SQL access advisor in Oracle?

1228

Does oracle partitioning improve performance?

1051

what are bitmap indexes? How does they work?

2302

How to invoke the data pump import utility?

1224

Explain the use of Merge statement in oracle 11g

1074

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2339

How to execute a stored program unit?

1125

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1089

What do you know about normalization? Explain in detail?

996

How to drop a stored procedure in oracle?

1102

What is procedure overloading in oracle?

1111

What are the limitations of check constraint?

1071

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