Interview Question

Question

Sir Please Answer my interview Question::

 

1. Interface main Use for real time and opps concepts? Its only have signature. So why in need Interface & apstract class??? Some people say we use these for Large amount of class to handle easily? But why should i need this?

 

2. What is route Collection action if we declare Default 1 Default 2

 

3. you have 2 record website traffic. The table contain we site name (Multiple website). Page Name IP Address and UTC datetime. What would be the Query to show all websites visited in the last 30 days with total number or visits if unique page view and total number of unique visitors (Using IP Address)

 

4.You have 3 fields ID Date and Total Your table contains multiple rows for the same day which is valid data however for reporting purpose you need to show only one row per day. The row with the highest ID Per day should be returned the rest should be hidden from users( not returned)

 

5. find the smallest sub-string in s1 containing all characters of s2 Ans : s2.substring(s1) is correct????

 

6.How to handle Temp Table in sql?

 

7. How to update Male to Female and Female to male in Single SQL Updating Query.

 

8.How to stored User Viewed URL in sql from MVC Thank you For advantage Sir..., ?