The _________ database stores basic configuration information for the server
1. Master
2.Msdb
3.Tempdb
4.Model
Which of the following is not a system database?
1.Northwind
2.Master
3.Tempdb
4.All of the mentioned
Addition of phosphate and nitrate/fertilizers into water leads to
1.Increased growth of decomposers
2.Reduced of algae growth
3.Increased growth of algae
4.Nutrient enrichment.
Air pollution is not caused by
1.Pollen grains
2.Hydroelectric power
3.Industries
4.Automobiles.
As it passes into food chain the concentration of DDT
1.Remains same
2.decreases
3.increases
4.unpredictable.
Atmosphere of metropolitan cities is mostly polluted by
1.Automobile exhausts
2.Pesticide residue
3.Household waste
4.Radio-active fall out.
BOD refers to
1.Biological oxygen deficit
2.Total oxygen demand of biosphere
3.Biological oxygen demand of polluted water
4.None of the above.
Burning of fossil fuels is the main source of which of the following pollutant?.
1.Nitrogen oxide
2.Nitric oxide
3.Nitrous oxide
4.Sulphur dioxide
Carbon dioxide content in atmosphere is
1.0.00%
2.0.03%
3.0.34%
4.3.4%.
Carbon monoxide emitted by automobiles prevents transport of oxygen in body due to
1.its combination with oxygen to form carbon dioxide
2.Break down of haemoglobin
3.preventing haemoglobin to form oxyhaemoglobin
4.formation of free radicals in the blood.
Chief source of water and soil pollution is
1.Mining of ores
2.Thermal power plant
3.Agro-industry
4.All of the above.
Cyclone collector is used for minimising
1.Radioactive pollution
2.Air pollution
3.Noise pollution
4.Water pollution.
DDT is.
1.Biodegradable pollutant
2.Nondegradable contaminent
3.Air pollutant
4.An antibiotic
Disease caused by eating fish found in water contaminated with industrial waste having mercury is
1.Minamata disease
2.Brights disease
3.Hashimotos disease
4.Osteosclerosis.
Domestic waste mostly constitutes
1.Non-biosegradable pollution
2.Biodegradable pollution
3.Effluents
4.Air pollution
Drained sewage has B.O.D.
1.More than that of water
2.Less than that of water
3.Equal to that of water
4.None of the above.
Environmental pollution affects
1.Biotic components
2.Plants only
3.Humans only
4.Both biotic and abiotic components of environmint.
Environmental pollution refers to
1.peeling of top soil
2.dissipation of energy
3.release of toxic/undesirable materials in environment
4.None of the above.
Fish die in water bodies polluted by sewage due to
1.Pathogens
2.Clogging of gills by silt
3.Reduction in dissolved oxygen
4.Foul smell.
From among the followings the major cause of pollution of air big cities?
1.Fossil fuel
2.Acid rain
3.Heat dispersion
4.Sewage waste.
Green chemistry refers to
1.Chemistry of plants
2.Chemistry of green pigments
3.Development of chemical products and processes less harmful to humans
4.Chemistry of geen house effect.
How many types of system databases are present in SQL Server 2008?
1.3
2.4
3.5
4.6
Measurement of rate of oxygen utilisation by the unit volume of polluted water over a period of time is referred to as.
1.Fermentation
2.Chemical oxygen demand
3.Oxidation potential
4.Biological oxygen demond
Minamata disease is because of pollution of
1.Organic waste going into drinking water
2.Oil spill in water
3.Industrial waste containing mercury into fishing water
4.Arsenic goning into the atmosphere.
Most hazardous metal pollutant of automobile exhaust is
1.Mercur
2.Tin
3.Cadmium
4.Lead.
Ozone depletion in stratosphere will result in
1.Forest fires
2.Increased incidence of skin cancer
3.Global warming
4.None of the above.
Ozone hole is maximum spread over
1.Europe
2.Antarctica
3.India
4.Africa
Ozone layer of stratosphere requires protection from indiscriminate use of
1.Fungicides insecticides bactericides and medicines
2.Aerosols and high flying jets
3.Atomic explosions and industrial wastes
4.Weather balloons.
Phosphate pollution is caused by
1.Weathering of phosphate roks only
2.Carbon dioxide dissolved in water
3.Phosphate rocks and sewage
4.Sewage and agricultural fertilizers.
Photochemical smog consists of excessive amount of X in addition to aldehydes ketones PAN etc. X is
1.Methane
2.Carbon monoxide
3.Carbondioxide
4.Ozone.
Photochemical smog is generally formed
1.in early hours of winters
2.around mid day in summer months
3.When intensity of solar radiations is very low
4.When concentration of particulate matter is very low.
Photochemical smog is related to pollution if
1.Air
2.Water
3.Soil
4.All of the above.
Point out the correct statement.
1.By default, tempdb auto grows as needed while SQL Server is running
2. By default, master auto grows as needed while SQL Server is running c) By default, pubs auto grows as needed while SQL Server is running d) By default, msdb auto grows as needed while SQL Server is r
3.By default, pubs auto grows as needed while SQL Server is running
4.By default, msdb auto grows as needed while SQL Server is running
Point out the correct statement.
1. By default, tempdb auto grows as needed while SQL Server is running
2.By default, master auto grows as needed while SQL Server is running
3.By default, pubs auto grows as needed while SQL Server is running
4.By default, msdb auto grows as needed while SQL Server is running
Sewage water is purified by
1.Microorganisms
2.Light
3.Fish
4.Aquatic plants.
The agricultural field that produces maximum methane gas intoatmosphere is
1.Wheat field
2.Paddy field
3.Cotton field
4.Groundnut field.
The approximate loaded Q due to dielectric loss for a dielectric resonator given the loss tangent is 0.0001 is:
1.1000
2.500
3.2000
4.10000
The chemical species released by chloroflurocarbons which are harmful to ozone is
1.Fluorine atoms
2.Chlorine free radicals
3.Nitrogen dioxide molecules
4.Chlorine molecules.
The gas responsible for causing Bhopal tragedy was
1.Methyl isocyanate
2.Potassium isothiocyanate
3.Sodium isothiocyante
4.Ethyl isothiocyante.
The pollutants released by jet aeroplanes inthe atomsphere as fluorocarbons are called
1.Phtochemical oxidants
2.Photochemical reductants
3.Aerosols
4.Physical pollutants.
The presence of which of the following in drinking water is responsible for mottling of teeth
1.Mercury
2.Iodine
3.Chlorine
4.Fluorine.
The region of atmosphere that extends from 50 km 85 km in altitude is called
1.Troposphere
2.Mesosphere
3.Stratosphere
4.Biosphere.
U.V. radiation from the sun causes a reaction in the atmosphere that leads to production of
1.Fluorides
2.Carbon monoxide
3.Sulphur dioxide
4.Ozone.
Ultra-violet radiation causes
1.Fomation of pyrimidines
2.Sticky metaphases
3.Photodynamic action
4.Destruction of hydrogen bonds between complementary DNA strands.
Water is often treated with chlorine to
1.Increase oxygen content
2.Kill germs
3.Cause sedimentation
4.Remove insoluble impurities.
Water pollution is due to
1.Agricultural discharges
2.Sewage and other wastes
3.Industrial effluents
4.All of the above.
Whcih of the following is biodegradable pollutant ?
1.Domestic waste
2.DDT
3.Mercury salts
4.Aluminium foil.
Which is the most important system database?
1.Northwind
2.Master
3.Tempdb
4.Tempdb
Which of the following cause water pollution ?
1.Smoke/fly ash
2.Automobile exhausts
3.Aeroplnes
4.Silt and pesticides.
Which of the following database is used by SQL Server Agent?
1.Pubs
2.Msdb
3.Tempdb
4.Model
Which of the following holds temporary data?
1.Northwind
2.Master
3.Tempdb
4.Msdb
Which of the following is a mode of controlling pollution in big cities?
1.Cleanliness and less use of insecticides
2.Proper disposal of organic wastes sewage and industrial effluents
3.Broder roads and shifting of factories out of the residential areas
4.All the above.
Which of the following is major sink for carbon monoxide ?
1.Water
2.Soil
3.animal respiration
4.Salts dissolved in ocean water
Which of the following play significant role in depletion of ozone layer ?
1.Oxides of nitrogen
2.Oxides of carbon
3.Oxides of sulphur
4.None of the above.
Which of the following pose threat to historical monument Taj ?
1.Floods in Yanuna river
2.Temperature mediated spoilage of marble
3.Air pollutants from Mathura refinery
4.Weathering of marble
Which of the following reacts with haemoglobin of blood and produce toxic effect.
1.Carbon dioxide
2.Carbon monoxide
3.Oxygen
4.Carbon suboxide.
Which of the following system database occupies more space and memory?
1.Master
2.Msdb
3.Tempdb
4.Model
Which of the following water pollutants encourage the formation of algae ?
1.Insecticides
2.Heavy metals
3.Plant neutriants
4.Sediments.
Which one is not a pollutant in the true sense of the word?
1.Hydrocarons
2.Carbon dioxide
3.Carbon monoxide
4.Sulphur dioxide.
Which one of the following is a source of energy but does not cause pollution ?
1.Gasoline
2.Nuclear power plant
3.Fossil fuels
4.Sun