Explore topic-wise InterviewSolutions in .

People gives food to cow, dog, fish, pigeon etc.

Salt and salt water spraying is in order to get protection from the ants. Nowadays insecticides are used for protection from ants.

The ants release a substance while moving due to which the other ants follow, recognizing their way easily.

In a comer of home, plant pots in the garden, ground hole, in the parks, tree trunks etc.

Dogs always bark at strangers is True.

We can recognize the sound of footsteps of our father and mother.

The trained dogs are used in intensive search operations because dogs have a very strong sense of smell.

When ants bite us, they release a poisonous substance to our body due to which we feel pain.

We can identify by smelling things like hing, camphor, flowers, fruits, food items etc.

Correct answer is a.

(a) Worker ant

(b) Queen ant

We were able to identify by touching such things like flowers, soap, book, sugar, salt, dal, pen and pencil etc.

We were able to identify by tasting items like fruits, vegetables, sugar, salt etc.

We were able to identify things such as fruits and flowers, by smelling.

Soldier ants.

Queen ant, worker ant and soldier ant.

We identify the rotten or spoiled food jy tasting or smelling it.

All animals have their own specific characteristics True.

Noise creates pollution which is very harmful to us.

Noise creates barrier in talking. Due to heavy noise, we may have severe headache and face problems in hearing properly.

We have heard a noise in a marriage party, on the roads, in factories, bus stands as well at in railway stations.

Is near about 1 lac.

In early morning.

As mosquitos maintain hibernation in winter, they are rarely seen in this season.

Noise is very useful for us is True.

Cockroach, butterfly.

Because lizards stay in hibernation during winters

Dogs always bark at stranger and do not allow them to enter in. They have very strong sense of smell.

The eyes of flies are of such type that they can see in all the directions. So, we are unable to catch flies.

Salt and salt water spraying is in order to get protection from the ants.

Loud noise  is very harmful for our ear.

Dog starts barking at a littile sound.

Ants move in a row

In summer season.

The houses of ants look like a colony. The ants always live in groups. They have their own world. There are 3 types of ants – queen, worker and soldier. Ants make their colony under the soil, in tree trunks and secure and safe places in our houses. There are near about 1 lac ants living in a colony. Work done by ants of their work Name on the basis

Only one ant cannot do all type of works alone. So, all ants live together in their colonies.

When a bat flies at night, it produces a sound of very high frequency which reflects back when it hits any object in front of it. Following the echo, a bat can fly very easily in the dark.

An electric current produces a magnetic field around it. This phenomenon is known as the magnetic effect of electric current. It was discovered by Hans Christian Oersted.

It was Ampere who first speculated that all magnetic effects are attributable to electric charges in motion (electric current). It takes a moving electric charge to produce a magnetic field, and it takes another moving electric charge to “feel” a magnetic field.

[Note : Hans Christian Oersted (1777-1851), Danish physicist, discovered electromagnetism in 1820. The oersted, the CGS unit of magnetic field strength, is named after him.]

Advantages of

1. By Pascal’s law, equal braking effort is applied to all the wheels. 

2. It is easily possible to increase or decrease the applied force-during the design stage-by changing the size of piston and cylinder relative to other.

Python has a native library for sqlite.

1. To display the name of all Games with their Geodes in descending order of their schedule date.

import sqlite3

conn = sqlite3.connect(“Games.db”)

cursor = conn.cursor( )

cursor.execute(“Select GameName, Geode from Games

order by ScheduleDate Desc “)

result = cursor,fetchall( )

print(*result, sep = “\n”)

conn.close( )

Output:

(’Table Tennis’ , 108)

(’Table Tennis’ , 103)

(’Carom Board’ , 101)

(’Carom Board’ , 105)

(’Badminton1, 102)

2. To display details of those games which are having

Prize Money more than 7000.

import sqlite3

conn = sqlit3.connect(“Games.db”) 

cursor = conn.cursor( )

cursor.execute(” Select * from Games where prize money > 7000″)

result = cursor.fetchall( )

print(*result, sep = “\n”)

conn.close( )

Output:

(102, ‘Vidhya’ , ‘Badminton’, 2, 12000, ’12-12-2013′)

(103, ‘Guru’ , ’Table Tennis’ , 4, 8000, ’02-14-2014’) 

(105, ‘Keerthana’ , ‘Carom Board’ , 2, 9000, ’01-01-2014′)

(108, ’Krishna’ , ’Table Tennis’ , 4, 25000, ’03-19-2014′)

3. To display the name and gamename of the Players in the ascending order of Gamename.

import sqlite3

conn = sqlite3.connect(“Games.db”)

cursor = conn.cursor( )

cursor.execute(” Select Name, GameName from games

order by GameName “)

result = cursor.fetchall( )

print(*result, sep = “\n”)

conn.close( )

Output:

(‘Vidhya’ , ‘Badminton’)

(‘Padmaja’ , ‘Carom Board’)

(‘Keerthana’ , ‘Carom Board’)

(‘Guru’ , ‘Table Tennis’)

(‘Krishna’ , ‘Table Tennis’)

4. To display sum of PrizeMoney for each of the Numberof participation groupings (as shown in column Number 4)

import sqlite3

conn = sqlite3.connect(“Games.db”)

cursor = conn.cursor( )

cursor.execute(“Select Sum(Number * Prizemoney) from games”)

result = cursor, fetchall( )

print(result)

conn.close( )

Output:

[(184000)]

5. Display all the records based on GameName import sqlite3

conn = sqlite3.connect(“Games.db”)

cursor = conn.cursor( )

cursor.execute(“Select * from games group by gamename”)

result = cursor. fetchall( )

print(*result, sep = “\n”)

conn.close( )

Output:

(‘Carom Board’ , 101, ‘Padmaja’ , 2, 5000, ’01-23-2014′)

(’Carom Board’ , 105, ‘Keerthana’ , 2, 9000, ’01-01-2014′)

(‘Badminton’, 102, ‘Vidhya’ , 2, 12000, ’12-12-2013′)

(‘Table Tennis’ , 103, ‘Guru’ , 4, 8000, ’02-14-2014′) 

(’Table Tennis’ , 108, ‘Krishna’ , 4, 25000, ’03-19-2014′)

Displaying all records using fetchall( )

The fetchall( ) method is used to fetch all rows from the database table

result = cursor.fetchall( )

Cursor is a control structure used to traverse and fetch the records of the database

AVG( ) function retrieves the average of a selected column of rows in a table

Answer is (c)  /, \

Aggregate functions are used to do operations from the values of the column and a single value is returned.

1. dialect

2. skipintialspace