30 Basic Easy DBMS aptitude Questions 2019/20

We have added New DBMS Questions so check em out

Here are some great latest 2019 DBMS basic easy questions which will help u greatly in the interviews ahead so boys and girls say thanks to MNCPLACEMENT blog and remember you can get these updates before anyone else.

JUST DROP ur EMAIL ADDRESS IN THE TOP LEFT CORNER for daily updates

Great NEW DBMS QUESTIONS LINK 

2019 DBMS QUESTIONS LINK 1

2019 DBMS QUESTIONS LINK 2

Remember a lotta these questions with detailed explanation can be found At this Website


READ ANSWER and EXPLANATION

Microsoft Interview Questions for 2020

Microsoft Interview Questions for 2020 preparation

The questions tend to follow some basic themes:


Riddles
Algorithms
Applications

Thinkers


Riddles
Why is a manhole cover round?
How many cars are there in the USA? (A popular variant is "How many gas stations are there in the USA?")
How many manhole covers are there in the USA?
You've got someone working for you for seven days & a gold bar to pay them. The gold bar is segmented into seven connected pieces. You must give them a piece of gold at the end of every day. If you are only allowed to make two breaks in the gold bar, how do you pay your worker? One train leaves Los Angeles at 15mph heading for New York. Another train leaves from New York at 20mph heading for

Los Angeles on the same track. If a bird, flying at 25mph, leaves from Los Angeles at the same time as the train & flies back & forth between the two trains until they collide, how far will the bird have traveled?


Suppose a disk spinning like a record player turn table. Half of the disk is black & the other is white. Assume you have an unlimited number of color sensors. How many sensors would you have to place around the disk to determine the direction the disk is spinning? Where would they be placed?
Suppose an analog clock set to 12 o'clock. Note that the hour & minute hands overlap. How many times each day do both the hour & minute hands overlap? How would you determine the exact times of the day that this occurs?

You have two jars, 50 red marbles & 50 blue marbles. A jar will be picked at random, & then a marble will be picked from the jar. Placing all of the marbles in the jars, how can you maximize the chances of a red marble being picked? What are the exact odds of getting a red marble using your scheme?
Pairs of primes separated by a single number are called prime pairs.
Examples are 17 & 19.

Prove that the number between a prime pair is always divisible by 6 (assuming both numbers in the pair are greater than 6). Now prove that there are no 'prime triples.'

There is a room with a door (closed) & three light bulbs. Outside the room there are three switches, connected to the bulbs. You may manipulate the switches as you wish, but once you open the door you can't change them. Identify each switch with its bulb.

Suppose you had 8 billiard balls, & one of them was slightly heavier, but the only way to tell was by putting it on a scale against another. What's the fewest number of times you'd have to use the scale to find the heavier ball?

Suppose you are standing in front of a mirror, facing it. Raise your left hand. Raise your right hand. Look at your reflection. When you raise your left hand your reflection raises what appears to be his right hand. But when you tilt your head up, your reflection does too, & does not appear to tilt his/her head down. Why is it that the mirror appears to reverse left & right, but not up & down?

You have 4 jars of pills. Each pill is a certain weight, except for contaminated pills contained in one jar, where each pill is weight + 1. How could you tell which jar had the contaminated pills in just one measurement?

The SF Chronicle has a word game where all the letters are scrambled up & you have to figure out what the word is. Suppose that a scrambled word is 5 characters long: How many possible solutions are there? What if we know which 5 letters are being used? Develop an algorithm to solve the word.

There are 4 women who want to cross a bridge. They all begin on the same side. You have 17 minutes to get all of them across to the other side. It is night. There is one flashlight. A maximum of two people can cross at one time. Any party who crosses, either 1 or 2 people, must have the flashlight with them. The flashlight must be walked back & forth, it cannot be thrown, etc. Each woman walks at a different speed. A pair must walk together at the rate of the slower woman's pace.
Woman 1: 1 minute to cross
Woman 2: 2 minutes to cross
Woman 3: 5 minutes to cross
Woman 4: 10 minutes to cross
For example if Woman 1 & Woman 4 walk across first, 10 minutes have elapsed when they get to the other side of the bridge. If Woman 4 then returns with the flashlight, a total of 20 minutes have passed & you have failed the mission. What is the order required to get all women across in 17 minutes? Now, what's the other way?

