1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

statement string in open is null or 0 length ORA-40735

RoboSoft, Unilog,

1 8815

types of indexes and the rationale behind choosing a particular index for a situation.

 1986

how the indexes are stored in the Oracle Database?

 1742

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

Oracle,

1829

various types of hints and their usage

 2131

various types of joins

 9 8177

what is the difference between UNION AND UNIONALL

 4 11512

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

 1848

what are the things that you consider while creating indexes on partitioning tables?

 1 3946

what happened to the global index when I truncate the data in one of the partition?

 1520

what are the advantages of running a database in archive log mode?

 1735

what are the advantages of running a database in NO archive log mode?

 1 3565

what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?

 2 13283

how do u setup a replication site?

 1502

what is a Nested Loop join?

 1568

Un-Answered Questions { Oracle }

What is dba and functionalities of dba?

301

What is the difference between sga and pga?

319

What is oracle thin client?

538

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

299

How to create an oracle database?

586




What is the function of cache fusion in oracle rac?

1

What is materialized view in Oracle?

630

How data locks are respected in oracle?

574

What are the predefined tablespaces in a database?

556

How to get a list of all background sessions in the database?

542

How to define and use table alias names in oracle?

510

How can you tell if an index on particular table is used or not used in 9i?

277

Explain the use of grant option in imp command.

578

What is flashback in Oracle?

581

How to export data to a csv file?

627

For More Un-Answered { Oracle } Questions Click Here