Oracle Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 16826

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

Wipro, BeBo Technologies,

7 62213

What are inner join and outer join?

3 8647




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

CSC, TCS, Amdocs,

29 62603

what are Triggers?

TCS,

5 8884

what are stored procedures?

TCS,

6 7168

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

TCS, Green Info Solutions,

7 12190

what are views?

TCS,

7 13719

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

Oracle, i2,

2 14991

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

CA,

1 2707

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

2 3266

For web applications from which version of Oracle is suitable?

1 3273

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

1 3114

What is Statement Auditing ?

2 2616

What are the use of Roles ?

3 2965







Un-Answered Questions { Oracle }

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

978


did u received a single file or multiple files

992


How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

2074


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

1015


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

935






Can a formula column referred to columns in higher group ?

1376


20. Using a set operator, display the client number of all clients who have never placed an order.

1128


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

879


There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

1058


If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

999


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

1016


how to make an oracle object

1185


21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

965


Suppose database is running slow, what will you do?

1359


how to clone 9i Database on to 10g Database.

1121