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 2752
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 2744
Q:

How can we call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL?

Answer

EXECUTE IMMEDIATE command can be used to call DDL statements. 


Example:


BEGIN


EXECUTE IMMEDIATE  'TRUNCATE TABLE employee';


END;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2743
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 2740
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 2738
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 2736
Q:

How do we measure progress in Data Integration?

Answer

Look for the existence of the following items:


- Generic Data Models


- An Enterprise Data Platform


- Identify the Data Sources


- Selection of a MDM Product


- Implementation of a Customer Master Index or appropriate alternative

Report Error

View answer Workspace Report Error Discuss

0 2736
Q:

what is flat aggregation?

Answer

If you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate. When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates.

Report Error

View answer Workspace Report Error Discuss

0 2735