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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What is the difference between $oracle_base and $oracle_home?

1052

State and explain the different types of data models?

910

What is key preserved table?

974

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

1088

What are the different pseudo commands? Explain in general?

1036

Explain the different normalization forms?

1032

State the various uses of dbcc command?

1006

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

1119

State the difference between a primary key and foreign key?

898

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

1028

Explain about functional dependency and its relation with table design?

968

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

957

What are privileges and grants?

1017

How to display row numbers with the records?

1041

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

1024

Un-Answered Questions { Oracle }

What do you understand by recovery catalog?

533

How to install oracle database 10g xe?

977

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

520

What is ODI console?

642

When should the default values for oracle initialization parameters be used as is?

624

What flow of MSExcel in odi?

552

How to list all tables in your schema?

1005

How many types of canvases are there. Explain them

How do we represent comments in oracle?

1009

What is CDC and explain complete CDC process flow?

545

What the is the diff between local index and global index. give some example.

1595

Explain index?

1217

what is a package n what r the packages availbla in report

2049

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2254

How many types of segments in Oracle?

1031

For More Un-Answered { Oracle } Questions Click Here