Technology Questions

Q:

What do you understand by MapReduce?

Answer

MapReduce is a software framework that was created by Google. It`s prime focus was to aid in distributed computing, specifically large sets of data on a group of many computers. The frameworks took its inspiration from the map and reduce functions from functional programming.

Report Error

View answer Workspace Report Error Discuss

Subject: Cloud Computing

1 2813
Q:

What is Interpreter in Java?

Answer

  • An Interpreter is a program that reads in as input a source program, along with data for the program, and translates the source program step by step.


 


The Java interpreter decodes each lines bytecode and runs a series of machine instructions for that bytecode. The JVM takes the byte code and generates machine code. The byte code is compiled to machine code, and the machine code is executed.

Report Error

View answer Workspace Report Error Discuss

7 2810
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 2808
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 2808
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 2806
Q:

How do you display last 5 records in DB2?

Answer

SELECT * FROM table_name ORDER BY column_name desc Fetch first 5 rows only;

Report Error

View answer Workspace Report Error Discuss

0 2805
Q:

Which of the following are acceptable names of an ABAP program?

A. ZQSDABAP
B. YMYFIRSTABAPPROGRAM
C. Z”MyFirst ABAP PROGRAM
D. Z==FIRSTABAPPROGRAM
E. THISISMYFIRSTABAPPROGRAMME

Answer

Answer: A, B, E

The name of an ABAP program can be between 1 and 30 characters long.

The following symbols and signs must not be used in program names:
Period (.), comma (,), space ( ), parentheses (), apostrophe (‘), inverted commas ("), equals sign (=), asterisk
(*), accented characters or German umlauts (à, é, ø, ä, ß, and so on), percentage signs (%), or underscores (_).

Report Error

View answer Workspace Report Error Discuss

Subject: ABAP

0 2805
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 2804