Premski.com - Questions tagged "mysql"

Puzzle Corner

Home

Blog

Add Question

coding (266)

algorithms (151)

puzzle (134)

CS Fundamentals (83)

arrays (45)

internet (40)

string (34)

databases (28)

system (26)

probability (26)

networking (25)

linkedlist (24)

binarytrees (24)

bit manipulation (19)

sorting (11)

next in series (7)

traversal (6)

debugging (4)

lateral thinking (4)

palindrome (4)

general (4)

duplication (3)

threading (3)

fibonacci (3)

encryption (3)

design patterns (2)

Random

Find duplicates in array with a twist			[2007-02-26 23:42:19]
You are given an array on N elements. A number in the array can atmost appear 10 times. Find all elements in the array which appears more than 10 times in the array.
link	Author:prem	Tags: arrays	2 Comments	Answer

Medical problem			[2007-02-26 23:42:19]
You are on a strict medical regimen that requires you to take two types of pills each day. You must take exactly one A pill and exactly one B pill at the same time. The pills are very expensive, and you don't want to waste any. So you open the bottle of A pills, and tap one out into your hand. Then you open the bottle of B pills and do the same thing -- but you make a mistake, and two B pills come out into your hand with the A pill. But the pills are all exactly identical. There is no way to tell A pills apart from B pills. How can you satisfy your regimen and take exactly one of each pill at the same time, without wasting any pills?
link	Author:prem	Tags: puzzle		Answer

Advantages of InnoDB over MyISAM?			[2007-02-26 23:42:21]
Explain advantages of InnoDB over MyISAM?
link	Author:prem	Tags: databases \| mysql		Answer

DB questions			[2007-09-03 23:08:45]
3 DB questions What id the difference between clustered and non clustered index? What is the difference between \'having\' and \'where\' What is query optimization??
link	Author:prem	Tags: coding \| CS Fundamentals \| databases \| mysql \| sql		Answer

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?			[2007-02-26 23:42:22]
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
link	Author:prem	Tags: mysql		Answer

Created by Premchand Jayamohan