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..., ?
Pankaj Kumar ChoudharyPosted Mar 18, 2015, 9:33 PM
Sorry if you thinks so this misunderstanding occur due to my weak english .......
victor ebePosted Mar 18, 2015, 5:11 PM
Vithal WadjePosted Mar 18, 2015, 1:48 PM
Pankaj Kumar ChoudharyPosted Mar 18, 2015, 12:48 PM
So Please Ask question Individually ....
Vithal WadjePosted Mar 18, 2015, 12:42 PM
Pankaj Kumar ChoudharyPosted Mar 18, 2015, 12:34 PM
Update Table_Change set sex=case Sex when 'male' then 'Female' when 'Female' then 'Male'
else Sex
end