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

Oracle General (1803)
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 6220

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 4981

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

2238

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

2202

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

3 5387

can we drop dual table

Metric Stream,

7 16468

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 4601

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 7280

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 4042

how to get last monday of a month?

Multifonds,

2 6603

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

BirlaSoft,

1 5972

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,

2250

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 6699

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 7838

what is insert all statement in sql

CGI, TCS,

2 6628

Un-Answered Questions { Oracle }

What privilege is needed for a user to insert rows to tables in another schema?

1065

Explain an exception?

1065

How to rename an index in oracle?

1175

What is the fastest query method to fetch data from the table?

1421

how to remove the duplicate in odi?

668

Mention what is new feature in oracle asm 12c?

What is tkprof and how is it used?

660

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

2285

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2130

What is the difference between truncate & delete command?

1238

How can I learn oracle dba?

601

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1073

What is an oracle database schema?

1168

What are the key components of oracle’s maximum availability architecture?

State and explain about oracle instance?

1053

For More Un-Answered { Oracle } Questions Click Here