Tuesday, 29 April 2014

FUNNY .NET INTERVIEW QUESTIONS BY Shivprasad Koirala

Nice Joke in Interview : This type of question make interview funny

Interviewer :- We are looking for 5 years of experience in MVC 5. 

 job seeker :- I have 10 years of experience in MVC 5 

 Interviewer :- Kya joke mar rahe ho(Are you joking) MVC 5 has been released hardly 1 year back. 

 Job seeker :- Joke chalu kisne kiya.(Who started this joke)

Friday, 25 April 2014

MS SQL SERVER COMPLEX INTERVIEW QUERY | CAR

Today I came with complex Sql server Query, You can face this query in interview but not in case of fresher sql server interview, It can be asked to experienced sql server developer. I think If you write down this query, then you must impress your interviewer, and if you impressed your interviewer then you must cracked your interview.

So now lets talk about the query.
Query : You have a table with ID, Fuel, And Date columns.
Fuel column is contain fuel at a particular time when car start traveling. So we need to find out that when the driver fill Petrol in his/her car.
By below image you can understand the query. 
Car start driving at 10 Am on 25th April
at 11 Am Petrol was 9 liters
at 12 Am petrol was 8 liters
at 2 Pm (14) petrol was 12 liters... 
This means that he/she fill the petrol at 25th April 2014 at 2PM
Next time he fill petrol at 7PM 25th April 2014
and Next time he fill petrol at  11PM  25th April 2014

So we need to find out the above date by query.


Solution of the is (by Deepak):
select c1.fuel,c1.[Date],c.fuel,c.[date]
from car c
join
car c1 on c1.[Date] =(select min([Date]) from car where [Date]>c.[Date] )
where c1.fuel>c.fuel




Second Solution you can try following Long Query (by Vikas):

Select * from
(
SELECT CASE
WHEN [Fuel] < fule1 THEN DATE1
ELSE
NULL
END AS [DATE]
FROM
(

select   A.[ID]
      ,A.[Fuel]
      ,m.[Fuel] as fule1
      ,A.[Date]
      ,M.[Date] AS DATE1
FROM
(SELECT TOP 2000 [ID]
      ,[Fuel]
      ,[Date]
  FROM [Vikas].[dbo].[Car]
  where [ID]%2 = 1
) A
  Join (
 SELECT TOP 2000 [ID]-1 as id
      ,[Fuel]
      ,[Date]
  FROM [Vikas].[dbo].[Car]
  where [ID]%2 = 0)
  M on A.ID = M.id
  ) R

Union all
SELECT CASE
WHEN [Fuel] < fule1 THEN DATE1
ELSE
NULL
END  AS [DATE]
FROM
(

select   A.[ID]
      ,A.[Fuel]
      ,m.[Fuel] as fule1
      ,A.[Date]
      ,M.[Date] AS DATE1
FROM
( SELECT [ID] as [ID]
      ,[Fuel]
      ,[Date]
  FROM (  SELECT TOP 2000 [ID]-1 AS ID
      ,[Fuel]
      ,[Date]
  FROM [Vikas].[dbo].[Car]
  WHERE [ID] NOT IN (1)) T
  where [ID]%2 = 1
) A
  Join (
 SELECT [ID]-1 as id
      ,[Fuel]
      ,[Date]
  FROM (  SELECT TOP 2000 [ID]-1 AS ID
      ,[Fuel]
      ,[Date]
  FROM [Vikas].[dbo].[Car]
  WHERE [ID] NOT IN (1)) T
  where [ID]%2 = 0)
  M on A.ID = M.id
  ) R
  ) Z WHERE DATE IS NOT NULL order by [DATE]


OUTPUT :







If you want to try this at your and then run the following script for create table.


