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 35502

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

BeBo Technologies, Wipro,

7 73592

What are inner join and outer join?

3 25256

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

Amdocs, CSC, TCS,

29 95821

what are Triggers?

TCS,

7 28153

what are stored procedures?

TCS, Wells Fargo,

7 26539

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

Green Info Solutions, TCS,

7 31145

what are views?

TCS,

8 34607

Define 'view' advantage ?

AZTEC, TCS,

2 11502

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

4 12993

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

4 14602

What is a Tablespace?

5 9726

What is SYSTEM tablespace and When is it Created?

2 7453

Explain the relationship among Database, Tablespace and Data file?

4 12423

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 61652

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

When do you get a .pll extension in oracle? Explain its importance

984

What is execute immediate in oracle?

948

Explain compound trigger in oracle?

985

Explain an exception?

919

What is an external table?

957

How to sort the query output in oracle?

967

IS it possible to built the oracle database without setting the kernal parameters?

2268

What are the numeric comparison operations?

1050

How to create a new tablespace in oracle?

932

What is oracle analytical function?

1028

What are transaction isolation levels supported by oracle?

994

How would you go about verifying the network name that the local_listener is currently using?

1994

How to generate query output in html format?

1031

How to create lov dynamically at runtime & attach to text field?

1096

What is an Oracle index?

1602

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