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?

975

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?

1095

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?

1014

State the various uses of dbcc command?

992

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

1106

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?

1015

Explain about functional dependency and its relation with table design?

958

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What happens to the current transaction if a ddl statement is executed?

953

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

2306

How to connect to a remote server?

1063

How to rename an existing table?

1055

What is an oracle tablespace?

991

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5431

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

1077

Can we create database in oracle using command line ?

1035

How to check the oracle tns settings?

996

How to use like conditions in oracle?

1001

How to convert times to characters in oracle?

986

What is logical backup in oracle?

973

candidate key is subset of super key but not vice-verse explain

2021

How to use windows user to connect to the server?

946

What happens if you use a wrong connect identifier?

988

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