If you had an infinite supply of water & a 5 quart & 3 quart pail, how would you measure exactly 4 quarts?

You have a bucket of jelly beans. Some are red, some are blue, & some green. With your eyes closed, pick out 2 of a like color. How many do you have to grab to be sure you have 2 of the same?

If you have two buckets, one with red paint & the other with blue paint, & you take one cup from the blue bucket & poor it into the red bucket. Then you take one cup from the red bucket & poor it into the blue bucket. Which bucket has the highest ratio between red & blue? Prove it mathematically.


READ ANSWER and EXPLANATION

2008 solved Tests for microsoft interview(bangalore)

Test Pattern for microsoft interview



· Puzzles, Riddles, etc. <http://localhost/papers/microsoft1.htm>

·
Programming Questions <http://localhost/papers/microsoft2.htm>

·
Computer Networks, Databases, etc. <http://localhost/papers/microsoft3.htm>

·
Computer Architecture <http://localhost/papers/microsoft4.htm>

Puzzles, Riddles & Others



0. Classic: If a bear walks one mile south, turns left & walks one mile to the east & then turns left again & walks one mile north & arrives at its original position, what is the color of the bear.

ANS. The color of the bear is trivial. The possible solutions to it are interesting. In addition to the trivial north pole, there are additional circles near south pole. Think it out.

* 1. Given a rectangular (cuboidal for the puritans) cake with a rectangular piece removed (any size or orientation), how would you cut the remainder of the cake into two equal halves with one straight cut of a knife?

ANS. Join the centers of the original & the removed rectangle. It works for cuboids too! BTW, I have been getting many questions asking why a horizontal slice across the middle will not do. Please note the "any size or orientation" in the question! Don't get boxed in by the way you cut your birthday cake :) Think out of the box.

