1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
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 3170

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

 1 2662

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 4483

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 7047

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.

 1857

how to find count rows in table without count function?

Oracle,

3 5634

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 6079

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

Infosys,

4 6909

is database gud carrier option??

 1 2924

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

 1673

how to retrive xml data for using sql query?

IBM, TCS,

3 5833

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 3931

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

 1729

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

TCS,

1 4214

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

1770

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Can you assign multiple query result rows to a variable?

537

What are operators in oracle?

519

What is the difference between Delete, Truncate and Drop in Oracle?

593

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2441

How to view the data files in the current database?

582




How to join two tables in a single query using oracle?

557

What are the system predefined user roles?

579

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

539

What is open database communication (odbc) in oracle?

536

What is integrity and what is constraint??Explain with example

1689

How to invoke the original export import utilities?

493

How to install oracle database 10g xe?

554

Explain about integrity constraint?

593

What are the various oracle database objects?

665

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2048

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