Oracle Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 17275

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

Wipro, BeBo Technologies,

7 62846

What are inner join and outer join?

3 8884




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

CSC, TCS, Amdocs,

29 63440

what are Triggers?

TCS,

6 9279

what are stored procedures?

TCS, Wells Fargo,

7 7525

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

TCS, Green Info Solutions,

7 12587

what are views?

TCS,

8 14124

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

Oracle, i2,

2 15191

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

CA,

1 2849

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

2 3416

For web applications from which version of Oracle is suitable?

1 3389

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

1 3228

What is Statement Auditing ?

2 2707

What are the use of Roles ?

3 3065







Un-Answered Questions { Oracle }

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

13746


What is the exact use of Collections?

989


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

865


what is the scripts in data base?

979


3. Steps in UAT?

1180






What's dateware house and what's clustor with practicle example

1036


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

892


QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

982


how to make an oracle object

1246


how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

3728


what is the odi console?

4


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1002


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

983


What is Data Dictionary Cache in Oracle?

18


what are basic modules required to implement oracle application in any oraganisation?

971