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 6595

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

BirlaSoft,

1 5960

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,

2246

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 6680

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 7830

what is insert all statement in sql

CGI, TCS,

2 6622

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

2 31414

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.

2042

primary key is foreign key for the same table?

Oracle,

2 7315

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 7112

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 4381

how to produce numbers from 1 to 10 using dual table

Genpact,

4 11050

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

2 5059

how may join possible between (requisition with purchase order)

2327

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

1 4769

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What do you understand by a database object?

1105

How to pass parameters to procedures in oracle?

1080

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2872

Explain do view contain data?

1049

Explain oracle’s server parameter file.

1040

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

3433

How to assign values to variables?

1163

Explain the function of optimizer in oracle?

1197

What is an oracle tablespace?

1094

How to view existing locks on the database?

1101

What is instant client oracle?

1072

What is oracle rownum?

1016

How to get maxsal , minsal, ename department wise in single query

1602

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1091

What is the usage of analyze command in oracle?

1140

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