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

Oracle General Interview Questions

Questions Answers Views Company eMail

how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

Verizon,

2 6003

how to get the second max val for every group in a table

Verizon,

6 9691

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

Wipro,

11 17094

dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.

3 5073

how to select second mauximum value in a given table under salary column

Sapient,

6 9574

Define Normalization with example?

1 5062

what is dynamic SGA and static SGA

Oracle,

4418

sql query to get zero records from a table

CTS,

7 11701

what is integrity constrains?

3 5939

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

Microsoft,

2 5762

how to get count of tables in particular database in Oracle?

3 5778

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

Cap Gemini,

4 8179

Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.

IBM,

1 4591

A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?

IBM,

1 5342

What is the difference between SQL and SQL Server?

CTS, TCS,

2 6004

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to create a table interactively?

1093

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

2207

What is MTTR advisor in Oracle?

1090

What is oracle data type?

964

How to convert a date to char in oracle? Give one example.

1068

What is rowid and rownum in oracle?

1011

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2066

What privilege is needed for a user to create views in oracle?

1050

What is a server parameter file in oracle?

1059

Explain the use of indexes option in imp command.

1180

How to create an oracle testing table?

1070

What is oracle server autotrace in oracle?

1166

Explain alias?

1154

What are internal user account in oracle?

1009

How to drop a stored procedure in oracle?

1051

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