Oracle Interview Questions
Questions Answers Views Company eMail

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

HCL,

581

How to Truncate Table in Oracle

HCL,

642

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

HCL,

571

 How to use an oracle sequence generator in a mapping?

Informatica,

549

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

Informatica,

568

Explain the use of Merge statement in oracle 11g

Infosys,

580

What are the tools for Oracle ?

Infosys,

588

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

617

What is an Oracle Instance?

670

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

579

Explain what are the different type of segments?

562

Explain a private synonyms?

616

Explain an index?

646

What do database buffers contain?

553

Explain view?

569


Un-Answered Questions { Oracle }

How to Truncate Table in Oracle

642


what are savepoint mode and cursor mode properties ?

1


What is the fastest query method to fetch data from the table?

830


What are the tools provided in oracle enterprise manager?

1


Please explain compound trigger in oracle?

586






What is raw datatype?

581


What is a dba?

277


Explain enable novalidate constraint.

585


types of receipts and detail desription about recipts and tables effected by receipts?

1616


What is the usage of analyze command in oracle?

597


What are the system predefined user roles?

579


Explain the use of rows option in exp command.

575


Explain constraining triggers.

576


Why oracle forms required?

544


How to login to the server without an instance?

610