Interview Questions

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;

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.

LINQ stands for " Language Integrated Query " and it is pronounced as "LINK".
LINQ was introduced in with .NET framework 3.5 including VS2008. It enables you to query the data from various data source like SQL, XML document, ADO .NET data source, web services and any other objects such as Collection, Generics etc...

The intention of the interviewer by asking this question is to discover the pain points for the candidate.

Here this can be explained with an example like this :

The administrative assistant might seem like someone whose job is simply keeping everything filed and organized and scheduled. But they actually are the building block of the entire office, making everyone's lives function more smoothly and with good access to information when they need it.

Sometimes I have so many things crossing my desk at a given time that I can get a bit overwhelmed. When this happens I take a deep breath and focus on prioritizing the work. Then I get a clear head again and can dive back in.

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

CURSOR STABILITY:

- CS is a row level locking

- Acquires an exclusive lock on the row that is to be updated

- When the control is moved to the next updatable row, the lock is released

REPEATABLE READ:

- RR is a page level locking

- Acquires an exclusive lock on the entire page which is the source of row availability

- When the control is moved to the next updatable page the lock is released

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

Following are the 3 core directives of AngularJS.

1. ng-app : This directive defines and links an AngularJS application to HTML.


2. ng-model : This directive binds the values of AngularJS application data to HTML input controls.


3. ng-bind : This directive binds the AngularJS Application data to HTML tags.