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 select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 4793

One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.

Polaris,

6 16016

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 4901

What is cursor

TCS,

4 9697

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1997

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

Telesis,

2064

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

IBM,

7 10749

Oracle me hindi notes chahiye or any web site address plz Give me in my email add,/////////// sunny.145@rediff.Com

2 8060

How to synchronize 2 schema's objects?

Virtusa,

2167

Can u explain me the Restricted and unrestricted procedure in Forms And reports and example as well ??

1 8649

why dont we assign not null constraint as table level constraint.

2733

How i get the client m/c IP address.

2 5250

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2131

how many types of index?

Cap Gemini, TCS,

2 7267

if you update view? where we store the data?

Cap Gemini,

5 11116

Un-Answered Questions { Oracle }

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

662

How many memory layers are in the oracle shared pool?

1176

What happens to the current transaction if the session is ended?

1094

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2325

How to load data from external tables to regular tables?

1060

You see multiple fragments in the system tablespace, what should you check first?

582

Explain how are indexes update?

1060

What are materialized views & where do we use them? What is a materialized view log?

Explain about integrity constraint?

1120

I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

How does Oracle guarantee data integrity of data changes?

2382

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

2119

What is a Garbage Collection? and what is full recursive Garbage collection?

2897

How many segment are present in Oracle Manufacturing

2314

Explain about your project and its relation to the current job position you are applying to?

1002

For More Un-Answered { Oracle } Questions Click Here