Interview 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 2667
Q:

What is UNION , UNION ALL?

Answer

Both these are used to combine the results of different SELECT statements.


    UNION       - Selects only distinct values 


    UNION ALL - Selects duplicate values also


 


Syntax:


    SELECT column_name(s) FROM table1


    UNION / UNION ALL


    SELECT column_name(s) FROM table2;


Notice that each SELECT statement within the UNION must have the same number of columns. The columns must also have similar data types. Also, the columns in each SELECT statement must be in the same order.


 

Report Error

View answer Workspace Report Error Discuss

0 2664
Q:

What is the difference between real money & nominal money?

Answer

Nominal money relates more to it's measure of counting - so nominal figure of what is written on bill, while "real" relates more to it's purchasing power (usually between some periods of time). For instance 100 units in nominal could buy 2 units of good in 1950 and 1 unit of good in 2005, at the same time real value of this 100 nominal units are 100 real units in 1950 and 50 real units in 2005.


Same is with GDP. In nominal it can rise due to inflation while it can stay the same or even decrease in real value.

Report Error

View answer Workspace Report Error Discuss

Subject: Finance

2 2664
Q:

Is Node.js is a single threaded application?

Answer

Node.js uses a single threaded model with event looping.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology
Job Role: Software Architect

0 2654
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 2654
Q:

How do you get more retailers / customers for your business? What are the steps you would take?

Answer

Applicant should answer that being in a wholesale market, he/she would plan and direct advertising and promotional activities to attract more retailer suppliers. Promotional activities like posters, contests, coupons, give-away to create extra interest in the purchase of a product or services from customers or retailers.

Report Error

View answer Workspace Report Error Discuss

Subject: Retail

1 2652
Q:

What is the differences between ABAP and OOABAP. In which situation we use OOABAP?

Answer

OOABAP is used to develop BSP/PCUI applications and also anthing involved object oriented like BADIs, SmartForms..etc.where as ABAP is used to develop traditional programs in R/3.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

2 2649
Q:

In-transit to destination or out for delivery means

Answer

When you give your item to the USPS for delivery, it accepts your item and starts the process of delivery. Transit is a part of the shipment delivery process. When we say that the package is in the transit or in transit to the destination, it means that the package is on the way to the delivery.

Report Error

View answer Workspace Report Error Discuss

0 2646