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 7029

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

2338

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

1 3790

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

6 14430

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.

2172

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

Genpact,

8 18051

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

ABC, Cap Gemini,

7 23744

difference between imlicit cursor and explicit cursor ?

Cap Gemini,

5 9402

what is query and types of query

Reliance,

6 9104

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 4796

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 16028

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 4903

What is cursor

TCS,

4 9704

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

1998

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

IBM,

7 10757

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is control file used for?

1200

What is oracle and what are its different editions?

1064

What happens if you lost a data file?

1034

Explain an index?

1130

Is truncate autocommit in oracle?

1082

What is archive log in Oracle?

1131

What are the built-in functions used for sending Parameters to forms ?

3384

How to drop an index?

955

What is index in Oracle?

1070

What is a schema in oracle?

1010

What is oracle in java?

963

What is the difference between Delete, Truncate and Drop in Oracle?

1129

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2179

Is there an oracle sql query that aggregates multiple rows into one row?

972

How to declare a local variable?

1109

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