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 6093

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 4881

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

2175

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

2141

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

3 5244

can we drop dual table

Metric Stream,

7 16196

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 4522

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 7094

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 3948

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 6543

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 7700

what is insert all statement in sql

CGI, TCS,

2 6513

Un-Answered Questions { Oracle }

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2275

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2192

Please explain drop constraint oracle?

1104

How can you tell if an index on particular table is used or not used in 9i?

564

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

590

Explain about the analyze command in oracle?

1052

How to determine what records to extract?

Can we invoke one form from another in a multi-forms application?

1131

What is materialized view in Oracle?

1074

How to write an inner join with the where clause in oracle?

1044

How do you analyze table partition using oracle provided package?

520

Explain the difference between sql and oracle?

1077

Why should I use oracle database?

991

How to load excel data sheet to oracle database

1024

does the query needs a hint to access a materialized view?

1857

For More Un-Answered { Oracle } Questions Click Here