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 5888

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

Verizon,

6 9441

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 16659

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 4952

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

Sapient,

6 9336

Define Normalization with example?

1 4924

what is dynamic SGA and static SGA

Oracle,

4335

sql query to get zero records from a table

CTS,

7 11404

what is integrity constrains?

3 5758

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

Microsoft,

2 5649

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

3 5607

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 7961

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 4486

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 5243

What is the difference between SQL and SQL Server?

CTS, TCS,

2 5829

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Does facebook use oracle?

987

How are extents allocated to a segment?

1068

Please explain oracle left join with an example?

963

Write a trigger example in oracle?

985

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2079

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

986

What are the uses of linked server and explain it in detail?

1008

How to execute the package in oracle?

1041

How many categories of data types?

940

Explain the use of constraints option in exp command.

994

How to create a new tablespace in oracle?

938

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1943

Explain oracle data types with examples?

971

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

2437

What is oracle instant client?

976

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