Oracle General Interview Questions
Questions Answers Views Company eMail

How many types of segments in Oracle?

MCN Solutions,

529

What is the difference between 10g OEM and 11g OEM?

MCN Solutions,

561

What are the different types of failures that occur in Oracle database?

HCL,

599

How to Truncate Table in Oracle

HCL,

655

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

HCL,

591

 How to use an oracle sequence generator in a mapping?

Informatica,

570

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

Informatica,

581

Explain the use of Merge statement in oracle 11g

Infosys,

596

What are the tools for Oracle ?

Infosys,

609

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

635

What is an Oracle Instance?

687

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

593

Explain what are the different type of segments?

578

Explain a private synonyms?

634

Explain an index?

658


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

how can we store any pdf file in oracle

1642


How to drop an index?

544


How to execute a stored program unit?

583


Explain a synonym?

604


In which language oracle has been developed?

647






How do I know if oracle client is installed on windows?

498


How to return top 5 rows in oracle?

547


What is redo log?

623


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1468


Explain enable novalidate constraint.

597


How oracle handles dead locks?

602


Explain integrity constraint?

644


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1607


How to use "in out" parameter properly?

612


How can we find out the current date and time in oracle?

641