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 4064

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

1 3462

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 5567

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 8793

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.

2365

how to find count rows in table without count function?

Oracle,

3 7125

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 7988

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

Infosys,

4 8564

is database gud carrier option??

1 3682

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

2197

how to retrive xml data for using sql query?

IBM, TCS,

3 7106

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 4750

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

2266

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

TCS,

1 5026

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

2341

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

does the query needs a hint to access a materialized view?

1910

How do we create privileges in oracle?

1103

How to use "for" statements in oracle?

1124

How to create an oracle testing table?

1128

How to see the table columns used in an index?

1072

How to write text literals in oracle?

1119

Explain alias?

1193

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2170

What are advantages of dateset in datastage?

2310

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1129

How oracle handles dead locks?

1131

What is a cursor variable?

1216

How to lock and unlock a user account in oracle?

1163

What's dateware house and what's clustor with practicle example

2237

What is a sub query? Describe its types?

1074

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