CREATE TABLE [dbo].[Car](
      [ID] [int] IDENTITY(1,1) NOT NULL,
      [Fuel] [int] NULL,
      [Date] [datetime] NULL,
CONSTRAINT [PK_Car] PRIMARY KEY CLUSTERED
(
      [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Car] ON
INSERT [dbo].[Car] ([ID], [Fuel], [Date]) VALUES (1, 10, CAST(0x0000A31800A4CB80 AS DateTime))
INSERT [dbo].[Car] ([ID], [Fuel], [Date]) VALUES (2, 9, CAST(0x0000A31800B54640 AS DateTime))
INSERT [dbo].[Car] ([ID], [Fuel], [Date]) VALUES (3, 8, CAST(0x0000A31800C5C100 AS DateTime))
INSERT [dbo].[Car] ([ID], [Fuel], [Date]) VALUES (4, 6, CAST(0x0000A31800D63BC0 AS DateTime))
INSERT [dbo].[Car] ([ID], [Fuel], [Date]) VALUES (5, 12, CAST(0x0000A31800E6B680 AS DateTime))
INSERT [dbo].[Car] ([ID], [Fuel], [Date]) VALUES (6, 11, CAST(0x0000A31800F73140 AS DateTime))
INSERT [dbo].[Car] ([ID], [Fuel], [Date]) VALUES (7, 10, CAST(0x0000A3180107AC00 AS DateTime))
INSERT [dbo].[Car] ([ID], [Fuel], [Date]) VALUES (8, 9, CAST(0x0000A318011826C0 AS DateTime))
INSERT [dbo].[Car] ([ID], [Fuel], [Date]) VALUES (9, 8, CAST(0x0000A3180128A180 AS DateTime))
INSERT [dbo].[Car] ([ID], [Fuel], [Date]) VALUES (10, 10, CAST(0x0000A31801391C40 AS DateTime))
INSERT [dbo].[Car] ([ID], [Fuel], [Date]) VALUES (11, 9, CAST(0x0000A31801499700 AS DateTime))
INSERT [dbo].[Car] ([ID], [Fuel], [Date]) VALUES (12, 8, CAST(0x0000A318015A11C0 AS DateTime))
INSERT [dbo].[Car] ([ID], [Fuel], [Date]) VALUES (13, 7, CAST(0x0000A318016A8C80 AS DateTime))
INSERT [dbo].[Car] ([ID], [Fuel], [Date]) VALUES (14, 15, CAST(0x0000A318017B0740 AS DateTime))

Monday, 21 April 2014

Monday, 14 April 2014

Chetan Bhagat Next/Upcoming 6th Novel/Book 2014-15 .pdf : FREE DOWNLOAD

Hey are you waiting for Chetan Bhagat's Upcoming 6th and 7th Novel/Book? And want to download it free as pdf., Then this is the place where you will got announcement of his upcoming novel. As per current news his next novel can be released in October 2014 on Diwali (23rd October 2014). So wait for some days as soon as it will announce we will inform you, for more info visit this links on regular bases.
 Novel readers, Happy reading....
As per latest new
Today(22 May 2014) Chetan Bhagat twitted about his new Novel/Book(2014), that It will launch on this Diwali(23rd October 2014). So wait for this Diwali. 

If you want any genital reminder then comment your email/mobile no, we will send you reminder/update when the Chetan Bhagat New Novel/Book Name will announce.

Tuesday, 8 April 2014

Princeton University Interview Questions Answers : Sample Interview Questions

Princeton University Interview Questions Answers
Princeton University interviews are conducted by Princeton alumni volunteers. They try to interview every single applicant because they truly feel that every student has something to bring to Princeton. It's not up to the alumni to decide who to interview.
There are some interview questions which are asked during Princeton University student interview.

Introduce yourself briefly.

What other schools did you apply to and why?

Why do you like Princeton?

Tell me about your family. What courses did you enjoy the most? 

Have you any leadership experience? 

What do you know about Princeton?

How suggest you about Princeton? 

Tell me about your interests?

DAVV B.Com Exam Result 2014 | B.Com. III Sem Result Declared

DAVV B.Com Exam Result 2014 (B.Com. III Sem Result Declared) :-

Are you searching here B.Com III Sem exam 2014 result ? now you are on the right way to check exam DAVV B.Com Exam Result 2014. All of the candidates of DAVV, happy to know that Devi Ahilya Vishwavidyalaya (DAVV), has recently declared the B.Com. III Sem (Regular and Private) Exam Result 2014.

First you need to open University site :- www.dauniv.ac.in 
Click to “ Results ” and re-click to “ 
Search By Roll No 
Now Enter your Required Details as Two time. 
Then your result will come on screen and students take print out it.

What part of this project most appeals to you? Best Answers?

Hey I have copied some Interview questions form Yahoo Answers. One of them is
Questions: 
What part of this project most appeals to you? Best Answers? 

 And the best answer of this question as I found is
 Ans: 
There’s a right way and a wrong way to answer this question. The wrong way is to see matters entirely from your own point of view and to cite some aspect of the vacancy which meets your own needs first and foremost. The right way is to make sure you identify some aspect of the vacancy which you can talk about in such a way as to place emphasis on how you meet the organization’s needs. The interviewer is more interested in how you meet their needs than on how they can meet yours.

Friday, 4 April 2014

X-Ray Developing Machine Operator Interview Questions Answers

Are you looking for job as a X-Ray Developing Machine Operator, then this post for you.


1). Tell me about your past experience/challenges?

2). What training have you taken for this job?

