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 joins..how many types of joins are there?

Amdocs, CSC, TCS,

29 62212

what are Triggers?

TCS,

5 8684

what are stored procedures?

TCS,

6 7001

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

TCS, Green Info Solutions,

7 12006

what are views?

TCS,

7 13531




Define 'view' advantage ?

AZTEC, TCS,

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.

1169


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

772


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

1283


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

2986


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

955






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

1248


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 ?

868


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.

551


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?

283


if you ctreate table identity

1002


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

960


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.

825


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.

2662


can u send the sql dumps to sivakumarr1987@gmail.com plz help me

1907


how do u setup a replication site?

825