Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 2923

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

1 2439

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 4143

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 6309

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.

1693

how to find count rows in table without count function?

Oracle,

3 5222

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 5554

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

Infosys,

4 6306

is database gud carrier option??

1 2692

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

1500

how to retrive xml data for using sql query?

IBM, TCS,

3 5437

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 3657

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

1540

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

TCS,

1 3979

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

1640


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Difference between varchar and varchar2 data types?

516


How to bring a tablespace offline?

399


How do I manually create a database in oracle?

384


How to delete multiple rows from a table in oracle?

423


how do u setup a replication site?

1332






What are the limitations oracle database 10g xe?

412


What are the components of logical database structure in oracle database?

413


Why is oracle used?

404


What are the different types of database objects?

380


How to use existing values in update statements using oracle?

383


How to use like conditions in oracle?

405


How do I find my oracle client driver version?

387


What are the built-in functions used for sending Parameters to forms ?

2694


Explain what are the advantages of views?

460


Which are the five query types available in oracle?

360