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

Oracle General Interview Questions

Questions Answers Views Company eMail

how to get last monday of a month?

Multifonds,

2 6469

Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??

BirlaSoft,

1 5885

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.

IBM,

2183

I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.

4 6545

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

CGI,

4 7702

what is insert all statement in sql

CGI, TCS,

2 6516

select trunc(round(156.00,-1),-1) from dual;

2 31269

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1994

primary key is foreign key for the same table?

Oracle,

2 7198

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

Accenture,

2 7001

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?

Infosys,

1 4298

how to produce numbers from 1 to 10 using dual table

Genpact,

4 10904

two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)

2 4964

how may join possible between (requisition with purchase order)

2250

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 4703

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How would you begin to troubleshoot an ORA-3113 error?

2078

What is the exact use of Collections?

2143

Is primary key indexed by default in oracle?

987

What is meant by an index?

1145

Explain the truncate in oracle?

967

How to speed up webrick?

1076

Explain an index segment?

1118

How to get a list of all background sessions in the database?

993

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2007

How to use in conditions in oracle?

1058

How to change program global area (pga) in oracle?

1092

What is a tns file?

996

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2397

Explain what are synonyms used for?

1034

What are the differences between interval year to month and interval day to second?

1027

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