3). What do you like and dislike about your job( As a X-Ray Developing Machine Operator)?

4). What's the worst mistake you have made at work hours( As a X-Ray Developing Machine Operator)?

5). How did your come out that worst situation?

6). Can you name the key tasks for X-Ray Developing Machine Operator?

7). Can you tell describe X-Ray Deveploying Machine part wise?

8). What can you do for us that someone else can't do?

9). What did you like or dislike about your previous job?

10). How much salary did you expect from us?

Best of luck...

NYU INTERVIEW QUESTIONS FOR STUDENTS

NEW YORK UNIVERSITY INTERVIEW QUESTIONS FOR STUDENTS

Following are the questions asked in NYU during student interview.

Interviewed at NYU (New York University)
Interview Details – There was a phone interview and then a second round in person interview.

Interview Question – 
what if you do not get into this college

Interview Question – 
How do you handle stress?

Interview Question – 
What did I think my biggest weakness was.

Interview Question – 
How do you stay organized?

Interview Question – 
How would you approach residents as a friend but as an RA at the same time.

Interview Question – 
Why you didn't score A's on all classes?

Interview Question – 
Who would you hang out with that is from NYC? What would you do ?

Most Common Mistakes in Interview | Reason for not being selected in interview

Top 10 job interview mistakes: (Before attend interview must think about following) following reason could be the reason for not being selected.
Following things could create problem in your career path.

1. Not dressing appropriately.

2. Not knowing the interviewer's name.

3. Not turning off your phone.

4. Not bringing extra copies of your resume.

5. Not bringing a list of references.

6. Not making eye contact with the interviewer.

7. Criticizing your prior bosses and companies.

8. Not remembering your work history.

9. Asking about salary.

10. Not sending a thank you note after the interviewer.

Research Assistant Interview Questions Answers

Research Assistant Interview Questions Answers

Here I come with most frequently asked interview questions related to Research Assistant

1. Tell me about yourself?

2. What are your biggest strengths?

3. Why did you leave your last job?

4. What are your career goals?

5. Why do you want to work here?

6. Let me know about how exactly you labored effectively pressurized.

7. How would your co-workers describe you?

8. What interested you within our company?

9. Why did you leave your last job?

10. What are your career goals for Research assistant?

Best of luck....

Rick Anderson's : ASP.NET MVC 4 EBOOK PDF FREE DOWNLOAD


MICROSOFT PROVIDING FREE BOOK FOR MVC LERNER/DEVELOPERS : ENJOY LEARNING 

Title            : Intro to ASP.NET MVC 4 with Visual Studio, Step-by-Step
Author(s)     : Rick Anderson and Scott Hanselman.
Publisher     : Microsoft Press (May 2012)
Paperback   : N/A
eBook         : Multiple Formats: PDF (118 pqges, 4.04 MB), ePub, Mobi, and HTML
Language    : English

CLICK HERE for download this book
Rick Anderson – Rick Anderson works as a programmer writer for Microsoft, focusing on ASP.NET MVC, Windows Azure and Entity Framework. You can follow him on twitter via @RickAndMSFT.

WALK-IN INTERVIEW IN NYC | LEBANESE RESTAURANT JOBS

Mama Ghanoush is now hiring following positions:

