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 6080

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 4873

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

2168

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

2139

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

3 5235

can we drop dual table

Metric Stream,

7 16162

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 4518

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 7061

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 3936

how to get last monday of a month?

Multifonds,

2 6466

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

BirlaSoft,

1 5877

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,

2179

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 6533

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 7688

what is insert all statement in sql

CGI, TCS,

2 6506

Un-Answered Questions { Oracle }

What is null value in oracle?

1095

How to convert character types to numeric types?

1118

How to pass parameters to procedures?

1028

How would you go about increasing the buffer cache hit ratio?

2593

if u want to delete all these detail block etc what will happen in form

1980

How many types of km's? And you what are the type's km are used in your project?

571

What is the sql query to find the employee who has Nth maximum salary?

5318

What are the benefits of ordbms?

1083

What are functions of dba?

548

Explain drop constraint oracle?

1053

What is an oracle table?

981

What is SKM and when we will use this SKM?

653

How would you identify the shared_pool_size parameter that needs to be adjusted?

How to join two tables in a single query using oracle?

982

How to create a table interactively?

1082

For More Un-Answered { Oracle } Questions Click Here