Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables

Mind Tree,

6 8625

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

Infosys,

2 8605

What is Partitions in Table ?

Atiric Software,

2 9815

Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com

2442

what is the scripts in data base?

2223

Is it possible to enter only time value into a column of a table in sql?

2 5148

Can anyone give me information about oracle certification

1 4644

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

2560

how the indexes are stored in the Oracle Database?

2336

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

Oracle,

2415

various types of hints and their usage

2751

various types of joins

9 10552

what is the difference between UNION AND UNIONALL

4 13124

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

2320

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

1 4942

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How many types of synonyms in Oracle?

1180

What is a server parameter file in oracle?

1098

What is the difference between count (*), count (expression), count (distinct expression)?

1047

How to turn on or off recycle bin for the instance?

1127

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2271

What are the types of trigger in oracle?

1029

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

1224

What are the uses of linked server and explain it in detail?

1118

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1959

What is the difference between PFILE and SPFILE in Oracle?

1112

What is control file used for?

1304

How to build data dictionary view an new database?

1052

How to loop through a cursor variable?

1128

What is snapshot is too old? Give and example for better understand.

1652

How do you bind variables in oracle?

1024

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