Software Interview Questions
Questions Answers Views Company eMail

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

iGate,

3 5787

write a c program to print the next of a particular no without using the arithmetic operator or looping statements?

TCS,

1 3162

shorting algorithmS

Wipro,

1786

WHAT IS ABSTRACT DATA TYPE

Wipro,

4 5445

FILE PROGRAMMING

Wipro,

1767

SRUCTURE PROGRAMMING

CTS, Wipro,

3 5611

A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.

Accenture,

1665

I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same

2 6618

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

Microsoft,

2 5061

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

Microsoft,

4 6206

I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

Microsoft,

3 5224

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

Microsoft,

1566

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

Microsoft, Oracle, TCS,

5 7908

What are the steps of ATP in asp sd

IBM,

1 7098

in case of web application what kind of areas we r tested and one more in case of database testing what we are testing tell me in brief.

HCL,

1 4456


Un-Answered Questions { Software }

How to reverse a string in python

462


in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1684


How many types of trigger events are there in qtp?

539


What the junction object is and what is the use?

189


what are the tools used for oracle 10g in real time.

1914






What are the libraries of spark sql?

200


how you can protect your presentation in powerpoint 2013?

108


Can you name the differences between object-oriented and component-based design?

485


How to implement CAS in .Net?

2370


A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

510


How to record & run on japanese language application using english version of ibm?

587


Which database is used for java?

516


What is shell script?

459


what is queuemanager in ibm websphere mq ? What does queuemanager do?

481


Is null operator in sql?

586