Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 4169

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

Verizon,

6 5975

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 10450

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 2895

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

Sapient,

6 5898

Define Normalization with example?

1 3390

what is dynamic SGA and static SGA

Oracle,

3221

sql query to get zero records from a table

CTS,

7 6466

what is integrity constrains?

3 3246

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

Microsoft,

2 3728

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

3 3307

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 5068

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 3050

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 3907

What is the difference between SQL and SQL Server?

CTS, TCS,

2 3556


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

How to invoke the data pump import utility?

175


How to invoke the data pump export utility?

136


What is a proxy object?

110


Why use resource manager in Oracle?

157


what is the difference between functional dependecy and multilevel dependency?

1582






How do I escape a reserved word in oracle?

152


defination of bitmap index

1167


What is set operator oracle?

105


What is oracle open database communication (odbc)?

130


Explain the use of full option in exp command.

133


Can we create database in oracle using command line ?

186


How to write date and time interval literals in oracle?

142


What is the maximum number of triggers that can be applied to a single table?

149


We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

4474


What is the minimum client footprint required to connect c# to an oracle database?

146