-LINE COOK/PREP COOK
-SERVERS & FOOD RUNNERS
-BUS PERSONNEL
-HOSTESS
-DISHWASHERS
-DELIVERY PERSONNEL

WALK-IN INTERVIEWS WILL BE HELD ON THE FOLLOWING DAYS:

SATURDAY 2014 APRIL 5TH FROM 10-6PM
&
SUNDAY 2014 APRIL 6TH FROM 10-6PM

442 Third Avenue between 30th & 31st Street, NEW YORK, NY 10016
Email resumes to mlgtgrill@gmail.com or bring with you on day of interview.
www.mamaghanoush.com 

Notice Walk in Interview - Maharshi Dayanand University Rohtak

One guest faculty is required in the Centre for Bioinformatics on lecture basis payment with specialization in System Biology or Genomics. The candidate should be eligible as per UGC norms. The candidate should be either M.Sc in concerned subject or in the area of specialization. The interested candidate may appear for interview along with their Bio-data on 05/03/2014 at 11:00 AM in the office of the undersigned. No TA/DA will be paid for interview. The post is up to 30/4/2014 or dispersal of classes whichever is earlier.

C.C to
1. Notice Board, CMBT
2. A.R (Estt.) Teaching
3. Librarian for the display on notice board of library
4. Director, Computer Centre for uploading on the website (Soft copy enclosed)

Thursday, 3 April 2014

DIFFERENCE BETWEEN STORED PROCEDURE AND FUNCTION IN SQL WITH EXAMPLE


DIFFERENCE BETWEEN STORED PROCEDURE AND FUNCTION IN SQL WITH EXAMPLE

PROCEDUREFUNCTION
Procedure can have both input\output parameters.
But function can have only input parameter.
Inside procedure we can use DML (INSERT/UPDATE/DELETE) statements.
But Inside function we can’t use DML statements.
We can’t utilize stored procedure in Select Statement.
But we can use function in Select Statement.
We can use Try-Catch Block in Stored Procedure.
But Inside function we can’t use Try-Catch block.
Procedure can’t be call inside a function.But we can call function inside a Procedure.
Procedure can return 0 or n values (max 1024).But function can return only 1 value which is mandatory.
We can go for transaction management in procedure.But we can't go in function.
Stored Procedures cannot be used in the
SQL statements anywhere in the WHERE/HAVING/SELECT section.
But we can use Function anywhere.
We can’t join Stored Procedure.But We can join functions.

Wednesday, 2 April 2014

Bank PO Interview Questions with Answers PDF

Do you want to download free bank po interview questions with answers pdf ? Then this post for you be happy here we will providing full pdf of bank po interview questions with answer without any money for get this pdf you need to comment on this post and tell your email id we will send this pdf by email. 
After getting pdf please recomment to point your feedback about this book. And please shere this post among your friends. Thanks

Tuesday, 1 April 2014

BIG DATA/HADOOP INTERVIEW QUESTIONS AND ANSWERS FOR EXPERIENCED : DBA

Big Data & Hadoop Interview Questions and Answers for Experienced developer and DBA
Hey here I come with Big data and Hadoop Interview questions with answers for experienced Database developers and fresher Big data and Hadoop developers. Here are most impotent Hadoop and Big data interview questions with Answers soon you will get these in pdf format. 

What is Big Data ? 
Big data is data that exceeds the processing capacity of traditional database systems. The data is too big, moves too fast, or doesn’t fit the strictures of your database architectures. To gain value from this data, you must choose an alternative way to process it. 

Name any org. who is generating Big Data ? 
Facebook,Google What is NoSQL? NoSQL is a whole new way of thinking about a database. NoSQL is not a relational database. The reality is that a relational database model may not be the best solution for all situations. The easiest way to think of NoSQL, is that of a database which does not adhering to the traditional relational database management system (RDMS) structure. Sometimes you will also see it revered to as 'not only SQL'. 

We have already SQL then Why NoSQL? 
 NoSQL is high performance with high availability, and offers rich query language and easy scalability. NoSQL is gaining momentum, and is supported by Hadoop, MongoDB and others. The NoSQL Database site is a good reference for someone looking for more information. 

