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

Oracle General Interview Questions

Questions Answers Views Company eMail

How can we view last record added to a table?

1104

What is the maximum number of triggers that can be applied to a single table?

1067

What is the usage of merge statement?

1202

Explain the difference between a procedure and a function?

1236

What is the difference between $oracle_base and $oracle_home?

1136

State and explain the different types of data models?

990

What is key preserved table?

1077

What is a sub query and what are the different types of subqueries?

1171

What are the different pseudo commands? Explain in general?

1121

Explain the different normalization forms?

1152

State the various uses of dbcc command?

1103

What are a collation and state the different types of collation sensitivity?

1233

State the difference between a primary key and foreign key?

994

What are the different types of trigger and explain its various uses and functions?

1166

Explain about functional dependency and its relation with table design?

1059

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1117

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2332

What is a read only transaction in oracle?

1078

What is an anonymous block?

1323

Explain self joins in oracle?

1058

How to use like conditions in oracle?

1111

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1991

How to get the Installed Oracle Version Information ?

1187

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2439

What is the maximum number of triggers that can be applied to a single table?

1067

Explain a synonym?

1086

How do I spool in oracle?

1060

How to do a full database export?

1150

How to delete multiple rows from a table in oracle?

1111

What is a trace file and how is it created in oracle?

1139

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