Oracle Interview Questions
Questions Answers Views Company eMail

how to call forms in parametar forms

2 5025

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 4034

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

1641

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

1669

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

3 3861

can we drop dual table

Metric Stream,

7 13964

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 3820

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 5628

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 3075

how to get last monday of a month?

Multifonds,

2 5461

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

BirlaSoft,

1 5146

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,

1704

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 5064

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 6338

what is insert all statement in sql

CGI, TCS,

2 5519


Un-Answered Questions { Oracle }

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1460


What is a nested table and how is it different from a normal table?

580


What are the uses of Database Trigger ?

1101


What do you understand by recovery catalog?

298


What is different type of rman backup?

319






If you are working Microsoft excel, which type of file you used .excel or .csv?

281


What does >> do?

298


What do we mean by record group in oracle forms?

612


What is StandAlone Agent and default port number?

360


What is the scope of a local variable?

585


What is oracle analytical function?

529


What do you understand by lov?

567


What is Journalization and why we are using in ODI?

277


I would like to study certification course in Data base adminidtrator then where would i go to study this course?

1731


Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

298