1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
Oracle General Interview Questions
Questions Answers Views Company eMail

How many types of segments in Oracle?

MCN Solutions,

531

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

MCN Solutions,

563

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

HCL,

605

How to Truncate Table in Oracle

HCL,

657

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,

583

Explain the use of Merge statement in oracle 11g

Infosys,

598

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?

 595

Explain what are the different type of segments?

 580

Explain a private synonyms?

 637

Explain an index?

 658

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain an index?

658

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

1468

How do I manually uninstall oracle client?

518

How to define an anonymous block?

620

State and explain the different types of data models?

538




How to define an explicit cursor in oracle?

603

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

647

List out the difference between commit, rollback, and savepoint?

622

How to use windows user to connect to the server?

536

What is the difference between PFILE and SPFILE in Oracle?

580

Name the various constraints used in oracle?

567

How to write a query with a left outer join in oracle?

607

what is Single Byte Overhead...?

2064

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

628

How to run the anonymous block again?

595

For More Un-Answered { Oracle General } Questions Click Here