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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

how to call forms in parametar forms

2 5978

how to create parameterised form in oracle 10g? and create another form from the value of the form? AND how to assign value to a parameter? sincerly your mamun

2 4784

What's dateware house and what's clustor with practicle example

2140

what's query optimization and without use of IN AND Exist can we get another way data from query

2099

What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

3 5128

can we drop dual table

Metric Stream,

7 15929

write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c

KPIT,

1 4461

write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000

TCS,

4 6897

Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).

1 3878

how to get last monday of a month?

Multifonds,

2 6397

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

BirlaSoft,

1 5813

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,

2143

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 6399

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 7578

what is insert all statement in sql

CGI, TCS,

2 6420

Un-Answered Questions { Oracle }

What are the oracle built-in data types?

1024

if some data is not transfered where it will get stored

1894

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2476

What are the daily activities of oracle dba?

568

What do you mean by redo log file mirroring?

985

What is oracle rowcount?

1043

How to find out what oracle odbc drivers are installed?

987

What is the difference between a primary key & a unique key?

1049

How to convert a string to a date in oracle database?

1008

please send me oracle pl/sql exp resume. and also faqs...

2460

How to rename an index?

1014

How to do a full database export?

1059

Explain an index?

1103

Describe an oracle table?

1003

What are the uses of a database trigger?

943

For More Un-Answered { Oracle } Questions Click Here