Saturday, February 16, 2013

RDBMS Concepts & Interview Questions

1. What is a Database?
A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose.

2. What is DBMS?
It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.

3. What is a Database system?
The database and DBMS software together is called as Database system.

4. Advantages of DBMS?
Redundancy is controlled. Unauthorized access is restricted. Providing multiple user interfaces. Enforcing integrity constraints. Providing backup and recovery.

5. Disadvantage in File Processing System?
• Data redundancy & inconsistency.  
• Difficult in accessing data.  
• Data isolation.  
• Data integrity.  
• Concurrent access is not possible.  
• Security Problems.

Top 10 free cool games for Windows 8

The mighty Microsoft proved again why Windows is most used operating system. It has came up with attractive new user interface of tiles and added multiple features in style. Some of them are integration of various online Microsoft services and enhancement of Windows features. One of the interesting feature is integration of Xbox to Windows 8. Users can play Xbox games in their systems by signing in their Microsoft account which can be commonly used for all Microsoft services like Xbox, Bing, Outlook and Skype. Here I will show you some must play HD free games to improve your entertainment level. You can install all this games and more at Windows store.

1. Hangman HD

Classic paper game comes alive with 11 categories to play with. You can choose your skill level and category from Basic English, Advanced English, Animals, Famous People, Movies, World Countries, Body Parts, Foods, Occupations, Video Games and Unbeatable Hangman Words.

2. Archery Master

Archery games which provides you 20 arrows to play. Hitting the center will give you maximum i.e. 50 points and an extra arrow.

3. Jetpack Joyride

Loaded with gadgets and vehicles to play. The aim of the game is to fly maximum distance. Levels will be passed as the challenges are accomplished.

4. Air Hockey

The table game is virtualized well. Provides you option to play with computer and other player which will require a joystick.

5. Dredd v/s Zombies

Judge Dredd is on mission. Help him fight against Zombies. Cool game to play. It gives you customizable guns. Various levels and arenas are provided.

6. Chess 4 All

Give some exercise to your brain muscles. You can play this game online, single player and two player.

7. Microsoft Solitaire Collection

All 5 types i.e. Klondike, Spider, FreeCell, Pyramid and TriPeaks of solitaire card games are grouped together. Loaded with nice themes and daily challenges. Help is provided to let you learn to play these games.

8. Microsoft Pinball Fx

Classic pinball turns 3D and HD. You can unlock new stages by scoring high.

9. Rat on a scooter XL

Simple game to have fun with. The objective is to jump to stay on a bridge and collect as many cheese and coins as you can before falling.

10. Tic Tac Toe

Wintage Tic Tac Toe turns HD. You can play against computer and other player. Logos : How to make an effective logo

--> An effective logo should be:
  • Simple 
  • Memorable 
  • Timeless 
  • Versatile 
  • Appropriate
--> The logo should be small and it is preferable to have a square logo.
--> Generally the 80x80 size is prefered.
--> Logo should be flexible so that you can resize it to another rectangle or wide planes.
--> The colors should be chosen such that it is visible in both light and dark backgrounds.
--> The figures and fonts should be clearly readable.


How to open a blocked website?

The most corrupted Indian government is making people frustrate. They are increasing the panic level of users by controlling Internet. The Internet addicts like me are highly affected and we have reached at peak of our capacity to bear the restriction on Internet which is meant to be open and free to all. Department of Telecommunication (DoT) is adding more sites everyday to block-list and its getting worse for everyone to use it as Internet is a primary requirement now-a-days. In this article I will help you dealing with sites blocked by your ISP so that you can have your right of availability of Internet. Lets get started. If you want to find a solution then you first need to understand the problem deeply. First I will tell you how the sites are blocked and then the solution will be given.

How the sites are blocked by ISP?

The process of blocking content for an ISP (Internet Service Provider) is very simple. After all, any content that is coming from a website to your computer has to travel through the ISP, giving it ample opportunity to observe and censor banned content. Think of it like this—you’re on an island, with no way to reach the mainland (Internet) where all the websites are. The ISP builds a bridge connecting you to the mainland, and charges you to let cars (data) from the sites come to you, by opening the road. Each web page has a unique ID, like a license plate. If the government tells the ISP to block a specific page, it’s added to the blacklist, and isn’t allowed on the bridge. The government could also block a full domain, such as, which would be like blocking all cars with DL plates, instead of specific numbers.

