Technology Questions

Q:

When do you use UPDATE_STATISTICS command?

Answer

This command is used when a large processing of data has occurred. If any large amount of deletions, any modifications, or Bulk Copy into the tables has occurred, it has to update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2906
Q:

Write the basic syntax of a LINQ query in Visual Basic as well as in C#.

Answer

In Visual Basic, the basic syntax of a LINQ query starts with the From clause and ends with the Select or Group By clause. In addition, you can use the Where, Order By, and Order By Descending clauses to perform additional functions, such as filtering data and generating the data in a specific order.

In C#, the basic syntax of a LINQ query starts with the From clause and ends with the Select or group by clause. In addition, you can use the where, orderby, and Orderby descending clauses to perform additional functions, such as filtering data and generating the data in a specific order.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2903
Q:

How do you eliminate duplicate values in DB2 SELECT?

Answer

Use SELECT DISTINCT ..... in DB2 query


 


The DISTINCT keyword can be used to return only distinct (different) values.


Syntax:


     SELECT DISTINCT column1,column2


      FROM table_name;


 

Report Error

View answer Workspace Report Error Discuss

0 2902
Q:

What is the common usage of serialization? What exceptions occur during serialization?

Answer

The object need to be serialized when it’s sent over a network and when it’s state is saved. Exceptions which occur during serialization are:


a. transient fields


b. when the base class is serialized then only base class fields are handled.


c. static fields are ignored because they are not part of any state.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

1 2901
Q:

Why static method can not call non static method of the same class?

Answer

bcoz the static method does not contains the 'this' reference.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2897
Q:

What is the difference between a Hub and a Switch?

Answer

Hub is device to connect two devices, switch is a network bridge which processes and routes data approirately over network layer of OSI Reference model

Report Error

View answer Workspace Report Error Discuss

0 2896
Q:

Explain the different types of errors in PHP.

Answer

Notices, Warnings and Fatal errors are the types of errors in PHP


Notices: 


Notices represents non-critical errors, i.e. accessing a variable that has not yet been defined. By default, such errors are not displayed to the user at all but whenever required, you can change this default behavior.


Warnings: 


Warnings are more serious errors but they do not result in script termination. i.e calling include() a file which does not exist. By default, these errors are displayed to the user.


Fatal errors: 


Fatal errors are critical errors i.e. calling a non-existent function or class. These errors cause the immediate termination of the script.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2895
Q:

What is Legaccy System Migration Workbench? How it can be carried out in SAP SD?

Answer

LSMW is widely used by EDI programmers. EDI Programmers connect the SAP system to Non SAP system. During this Data migration is a necessity. When data migrates from source to destination the destination code is differrent from the source code. So what LSMW does is 


* Converts the data in to batch files


* Then converts the batch files in to source code batch files 


* And then mirgates data. Standard Interfaces like BAPI or Idoc are used in this process.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

0 2894