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

Which object is create by UIApplicationMain function at app launch time?

Answer

The app delegate object is created by UIApplicationMain function at app launch time. The app delegate object's main job is to handle state transitions within the app.

Report Error

View answer Workspace Report Error Discuss

Subject: IOS

6 2501
Q:

Are you willing to travel?

Answer

Most people say "Yes" and do not add more to it. Use this opportunity to market yourself and express interests and activities that are aligned with job role you are applying.

Report Error

View answer Workspace Report Error Discuss

Subject: Common Interview

3 2497
Q:

What is the difference between view and materialized view?

Answer

View:


- Tail raid data representation is provided by a view to access data from its table.


- It has logical structure can not occupy space.


- Changes get affected in corresponding tables.


 


Materialized view


- Pre calculated data persists in materialized view.


- It has physical data space occupation.


- Changes will not get affected in corresponding tables.

Report Error

View answer Workspace Report Error Discuss

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

What is the difference between an alert box and a confirmation box?

Answer

An alert box displays only one button which is the OK button whereas the Confirm box displays two buttons namely OK and cancel.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2494
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 2492
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 2490