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

Oracle General (1789)
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 3918

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 13865

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 3940

What is cursor

TCS,

4 7867

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

1567

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,

1649

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

IBM,

7 8669

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

2 7198

How to synchronize 2 schema's objects?

Virtusa,

1690

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

1 7830

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

2257

How i get the client m/c IP address.

2 4264

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

1710

how many types of index?

Cap Gemini, TCS,

2 6184

if you update view? where we store the data?

Cap Gemini,

5 9411

Un-Answered Questions { Oracle }

How to call a sub procedure?

564

Explain the oracle grid infrastructure?

How can we find out the duplicate values in an oracle table?

610

What is null value in oracle?

638

What privilege is needed for a user to create tables in oracle?

550

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1490

Is a rollback possible to any savepoint?

556

What operator tests column for the absence of data?

292

What is the use of aggregate functions in oracle?

581

What is the relation between database and instance?

296

What are named parameters?

616

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

1976

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

609

What is oracle host variable?

537

How to create tables for odbc connection testing?

495

For More Un-Answered { Oracle } Questions Click Here