Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1789)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 20081

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

BeBo Technologies, Wipro,

7 67231

What are inner join and outer join?

3 10533

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

Amdocs, CSC, TCS,

29 70619

what are Triggers?

TCS,

7 11797

what are stored procedures?

TCS, Wells Fargo,

7 10211

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

Green Info Solutions, TCS,

7 15006

what are views?

TCS,

8 16926

what is the difference between oracle 81,91,11i

i2, Oracle,

2 16608

How client makes connection with server in client/server architecture?

CA,

1 3872

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 4488

For web applications from which version of Oracle is suitable?

1 4106

What are the main diff. between oracle 7.3 and oracle 8i?

1 3961

What is Statement Auditing ?

2 3489

What are the use of Roles ?

3 4026

Un-Answered Questions { Oracle }

Why do we need integrity constraints in a database?

350

What is different types of joins?

335

What is partitioned table in Oracle?

379

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

1715

what is the difference between data migration and production migration.

1553

how report can be generated if we have the database designed in oracle 10g?

1207

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1569

Difference between ETL and E_LT?

118

How to drop an index?

310

What is the sql query to concatenate column values from multiple rows in oracle?

306

What do you understand by a database object?

336

Explain self joins in oracle?

331

What is mrc and what is its use? : oracle accounts receivable

377

How to create an oracle testing table?

347

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

3395

For More Un-Answered { Oracle } Questions Click Here