How to visit blocked sites?

Here we go. The solution to the problem is very simple. When you make a request to access a website by opening the URL (web address) in your browser, it tells the server to send that data to you. The data is sent to you by your IP address, which is provided by your ISP and is unique for everyone. So the accessibility of a website depends upon checking your IP whether in your region that site is permitted or not. So if you want to visit a blocked site then all you need to do is change your IP address to that one where that site is allowed. But it is not easy to change your IP as it is dynamically control by your ISP and you can only have variants of same network address which will ultimately represent your region. So does it mean that there is no solution and we can only access banned sites by changing our region? Well No! There is another way. That is called proxy.

What is a proxy server?

During a HTTP connection, the IP address of the client machine is necessarily transmitted in order to get the information back. This allows a server to identify the source of the web request. Any resource you access can gather personal information about you through your unique IP address - your ID in the Internet. They can monitor your reading interests, spy upon you and log your requests for third parties. Also, owners of the Internet resources may impose some restrictions on users from certain countries or geographical regions. An anonymous proxy server acts as a middleman between your browser and an end server. Instead of contacting the end server directly to get a web page, the browser contacts the proxy server, which forwards the request on to the end server. So an anonymous proxy server can protect your identity by stripping a request of all identifying information.

How do I use a proxy server?

There are a many online anonymous free proxy servers available using which you can access a blocked site in your region. Some of my favorites are Hide my ass and Zend 2. You can also google it to discover proxy sites. You can also install some plugins and extensions provided by proxy sites which will help you to have quick access. OK then here I am completing my article, I hope it helped you to increase your knowledge and you found a satisfactory solution. Feel free to share it with your friends and spread the word to help them out! For further queries you may contact me on Facebook, Twitter, Skype, Google+, Yahoo and also Email me. Enjoy!!.. :D

Friday, February 15, 2013

India blocks 78 IIPM URLs

India’s Department of Telecommunications (DoT) yesterday issued instructions to Internet Service Licensees to block access to 78 URLs from India, and what is evident from the list of URLs is that 73 of these are related to the educational institution IIPM (Indian Institute of Planning and Management). The order is signed by Subodh Saxena of the DoT.

First 1-73 of the following blocked URLs are about IIPM and last 5 are about fake high-court sites. The blocked IIPM URLs contains articles about exposing IIPM and sites throwing light on truth of corruption, fraud and scams prevailing by IIPM. Most of them are published by highly prestigious Indian dailies i.e. Indian Express, Times of India, and Economic Times. They have also blocked URLs registering online complaints about IIPM on Consumer Forum. 

Bottom Line:
Another incident of corruption by Indian government employees. 
IIPM must have bribed to block this content to prevent exposure!

List of blocked URLs :-
  33. http://

Love Syndrome



Age of Onset:
Mostly teenage. Recent studies have shown that it may affect people of any age group.

Risk Factors:

The age itself is the major risk factor. Others include…
(a) Co-education
(b) Cell Phones
(c) Movies
(d) Internet
of these the part played by the cell phones is noteworthy.

Multi-organ System Failure.

A) The most common presenting feature is throbbing pain in the heart often described by the patient as sweet pain.
B) Loss of appetite.
C) Sleeplessness.
D) Daydreaming
E) Disinterest in any type of work. There is a danger of patient being transformed into a poet.

A) Very much dilated pupil (In search of his sweet heart).
B) Blushing of cheeks (mainly seen in girls).
C) On Auscultation: The First Heart Sound is heard as LOVE instead of LUB.
D) Smiling to self.

Pathogenesis and Clinical Course:

