Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 35714

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

BeBo Technologies, Wipro,

7 73980

What are inner join and outer join?

3 25467

What are joins..how many types of joins are there?

Amdocs, CSC, TCS,

29 97065

what are Triggers?

TCS,

7 28436

what are stored procedures?

TCS, Wells Fargo,

7 26877

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

Green Info Solutions, TCS,

7 31486

what are views?

TCS,

8 34975

Define 'view' advantage ?

AZTEC, TCS,

2 11656

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

4 13194

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

4 14801

What is a Tablespace?

5 9961

What is SYSTEM tablespace and When is it Created?

2 7577

Explain the relationship among Database, Tablespace and Data file?

4 12624

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 63186

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Which is faster join or subquery in oracle?

995

How to count groups returned with the group by clause in oracle?

1075

What is the sql query to concatenate column values from multiple rows in oracle?

1056

Can we write insert statement in function in oracle?

1089

What is truncate oracle?

971

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

How can I create database in oracle?

1026

What is the difference between primary key and unique key and foreign key in oracle?

982

What is the difference between 10g OEM and 11g OEM?

965

How do I escape a reserved word in oracle?

1197

What are a cluster and non-cluster index?

1018

How to use "startup" command to start default instance?

1031

How to calculate date and time differences in oracle?

1042

How to create a table in a specific tablespace?

976

What is difference between sid and service name in oracle?

956

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