Oracle Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 21646

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

BeBo Technologies, Wipro,

7 69857

What are inner join and outer join?

3 11625

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

Amdocs, CSC, TCS,

29 76114

what are Triggers?

TCS,

7 13633

what are stored procedures?

TCS, Wells Fargo,

7 12089

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

Green Info Solutions, TCS,

7 16662

what are views?

TCS,

8 19178

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

i2, Oracle,

2 17496

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

CA,

1 4549

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

2 5196

For web applications from which version of Oracle is suitable?

1 4609

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

1 4459

What is Statement Auditing ?

2 4049

What are the use of Roles ?

3 4717


Un-Answered Questions { Oracle }

What do you understand by oracle forms and why are they required?

525


How to define an anonymous block?

587


How many segment are present in Oracle Manufacturing

1782


How do you prevent oracle from giving you informational messages during and after a sql statement execution?

266


What is the use of Markers?

257






What are the steps involved in instance recovery in oracle?

266


What is coalesce function?

539


How to retrieve the count of updated rows?

547


In the oracle version 9.3.0.5.0, what does each number shows?

697


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1528


What are internal user account in oracle?

544


Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

261


What is the simplest tool to run commands on oracle servers?

485


When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

272


What is connection pool in oracle?

523