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 7039

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 3792

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

6 14452

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 18076

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

ABC, Cap Gemini,

7 23760

difference between imlicit cursor and explicit cursor ?

Cap Gemini,

5 9428

what is query and types of query

Reliance,

6 9121

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 4806

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 16053

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 4920

What is cursor

TCS,

4 9719

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 10770

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What happens if the imported table already exists?

1033

How to rollback the current transaction in oracle?

1054

What are the tools for Oracle ?

1062

Difference between varchar and varchar2 data types?

1184

Explain the use of constraints option in exp command.

1048

What is a snapshot log?

1003

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2497

material view and view disadvantages?

1073

definition of cluster and non-clustered index?

3035

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2275

How to define a cusotmer as a supplier in ORACLE R12

2232

how may join possible between (requisition with purchase order)

2252

How to pass parameters to procedures?

1034

What is a system tablespace?

1079

How to use values from other tables in update statements using oracle?

1080

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