Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Oracle General Interview Questions
Questions Answers Views Company eMail

when i run my query on yesterday it is fast but today it is slow why?

1 6072

how to find find & delete duplicate rows from two different tables?

Accenture, TCS,

3 8988

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

Amazon, HCL,

3 5459

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

1 1975

how to retrieve 1st and last row of table without using group functions??

6 5357

How to Identify the previously inserted/updated records in already populated table.

1802

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

TCS,

2 3071

without using count(*) and rownum how can we count total record in a table

AC, HP,

5 6220

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

BirlaSoft,

2 3964

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

1186

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

1211

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

3 2673

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 3079

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 4082

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 2376


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

Define oracle database

157


Please explain compound trigger in oracle?

161


What is parameterized cursor in oracle?

110


what is the use of system.effective.date variable in oracle?

204


What is ceil and floor in oracle?

149






Can group functions be mixed with non-group selection fields?

121


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

1457


What are operators in oracle?

112


What are the parameters that we can pass through a stored procedure?

139


What are the restrictions in a oracle read only transaction?

142


What is the difference between I and G in Oracle?

176


How to delete multiple rows from a table in oracle?

159


6. Display the client name and order date for all orders using the traditional method.

1252


How is it different from a normal table?

164


What is a cursor in oracle?

163