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 7589

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

Accenture, TCS,

3 11808

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 8697

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 3442

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

6 8731

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

2730

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 5058

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

AC, HP,

5 10174

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 5853

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

2175

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

2141

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

3 5244

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 4522

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 7095

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 3948

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to export several tables together?

1049

How to select an oracle system id (sid)?

1064

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2026

How to empty your oracle recycle bin?

1021

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2093

What is oracle host variable?

1061

various types of hints and their usage

2699

How to define an external table with a text file?

1069

What is a trigger and what are its types in oracle?

1072

How to run queries on external tables?

1047

Hi Can any one tell me what are the API's used in requisition import.

1923

What is truncate oracle?

971

How to delete multiple rows from a table in oracle?

1060

What is an oracle data file?

1103

List the parts of a database trigger.

1050

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