2. There are 3 baskets. one of them have apples, one has oranges only & the other has mixture of apples & oranges. The labels on their baskets always lie. (i.e. if the label says oranges, you are sure that it doesn't have oranges only,it could be a mixture) The task is to pick one basket & pick only one fruit from it & then correctly label all the three baskets.

HINT. There are only two combinations of distributions in which ALL the baskets have wrong labels. By picking a fruit from the one labeled MIXTURE, it is possible to tell what the other two baskets have.

3. You have 8 balls. One of them is defective & weighs less than others. You have a balance to measure balls against each other. In 2 weighings how do you find the defective one?

4. Why is a manhole cover round?

HINT. The diagonal of a square hole is larger than the side of a cover!

Alternate answers: 1. Round covers can be transported by one person, because they can be rolled on their edge. 2. A round cover doesn't need to be rotated to fit over a hole.

5. How many cars are there in the USA?

6. You've got someone working for you for seven days & a gold bar to pay them. The gold bar is segmented into seven connected pieces. You must give them a piece of gold at the end of every day. If you are only allowed to make two breaks in the gold bar, how do you pay your worker?

7. One train leaves Los Angeles at 15mph heading for New York. Another train leaves from New York at 20mph heading for Los Angeles on the same track. If a bird, flying at 25mph, leaves from Los Angeles at the same time as the train & flies back & forth between the two trains until they collide, how far will the bird have traveled?

HINT. Think relative speed of the trains.

8. You have two jars, 50 red marbles & 50 blue marbles. A jar will be picked at random, & then a marble will be picked from the jar. Placing all of the marbles in the jars, how can you maximize the chances of a red marble being picked? What are the exact odds of getting a red marble using your scheme?

9. Imagine you are standing in front of a mirror, facing it. Raise your left hand. Raise your right hand. Look at your reflection. When you raise your left hand your reflection raises what appears to be his right hand. But when you tilt your head up, your reflection does too, & does not appear to tilt his/her head down. Why is it that the mirror appears to reverse left & right, but not up & down?

10. You have 5 jars of pills. Each pill weighs 10 gram, except for contaminated pills contained in one jar, where each pill weighs 9 gm. Given a scale, how could you tell which jar had the contaminated pills in just one measurement?

ANS. 1. Mark the jars with numbers 1, 2, 3, 4, & 5.

2. Take 1 pill from jar 1, take 2 pills from jar 2, take 3 pills from jar 3, take 4 pills from jar 4 & take 5 pills from jar 5.

3. Put all of them on the scale at once & take the measurement.

4. Now, subtract the measurement from 150 ( 1*10 + 2*10 + 3*10 + 4*10 + 5*10)

5. The result will give you the jar number which has contaminated pill.

11. If you had an infinite supply of water & a 5 quart & 3 quart pail, how would you measure exactly 4 quarts?

12. You have a bucket of jelly beans. Some are red, some are blue, & some green. With your eyes closed, pick out 2 of a like color. How many do you have to grab to be sure you have 2 of the same?

13. Which way should the key turn in a car door to unlock it?

14. If you could remove any of the 50 states, which state would it be & why?

15. There are four dogs/ants/people at four corners of a square of unit distance. At the same instant all of them start running with unit speed towards the person on their clockwise direction & will always run towards that target. How long does it take for them to meet & where?

HINT. They will meet in the center & the distance covered by them is independent of the path they actually take (a spiral).

16. (from Tara Hovel) A helicopter drops two trains, each on a parachute, onto a straight infinite railway line. There is an undefined distance between the two trains. Each faces the same direction, & upon landing, the parachute attached to each train falls to the ground next to the train & detaches. Each train has a microchip that controls its motion. The chips are identical. There is no way for the trains to know where they are. You need to write the code in the chip to make the trains bump into each other. Each line of code takes a single clock cycle to execute.

You can use the following commands (& only these);

MF - moves the train forward

MB - moves the train backward

IF (P) - conditional that's satisfied if the train is next to a parachute. There is no "then" to this IF statement.

GOTO

ANS.

A: MF

IF (P)

GOTO B

GOTO A

-----

B: MF

GOTO B

Explanation: The first line simply gets them off the parachutes. You need to get the trains off their parachutes so the back train can find the front train's parachute, creating a special condition that will allow it to break out of the code they both have to follow initially. They both loop through A: until the back train finds the front train's parachute, at which point it goes to B: & gets stuck in that loop. The front train still hasn't found a parachute, so it keeps in the A loop. Because each line of code takes a "clock cycle" to execute, it takes longer to execute the A loop than the B loop, therefore the back train (running in the B loop) will catch up to the front train.

Personality

It is best to read some website or a book for questions like these.

1. Tell me the courses you liked & why did you like them.

2. Give an instance in your life in which you were faced with a problem & you tackled it successfully.

3. What is your ideal working environment.

4. Why do you think you are smart.

5. Questions on the projects listed on the Resume.

6. Do you want to know any thing about the company.( Try to ask some relevant & interesting question).

7. How long do you want to stay in USA & why (I guess non-citizens get this)?

8. What is your geographical preference?

9. What are your expectations from the job.


READ ANSWER and EXPLANATION

2007 COMPLETE Test paper for Microsoft(all repeated questions diff papers)

Updated for 2026
The current version of this guide — verified for 2026 placement season — is on PapersAdda. Read the latest →
Test paper for Microsoft

0. Classic: If a bear walks one mile south, turns left & walks one mile to the east & then turns left again & walks one mile north & arrives at its original position, what is the color of the bear.

Answer. The color of the bear is trivial. The possible solutions to it are interesting. In addition to the trivial north pole, there are additional circles near south pole. Think it out.

* 1. Given a rectangular (cuboidal for the puritans) cake with a rectangular piece removed (any size or orientation), how would you cut the remainder of the cake into two equal halves with one straight cut of a knife?

Answer. Join the centers of the original & the removed rectangle. It works for cuboids too! BTW, I have been getting many questions asking why a horizontal slice across the middle will not do. Please note the "any size or orientation" in the question! Don't get boxed in by the way you cut your birthday cake :) Think out of the box.

2. There are 3 baskets. one of them have apples, one has oranges only & the other has mixture of apples & oranges. The labels on their baskets always lie. (i.e. if the label says oranges, you are sure that it doesn't have oranges only,it could be a mixture) The task is to pick one basket & pick only one fruit from it & then correctly label all the three baskets.

HINT. There are only two combinations of distributions in which ALL the baskets have wrong labels. By picking a fruit from the one labeled MIXTURE, it is possible to tell what the other two baskets have.

3. You have 8 balls. One of them is defective & weighs less than others. You have a balance to measure balls against each other. In 2 weighings how do you find the defective one?

4. Why is a manhole cover round?

HINT. The diagonal of a square hole is larger than the side of a cover!

Alternate answers: 1. Round covers can be transported by one person, because they can be rolled on their edge. 2. A round cover doesn't need to be rotated to fit over a hole.

5. How many cars are there in the USA?

6. You've got someone working for you for seven days & a gold bar to pay them. The gold bar is segmented into seven connected pieces. You must give them a piece of gold at the end of every day. If you are only allowed to make two breaks in the gold bar, how do you pay your worker?

7. One train leaves Los Angeles at 15mph heading for New York. Another train leaves from New York at 20mph heading for Los Angeles on the same track. If a bird, flying at 25mph, leaves from Los Angeles at the same time as the train & flies back & forth between the two trains until they collide, how far will the bird have traveled?

HINT. Think relative speed of the trains.

8. You have two jars, 50 red marbles & 50 blue marbles. A jar will be picked at random, & then a marble will be picked from the jar. Placing all of the marbles in the jars, how can you maximize the chances of a red marble being picked? What are the exact odds of getting a red marble using your scheme?

9. Imagine you are standing in front of a mirror, facing it. Raise your left hand. Raise your right hand. Look at your reflection. When you raise your left hand your reflection raises what appears to be his right hand. But when you tilt your head up, your reflection does too, & does not appear to tilt his/her head down. Why is it that the mirror appears to reverse left & right, but not up & down?

10. You have 5 jars of pills. Each pill weighs 10 gram, except for contaminated pills contained in one jar, where each pill weighs 9 gm. Given a scale, how could you tell which jar had the contaminated pills in just one measurement?

Answer. 1. Mark the jars with numbers 1, 2, 3, 4, & 5.

2. Take 1 pill from jar 1, take 2 pills from jar 2, take 3 pills from jar 3, take 4 pills from jar 4 & take 5 pills from jar 5.

3. Put all of them on the scale at once & take the measurement.

4. Now, subtract the measurement from 150 ( 1*10 + 2*10 + 3*10 + 4*10 + 5*10)

5. The result will give you the jar number which has contaminated pill.

11. If you had an infinite supply of water & a 5 quart & 3 quart pail, how would you measure exactly 4 quarts?

12. You have a bucket of jelly beans. Some are red, some are blue, & some green. With your eyes closed, pick out 2 of a like color. How many do you have to grab to be sure you have 2 of the same?

13. Which way should the key turn in a car door to unlock it?

14. If you could remove any of the 50 states, which state would it be & why?

15. There are four dogs/ants/people at four corners of a square of unit distance. At the same instant all of them start running with unit speed towards the person on their clockwise direction & will always run towards that target. How long does it take for them to meet & where?

HINT. They will meet in the center & the distance covered by them is independent of the path they actually take (a spiral).

16. (from Tara Hovel) A helicopter drops two trains, each on a parachute, onto a straight infinite railway line. There is an undefined distance between the two trains. Each faces the same direction, & upon landing, the parachute attached to each train falls to the ground next to the train & detaches. Each train has a microchip that controls its motion. The chips are identical. There is no way for the trains to know where they are. You need to write the code in the chip to make the trains bump into each other. Each line of code takes a single clock cycle to execute.

You can use the following commands (& only these);

MF - moves the train forward

MB - moves the train backward

IF (P) - conditional that's satisfied if the train is next to a parachute. There is no "then" to this IF statement.

GOTO

Answer.

A: MF

IF (P)

GOTO B

GOTO A

-----

B: MF

GOTO B

Explanation: The first line simply gets them off the parachutes. You need to get the trains off their parachutes so the back train can find the front train's parachute, creating a special condition that will allow it to break out of the code they both have to follow initially. They both loop through A: until the back train finds the front train's parachute, at which point it goes to B: & gets stuck in that loop. The front train still hasn't found a parachute, so it keeps in the A loop. Because each line of code takes a "clock cycle" to execute, it takes longer to execute the A loop than the B loop, therefore the back train (running in the B loop) will catch up to the front train.

Personality

It is best to read some website or a book for questions like these.

1. Tell me the courses you liked & why did you like them.

2. Give an instance in your life in which you were faced with a problem & you tackled it successfully.

3. What is your ideal working environment.

4. Why do you think you are smart.

5. Questions on the projects listed on the Resume.

6. Do you want to know any thing about the company.( Try to ask some relevant & interesting question).

7. How long do you want to stay in USA & why (I guess non-citizens get this)?

8. What is your geographical preference?

9. What are your expectations from the job.

Gudluck for ur employment and optimization of ur Career

Note: This article is from the original mncplacement archive (2008+). For the 2026-current version with verified offers, salary data, and exam patterns, visit the updated guide on PapersAdda.


READ ANSWER and EXPLANATION

2008 Exclusive Technical test for Microsoft Interview

Technical test for Microsoft

Networks & Security

1. How do you use RSA for both authentication & secrecy?

2. What is ARP & how does it work?

3. What's the difference between a switch & a router?

4. Name some routing protocols? (RIP,OSPF etc..)

5. How do you do authentication with message digest(MD5)? (Usually MD is used for finding tampering of data)

6. How do you implement a packet filter that distinguishes following cases & selects first case & rejects second case.

i) A host inside the corporate n/w makes a ftp request to outside host & the outside host sends reply.

ii) A host outside the network sends a ftp request to host inside. for the packet filter in both cases the source & destination fields will look the same.

