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 2456
Q:

What happens when a CICS command contains the NOHANDLE option?

Answer

- NOHANDLE is an option that can be specified along with abnormal condition during program execution.


- When the exception occurs, no action is performed during execution of NOHANDLE command.


- The abnormal condition is ignored, even the EXEC CICS HANDLE condition exist.


- The abnormal condition is also ignored when EXEC CICS IGNORE condition is tested.


- The previous HANDLE CONDITION for other commands will not be effected with NOHANDLE option.

Report Error

View answer Workspace Report Error Discuss

0 2453
Q:

What is Marshalling?

Answer

Marshalling is the process of gathering data from one or more applications or non-contiguous sources in computer storage, putting the data pieces into a message buffer, and organizing or converting the data into a format that is prescribed for a particular receiver or programming interface.  

Report Error

View answer Workspace Report Error Discuss

0 2453
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 2453
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 2451
Q:

What does window.history object?

Answer

The window.history object can be written without the window prefix.
To protect the privacy of the users, there are limitations to how JavaScript can access this object.
Some methods:


    history.back() - same as clicking back in the browser
    history.forward() - same as clicking forward in the browser

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2447
Q:

Which interface implements the standard query operators in LINQ?

Answer

The standard query operators implement the IEnumerable<T> or the IQueryable<T> interface in C# and the IEnumerable(Of T) or the IQueryable(Of T) interface in Visual Basic.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2443
Q:

If a method is declared as protected, where may the method be accessed?

Answer

A protected method may only be accessed by classes or interfaces of the same package or by subclasses of the class in which it is declared.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2441