Oracle General Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 16576

What is the difference between SQL, DDL, and DML?

BeBo Technologies, Wipro,

7 61785

What are inner join and outer join?

3 8524

What are many types of joins are there?

Amdocs, CSC, TCS,

29 62212

what are Triggers?


5 8684

what are stored procedures?


6 7001

what are many types of index's are there and what are they?

TCS, Green Info Solutions,

7 12006

what are views?


7 13531

Define 'view' advantage ?


2 8519

What are the components of Physical database structure of Oracle Database?

4 8242

What are the components of Logical database structure of ORACLE database?

4 10096

What is a Tablespace?

5 5078

What is SYSTEM tablespace and When is it Created?

2 4616

Explain the relationship among Database, Tablespace and Data file?

4 7594

What is schema?

Cognizant, HCL, Bodhi Global Services,

41 38132

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

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


What would you do with an in-doubt distributed transaction?


HI, Please let me know the syllabus for Oracle OCA and OCP Certification


In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.


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


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?


Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.


Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?


if you ctreate table identity


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ thanks Arun


Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.


can u send the sql dumps to plz help me


how do u setup a replication site?