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 35728

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

BeBo Technologies, Wipro,

7 74005

What are inner join and outer join?

3 25486

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

Amdocs, CSC, TCS,

29 97115

what are Triggers?

TCS,

7 28460

what are stored procedures?

TCS, Wells Fargo,

7 26892

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

Green Info Solutions, TCS,

7 31504

what are views?

TCS,

8 34993

Define 'view' advantage ?

AZTEC, TCS,

2 11674

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

4 13203

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

4 14812

What is a Tablespace?

5 9977

What is SYSTEM tablespace and When is it Created?

2 7582

Explain the relationship among Database, Tablespace and Data file?

4 12633

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 63294

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2266

What is a nested table and how is it different from a normal table?

1054

What is Data Dictionary Cache in Oracle?

1167

What is a cursor variable?

1135

What is private procedure oracle?

1012

How to define a record variable to store a table row?

1058

How to connect the oracle server as sysdba?

1079

Explain the use of tables option in exp command.

1117

What is the difference between a user and a schema in oracle?

1034

What privilege is needed for a user to delete rows from tables in another schema?

1070

what is reindexing?

1679

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

1079

What are group functions in oracle?

1044

Name the various constraints used in oracle?

1022

What is meant by an index?

1145

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