1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
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 6774

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

Accenture, TCS,

3 10289

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 7135

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 2681

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

 6 6930

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

 2222

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 4061

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

AC, HP,

5 7987

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 4865

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

 1629

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

 1659

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

 3 3811

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 3808

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 5574

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 3060

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How does oracle handle read consistency?

668

What is Segment Advisor in Oracle?

659

Why does oracle 9i treat an empty string as null?

530

How to delete a column in an existing table in oracle?

588

How many categories of data types in oracle?

596




Why do we need integrity constraints in a database?

576

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

849

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1598

What is a parameter file in oracle?

548

Explain the use of constraints option in exp command.

551

How view is different from a table?

542

Will you be able to store pictures in the database?

629

What is oracle and what are its different editions?

564

How to create a stored procedure in oracle?

567

what is port in oracle? how is it related to database application.

1426

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