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 6002

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

Verizon,

6 9690

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 17092

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 9572

Define Normalization with example?

1 5061

what is dynamic SGA and static SGA

Oracle,

4417

sql query to get zero records from a table

CTS,

7 11700

what is integrity constrains?

3 5937

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

Microsoft,

2 5760

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

3 5777

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 4590

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 5341

What is the difference between SQL and SQL Server?

CTS, TCS,

2 6002

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a cursor and what are the steps need to be taken?

1202

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

953

What are the types of trigger in oracle?

984

why dont we assign not null constraint as table level constraint.

2739

what is the difference between functional dependecy and multilevel dependency?

2462

How to create a new oracle data file?

1032

How to rebuild an index in oracle?

1028

How to assign values to data fields in record variables?

1035

What is Java Pool in Oracle?

1171

What is recovery manager(rman) backup in Oracle?

1185

How to write a query with a left outer join in oracle?

1065

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

1056

What is an index associated with a constraint?

1040

How to connect ms access to oracle servers?

1009

what is the difference between substr and instr function in oracle?

1090

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