Describe a project you've done. (be passionate)

Microsoft Interview Question | Submitted by anonymous on 2009-06-28 00:35:57

Answers:

No Answers yet. Be the first one to submit an answer!

To post an answer to this question, please login or sign up.

Share

Share on Facebook

Bookmark this on Delicious

Reddit This!

Digg This!

Copyright © 2009 HireCube, Inc. All rights reserved. Terms of Use Privacy Policy

(default) 11 queries took 67 ms

Nr Query Error Affected Num. rows Took (ms)

1 DESCRIBE `questions` 12 12 1

2 DESCRIBE `users` 10 10 1

3 DESCRIBE `answers` 9 9 1

4 DESCRIBE `ratings` 8 8 1

5 DESCRIBE `companies` 11 11 1

6 SELECT `Question`.`id`, `Question`.`interview_id`, `Question`.`question`, `Question`.`code`, `Question`.`created`, `Question`.`modified`, `Question`.`user_id`, `Question`.`company_id`, `Question`.`site_name`, `Question`.`url`, `Question`.`company_name`, `Question`.`category`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`firstname`, `User`.`lastname`, `User`.`created`, `User`.`modified`, `User`.`confirmed`, `User`.`confirm_code`, `Company`.`id`, `Company`.`linkedinid`, `Company`.`company_name`, `Company`.`industry`, `Company`.`type`, `Company`.`status`, `Company`.`company_size`, `Company`.`year_founded`, `Company`.`website`, `Company`.`description`, `Company`.`counter` FROM `questions` AS `Question` LEFT JOIN `users` AS `User` ON (`Question`.`user_id` = `User`.`id`) LEFT JOIN `companies` AS `Company` ON (`Question`.`company_id` = `Company`.`id`) WHERE `Question`.`id` = 13 LIMIT 1 1 1 54

7 SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`firstname`, `User`.`lastname`, `User`.`created`, `User`.`modified`, `User`.`confirmed`, `User`.`confirm_code` FROM `users` AS `User` WHERE `User`.`id` = 15 1 1 0

8 SELECT `Question`.`id`, `Question`.`interview_id`, `Question`.`question`, `Question`.`code`, `Question`.`created`, `Question`.`modified`, `Question`.`user_id`, `Question`.`company_id`, `Question`.`site_name`, `Question`.`url`, `Question`.`company_name`, `Question`.`category` FROM `questions` AS `Question` WHERE `Question`.`user_id` = (15) 1796 1796 3

9 SELECT `Answer`.`id`, `Answer`.`question_id`, `Answer`.`answer`, `Answer`.`code`, `Answer`.`sourceurl`, `Answer`.`created`, `Answer`.`modified`, `Answer`.`user_id`, `Answer`.`anonymous` FROM `answers` AS `Answer` WHERE `Answer`.`user_id` = (15) 0 0 0

10 SELECT `Company`.`id`, `Company`.`linkedinid`, `Company`.`company_name`, `Company`.`industry`, `Company`.`type`, `Company`.`status`, `Company`.`company_size`, `Company`.`year_founded`, `Company`.`website`, `Company`.`description`, `Company`.`counter` FROM `companies` AS `Company` WHERE `Company`.`id` = 0 0 0 0

11 SELECT `Answer`.`id`, `Answer`.`question_id`, `Answer`.`answer`, `Answer`.`code`, `Answer`.`sourceurl`, `Answer`.`created`, `Answer`.`modified`, `Answer`.`user_id`, `Answer`.`anonymous` FROM `answers` AS `Answer` WHERE `Answer`.`question_id` = (13) 0 0 5

Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `questions`	12	12	1
2	DESCRIBE `users`	10	10	1
3	DESCRIBE `answers`	9	9	1
4	DESCRIBE `ratings`	8	8	1
5	DESCRIBE `companies`	11	11	1
6	SELECT `Question`.`id`, `Question`.`interview_id`, `Question`.`question`, `Question`.`code`, `Question`.`created`, `Question`.`modified`, `Question`.`user_id`, `Question`.`company_id`, `Question`.`site_name`, `Question`.`url`, `Question`.`company_name`, `Question`.`category`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`firstname`, `User`.`lastname`, `User`.`created`, `User`.`modified`, `User`.`confirmed`, `User`.`confirm_code`, `Company`.`id`, `Company`.`linkedinid`, `Company`.`company_name`, `Company`.`industry`, `Company`.`type`, `Company`.`status`, `Company`.`company_size`, `Company`.`year_founded`, `Company`.`website`, `Company`.`description`, `Company`.`counter` FROM `questions` AS `Question` LEFT JOIN `users` AS `User` ON (`Question`.`user_id` = `User`.`id`) LEFT JOIN `companies` AS `Company` ON (`Question`.`company_id` = `Company`.`id`) WHERE `Question`.`id` = 13 LIMIT 1	1	1	54
7	SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`firstname`, `User`.`lastname`, `User`.`created`, `User`.`modified`, `User`.`confirmed`, `User`.`confirm_code` FROM `users` AS `User` WHERE `User`.`id` = 15	1	1	0
8	SELECT `Question`.`id`, `Question`.`interview_id`, `Question`.`question`, `Question`.`code`, `Question`.`created`, `Question`.`modified`, `Question`.`user_id`, `Question`.`company_id`, `Question`.`site_name`, `Question`.`url`, `Question`.`company_name`, `Question`.`category` FROM `questions` AS `Question` WHERE `Question`.`user_id` = (15)	1796	1796	3
9	SELECT `Answer`.`id`, `Answer`.`question_id`, `Answer`.`answer`, `Answer`.`code`, `Answer`.`sourceurl`, `Answer`.`created`, `Answer`.`modified`, `Answer`.`user_id`, `Answer`.`anonymous` FROM `answers` AS `Answer` WHERE `Answer`.`user_id` = (15)	0	0	0
10	SELECT `Company`.`id`, `Company`.`linkedinid`, `Company`.`company_name`, `Company`.`industry`, `Company`.`type`, `Company`.`status`, `Company`.`company_size`, `Company`.`year_founded`, `Company`.`website`, `Company`.`description`, `Company`.`counter` FROM `companies` AS `Company` WHERE `Company`.`id` = 0	0	0	0
11	SELECT `Answer`.`id`, `Answer`.`question_id`, `Answer`.`answer`, `Answer`.`code`, `Answer`.`sourceurl`, `Answer`.`created`, `Answer`.`modified`, `Answer`.`user_id`, `Answer`.`anonymous` FROM `answers` AS `Answer` WHERE `Answer`.`question_id` = (13)	0	0	5