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

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 7684

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

Accenture, TCS,

3 11974

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 8864

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 3517

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

6 8908

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

2772

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 5144

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

AC, HP,

5 10386

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 5938

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

2233

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

2197

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

3 5378

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 4590

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 7265

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 4029

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the difference between sharding and partitioning?

1038

How to define a variable to match a table column data type?

1036

What is a proxy object?

1105

What are the oracle differences between nvl and coalesce

1233

What is a procedure in oracle?

1280

What is java oracle used for?

1075

Whether any commands are used for months calculation? If so, what are they?

1137

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2545

How do I recompile a procedure in oracle?

1018

What is a nvl function?

1093

How much memory your 10g xe server is using?

1153

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2384

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2262

How to count groups returned with the group by clause in oracle?

1122

What is Reduced List of Values?

2244

For More Un-Answered { Oracle General } Questions Click Here