The Disease is gradual in onset. The patient presents with vague symptoms like loss of appetite, sleeplessness, etc., As time progress multi-organ system involvement occurs with varied symptoms. The symptoms are aggravated at the sight of patients sweetheart The sight of patients love causes the contraction of the radial fibres of the iris muscle leading to the dilation of the pupil. The eyes remain wide open and cease to blink. The Zygomaticus major muscle automatically contracts and the patient smiles (Smile at Sight Phenomenon). As the patient approaches his sweetheart action potentials are generated at an irregular rate in the heart and the normal rhythm of the heart is lost. Microscopic examination of the cardiac muscle reveals the presence of abnormal pacemaker tissue at certain areas called the ROMANTIC SPOTS that are responsible for the lost rhythm of the Heart. The patient feels agitated, and a throbbing pain develops in the heart. The characteristic feature of the pain that patient wants to feel it more and more. In advanced stages, the brain is affected. If not treated properly, the patient may go bad.


Marriage Therapy holds promise of 100% cure rates. If is effective only after 22 years of age. If performed early, it may lead to adverse reactions.

Preventive Measures:

Several attempts have been made to prevent the disease. The WLO (World Love Organization) expert committee has finally declared that the disease is inevitable during the age group and its prevention is literally impossible. Any attempts to interrupt the normal course of the disease may lead to more severe from of disease. So interventional measures are highly contraindicated for this disease.


Complication of love syndrome is euphoria, financial crisis, idiotic look, loss of appetite and sleep. Acute romantic failure lead to suicidal tendency. Survival may have life long immunity.

Petrol price hiked by 1.50 rupees

Indian Oil Corporation (IOC) and BPCL on Friday announced a 45 paisa per litre hike in diesel prices with effect from Friday-Saturday midnight. Along with diesel, IOC will also hike petrol prices by Rs 1.50 per litre.

Crude oil price has increased from $109.08 per barrel to $113.24, while international gasoline or petrol prices have risen from $119.59 a barrel to $128.57. [1 US Dollar equals 53.98 Indian Rupee]

In addition to loss on sale of diesel, state-owned fuel retailers are losing Rs 31.60 per litre on kerosene and Rs 481 per 14.2-kg cylinder of domestic cooking gas (LPG).

The increase announced is excluding local sales tax or VAT and the actual hike for consumers would be more after the incidence of duty is included.

Love is actually a name of care

Its love,
when a little girl puts her energy to give dad a head massage.
Its love,
when a wife makes tea for husband and take a sip
before him.
Its love,
when a mother gives her son the best piece of cake.
Its love,
when your friend holds your hand tightly on a slippery
Its love,
when your brother messages you and asks did you
reach home on time..
Love is not just a guy holding a girl and going around
the city.
Love wen u send a small message to your friends to make them smile

Love is actually a name of"care"...♥

No. 7 v/s No. 10

no. 7 is always The Genius...
but no.10, will always be his Master

Most 300 Scores By A Team In ODI

Most 300 Scores By A Team In ODIs:

1. India (71)
2. Australia (67)
3. Pakistan (54)
4. South Africa (48)
5. Sri Lanka (42)
6. New Zealand (35)
7. England (28)
8. West Indies (28)

Friday, February 1, 2013

Graeme Smith captains his 100th test

February 1, 2013 will be a red letter day in the annals of Test cricket, South African cricket and more importantly in Graeme Smith's Test career. On his 32nd birthday, Smith will lead South Africa out for the 99th time when the first test gets under way at the Wanderers, having also captained a World XI in a test against Australia in 2005.
Matches Win Lose Draw Win %
99 47 26 26 47.47

Valentine Girls : Can I Be Your Valentine

Valentine Girls : Can I Be Your Valentine

Everyday we act as though we are just good friends.
It is though we are seeing through a different lens.
But I wish we could be more.
Because crying makes me feel poor.
Poor of love, as though nobody loves me.
If you look it isn't that hard to see.

Can't we be more than just good friends?
Can't we look through the same lens?
Can you picture us together?
Can I be the certain her?
The her you're always talking about.
The one you say you can't live without.

I know what I ask is a little much.
I just want us to be able to touch.
Hold each other and never let go.
But if I ask will the answer be no?
Either way I have to take a chance.
May our hearts have one dance?