Technology Questions

Q:

How will you find the 3rd max salary in the employment table?

Answer

SELECT DISTINCT(salary) FROM emp as e1 


WHERE (3) = (SELECT COUNT(DISTINCT(salary)) FROM emp as e2  WHERE e1.salary <= e2.salary)

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 2767
Q:

What are the differences between COBOL and COBOL II?

Answer

There are some differences:


COBOL II supports structured programming by using in line Performs and explicit scope terminators. It introduces new features (EVALUATE, SET. TO TRUE, CALL BY CONTEXT, etc). It permits programs to be loaded and addressed above the 16-megabyte line .  It does not support many old features (READY TRACE, REPORT-WRITER, ISAM, etc.). It offers enhanced CICS support.

Report Error

View answer Workspace Report Error Discuss

0 2767
Q:

What are user defined data-types and when do you use them?

Answer

User defined data-types in SQL is an extension to the base SQL server data-types by provision of a descriptive name.


We use them to format the database and segregate specific repetitions of rows and columns in the database.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 2766
Q:

What divisions, sections and paragraphs are mandatory for a COBOL program?

Answer

IDENTIFICATION DIVISION and PROGRAM-ID paragraph are mandatory for a compilation error free COBOL program.

Report Error

View answer Workspace Report Error Discuss

0 2763
Q:

When would you use the ping command with the "-t" switch?

Answer

to get the ping back from other computer with no packet loss

Report Error

View answer Workspace Report Error Discuss

1 2760
Q:

What are different ABAP/4 editors? What are the differences?

Answer

The 2 editors are se38 and se80 both have the abap editor in place. In se38 you can go create programs and view online reports and basically do all thedevelopmet of objects in this editor. In se80 ( object navigator) there are additional features such as creating packages,module pool , function group ,classes, programs ( where you can create ur programs) and BSP applications .

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

0 2760
Q:

Why interface method is always public?

Answer

To make this method available to every implementation class

Report Error

View answer Workspace Report Error Discuss

Subject: Java
Job Role: IT Trainer

0 2760
Q:

What is the basic difference between ASP and ASP.NET?

Answer

The basic difference between ASP and ASP.NET is that ASP is interpreted; whereas, ASP.NET is compiled. This implies that since ASP uses VBScript; therefore, when an ASP page is executed, it is interpreted. On the other hand, ASP.NET uses .NET languages, such as C# and VB.NET, which are compiled to Microsoft Intermediate Language (MSIL).

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2759