7. How does traceroute work? Now how does traceroute make sure that the packet follows the same path that a previous (with ttl - 1) probe packet went in?

8. Explain Kerberos Protocol ?

9. What are digital signatures & smart cards?

10. Difference between discretionary access control & mandatory access control?



Java

1. How do you find the size of a java object (not the primitive type) ?

ANS. type cast it to string & find its s.length()

2. Why is multiple inheritance not provided in Java?

3. Thread t = new Thread(); t.start(); t = null; now what will happen to the created thread?

4. How is garbage collection done in java?

5. How do you write a "ping" routine in java?

6. What are the security restrictions on applets?

Graphics

1. Write a function to check if two rectangles defined as below overlap or not. struct rect { int top, bot, left, right; } r1, r2;

2. Write a SetPixel(x, y) function, given a pointer to the bitmap. Each pixel is represented by 1 bit. There are 640 pixels per row. In each byte, while the bits are numbered right to left, pixels are numbered left to right. Avoid multiplications & divisions to improve performance.



Databases

* 1. You, a designer want to measure disk traffic i.e. get a histogram showing the relative frequency of I/O/second for each disk block. The buffer pool has b buffers & uses LRU replacement policy. The disk block size & buffer pool block sizes are the same. You are given a routine int lru_block_in_position (int i) which returns the block_id of the block in the i-th position in the list of blocks managed by LRU. Assume position 0 is the hottest. You can repeatedly call this routine. How would you get the histogram you desire?

