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

Oracle General (1809)
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 35683

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

BeBo Technologies, Wipro,

7 73926

What are inner join and outer join?

3 25440

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

Amdocs, CSC, TCS,

29 96925

what are Triggers?

TCS,

7 28401

what are stored procedures?

TCS, Wells Fargo,

7 26834

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

Green Info Solutions, TCS,

7 31450

what are views?

TCS,

8 34927

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

i2, Oracle,

2 30943

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

CA,

1 17696

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

2 6716

For web applications from which version of Oracle is suitable?

1 6141

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

1 5606

What is Statement Auditing ?

2 5516

What are the use of Roles ?

3 6278

Un-Answered Questions { Oracle }

What is an Oracle database Full Backup?

1126

How can you find your id on a system?

561

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

586

What is Segment Advisor in Oracle?

1101

What are the arithmetic operations?

1077

What is dba training?

554

How to end the current transaction in oracle?

1020

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2262

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2288

i am writing a query select EmpNo from Emp how can i call in after parameter form

2116

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1332

What is data file?

1097

How to create lov dynamically at runtime & attach to text field?

1160

Difference between Row Id and Row Num?

674

all steps of bitmap report?

2347

For More Un-Answered { Oracle } Questions Click Here