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 35531

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

BeBo Technologies, Wipro,

7 73656

What are inner join and outer join?

3 25286

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

Amdocs, CSC, TCS,

29 96069

what are Triggers?

TCS,

7 28197

what are stored procedures?

TCS, Wells Fargo,

7 26594

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

Green Info Solutions, TCS,

7 31203

what are views?

TCS,

8 34692

Define 'view' advantage ?

AZTEC, TCS,

2 11533

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

4 13019

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

4 14634

What is a Tablespace?

5 9762

What is SYSTEM tablespace and When is it Created?

2 7479

Explain the relationship among Database, Tablespace and Data file?

4 12452

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 61943

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

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

964

How does oracle handle read consistency?

1055

How to start your 10g xe server?

976

What are privileges and grants?

1010

How to create an initialization parameter file?

994

How does the on-delete-cascade statement work?

1063

List the various oracle database objects?

1001

What is a database schema in oracle?

1064

How to use "if" statements on multiple conditions?

1120

What is index in Oracle?

1019

How to display row numbers with the records?

1032

How to convert csv to table in oracle?

930

Is a rollback possible to any savepoint?

1013

How to start instance with a minimal initialization parameter file?

995

What is oracle rowcount?

1041

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