brain international school term-ii class-xii 2020-21 …
TRANSCRIPT
BRAIN INTERNATIONAL SCHOOL
TERM-II CLASS-XII 2020-21
SUB: - ENGLISH REVISION SHEET
The Last Lesson
Q1. What was the mood in the classroom when M. Hamel gave his last French lesson?
Q 2. What had the narrator counted on to enter the school, unnoticed?
Q3. “This is your last French lesson.” How did Franz react to this declaration of M.Hamel?
Q 4.“What a thunder clap these words were to me!” Which were the words that shocked and
surprised little Franz?
Q5. What changes came over little Franz after he heard M.Hamel’s announcement?
Q 6. What was tempting Franz to keep away from school That morning’?
Q 7. What was unusual about M. Hamel’s dress and behaviour on the day of his last French
lesson?
Lost Spring
Q1.Do you think Saheb was happy to work at the tea stall? Answer giving reasons
Q 2. What does the title, ‘Lost Spring’ convey?
Q3What does the writer mean when she says, ‘Saheb is no longer his own master’?
The Rattrap
Q 1. Why did the peddler sign himself as Captain von Stahle?
Q 2Why was Edla happy to see the gift left by the peddler?
Q 3Which act of the crofter surprised the peddler? Why?
Indigo
Q 1. Why did Gandhiji agree to the planters’ offer of a 25 percent refund to the farmers?
Q 2. How was Gandhiji able to influence the lawyers at Champaran?
Q 3. How did Gandhiji help the peasants of Champaran?
Q 4. Why did the servants think Gandhiji to be another peasant?
Q5. Why did Gandhiji agree to the planters’ offer of a 25% refund to the farmers?
An Elementary School Classroom in a Slum
Q 1. Why does Stephen Spender say that the pictures and maps in the elementary school
classroom are meaningless?
Q 2. How does the world depicted on the classroom walls differ from the world of the slum
children?
Q3. Read the extract given below and answer the questions that follow:
On their slag heap, these children
Wear skins peeped through by bones and spectacles of steel
With mended glass, like bottle bits on stones All of their time and space are foggy slum.
So blot their maps with slums as big as doom.
1. Which two images are used to describe these slums?
2. What sort of life do these children lead?
3. Which figure of speech is used in the last line?
A Thing of Beauty
1.Read the extract given below and answer the questions that follow:
Therefore, on every morrow, are we wreathing
A flowery band to bind us to the earth,
Spite of despondence, of the inhuman dearth
Of noble natures, of the gloomy days,
Of all the unhealthy and o’er-darkened ways
Made for our searching:
1. What are the flowery bands that bind us to the earth?
2. What message do the above lines convey?
Aunt Jennifer’s Tigers
Q1. Describe the tigers created by Aunt Jennifer.
Q2. Why did Aunt Jennifer choose to embroider tigers on the panel?
Q 3. Read the extract given below and answer the questions that follow
Aunt Jennifer’s tigers prance across a screen,
Bright topaz denizens of a world of green.
They do not fear the men beneath the tree;
They pace in sleek chivalric certainty.
1. How are aunt Jennifer’s tigers described?
2. Why are they described as denizens of a world of green?
3. Why are they not afraid of the men?
The Third Level
Q 1. What does the third level refer to? What is the significance of the third level?
Q2. What did Charley learn about Sam from the stamp and coin store?
Q 3. How does Charley, the narrator describe the third level at Grand Central Station?
Q 4. How did Charley make sure that he was not in the present time?
Q5.Why did Charley suspect that Sam had gone to Galesburg?
The Enemy
Q 1. Why did the General spare the American soldier?
Q2. Why was Dr. Sadao not sent to the battlefield?
Q3.Why did the messenger come to Dr. Sadao? What did Hana think about it?
Evans Tries an O-level
Q1. What clues did the answer sheet of Evans provide to the Governor?
Q2. Why did Evans not take off his hat when Jackson ordered him to do so?
WRITING SECTION
Q 1.You are Sweety/Suresh of L.M. Jain School, Ajmer. As Secretary of your School Co-
curricular Activities Club, you visited a slum area in your city where the people suffered a great
loss of life and property in a massive fire. The students of your school rendered their services and
material help to the victims. Write a report in 100-125 words for your school magazine.
Q 2 The literary club of your school is putting up the play ‘Waiting for Godot’. As secretary of the
club, draft an invitation inviting the famous writer Sudeesh Gupta to be the guest of honour at the
function. Write the invitation in not more than 50 words. You are Govind/Gauri.
Q3As the principal of a reputed college, you have been invited to inaugurate a Book Exhibition in
your neighbourhood. Draft a reply to the invitation in not more than 50 words, expressing your
inability to attend the function. You are Tarun/Tanvi.
Q4 You have received an invitation to be the judge for a literary competition in St. Ann’s School.
Send a reply in not more than 50 words, confirming your acceptance. You are Mohan/Mohini.
BRAIN INTERNATIONAL SCHOOL
TERM-II CLASS-XII 2020-21
SUB:- ECONOMICS REVISION SHEET
INDIAN ECONOMIC DEVELOPMENT
CHAPTER-1 Indian Economy on the Eve of Independence
Q1. When was Railways introduced?
Q2. Define export surplus.
Q3. Name some notable economist who estimated India’s per capita income during colonial period.
Q4. What was the two fold motive behind the de- industrialization by the colonial govt. in pre-
independent India?
Q5. How did the British ruler’s policy adversely affect the foreign Trade of India?
Q6. Give a brief account of qualitative aspect of demographic profile of India during British rule?
Q7. What does colonialism refer?
Q8. When was India’s first official census operation undertaken?
Q9.Whose interest were served by the economic policies pursued by the British govt. in India?
CHAPTER-1 Indian Economy (1950-90)
Q1. Differentiate between long term and short term planning.
Q2. Give a brief note on Industrial Policy Resolution 1956.
Q3. Who formulated plans in India?
Q4. When was India’s planning commission constituted and who was its chairman?
Q5. What is the current name of the planning commission and when it was constituted?
Q6. What were the main objectives of first three five year plan?
Q7. What is the main objective of current five year plan and its duration?
Q8. Differentiate among different type of economic system.
Q9. Explain the following:
(a) Self-reliance
(b) Equity
(c) Modernization
(d) Growth
(e) Land reforms
(f) Land ceiling
(g) Green revolution
(h) Industrial Policy resolution 1956.
(i) Trade Policy/ Import substitution
Q10. Define new economic policy and its features of it.
Q11. Define WTO
CHAPTER-3 Liberalization, privatization and globalization ( Including GST and Demonetization)
Q1. Define new economic reforms. And its objectives .
Q2. Define LPG in details.
Q3. Define Navratnas
Q4. What is the effect of Demonetisation in India?
Q5. Discuss the disadvantages of Demonetisation?
Q6. What are the advantages of Demonetisation?
Q7.What do you mean by Demonetisation?
Q8. What are final GST rate slabs?
Q9. What are CGST, SGST and IGST?
Q10. What are the differences between the UPA’s GST and the NDA’s GST?
Q12. What are the taxes that GST replaces?
Q13.What will be the short-term impact of GST?
Q14.What is a constitutional amendment?
Q15.What are the finer points in the implementation of the bill?
Q16.What is the Empowered Committee?
Q17.What will become costlier and cheaper?
CHAPTER-4 Poverty
Q1. What do you mean by poverty? Discuss the common characteristics of poor people.
Q2 .“Poverty in India has been studied from two points: urban and rural.”Comment.
Q3 .Distinguish between relative and absolute measures of poverty.
Q4 .Give a brief comparison of poverty determination in pre and post independent India.
Q5 .Discuss the concept of poverty line.
Q6 .State the criticism of “Monthly Per Capita Expenditure” method of determining poverty line.
Q7 .How the situation of poverty can be categorized?
Q8 “.Poverty is continuously declining in India” Support the statement by giving some historical trends of
India.
Q9 .What are the causes of poverty in India?
Q10. Why agriculture sector is regarded a s the core sector for Indian economic development?
Q11. Discuss the three dimensional approach adopted by Government of India to tackle the situation of
poverty.
Q12. Mention any two poverty alleviation programmes started by Government of India. Explain the reasons
for their unsatisfactory performance.
CHAPTER-5 Human Capital Formation
Q1 Distinguish between Human Capital and Physical Capital.
Q2 What do you mean by Human Capital Formation (HCF)?
Q3 Discuss various sources of HCF.
Q4 Why is it difficult to prove cause and effect relation between HCF and Economic Growth?
Q5 Discuss the role of Human Capital Formation for an economy.
Q6 What are the problems related to HCF?
Q7 Distinguish between Human Capital and Human Development.
Q8 Discuss the need for Government Intervention in Human Capital formation (HCF).
Q9 Why education and health sector are regarded as the pillars of an economy. Mention the
regulatory authorities of the respective sectors.
Q10 Discuss the educational achievements in India.
Q11What are the future prospects of Educational sector in India?
CHAPTER-6 Rural Development
Q1 What do you mean by rural development? Explain the process of rural development.
Q2 Discuss the importance of credit in the process of rural development.
Q3 Explain the institutional and non- institutional sources of rural credit.
Q4 What are the problems faced in the process of rural banking?
Q5 What do you mean by agricultural marketing? Discuss the problems faced by farmers in marketing of their
agricultural produce.
Q6 Briefly discuss some measures adopted by Government of India to improve the system of agricultural
marketing.
Q7 Why is agricultural diversification required? State the benefits of diversification. What are the two types of
diversification.
Q8 Bring out the importance of animal husbandry, fisheries and horticulture as a source of diversification.
Q9 What is meant by organic farming? How does it promote sustainable development?
CHAPTER -7 Employment: Growth, Informalisation and other issues
Q1 What do you mean by employment? Discuss the two main forms of employment.
Q2 Distinguish between Labour Force and Work Force.
Q3 Describe the concept of Worker-Population ratio. Explain its importance.
Q4 Why does people work? Who all are included in ‘Workers’?
Q5 Briefly discuss the causes of unemployment in India.
Q6 Discuss the male-female distribution of workforce on the basis of
Region (rural-urban) in India.
In different sectors
Q7 Briefly discuss the distribution of overall employment
In different sectors of the economy.
By gender
Q8 Discuss various remedial measures which are needed to solve the problem of unemployment in India.
Q9 What do you mean by formal and informal sectors? Discuss the conditions of workers in each of these
sectors.
Q10 What do you mean by casualization of workforce? Discuss the concept with relevant facts.
Q11 Discuss the steps taken by the government to solve the problem of unemployment?
Q12 Discuss the distribution of workforce in formal and informal sectors.
Q13 Write a short note on following types of unemployment:
Disguised Unemployment
Seasonal Unemployment
Open Unemployment
Ch: Infrastructure
Ch: Environment and sustainable development
Ch : Comparative Development Experience
Q1 What are the reasons for environmental crisis ?
Q2 What do you mean by global warming and explain its causes.
Q3 Write a short note on
1 Land degradation (concept and its causes ).
2 Deforestation .
3 Biodiversity loss.
4 Air pollution .
Q4 Explain the concept of Ozone depletion and its effect on living organisms.
Q5 What are the functions of Environment
Q6”Corrections for environmental damages involves OC “ explain
Q7 What do you mean by Environment?
Q8 Do you think global warming is harmful. Explain?
Q9 Explain how the OCs of negative environmental impact are high ?
Q10 “India has abundant natural resources ”.Comment
Q11 Explain the supply demand reversal of environmental resources
Q12 What do you mean by sustainable development ? What does it aim to ensure
Q 13 Why China’s population growth rate has sharply declined as compared to India and Pakistan?
Q14 Briefly discuss the similarities in the developmental strategies followed by India, Pakistan and
China.
Q15 How is China’s experience different from that of India and Pakistan , in its industrial development ?
Q16 Discuss the concept of ‘Dual Pricing’ in the reform process of India.
Q17 Briefly discuss the Give a brief account of the contribution of the agricultural sector in GDP of India
,Pakistan and China.
Q18 Compare the GDP growth of India ,China and Pakistan.
Q19 Discuss “the Great Proletarian Cultural Revolution “ introduced in China.
Q20 Compare the demographic indicators of India with China and Pakistan.
Q21 “The economies of China ,India and Pakistan differ in terms of sectoral growth .”
Comment.
Q22 Compare India and China on the basis of (i)People below poverty line ; (ii)Growth Rate of
population ; and (iii)Growth rate of Gross Domestic Product.
Q23 Briefly discuss the sectoral contribution to the GDP of India ,Pakistan and China .
Q24 Among the three sectors of the economy , which sector became the driving force for achieving a
higher growth rate in India and China ?
Q25 Discuss the concept of “Disguised unemployment”.
Q26 What are the two types of infrastructure?
Q27 Explain the importance of infrastructure for an economy.
Q28. Give examples of social and economic infrastructure.
MACROECONOMICS
UNIT 5 NATIONAL INCOME
Q1. How will you treat the following while estimating national income of India.
(a) Dividend received by an Indian from his investment in shares of a foreign company.
(b) Money received by a family in India from relatives working abroad.
(c) Interest received on loan given to a friend for purchasing a car.
Q2. How will you treat the following while estimating national income of India? Give reason for your
answer?
(a) Dividend received by a foreigner from investment in shares of an Indian Company.
(b) Money received by a family in India from relatives working abroad.
(c) Interest received on loan given to a Friend for purchasing a car.
Q3. Explain the problem of double counting in estimating national income, with the help of an
example. Also
explain two alternative ways of avoiding the problem.
Q4. Distinguish between real gross domestic product and nominal gross domestic product. Can gross
domestic
product be used as an index of welfare of the people? Give two reasons.
Q5. How will you treat the following in estimating national income of India? Give reasons for your
answer.
(a) Value of bonus shares received by shareholders of a company.
(b) Fees received from students.
(c) Interest received on loan given to a foreign company in India.
Q6. Explain the steps of measuring national income by income method.
Q7. Explain value added method of estimating National Income with the help of suitable example. 8.
Giving
reasons, categories following into transfer payment or factor payments.
(a) financial help gives to flood victims
(b) Old age pension.
(c) Imputed rent.
UNIT 6 MONEY AND BANKING
Q1. How the monetary system solved the problems of barter system?
Q2. Define M1 also explain the meaning of its components.
Q3. Explain unit of value function of money.
Q4. How was the money evolved?
Q5. Explain how the commercial banks create credit.
Q6. Explain the Banker’s bank and Supervisor function of Central Bank.
Q7. How the Central bank of a country control the credit creation in the economy? Explain any three
measures.
Q8. Why the Post Offices and LIC are not bank?
Q9. Give the four definitions used by the Reserve Bank of India to estimate money supply in the
Economy,
UNIT 7 DETERMINATION OF INCOME AND EMPLOYMENT
Q1. What is aggregate demand?
Q2. What is meant by aggregate supply in macroeconomics?
Q3. Define MPC.
Q4. What is the saving function?
Q5. Define MPS
Q6. If in an economy investment is greater than saving, what is the effect on the national income?
Q7. What is meant by equilibrium?
Q8. What is under employment equilibrium?
Q9. What is the meaning of excess demand in an economy?
Q10. When does a situation deficient demand arise in an economy?
Q11. Give the meaning of MPS and APS. Can the value of APS be negative? If yes, when?
Q12. What is difference between plant (Expost) and actual (Exante) investments?
Q13. Explain two physical measures by which excess demand in an economy can be reduce.
Q14.What is deficient demand in an economy? What is its impact on out put, employment and prices?
Q15. With help of a diagram explain the concept of inflationary gap.
Q16. What is monetary policy? Explain the role of 1. Bank Rate and 2. Margin requirement in
influencing the
available of the credit in an economy.
Q17. Explain the theory of determination of income and employment with the help of aggregate
demand and
aggregate supply curves.
UNIT 8 GOVERNMENT BUDGET AND THE ECONOMY
Q1. Why is tax not a capital receipt?
Q2. What happened to aggregate demand when the govt. budget is in surplus?
Q3. What happened to aggregate demand when the govt. budget is in deficit?
Q4. Would you advocate deficit or surplus budget if there is excess demand in the economy?
Q5. Would you advocate deficit or surplus budget if there is deficient demand in the economy?
Q6. Can there be fiscal deficit if there is no deficit in revenue account?
Q7. Why repayment loan is a capital expenditure?
Q8. What type of expenditure is the payment of interest/
Q9. Why the receipt of interest on load treated as revenue receipts?
Q10. Categorise the following into revenue receipts and capital receipts by giving the reason:
Recovery of loans, Corporation tax, Dividends on investment made by govt., sale of PSU,
interest on
loan given to other countries.
UNIT 9 BALANCE OF PAYMENTS
Q1. Ten dollars are exchanged for five hundred rupees. What is the exchange rate of Indian currency?
Q2. What does a change from $3 = ₤1 to $2 = ₤1 represent?
Q3. What happen to exchange rate if the supply of foreign currency increases? Explain with the help of
a diagram.
Q4. What happen to exchange rate if the demand of foreign currency decreases? Explain with the help
of a diagram.
Q5. Explain the relation between balance of payment and FOREX rate.
Q6. Explain the relationship between foreign exchange rate and the demand for FOREX.
Q7. Explain the relationship between foreign exchange rate and the supply of FOREX.
Q8. Explain how foreign exchange rate is determined in a foreign exchange market? Use diagram
Q9. How the flexible or floating exchange rate is different from the managed floating exchange rate?
Q10. A country’s BOT is Rs. (-)60 crores and the value of import of goods is Rs.100 Crores. Find out
the value
of exports.
Q11. How is the balance of trade different from balance of payments?
Q12. Balance of trade shows the deficit of Rs. 5000 crores. Value of export is Rs.4000 crores. Find out
the value of imports.
Q13. Differentiate between devaluation and depreciation.
Q14. Differentiate between revaluation and appreciation.
Q15. Are the following transactions entered on the credit or debit side of balance of payments account:
Q16. Exports, Imports, Borrowings from rest of the world, Lending to rest of the world, Import of
software services.
BRAIN INTERNATIONAL SCHOOL
TERM-II CLASS-XII 2020-21
SUB:- MATHS REVISION SHEET
RELATIONS AND FUNCTIONS
Q1. If 𝑓(𝑥) is an invertible function, find the inverse of (𝑥) =3𝑥−2
5 .
Q2. If 𝑓(𝑥) = 2𝑥 + 3 and If 𝑔(𝑥) = 3𝑥 − 9, 𝑥 ∈ 𝑅 find (𝑓𝑜𝑔)(0).
Q3. If 𝑓 ∶ 𝑅 → 𝑅, be defined by 𝑓(𝑥) = (4 − 𝑥4)1
4, then find (𝑓𝑜𝑓)(𝑥).
Q4. Let be a binary operation on N given by 𝑎 ∗ 𝑏 = 2𝑎𝑏 , 𝑎, 𝑏 ∈ 𝑁. Write the value of (1 ∗ 2) ∗ 1.
Q5. State the reason for the relation R in the set {1, 2, 3} given by 𝑅 = {(1, 3), (3, 1)} not to be
transitive.
Q6. Show that 𝑓 ∶ 𝑅 → 𝑅, given by 𝑓(𝑥) = 𝑥2 + 1 is not a one-one function.
Q7. Let 𝑓 ∶ 𝑅 → 𝑅, be given by 𝑓(𝑥) = 𝑥2 + 1. Find the pre-image of (i) 17 (ii) -3.
Q8. Write the inverse relation corresponding to the relation
𝑅 = {(𝑥, 𝑦) ∶ 𝑥 ∈ 𝑁, 𝑥 < 5, 𝑦 = 3}.
Q9. Is 𝑓 ∶ [0, 𝜋] → 𝑅, given by 𝑓(𝑥) = cos 𝑥, one-one?
Q10. Is 𝑓 ∶ [0, 2𝜋] → 𝑅, given by 𝑓(𝑥) = cos 𝑥, one-one?
INVERSE TRIGONOMETRIC FUNCTIONS
Q1. Show that 𝑠𝑖𝑛−1 (√𝑎−𝑥
2𝑎) =
1
2 𝑐𝑜𝑠−1 𝑥
𝑎 .
Q2. Write the principle value :
(i) 𝑐𝑜𝑠𝑒𝑐−1(2)
(ii) 𝑐𝑜𝑠−1 (−√3
2)
(iii) 𝑡𝑎𝑛−1(−√3)
(iv) 𝑡𝑎𝑛−1 (tan3 𝜋
4)
Q3. Write the value in
(i) 𝑐𝑜𝑠𝑒𝑐−1(√2) + 𝑠𝑒𝑐−1(√2)
(ii) 𝑐𝑜𝑠−1 (𝑐𝑜𝑠 2 𝜋
3) + 𝑠𝑖𝑛−1 (𝑐𝑜𝑠
2 𝜋
3)
(iii) 𝑡𝑎𝑛−1(√3) + 𝑐𝑜𝑡−1 (1
√3)
Q4. What is the domain of the function 𝑐𝑜𝑠𝑒𝑐−1𝑥?
Q5. Write one branch of 𝑡𝑎𝑛−1𝑥 other than the principle branch.
Q6. Evaluate in
(i) 𝑠𝑖𝑛−1 {cos (𝑠𝑖𝑛−1 3
2)}
(ii) 𝑐𝑜𝑠𝑒𝑐−1 {cosec (−𝜋
4)}
(iii) cos {𝜋
3− 𝑐𝑜𝑠−1 (
1
2)}
(iv) 𝑠𝑒𝑐2 (𝑡𝑎𝑛−1 2)
(v) 𝑐𝑜𝑠−1 (cos5 𝜋
3)
(vi) 𝑠𝑒𝑐−1 (𝑥−3
𝑥+3) + 𝑠𝑖𝑛−1 (
𝑥+3
𝑥−3)
(vii) 𝑡𝑎𝑛−1 {cos 𝜋}
Q7. Prove that in
(i) 2 𝑡𝑎𝑛−1𝑥 = 𝑠𝑖𝑛−1 (2𝑥
1+𝑥2)
(ii) 2 𝑐𝑜𝑠−1𝑥 = 𝑠𝑒𝑐−1 (1
2𝑥2−1)
(iii) 𝑠𝑖𝑛−1𝑥 = 𝑐𝑜𝑡−1 (√1−𝑥2
𝑥)
(iv) 𝑐𝑜𝑠−1𝑥 = 2 𝑐𝑜𝑠−1 √1+𝑥
2
Q8. Find the value of 𝑐𝑜𝑠𝑒𝑐 (𝑐𝑜𝑡−1 𝑦
2) in terms of 𝑦 alone.
MATRICES
Q1. If [𝑥 + 3 4 𝑦 − 4 𝑥 + 𝑦
] = [5 43 9
], find 𝑥 and 𝑦.
Q2. Construct a 3 × 2 matrix A, if 𝐴 = [𝑎𝑖𝑗], 𝑤ℎ𝑒𝑟𝑒 𝑎𝑖𝑗 = {𝑖 + 𝑗, 𝑖𝑓 𝑖 ≥ 𝑗𝑖 + 𝑗, 𝑖𝑓 𝑖 < 𝑗
}.
Q3. If matrix 𝐴 = [1 2 3], write matrix AA’ where A’ is transpose of matrix A.
Q4. Find the number of all possible matrices of order 2 × 2 with each entry 1 or 2.
Q5. If 𝐴 = [𝑎𝑖𝑗] = [2 3 − 51 4 90 7 − 2
] 𝑎𝑛𝑑 𝐵 = [𝑏𝑖𝑗] [ 2 1 −1 −3 4 4 1 5 2
], then find 3𝑎12 − 5𝑏21.
Q6. Write a square matrix of order 2 which is both symmetric and skew symmetric.
Q7. If [2𝑥 − 1
5] = [
3𝑥 + 𝑦
], find 𝑥 and 𝑦.
Q8. Simplify, 𝑠𝑖𝑛 𝜃 [sin θ −cos θcos θ sin θ
] + 𝑐𝑜𝑠 𝜃 [ cos θ sin θ −sin θ cos θ
] − 𝑑𝑖𝑎𝑔 [−1, 1].
Q9. If 𝑋𝑚×3𝑌𝑝×4 = 𝑍2×𝑏′ find the values of m, p and b.
Q10. For what value of k, the matrix [ 0 −1 𝑘 1 0 54 −5 0
] is skew symmetric?
DETERMINANTS
Q1. If |𝑥 + 2 3 𝑥 + 5 4
| = 3, find the value of 𝑥.
Q2. Evaluate |1 0 02 𝑐𝑜𝑠 𝑥 sin 𝑥3 − sin 𝑥 𝑐𝑜𝑠 𝑥
|.
Q3. Find the minor of 𝑎12 in the following determinant : |2 −3 56 0 41 5 −7
|.
Q4. Evaluate |sec 350 tan 350
cot 550 cosec 550|.
Q5. For what value of k, the matric [𝑘 23 4
] is invertible?
Q6. Write the value of the determinant |2 3 45 6 8
23 33 44|.
Q7. If 𝐴 = |1 24 2
|, then find the value of k if |2𝐴| = 𝑘 |𝐴|.
Q8. Given a non-zero real number k and a determinant ∆ = |𝑎 𝑏𝑐 𝑑
| , 𝑡ℎ𝑒𝑛 𝑘∆ = |𝑘𝑎 𝑏𝑐 𝑘𝑑
|. State true or
false. If false give one determinant which can be true.
Q9. Write |𝐴−1| for the matrix 𝐴 = [2 51 3
].
CONTINUITY AND DIFFERENTIABILITY
Q1. Differentiation each of the following with respect to 𝑥
(i) sin log 𝑥
(ii) 𝑐𝑜𝑠−1 √𝑥
(iii) log𝑎(sin 𝑥)
(iv) 𝑒𝑠𝑖𝑛−1 𝑥
(v) sin [log (𝑥2 − 1)]
Q2. Differentiate cos 𝑥 with respect to 𝑒𝑥.
Q3. If = 𝑠𝑒𝑐−1 (√𝑥+1
√𝑥−1) + 𝑠𝑖𝑛−1 (
√𝑥−1
√𝑥+1) , 𝑓𝑖𝑛𝑑
𝑑𝑦
𝑑𝑥 .
Q4. Given 𝑓(0) = −2, 𝑓(0) = 3. Find ℎ ′(0), where ℎ(𝑥) = 𝑥𝑓(𝑥).
Q5. Find 𝑑𝑦
𝑑𝑥 at (4, 9), when √𝑥 + √𝑦 = 5.
Q6. Find the second derivative of log 𝑥 with respect to 𝑥
Q7. Show that the function 𝑓(𝑥) =sin 𝑥
|𝑥| is discontinuous at 𝑥 = 0.
Q8. Show that the function 𝑓(𝑥) = 𝑥 − |𝑥| is continuous at 𝑥 = 0.
Q9. Let 𝑓 be the function defined as (𝑥) = {
2𝑥
√𝑎+𝑥− √𝑎−𝑥, 𝑖𝑓 𝑥 ≠ 0
3𝑘, 𝑖𝑓 𝑥 = 0 , 𝑎 > 0. For what value of k,
function is continuous at 𝑥 = 0?
Q10. A function 𝑓 is defined as 𝑓(𝑥) = {
1−cos 4𝑥
𝑥2 , 𝑖𝑓 𝑥 < 0
√𝑥
√16+√𝑥−4 , 𝑖𝑓 𝑥 > 0
. Is the function continuous at
APPLICATION OF DERIVATIVES
Q1. Find the intervals of monotonicity of the function 𝑓(𝑥) = 𝑥1
𝑥, 𝑥 > 0. Hence find the bigger of the
two numbers 𝑒𝜋 𝑎𝑛𝑑 𝜋𝑒.
Q2. Show that function 𝑓(𝑥) = 𝑥2 is strictly increasing function in (0, ∞) without using derivatives.
Q3. Show that the function 𝑓(𝑥) = (3𝑥 + 5)3 is increasing in R.
Q4. Show that the function 𝑓(𝑥) = log(cos 𝑥) is decreasing in (0,𝜋
2).
Q5. Show that the function 𝑓(𝑥) = log𝑒 𝑥 is an increasing function for 𝑥 > 0.
Q6. At what point on the curve 𝑦 = 𝑥2 does the normal make an angle of 300 clockwise with the x-axis?
Q7. Find the point (s) on the curve 𝑥2
𝑎2+
𝑦2
𝑏2= 1, where tangent is parallel to the y-axis.
Q8. Find the interval in which the function 𝑓(𝑥) =4 sin 𝑥−2𝑥−𝑥 cos 𝑥
2+cos 𝑥, is strictly increasing or strictly
decreasing in (0, 2𝜋).
Q9. A particle moves along a straight line in such a way that its distance from fixed origin is the square
root of the quadratic function of time. Prove that the acceleration varies inversely as the cube of the
distance.
Q10. Prove that 𝑥
1+𝑥 < log(1 + 𝑥) < 𝑥 for all 𝑥 > 0.
Q11. A particle moves in a straight line according to the formula 𝑠 = 𝑡3 − 6𝑡2 − 15𝑡, where s represents
the distance in meters and t represents the time in seconds. Find the time interval during which the speed
of the particle decreases. (𝑠𝑝𝑒𝑒𝑑 =𝑑𝑠
𝑑𝑡).
Q12. Find the interval in which the function 𝑓(𝑥) = 2𝑥3 − 15𝑥2 + 36𝑥 + 17 is strictly increasing or
strictly decreasing.
INTEGRALS
Evaluate each of the following integrals in
(i) ∫𝑥2
1+𝑥3 𝑑𝑥
(ii) ∫2 cos 𝑥
3 𝑠𝑖𝑛2𝑥 𝑑𝑥
(iii) ∫𝑥+cos 6𝑥
3𝑥2+sin 6𝑥 𝑑𝑥
(iv) ∫𝑠𝑒𝑐2 √𝑥
√𝑥 𝑑𝑥
(v) ∫1
√𝑎𝑥+𝑏− √𝑎𝑥−𝑑𝑑𝑥, 𝑏 ≠ −𝑑
(vi) ∫ sec 𝑥 log(sec 𝑥 + tan 𝑥) 𝑑𝑥
(vii) ∫2+3𝑥
3−2𝑥 𝑑𝑥
(viii) ∫ √𝑎+𝑥
𝑥 𝑑𝑥
(ix) ∫𝑥−sin 𝑥
1−cos 𝑥 𝑑𝑥
(x) ∫1
sin 𝑥 (2+cos 𝑥)𝑑𝑥
(xi) ∫1
(2𝑥+3) √𝑥+1𝑑𝑥
(xii) ∫1
(𝑥+1) √𝑥2−1𝑑𝑥
(xiii) ∫sin 4𝑥
(2+sin 2𝑥)2 𝑑𝑥
(xiv) ∫ 𝑐𝑜𝑡3𝑥 𝑑𝑥
(xv) ∫sin 𝑥
sin 𝑥−3 cos 𝑥−1𝑑𝑥
(xvi) ∫1
(cos 𝑥+2 sin 𝑥) 2𝑑𝑥
(xvii) ∫1
(𝑥+1) √2𝑥−3𝑑𝑥
(xviii) ∫ 𝑥 √1+𝑥
1−𝑥𝑑𝑥
(xix) ∫1
1−𝑐𝑜𝑠4𝑥𝑑𝑥
(xx) ∫ 𝑓(𝑥) 𝑑𝑥, 𝑤ℎ𝑒𝑟𝑒 𝑓(𝑥) = {2𝑥 − 1, −2 ≤ 𝑥 ≤ 13𝑥 − 2, 1 ≤ 𝑥 ≤ 2
2
−2
(xxi) ∫1
3+2 cos 𝑥 𝑑𝑥
𝜋
20
(xxii) ∫ |cos 𝑥| 𝑑𝑥𝜋
0
(xxiii) ∫ 𝑥3 cos2 𝑥 𝑑𝑥𝜋
4𝜋
4
(xxiv) ∫ [sin|𝑥| − cos|𝑥|] 𝑑𝑥𝜋
2𝜋
2
(xxv) ∫sin 2𝑥
𝑠𝑖𝑛4𝑥+𝑐𝑜𝑠4 𝑥 𝑑𝑥
𝜋
20
(xxvi) ∫1
𝑎 sin 𝑥+𝑏 cos 𝑥 𝑑𝑥, 𝑎, 𝑏 > 0
𝜋
20
(xxvii) ∫ log |2−sin 𝑥
2+sin 𝑥| 𝑑𝑥
𝜋
2𝜋
2
(xxviii) ∫log 𝑥
√1−𝑥2 𝑑𝑥
1
0
(xxix) ∫ (sin 𝑥 − cos 𝑥) log(sin 𝑥 + cos 𝑥) 𝑑𝑥𝜋
20
(xxx) ∫cos 𝑥
3 𝑐𝑜𝑠 𝑥+𝑠𝑖𝑛 𝑥 𝑑𝑥
𝜋
20
APPLICATION OF INTEGRATION
Q1. Find the area bounded by the curve 𝑦 = 𝑥2 and the line 𝑦 = 16.
Q2. Find the area of the region bounded by the parabola 𝑦2 = 4𝑎𝑥 and its latus rectum.
Q3. Find the area of the region bounded by the curve 𝑦2 = 4𝑎2 (𝑥 − 1) and the lines curve 𝑥 = 1 and
curve 𝑦 = 4𝑎.
Q4. Find the area of the region bounded by the curve 𝑦 = |𝑥 + 1| + 1, 𝑥 = −2, 𝑥 = 3, and 𝑦 = 0.
Q5. Draw the rough sketch of the region {(𝑥, 𝑦) ∶ 𝑦2 ≤ 3𝑥, 3𝑥2 + 3𝑦2 ≤ 16} and find the area of the
region enclosed by using the method of integration.
Q6. Find the area bounded by the curve 𝑥𝑦 = 3𝑥 − 2𝑦 − 10 = 0, the x-axis and the lines 𝑥 = 3 and
𝑥 = 4.
Q7. Find the area bounded by the curve 𝑦 = 6𝑥 − 𝑥2 and 𝑦 = 𝑥2 − 2𝑥.
DIFFERENTIAL EQUATIONS
Q1. Write the order and degree of the differential equation 𝑥𝑑𝑦
𝑑𝑥− cos (
𝑑2𝑦
𝑑𝑥2) = 0.
Q2. Write the order and degree of the differential equation 𝑦 = 𝑝𝑥 + √1 + 𝑝2 , where 𝑝 =𝑑𝑦
𝑑𝑥.
Q3. Show that the differential equation of which 𝑦 = 2(𝑥2 − 1) + 𝑐𝑒−𝑥2 is a solution, is
𝑑𝑦
𝑑𝑥+ 2𝑥𝑦 =
4𝑥3.
Q4. Show that the differential equation of which 𝑐𝑦2 = 1 + 8𝑦2 tan 𝑥 is a solution, is 𝑐𝑜𝑠2𝑥𝑑𝑦
𝑑𝑥= 4𝑦3.
Q5. Solve each of the following differential equations.
(i) √4 − 𝑥2 𝑑𝑦 + √4 + 𝑦2 𝑑𝑥 = 0
(ii) 𝑒𝑑𝑦
𝑑𝑥 = (𝑥 + 2)
(iii) 𝑠𝑖𝑛−1 (𝑑𝑦
𝑑𝑥) = 𝑥 + 𝑦
(iv) √1 + 𝑥2 + 𝑦2 + 𝑥2𝑦2 + 𝑥𝑦𝑑𝑦
𝑑𝑥= 0
(v) 𝑑𝑦
𝑑𝑥=
3 (𝑒2𝑥+𝑒4𝑥)
𝑒𝑥+𝑒−𝑥
(vi) 𝑐𝑜𝑠2 (𝑥 − 2𝑦) = 1 − 2𝑑𝑦
𝑑𝑥
(vii) (𝑥2 − 1)𝑑𝑦
𝑑𝑥+ 2(𝑥 + 2)𝑦 = 2(𝑥 + 1)
(viii) 𝑦 +𝑑
𝑑𝑥(𝑥𝑦) = 𝑥(sin 𝑥 + log 𝑥)
(ix) 𝑑𝑦
𝑑𝑥+
3𝑥2
1+𝑥3 𝑦 =𝑠𝑖𝑛2𝑥
1+𝑥3
(x) 2𝑥𝑑𝑦
𝑑𝑥= 𝑦 + 6𝑥
5
2 − 2√𝑥
VECTORS
Q1. If �⃗� ∙ �⃗⃗� = −|�⃗�||�⃗⃗�|, then how are vectors �⃗� and �⃗⃗� related?
Q2. Find the volume of a parallel piped whose sides are given by 7𝑖̂ − 5𝑗̂ − 3�̂�, 𝑖̂ + 2 𝑗̂ − �̂� and −3𝑖̂, 𝑖̂ +
7 𝑗̂ + 5�̂�.
Q3. If �⃗� = 4𝑖̂ + 3𝑗̂ + �̂� and �⃗⃗� = 𝑖̂ − 2�̂�, then find |2�⃗⃗� × �⃗�|.
Q4. Find a unit vector in the direction of vector (�⃗� − �⃗⃗�), where �⃗� = −𝑖̂ + 𝑗̂ + �̂� and
�⃗⃗� = 2𝑖̂ + 𝑗̂ − 3�̂�.
Q5. Show that |�⃗� × �⃗⃗�| = (�⃗� ∙ �⃗⃗�) tan 𝜃 where 𝜃 is angle between �⃗� and �⃗⃗�.
Q6. If |�⃗�| = 2, |�⃗⃗�| = 3 and �⃗� ∙ �⃗⃗� = 4, find |�⃗⃗� − �⃗�|.
Q7. For non-zero vectors �⃗�, �⃗⃗� and 𝑐, if �⃗� × �⃗⃗� + �⃗⃗� × 𝑐 + 𝑐 × �⃗� = 0⃗⃗, show that vectors �⃗�, �⃗⃗� and 𝑐 are
coplanar.
Q8. Find the area of a triangle using vectors, whose vertices are (3, −1, 2), (1, −1, −3) and (4, −3, 1).
Q9. Dot product of a vector with vectors 𝑖̂ + 𝑗̂ + �̂�, 𝑖̂ + 2 𝑗̂ + 3�̂� and 𝑖̂ + 3 𝑗̂ + 4 �̂� are respectively 7,
16 and 22. Find the vector.
Q10. If vectors �⃗�, �⃗⃗� and 𝑐 represent the vectors 𝐵𝐶⃗⃗⃗⃗⃗⃗ , 𝐶𝐴⃗⃗⃗⃗⃗⃗ 𝑎𝑛𝑑 𝐴𝐵⃗⃗⃗⃗ ⃗⃗ along the sides of a triangle ABC, show
that �⃗� × �⃗⃗� = �⃗⃗� × 𝑐 = 𝑐 × �⃗� and hence deduce sine rule for triangles.
THREE DIMENSIONAL GEOMETRY
Q1. Find the distance between the parallel planes 𝑟 ∙ (2𝑖̂ − 𝑗̂ + 3�̂�) = 4 and 𝑟 ∙
(6𝑖̂ − 3𝑗̂ + 9�̂�) + 13 = 0.
Q2. Show that the line 𝑟 = (𝑖̂ + 𝑗̂) + 𝜆(2𝑖̂ + 𝑗̂ + 4�̂�) lies in the plane 𝑟 ∙ (𝑖̂ + 2𝑗̂ − �̂�) = 3.
Q3. Find the angle between the line 𝑟 = (𝑖̂ − 𝑗̂ + �̂�) + 𝜆(2𝑖̂ − 𝑗̂ + 3�̂�) and the plane 𝑟 ∙ (2𝑖̂ + 𝑗̂ − �̂�) =
4.
Q4. Find the coordinates of the point where the line joining the point 𝐴(3, 4, 1) and 𝐵(5, 1, 6) crosses
the XY-plane.
Q5. If direction cosines of a line are 1
𝑎 ,
1
𝑎 ,
1
𝑎 , find the value of a.
Q6. Find the foot of the perpendicular drawn from the point 𝐴(1, 0, 3) to the join of the points 𝐵(4, 7, 1)
and 𝐶(3, 5, 3).
Q7. A variable plane is at a constant distance 𝒫 from the origin 𝒪 and meets the axes in the points 𝐴, 𝐵
and 𝐶. If centroid of the tetrahedron 𝑂𝐴𝐵𝐶 is (𝛼, 𝛽, 𝛾), show that 𝛼−2 + 𝛽−2 + 𝛾−2 = 16𝑝−2.
Q8. Find whether or not the two given lines intersect : 𝑟 = (𝑖̂ − 2𝑗̂ + 3�̂�) + 𝜆 (−𝑖̂ + 𝑗̂ − 2�̂�) and 𝑟 =
(𝑖̂ − 𝑗̂ − �̂�) + 𝜆 (𝑖̂ + 2𝑗̂ − 2�̂�).
Q9. Find the value of 𝜆, for which the points with position vectors 𝑖̂ − 𝑗̂ + 3�̂� and 3𝑖̂ + 𝜆𝑗̂ + 3�̂�
are equidistant from the plane 𝑟 ∙ (5𝑖̂ + 2𝑗̂ − 7�̂�) + 9 = 0.
Q10. State when the line 𝑟 = �⃗� + 𝜆�⃗⃗� is parallel to the plane 𝑟 ∙ �⃗⃗� = 𝑑.
Show that the line 𝑟 = (𝑖̂ + 𝑗̂) + 𝜆 (2𝑖̂ + 𝑗̂ + 4�̂�) is parallel to the plane 𝑟 ∙ (−2𝑖̂ + �̂�) = 5. Also find
the distance between the line and the plane.
Q11. Find the equation of the plane passing through the point (3, 2, 1) and parallel to the plane 𝑥 + 𝑦 −2𝑧 = 2. Find the distance of the point (2, 3, 2) from the plane.
Q12. Find the equation of the plane passing through the intersection of planes 4𝑥 − 𝑦 + 𝑧 =10 and 𝑥 + 𝑦 − 𝑧 = 4 and parallel to the line with direction ratios, 2, 1, 1. Find the perpendicular
distance of the point (1, 1, 1) from this plane.
Q13. Find the equation of the lines of shortest distance between the lines, 𝑥−8
3=
𝑦+9
−16=
𝑧−10
7 and
𝑥−15
3=
𝑦−29
8=
5−𝑧
5 . Also find the shortest distance between the lines.
PROBABILITY
Q1. A die is thrown three times, if the first throw results in 4, then find the probability of getting 15 as a
sum.
Q2. If 𝑃(𝐴) =7
13 , 𝑃(𝐵) =
9
13 and 𝑃(𝐴 ∩ 𝐵) =
4
13 , find 𝑃(𝐴′/𝐵).
Q3. If 𝑃(𝐴′) =7
10 , 𝑃(𝐵) =
7
10 and 𝑃(𝐵/𝐴) =
1
2 , find 𝑃(𝐴/𝐵).
Q4. If 𝑃(𝐴) =3
5 , 𝑃(𝐵) =
9
13 and 𝑃(𝐴 ∩ 𝐵) =
4
13 , find 𝑃(𝐴′/𝐵).
BRAIN INTERNATIONAL SCHOOL
TERM-II CLASS-XII 2020-21
SUB:- IP REVISION SHEET
PART A
SECTION - I
1. Name the primary law in India dealing with cybercrime and electronic commerce.
2. _________ method in pandas can be used to change the index of rows and columns of a series or
dataframes.
(a) rename()
(b) reindex()
(c) reframe()
(d) none of these
3. In SQL the operation whose result contains all pair of tuples from the two relations regardless of whether
their attribute values match.
(a) Join
(b) Cartesian product
(c) Intersection
(d) Set difference
4. Consider a series object vls, created using following statement:
vls= pd.Series([11, 23, 31, 61, 87, 93],
index=[‘a’, ‘b’, ‘c’, ‘d’, ‘f’])
Based on this series object, write statement to retrieve and print the first three elements.
5. Given the following Series S1 and S2:
S1 S2
Now write the command to find the sum of Series S1 and S2.
6. Using python matplotlib________ can be used to count how many values fall into each interval:
(a) line plot
(b) bar graph
(c) histogram
(d) None of these
7. When someone steals someone else’s personal information to commit theft or fraud, it is
called_________.
A
B
C
D
4
5
4
3
A
B
C
D
7
9
7
9
(a) Identity theft
(b) Hacking
(c) Computer piracy
(d) Infringement
8. Given a Data Frame mdf as shown below:
A B C
0 7 8 9
1 41 45 48
What will be the output produced by the following code?
print(“I:”, mdf.loc[0][‘C’])
print(“II:”, mdf.iloc[1][2])
9. Which of the following is not a network topology:
Star, Mesh, Tree, Bug, Bus
10. Which of the following is an act of plagiarism?
(a) Stealing a painting and selling it to a buyer.
(b) Copying your friend’s essay and using it by own name
(c) Deleting your friend’s stored work on drive
(d) Writing virus program
11. With SQL, how do you select all records from a table named “students” where the value
of the column “FirstName” ends with an “a”?
(a) SELECT * FROM students WHERE FirstName= ‘a’;
(b) SELECT * FROM students WHERE FirstName like ‘a%’;
(c) SELECT * FROM students WHERE FirstName like ‘%a’;
(d) SELECT * FROM students WHERE FirstName like ‘%a%’;
12. Which of the following is not ‘open source’ software:
(a) Linux
(b) Ubuntu
(c) open office
(d) windows 10
13. A ___________ is a pandas data structure that represent 1D array like objects.
14. In the context of computer Networks identify me
I can keep you singed in
I can remember your site preferences
I can give you locally relevant content
Who am I?
15. _________ is a networking device that forwards the data packets between computer networks.
(a) Repeater
(b) Hub
(c) Switch
(d) Router
16. Define the term spam.
17. According to a survey one of the major Asian country generates approximately about 2
million tonnes of electronic waste per year only 1.5% of the total e-waste gets recycled.
Suggest a method to manage e-waste.
18. Consider the following query:
SELECT name FROM student WHERE subject=’IP’ ODER BY name;
The above query will list result in _________ order of _____________
(a) Descending, subject
(b) Ascending, subject
(c) Descending, name
(d) Ascending, name
19. Which of the following group functions will ignore NULL values
(a) MAX
(b) COUNT
(c) SUM
(d) All the above
20. _________ network type comprises of multiple LAN/MAN.
21. In this topology, each node is connected to more than one node to provide an alternate
route in the case the host is either down or too busy.
(a) Star
(b) Bus
(c) Mesh
(d) Ring
SECTION – II
22. Consider the following DataFrame df and answer any questions from (i) – (v)
rollno Name UT1 UT2 UT3 UT4
0 1 Pratima Sinha 29 30 19 20
1 2 Manoj Gupta 20 18 18 24
2 3 Tathagata Patra 18 22 20 20
3 4 Firoz Khan 22 23 27 22
4 5 Kirti Rani 15 24 29 21
5 6 Raman Kumar 21 15 23 30
6 7 Bineet Banerjee 28 16 24 33
(a) Select the options from the command that will give the following ouput:
Roll No 7
Name Tathagata Patra
UT1 29
UT2 30
UT3 29
UT4 33
dtype: object
(i) print(df.max)
(ii) print(df.max())
(iii) print(df.max(axis is=1))
(iv) print(df.max, axis=1)
(b) The teacher needs to know the marks scored by the student with roll number 7. Help
him/her to identify the correct set of statements from the given options (More than one
option may be correct):
(i) df1=df [roll no = =7]
print (df1)
(ii) df1=df [df [‘rollno’] = =7 ]
print (df1)
(iii) df1=df [ df.rollno = = 7 ]
print (df1)
(iv) df1=df [rollno.df = =7 ]
print (df1)
(c) Which of the following statement/s will give the exact number of values in each
column of the data frame?
(1) print( df.count( ) )
(2) print( df.count(0) )
(3) print(df.count)
(4) print(df.count(axis = ‘index’))
Choose the correct option:
(i) both (1) and (2)
(ii) only (2)
(iii) (1), (2) and (3)
(iv) (1), (2) and (4)
(d) Which of the following command will display the column labels of the DataFrame?
(i) print( df.columns( ))
(ii) print( df.column)
(iii) print( df.columns)
(iv) print( df.column( ))
(e) A student Neeraj wants to add a new column, the score of Grade with the values ‘B1’,
‘B2’, ‘A2’, ‘B2’, ‘B1’, ‘A1’ , ‘A1’ to the DataFrame. Help him choose the command to do
so:
(i) df[‘Grade’] = [‘B1’, ‘B2’, ‘A2’, ‘B2’, ‘B1’, ‘A1’ , ‘A1’]
(ii) df.column = [‘B1’, ‘B2’, ‘A2’, ‘B2’, ‘B1’, ‘A1’ , ‘A1’]
(iii) df.loc[‘Grade’] = [‘B1’, ‘B2’, ‘A2’, ‘B2’, ‘B1’, ‘A1’ , ‘A1’]
(iv) both b and c are correct.
23. Consider the table TEACHER given below:
Emp_id name DOJ Sex City Grade Salary
111 Jugal 21/05/1998 M Delhi A 8000
222 Sharmila 21/05/1997 F Mumbai B 9000
333 Sandeep 29/08/1998 M Kochi A 8000
444 Sangeeta 13/06/1996 F Kolkata B 10000
555 Rakesh 31/10/1999 M Mumbai C 9000
666 Shyam 21/05/1989 M Bangalore A 8000
777 Aishwarya 11/01/1990 F Delhi B 12000
(a) State the command that will give the output as :
(i) Select name from EMPLOYEE where Gender= ‘M’ AND Salary>7000;
(ii) Select name from EMPLOYEE where Gender= ‘M’ OR Grade=A;
(iii) Select name from EMPLOYEE where Gender= ‘M’ AND Grade= ‘A’;
(iv) Select name from EMPLOYEE where Salary=8000 AND NOT Grade=’B’ ;
Choose the correct option
(A) Both (i) and (ii)
(B) Both (ii) and (iii)
(C) Only (iii)
(D) Only (iv)
(b) What will be the output of the following command?
Select Name, DOJ from EMPLOYEE where Gender = “F” order by Name;
(c) Aman has given the following command to obtain the total salary of female employees.
“SELECT sum(salary) FROM Employee;”
Name
Jugal
Sandeep
Shyam
But she is not getting the desired result. Help her by writing the correct command.
(i) select sum(salary) from EMPLOYEE where group by ‘F’;
(ii) select sum (salary) from EMPLOYEE where group by ‘F’ ;
(iii) select sum(salary) from EMPLOYEE where group by sex= ‘F’
(iv) select sum(salary) from EMPLOYEE group by sex having sex= ‘F’;
(d) Help Raman to write the command to display the name of the employee having more
experience:
(i) select name, min(DOJ) from EMPLOYEE;
(ii) select name, max(DOJ) from EMPLOYEE;
(iii) select name, min(DOJ) from EMPLOYEE group by name;
(iv) select name, maximum(DOJ) from EMPLOYEE;
(e) State the command to display the average(salary) of employees of each grade.
(i) select grade, average(salary) from EMPLOYEE where group by Grade;
(ii) select grade, avg(salary) from EMPLOYEE where grade= ‘A’, ‘B’, ‘C’;
(iii) select grade, avg(salary) group by Grade from EMPLOYEE ;
(iv) select grade, avg(salary) from EMPLOYEE group by Grade ;
PART B
SECTION – I
24. Write a small python code to create a dataframe with column heading (a and b) from the
list given below:
[[1, 2], [3, 4], [5, 6], [7, 8]]
25. What is the purpose of pow function? Explain with the help of an example.
OR
What is the purpose of mod function? Explain with the help of an example.
26. What will be the output of following SQL commands:
a. Select round(3456123.666,-2);
b. Select round(9981661.88,-3);
27. Consider the following Series object, S11:
Write statements to do the following :
(a) Extract row t2’s column col2’s value.
(b) Extract row t4’s columns col2, col3 and Res.
28. Gayatri writes the following commands with respect to a table employee having fields:
EMPNO, NAME, DEPARTMENT, COMMISSION
Command1: select count(*) from employee;
Command2: select count(commission) from employee;
She gets the output as 4 for the first command but gets an output 3 for the second command.
Explain the output with justification.
29. Write SQL query for the following
(a) Display 5 characters extracted from 6th right character onwards from string
“INFORMATICS”.
(b) Display number of characters in the string “INFORMATICS PRACTICES”.
OR
Explain the difference between Now() and Sysdate() functions using an example.
30. Consider the following DataFrame, classframe given as under. Write commands to:
(a) Add a new column ‘Address’ to the Dataframe with values (Barrackpore,
Sealdah, Ichapore, Sodepur)
(b) Add a new row with values (5, Anita, X, F, 9.8, Commerce) having index St5
31. Expand the following terms related to Computer Networks:
(a) NIC (b) SMTP (c) PPP (d) MAC
32. As a citizen of India, what advise you should give to others for e-waste disposal?
33. Anushka is using her internet connection to book a flight ticket. This is a classic example of
leaving a trail of web activities carried by her. What do we call this type of activity? What
is the risk involved by such king of activity?
SECTION – II
34. Consider two objects m and n. m is a list whereas n is a series. Both have values:
10,20,30,40
What will be the output of the following two statements considering that the above objects have
been created already.
(a) print(m*2) (b) print(n*2)
Justify your answer .
35. Explain the difference between Phishing, Identity theft and Spamming.
OR
What do you Hacking and Cracking? How to be safe from these?
36. Generally ten different prices of a stock are stored. However for ABC Company only 5
prices are available for a day: [74.25, 76.06, 69.5, 72.55, 81.5].
Write a program to create a bar chart with the given prices but the graph should be plotted
between the limits -2 to 10 on x-axis.
OR
Plot a histogram for the above given data.
37. Consider the following table GAMES. Write SQL commands for the following statements.
(a) To display the details of those GAMES which are having prizemoney more than
7000.
(b) To display sum of PrizeMoney for each Type of GAMES.
(c) To display the total number of games available in the above table GAMES
SECTION – III
38. Given a dataframe namely sal as shown below:
Qtr1 Qtr2 Qtr3 Qtr4
North 65 83 92 84
South 85 82 92 93
East 83 84 87 86
West 74 83 93 92
Central 82 84 94 87
Write statement to do the following :
(a) Change the indexes form “North”, “South”, “East”, “West”, “Central” to “N”, “S”,
“E”, “W”, “C” respectively.
(b) How will the dataframe look like after executing the statements of part(a).
(c) Write code to store the dataframe in a csv file sal.csv whose path is d:\sal.csv
(d) Add a new column with the name “Campgn” and fill with value 100 for each row.
(e) Write code to print the top 3 rows of the dataframe
39. Write the SQL functions which will perform the following operations:
(a) To display the name of the month of the current date.
(b) To remove spaces from the beginning and end of a string. “ Panorama “.
(c) To display the name of the day eg . Friday or Sunday from your date of birth, dob.
(d) To display the starting position of your first name(fname) from your whole name
(name).
(e) To compute the remainder of division between two numbers, n1 and n2.
OR
Consider the Salesman table with the following data:
SNO SNAME SALARY BONUS DATEOFJOI
N
A01 Beena Mehta 30000 45.23 29-10-2019
A02 K. L. Sahay 50000 25.34 13-03-2018
B03 Nisha
Thakur 30000 35.00 18-03-2017
B04 Leela Yadav 80000 NULL 31-12-2018
C05 Gautam Gola 20000 NULL 23-01-1989
C06 Trapti Garg 70000 12.37 15-06-1987
D07 Neena
Sharma 50000 27.89 18-03-1999
Write SQL queries using SQL functions to perform the following operations:
(a) Display salesman name and bonus after rounding off to zero decimal places.
(b) Display the position of occurrence of the string “ta” in salesman names.
(c) Display four characters from salesman name starting from second character.
(d) Display the year for the date of join of salesman.
(e) Display the names of salesmen having two consecutive ‘e’ in their name
40. Write short note on the following:
(a) Ethernet Card
(b) RJ-45 connector
(c) RJ-11 Connector
(d) LAN
(e) MAC address