Hints & Answers

1. Simply do histogram [lru_block_in_position (b-1)] ++ at frequent intervals... The sampling frequency should be close to the disk I/O rate. It can be adjusted by remembering the last block seen in position b. If same, decrease frequency; if different, increase, with exponential decay etc. & of course, take care of overflows in the histogram.

Gudluck for ur employment & optimization of ur Career


READ ANSWER and EXPLANATION

2008 Aptitude test for Microsoft Interview (omg must read)

Aptitude test for Microsoft(2008 LATEST!!!!!!!!)

Computer Architecture

1. Explain what is DMA?

2. What is pipelining?

3. What are superscalar machines and vliw machines?

4. What is cache?

5. What is cache coherency and how is it eliminated?

6. What is write back and write through caches?

7. What are different pipelining hazards and how are they eliminated.

8. What are different stages of a pipe?

9. Explain more about branch prediction in controlling the control hazards

10. Give examples of data hazards with pseudo codes.

11. How do you calculate the number of sets given its way and size in a cache?

12. How is a block found in a cache?

13. Scoreboard analysis.

14. What is miss penalty and give your own ideas to eliminate it.

15. How do you improve the cache performance.

16. Different addressing modes.

17. Computer arithmetic with two's complements.

18. About hardware and software interrupts.

19. What is bus contention and how do you eliminate it.

20. What is aliasing?

21) What is the difference between a latch and a flip flop?

22) What is the race around condition? How can it be overcome?

23) What is the purpose of cache? How is it used?

24) What are the types of memory management?

Gudluck for ur employment and optimization of ur Career


READ ANSWER and EXPLANATION
Take Advantage Of 25 of the finest Articles to help u prepare for the Placement Papers and Interview questions
You’d Never Guess How easy it is to get a job after reading these placement preparation articles

Here are 25 Placement Preparation Articles


"IMPORTANT NOTE"
We Update our site frequently and we want to keep you guys informed so enter your email in the top left hand box and click subscribe,so that whenever we post new papers it gets delivered right to your mail.



 

© New Placement papers | Latest Placement Papers