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 35681

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

BeBo Technologies, Wipro,

7 73921

What are inner join and outer join?

3 25439

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

Amdocs, CSC, TCS,

29 96907

what are Triggers?

TCS,

7 28399

what are stored procedures?

TCS, Wells Fargo,

7 26832

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

Green Info Solutions, TCS,

7 31443

what are views?

TCS,

8 34923

Define 'view' advantage ?

AZTEC, TCS,

2 11627

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

4 13161

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

4 14772

What is a Tablespace?

5 9939

What is SYSTEM tablespace and When is it Created?

2 7558

Explain the relationship among Database, Tablespace and Data file?

4 12599

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 62955

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is oracle analytical function?

1125

How will you differentiate between varchar & varchar2?

1037

What are the types of partitions in oracle?

1033

What are operators in oracle?

1050

Can we store images in oracle database?

1001

When do we use group by clause in a sql query?

1030

What is the quickest way to export a table to a flat file?

959

What are the data types in oracle?

1032

Can a parameter be passed to a cursor?

1111

How to omit columns with default values in insert statement in oracle?

1039

What is a sub query? What are its various types?

1163

Explain the function of optimizer in oracle?

1124

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1996

What is a database schema in oracle?

1102

What happens if the update subquery returns multiple rows?

1108

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