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

Oracle General Interview Questions

Questions Answers Views Company eMail

Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

IBM,

1 3967

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

1 3389

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

Zensar,

2 5470

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

Zensar,

5 8587

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2311

how to find count rows in table without count function?

Oracle,

3 7013

i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?

Oracle,

5 7803

Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)

Infosys,

4 8438

is database gud carrier option??

1 3597

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122

how to retrive xml data for using sql query?

IBM, TCS,

3 7010

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

IBM,

1 4680

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2209

Without giving condition how to retrieve the unmatched records from table.

TCS,

1 4968

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2286

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain integrity constraint?

1163

Give the different types of rollback segments.

1031

How to drop an index?

959

How to define an oracle cursor variable?

1028

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

What is a select query statement in oracle?

968

What is logical backup in oracle?

1018

What is a procedure in oracle?

1199

How to concatenate two text values in oracle?

1114

How to install oracle database 10g xe?

1020

How to install oracle odbc drivers?

1093

Can objects of the same schema reside in different tablespace?

1062

What is the data pump export utility?

1081

What is oracle open database communication (odbc)?

1028

What is a trigger oracle?

1088

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