Oracle General Interview Questions
Questions Answers Views Company eMail

How many types of segments in Oracle?

MCN Solutions,

523

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

MCN Solutions,

557

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

HCL,

589

How to Truncate Table in Oracle

HCL,

648

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

HCL,

581

 How to use an oracle sequence generator in a mapping?

Informatica,

556

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

Informatica,

572

Explain the use of Merge statement in oracle 11g

Infosys,

588

What are the tools for Oracle ?

Infosys,

594

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

626

What is an Oracle Instance?

677

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

583

Explain what are the different type of segments?

572

Explain a private synonyms?

623

Explain an index?

654


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a nvl function? How can it be used?

551


What is an Oracle index?

1168


what is the scenario where you take the database to NoArchivelog mode?

1823


How to use an explicit cursor without open statements?

606


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

572






How to add a new column to an existing table with a default value?

540


What are the various constraints used in oracle?

546


What is a system tablespace and when it is created?

554


Describe an oracle table?

565


How to get a list of all user accounts in the database?

599


Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1650


How to invoke the data pump export utility?

553


How to define an anonymous block?

610


What happens if variable names collide with table/column names?

574


How to install oracle database 10g xe?

556