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

Oracle General Interview Questions

Questions Answers Views Company eMail

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 7041

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

2340

Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

1 3793

what r tyhe major differences between oracle 9i & 10g?

6 14457

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2180

Is primary key = unique key,not null? If yes,please explain IF No,please explain

Genpact,

8 18080

how to delete all duplicate records from a table using subquery?

ABC, Cap Gemini,

7 23763

difference between imlicit cursor and explicit cursor ?

Cap Gemini,

5 9429

what is query and types of query

Reliance,

6 9122

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 4809

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 16056

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 4921

What is cursor

TCS,

4 9722

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

1999

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

IBM,

7 10773

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the various types of snapshots ?

1029

What are the system predefined user roles?

1043

What is a subquery in oracle?

1110

How to create a temporary table in oracle?

1271

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1989

What is an oracle transaction?

1146

what is the scenario where you take the database to NoArchivelog mode?

2331

How does one get the view definition of fixed views/tables?

1022

What are the various oracle database objects?

1145

what is the dual table in oracle?

993

How to delete a column in an existing table in oracle?

1073

How to load data from external tables to regular tables?

1062

How many memory layers are in the oracle shared pool?

1184

How do I spool in oracle?

1006

How to retrieve values from data fields in record variables?

1117

For More Un-Answered { Oracle General } Questions Click Here