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 35709

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

BeBo Technologies, Wipro,

7 73970

What are inner join and outer join?

3 25465

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

Amdocs, CSC, TCS,

29 97055

what are Triggers?

TCS,

7 28434

what are stored procedures?

TCS, Wells Fargo,

7 26874

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

Green Info Solutions, TCS,

7 31484

what are views?

TCS,

8 34971

Define 'view' advantage ?

AZTEC, TCS,

2 11653

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 14795

What is a Tablespace?

5 9960

What is SYSTEM tablespace and When is it Created?

2 7577

Explain the relationship among Database, Tablespace and Data file?

4 12621

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 63166

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How index is implemented in oracle database?

1006

How to assign a table row to a record variable?

1040

What is the use of aggregate functions in oracle?

1026

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2204

What is Segment Advisor in Oracle?

1103

Explain the difference between sap and oracle?

1029

What is oracle used for?

1026

How to assign data of the deleted row to variables?

1075

What is the max number of columns in an oracle table?

999

Explain how you would restore a database using RMAN to Point in Time?

2144

Explain the different normalization forms?

1094

What is meant by joins? List out the types of joins.

1030

How to invoke the data pump import utility?

1162

interview questions with answer for cts

2582

How to use an explicit cursor without open statements?

1055

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