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 35843

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

BeBo Technologies, Wipro,

7 74263

What are inner join and outer join?

3 25629

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

Amdocs, CSC, TCS,

29 97988

what are Triggers?

TCS,

7 28634

what are stored procedures?

TCS, Wells Fargo,

7 27104

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

Green Info Solutions, TCS,

7 31727

what are views?

TCS,

8 35190

Define 'view' advantage ?

AZTEC, TCS,

2 11745

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

4 13330

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

4 14963

What is a Tablespace?

5 10150

What is SYSTEM tablespace and When is it Created?

2 7672

Explain the relationship among Database, Tablespace and Data file?

4 12758

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 64282

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Why we use bulk collect in oracle?

1108

What is dual table oracle?

1027

How to define a variable of a specific record type?

1112

What are the limitations oracle database 10g xe?

1089

Can I create users through internet explorer in oracle 10g?

1151

What is SQL access advisor in Oracle?

1225

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1980

What is bulk collect in oracle?

1051

What is the difference between postgresql and oracle?

1100

what are actual and formal parameters?

1159

How to initialize variables with default values?

1299

How to delete an existing row from a table in oracle?

1125

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4566

How to create a new view in oracle?

1122

What is MTTR advisor in Oracle?

1133

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