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 are the different types of failures that occur in Oracle database?

HCL,

1072

How to Truncate Table in Oracle

HCL,

1165

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

HCL,

1053

Â How to use an oracle sequence generator in a mapping?

Informatica,

1081

Â What are the oracle DML commands possible through an update strategy?

Informatica,

1070

Explain the use of Merge statement in oracle 11g

Infosys,

1031

What are the tools for Oracle ?

Infosys,

1073

Name the three major set of files on disk that compose a database in Oracle?

1127

What is an Oracle Instance?

1132

What are the four Oracle system processes that must always be up and running for the database to be useable?

1023

Explain what are the different type of segments?

973

Explain a private synonyms?

1045

Explain an index?

1142

What do database buffers contain?

1043

Explain view?

1050

Un-Answered Questions { Oracle }

what is meant by magic query

2192

Can we convert a date to char in oracle and if so, what would be the syntax?

1022

How can I combine multiple rows into a comma-delimited list in oracle?

1065

How can we force the database to use the user specified rollback segment?

1154

Can we connect to ORACLE db using Windows Authentication?

1266

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1925

how can you pass values to-and-fro from foreign function?

What is oracle d2k? Why we use it?

What are the different oracle database objects?

1103

How to use group functions in the select clause using oracle?

1078

Which function is used to find the largest integer less than or equal to aspecific value?

568

Explain coalesce function?

1211

What is the Repository and how many types of repository?

580

What do you understand by redo log file mirroring?

How to turn on or off recycle bin for the instance?

1090

For More Un-Answered { Oracle } Questions Click Here