What is Hadoop and where did Hadoop come from ? 
By Mike Olson: The underlying technology was invented by Google back in their earlier days so they could usefully index all the rich textural and structural information they were collecting, and then present meaningful and actionable results to users. There was nothing on the market that would let them do that, so they built their own platform. Google’s innovations were incorporated into Nutch, an open source project, and Hadoop was later spun-off from that. Yahoo has played a key role developing Hadoop for enterprise applications. 

What problems can Hadoop solve ? 
By Mike Olson: The Hadoop platform was designed to solve problems where you have a lot of data — perhaps a mixture of complex and structured data — and it doesn’t fit nicely into tables. It’s for situations where you want to run analytics that are deep and computationally extensive, like clustering and targeting. That’s exactly what Google was doing when it was indexing the web and examining user behavior to improve performance algorithms. 

What is the Difference between Hadoop and Apache Hadoop ? 
There is no diff, Hadoop, formally called Apache Hadoop, is an Apache Software Foundation project. 

What is the difference between SQL and NoSQL? Is NoSQL follow relational DB model ? 
No 

Why would NoSQL be better than using a SQL Database ? 
And how much better is it? It would be better when your site needs to scale so massively that the best RDBMS running on the best hardware you can afford and optimized as much as possible simply can't keep up with the load. How much better it is depends on the specific use case (lots of update activity combined with lots of joins is very hard on "traditional" RDBMSs) - could well be a factor of 1000 in extreme cases. 

Name the modes in which Hadoop can run ? 
Hadoop can be run in one of three modes: 
i. Standalone (or local) mode
ii. Pseudo-distributed mode 
iii. Fully distributed mode 

What do you understand by Standalone (or local) mode ? 
There are no daemons running and everything runs in a single JVM. Standalone mode is suitable for running MapReduce programs during development, since it is easy to test and debug them. 

What is Pseudo-distributed mode ? 
The Hadoop daemons run on the local machine, thus simulating a cluster on a small scale. 

What does /var/hadoop/pids do ? 
It stores the PID. 

What is the full form of HDFS ? 
Hadoop Distributed File System 

What is the idea behind HDFS ? 
HDFS is built around the idea that the most efficient approach to storing data for processing is to optimize it for write once, and read many approach. 

Where does HDFS fail ? 
Cannot support large number of small files as the file system metadata increases with every new file, and hence it is not able to scale to billions of files. This file system metadata is loaded into memory and since memory is limited, so is the number of files supported. 

What are the ways of backing up the file-system metadata ? 
There are 2 ways of backing up the filesystem metadata which maps different filenames with their data stored as different blocks on various data nodes: Writing the filesystem metadata persistently onto a local disk as well as on a remote NFS mount. Running a secondary namenode. 

What is Namenode in Hadoop ? 
Namenode is the node which stores the filesystem metadata i.e. which file maps to what block locations and which blocks are stored on which datanode. What is DataNode in Hadoop? Namenode is the node which stores the filesystem metadata i.e. which file maps to what block locations and which blocks are stored on which datanode. 

What is Secondary NameNode ? 
The Secondary NameNode (SNN) is an assistant daemon for monitoring the state of the cluster HDFS, Like the NameNode, Each cluster has one SNN, and it typically resides on its own machine as well. 

What is JobTracker in Hadoop ? 
The JobTracker is the service within Hadoop that farms out MapReduce tasks to specific nodes in the cluster, ideally the nodes that have the data, or at least are in the same rack. 

What are the functions of JobTracker in Hadoop ? 
Once you submit your code to your cluster, the JobTracker determines the execution plan by determining which files to process, assigns nodes to different tasks, and monitors all tasks as they are running. If a task fail, the JobTracker will automatically relaunch the task, possibly on a different node, up to a predefined limit of retries. There is only one JobTracker daemon per Hadoop cluster. It is typically run on a server as a master node of the cluster. 

What is MapReduce in Hadoop ? 
Hadoop MapReduce (Hadoop Map/Reduce) is a software framework for distributed processing of large data sets on compute clusters of commodity hardware. It is a sub-project of the Apache Hadoop project. The framework takes care of scheduling tasks, monitoring them and re-executing any failed tasks. 

What are the Hadoop configuration files ? 
1. hdfs-site.xml 
2. core-site.xml 
3. mapred-site.xml