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?

978

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

962

What is the usage of merge statement?

1099

Explain the difference between a procedure and a function?

1097

What is the difference between $oracle_base and $oracle_home?

1036

State and explain the different types of data models?

899

What is key preserved table?

969

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

1077

What are the different pseudo commands? Explain in general?

1028

Explain the different normalization forms?

1018

State the various uses of dbcc command?

994

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

1107

State the difference between a primary key and foreign key?

891

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

1016

Explain about functional dependency and its relation with table design?

960

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to pass a parameter to a cursor in oracle?

1114

Explain about functional dependency and its relation with table design?

960

What is a tns file?

948

How to create a stored program unit?

1133

In what script is snap$ created? In what script is the scott/tiger schema created?

2662

What are the set operators union, union all, minus & intersect meant to do?

943

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2309

In which language oracle has been developed?

1020

Can you have more than one content canvas view attached with a window ?

2272

What do you mean by a database transaction & what all tcl statements are available in oracle?

936

How to start your 10g xe server?

975

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1597

How to grant create session privilege to a user in oracle?

951

How many types of tables supported by oracle?

1026

How to fetch the row which has the max value for a column?

954

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