Official Paper

KVS PGT Computer Science Official Paper (Held On: 23 Feb, 2023 Shift 2) (Previous Year Paper)

180 questions · 180 minutes · with answers · free

Language Proficiency (20 questions)

1

NOTABLE

Choose the word similar in meaning to the one given above.

  1. ((a))

    Prosperous

  2. ((b))

    Comfortable

  3. ((c))

    Distinguished

  4. ((d))

    Average

Show Answer
Answer: ((c))

Distinguished

The correct answer is: Option 3 (Distinguished).

Key Points

  • The word "Notable" means worthy of attention or remarkable; someone or something that is significant or outstanding in some way. (उल्लेखनीय)
  • Example: She made a notable contribution to the success of the project.
  • "Distinguished" refers to someone or something that stands out because of excellence, achievement, or eminence. (प्रसिद्ध, विशिष्ट)
  • Example: He is a distinguished professor known for his groundbreaking research.
  • Hence, "distinguished" is the word most similar in meaning to "notable".

Therefore, the correct answer is: Option 3 (Distinguished).

Additional Information

Here are the other options explained along with their Hindi meanings and example sentences:

  • Prosperous (समृद्ध): Someone who is wealthy or successful, especially in financial matters.
  • Example: They live in a prosperous neighborhood with beautiful houses.
  • Comfortable (आरामदायक): Free from stress or discomfort; providing physical ease.
  • Example: The sofa is so comfortable that I could sit on it all day.
  • Average (औसत): Something typical or normal, not outstanding or remarkable.
  • Example: His performance in the test was average, not exceptional.
2

Choose the word opposite in meaning to the one given above.

OBSCURE

  1. ((a))

    Ponderous 

  2. ((b))

    Thoughtful 

  3. ((c))

    Heedless

  4. ((d))

    Apparent

Show Answer
Answer: ((d))

Apparent

The correct answer is: Apparent.

Key Points

  • The word "obscure" means something that is not clearly understood or is hidden; it refers to something vague or unclear. (अस्पष्ट)
  • Example: The meaning of the poem was obscure to most readers, requiring further analysis.
  • "Apparent" refers to something that is clearly visible or easily understood; it is the opposite of obscure, as it denotes clarity or obviousness. (स्पष्ट)
  • Example: It was apparent from her expression that she was excited about the news.
  • Hence, we can infer that the opposite of 'obscure' is 'apparent'.

Therefore, the correct answer is: Apparent.

Additional Information

Here are the other options explained along with their Hindi meanings and example sentences:

  • Ponderous (भारी): Something that is heavy or slow-moving, especially due to weight or complexity.
  • Example: The speaker's ponderous style made it hard for the audience to stay engaged.
  • Thoughtful (विचारशील): Showing careful consideration or attention to details.
  • Example: She gave him a thoughtful gift that reflected his love for books.
  • Heedless (लापरवाह): Not paying attention; careless or reckless.
  • Example: He drove heedlessly through the busy streets, ignoring the traffic signals.
3

Identify the part of speech of the underlined word in the following sentence.

I cannot give him credit for this.

  1. ((a))

    Preposition

  2. ((b))

    Adverb

  3. ((c))

    Adjective

  4. ((d))

    Interjection

Show Answer
Answer: ((a))

Preposition

The correct answer is Option 1 i.e 'Preposition'.

Key Points

  • The underlined word "for" shows the relationship between "credit" and "this" in the sentence "I cannot give him credit for this."
  • Prepositions are words that link nouns or pronouns to other words in a sentence and show relationships such as direction, location, time, or reason.
  • Here, "for" indicates the reason or purpose for giving credit, which is a typical function of a preposition.
  • Other parts of speech (adverb, adjective, interjection) do not fit the function of the word "for" in this context.

Therefore, the correct answer is- Option 1.

Additional Information

  • Adverb: An adverb modifies a verb, adjective, or another adverb by providing information about how, when, where, or to what extent something happens. "For" does not do this in the sentence.
  • Adjective: An adjective describes or modifies a noun or pronoun. "For" is not used to describe a noun in this context.
  • Interjection: An interjection is a word or phrase that expresses emotion or exclamation. "For" is not used in this way in the sentence.
4

Many aspire for greatness.

Choose the option in which the Voice in the above sentence has been correctly changed into Passive Voice.

  1. ((a))

    Greatness is being aspired by many.

  2. ((b))

    Greatness is aspired by many.

  3. ((c))

    Greatness has been aspired for by many. 

  4. ((d))

    Greatness is aspired for by many.

Show Answer
Answer: ((d))

Greatness is aspired for by many.

The correct answer is Option 4.

 

Key Points

  • Passive voice structure: The object of the active voice sentence becomes the subject of the passive voice sentence.
  • In the active voice, the sentence is: Many aspire for greatness.
  • To convert to passive voice: Place the object "greatness" at the beginning.
  • The verb "aspire" is always used with the preposition "for", so in passive, it should be "is aspired for".
  • Add "by many" to indicate the doer.
  • The correct passive structure is: Greatness is aspired for by many.

Therefore, the correct answer is Option 4.

 

Correct Sentence: "Greatness is aspired for by many."

 

Additional Information

  • Option 1: "Greatness is being aspired by many." – Incorrect tense and missing "for".
  • Option 2: "Greatness is aspired by many." – Missing the preposition "for".
  • Option 3: "Greatness has been aspired for by many." – Incorrect tense (present perfect passive instead of simple present).
  • Option 4: "Greatness is aspired for by many." – Correct usage of passive voice, preposition, and tense.
5

Hari said to me, "I want to help you."

Choose the option in which the above sentence has been correctly changed into Indirect Narration.

  1. ((a))

    Hari told me that I wanted to help you.

  2. ((b))

    Hari told me that he wanted to help you

  3. ((c))

    Hari told me that he wanted to help me. 

  4. ((d))

    Hari supported me with an offer of help.

Show Answer
Answer: ((c))

Hari told me that he wanted to help me. 

The correct answer is Option 3.

 

Key Points

  • Indirect Speech: Hari said to me, "I want to help you." changes to indirect as: Hari told me that he wanted to help me.
  • Key Conversions:
  • Pronoun Change:
  • "I" (Hari) changes to "he" in indirect speech.
  • "you" (me) changes to "me" in indirect speech.
  • Tense Change:
  • Simple present "want" changes to simple past "wanted" in indirect speech.
  • Reporting Verb:
  • "said to" changes to "told".
  • Punctuation and Format:
  • No quotation marks in indirect speech.
  • The word "that" is used to connect the reporting clause and the reported speech.

Therefore, the correct answer is Option 3.

 

Correct Sentence: Hari told me that he wanted to help me.

 

Additional Information

  • Option 1: Hari told me that I wanted to help you.
  • Incorrect pronoun usage: "I" and "you" are not converted properly.
  • Option 2: Hari told me that he wanted to help you.
  • Incorrect pronoun usage: "you" should be "me" based on the original conversation.
  • Option 4: Hari supported me with an offer of help.
  • This option changes the meaning and structure entirely, not a correct indirect speech conversion.
6

Choose the option in which the following words/phrases have been rearranged to form a meaningful and grammatically correct sentence.

(A) to the

(B) we should

(C) ourselves

(D) accommodate

(E) circumstances

  1. ((a))

    (A) (C) (B) (D) (E) 

  2. ((b))

    (C) (B) (D) (A) (E)

  3. ((c))

    (B) (D) (C) (A) (E)

  4. ((d))

    (D) (E) (A) (B) (C)

Show Answer
Answer: ((c))

(B) (D) (C) (A) (E)

The correct answer is Option 3.

 

Key Points

  • Let's analyze the fragments:
  • (B) we should is the best way to start a suggestion sentence.
  • (D) accommodate naturally follows "we should" to form "we should accommodate."
  • (C) ourselves comes next, resulting in "we should accommodate ourselves."
  • (A) to the is the connecting phrase before the final part.
  • (E) circumstances completes the sentence logically.
  • The rearranged sentence reads:

We should accommodate ourselves to the circumstances.

  • This is both grammatically correct and meaningful.

 

Coherent sentence after rearrangement:

We should accommodate ourselves to the circumstances.

7

Identify the part of the following sentence which has an error in it.

All kinds (a) / of stationery (b) / is (c) / available here.(d)

  1. ((a))

    (a)

  2. ((b))

    (b)

  3. ((c))

    (c)

  4. ((d))

    (d)

Show Answer
Answer: ((c))

(c)

The correct answer is Option 3.

 

Key Points

  • The error lies in the use of the verb "is", which does not agree with the plural subject "all kinds".
  • The phrase "all kinds" is plural and thus requires a plural verb, such as "are".
  • The correct verb should be "are" instead of "is".
  • Thus, the error is located in part C of the sentence.

Therefore, the correct answer is C.

 

Correct Sentence: "All kinds of stationery are available here."

 

Additional Information

  • A: "All kinds" – This part is grammatically correct and does not require any changes.
  • B: "of stationery" – This part is grammatically correct and does not require any changes.
  • D: "available here" – This part is grammatically correct and does not require any changes.
8

Fill in the blank in the following sentence by choosing option out of the given ones.

He did not come to the party, _______

  1. ((a))

    wasn't he

  2. ((b))

    didn't he

  3. ((c))

    was he

  4. ((d))

    did he

Show Answer
Answer: ((d))

did he

The correct answer is Option 4.

 

Key Points

  • This sentence requires a question tag to match the main clause in tense and polarity.
  • When the main clause is negative ("did not come"), the tag should be positive and use the same auxiliary verb ("did he?").
  • "Did he" is the correct question tag for "He did not come to the party".
  • Thus, the correct choice is Option 4: did he.

Therefore, the correct answer is Option 4.

 

Correct Sentence: "He did not come to the party, did he?"

 

Additional Information

  • Option 1: wasn't he – Incorrect, as it does not match the auxiliary verb "did" used in the main clause.
  • Option 2: didn't he – Incorrect, as the tag must be positive when the main clause is negative.
  • Option 3: was he – Incorrect, as "was" is not the correct auxiliary verb for the verb "come" in this context.
  • Option 4: did he – Correct, as it matches the auxiliary verb and the polarity required for the question tag.
9

Fill in the blank in the following sentence by choosing option out of the given ones. 

Rita ______ her seat in the class.

  1. ((a))

    dropped into

  2. ((b))

    dropped off in

  3. ((c))

    fell in with

  4. ((d))

    got on with

Show Answer
Answer: ((a))

dropped into

The correct answer is 'dropped into'.

 

Key Points

  • The phrase "dropped into" is the correct choice as it conveys the action of taking a seat, which fits the context of the sentence.
  • Options 2, 3, and 4 are incorrect because they do not match the context or grammatical structure of the sentence.

Therefore, the correct answer is Option 1.

 

Complete Sentence: "Rita dropped into her seat in the class."

 

Additional Information

  • Option 2: "dropped off in" is incorrect because "dropped off" typically refers to delivering or falling asleep, which does not fit this sentence.
  • Option 3: "fell in with" is incorrect because it means to become friendly with or to agree with, which is unrelated to the context.
  • Option 4: "got on with" is incorrect because it refers to maintaining a good relationship or continuing an activity, which does not apply here.
10

Fill in the blank in the following sentence by choosing option out of the given ones.

One should not be devoid _____ decency.

  1. ((a))

    of

  2. ((b))

    on

  3. ((c))

    off

  4. ((d))

    into

Show Answer
Answer: ((a))

of

The correct answer is 'of'.

 

Key Points

  • The word "devoid" always takes the preposition "of" to indicate the absence or lack of something.
  • Option 2 (on), 3 (off), and 4 (into) are grammatically incorrect when used with the word "devoid."
  • The correct phrase is "devoid of decency," which means lacking decency.

Therefore, the correct answer is Option 1.

 

Complete Sentence: "One should not be devoid of decency."

 

Additional Information

  • Option 2: "on" is incorrect because "on" does not fit the phrase "devoid on."
  • Option 3: "off" is incorrect because "off" cannot be used with "devoid."
  • Option 4: "into" is incorrect because it does not convey the correct meaning in this context.

नीचे दिए गए गद्यांश को पढ़कर सर्वाधिक उचित विकल्प का चयन कीजिए-

यहाँ आकर और यहाँ के ���ोगों तथा उनकी कार्य प्रणाली को देखकर मैं अनुमान करता हूँ कि हमारे देश में दो चीजें बहुत आवश्यक हैं- जन साधारण में शिक्षा का प्रसार और श्रमिक आन्दोलन भारत की प्रगति का मूल जनशक्ति ही है। इसलिए हमें जन शिक्षा और श्रमिक संगठन का प्रयास करना चाहिए।

11

लेखक ने क्या देखकर अनुमान लगाया ?

  1. ((a))

    लोगों के रहन-सहन का तरीका

  2. ((b))

    लोगों के कार्य करने का तरीका 

  3. ((c))

    लोगों के रोज़गार की उत्कृष्टता 

  4. ((d))

    लोगों के सोचने-समझने का स्तर

Show Answer
Answer: ((b))

लोगों के कार्य करने का तरीका 

इसका सही उत्तर "लोगों के कार्य करने का तरीका" है।

महत्वपूर्ण बिंदु

गद्यांश के अनुसार,

  • लेखक ने लोगों की कार्य प्रणाली को देखकर यह अनुमान लगाया कि जन साधारण में शिक्षा का प्रसार और श्रमिक आन्दोलन की आवश्यकता है।
  • उनके मत में, भारत की प्रगति का मूल जनशक्ति है, जिसे जन शिक्षा और श्रमिक संगठन से सुदृढ़ किया जा सकता है।

अतिरिक्त जानकारी अन्य विकल्प:

लोगों के रहन-सहन का तरीका -

  • यह भी महत्वपूर्ण है, लेकिन लेखक ने कार्य प्रणाली को प्राथमिकता दी है।

लोगों के रोज़गार की उत्कृष्टता -

  • यह विकल्प भी सटीक नहीं है क्योंकि कार्य प्रणाली पर अधिक जोर दिया गया है।

लोगों के सोचने-समझने का स्तर -

  • यह महत्वपूर्ण है, लेकिन लेखक ने इसे सीधे नहीं सोचा है।

नीचे दिए गए गद्यांश को पढ़कर सर्वाधिक उचित विकल्प का चयन कीजिए-

यहाँ आकर और यहाँ के लोगों तथा उनकी कार्य प्रणाली को देखकर मैं अनुमान करता हूँ कि हमारे देश में दो चीजें बहुत आवश्यक हैं- जन साधारण में शिक्षा का प्रसार और श्रमिक आन्दोलन भारत की प्रगति का मूल जनशक्ति ही है। इसलिए हमें जन शिक्षा और श्रमिक संगठन का प्रयास करना चाहिए।

12

कौन-सी दो बातें आवश्यक कही गई हैं?

  1. ((a))

    शिक्षा की गुणवत्ता और जन आन्दोलन

  2. ((b))

    शिक्षा का प्रसार और श्रमिक आन्दोलन

  3. ((c))

    जन आन्दोलन और श्रमिक संगठन

  4. ((d))

    श्रमिक संगठन और कार्य प्रणाली

Show Answer
Answer: ((b))

शिक्षा का प्रसार और श्रमिक आन्दोलन

इसका सही उत्तर "शिक्षा का प्रसार और श्रमिक आन्दोलन" है।

महत्वपूर्ण बिंदु

गद्यांश के अनुसार,

  • लेखक के अनुसार, भारत की प्रगति का मूल जनशक्ति है।
  • इसलिए, उन्होंने जन साधारण में शिक्षा के प्रसार और श्रमिक आन्दोलन को आवश्यक बताया है।

अतिरिक्त जानकारी अन्य विकल्प:

शिक्षा की गुणवत्ता और जन आन्दोलन -

  • यह विकल्प सही उत्तर को पूरी तरह से स्पष्ट नहीं करता है।

जन आन्दोलन और श्रमिक संगठन -

  • इस विकल्प में शिक्षा का उल्लेख नहीं है, जो आवश्यकताएँ बताई गई हैं।

श्रमिक संगठन और कार्य प्रणाली -

  • यह विकल्प सही उत्तर नहीं है क्योंकि इसमें शिक्षा का प्रसार शामिल नहीं है।
13

भारत की उन्नति का आधार है।

  1. ((a))

    शिक्षा का प्रसार 

  2. ((b))

    श्रमिक संगठन

  3. ((c))

    जनशक्ति

  4. ((d))

    कार्य प्रणाली

Show Answer
Answer: ((c))

जनशक्ति

इसका सही उत्तर "जनशक्ति" है।

महत्वपूर्ण बिंदु

गद्यांश के अनुसार,

  • लेखक के अनुसार, भारत की प्रगति का मूल जनशक्ति है।
  • इसीलिए, जनशक्ति को सशक्त बनाने के लिए जन साधारण में शिक्षा का प्रसार और श्रमिक आन्दोलन आवश्यक हैं।

अतिरिक्त जानकारी अन्य विकल्प:

शिक्षा का प्रसार -

  • यह महत्वपूर्ण है लेकिन इसका मुख्य आधार जनशक्ति है।

श्रमिक संगठन -

  • श्रमिक संगठन आवश्यक हैं, लेकिन यह भी जनशक्��ि पर निर्भर करता है।

कार्य प्रणाली -

  • यह महत्वपूर्ण है, लेकिन इसका सीधा संबंध जनशक्ति से नहीं है।
14

गद्यांश के अनुसार हमें निम्नलिखित में से क्या करने की आवश्यकता है?

  1. ((a))

    सभी को नौकरी देना

  2. ((b))

    सभी को शिक्षित करना

  3. ((c))

    सभी को व्यापार देना

  4. ((d))

    सभी के द्वारा आंदोलन करना

Show Answer
Answer: ((b))

सभी को शिक्षित करना

इसका सही उत्तर "सभी को शिक्षित करना" है।

महत्वपूर्ण बिंदु

गद्यांश के अनुसार,

  • लेखक ने बताया कि भारत की उन्नति के लिए सभी को शिक्षित करना आवश्यक है।
  • उन्होंने जन साधारण में शिक्षा का प्रसार और श्रमिक आन्दोलन की आवश्यकता पर बल दिया है।

अतिरिक्त जानकारी अन्य विकल्प:

सभी को नौकरी देना -

  • यह महत्वपूर्ण है, लेकिन इसका उल्लेख गद्यांश में नहीं किया गया है।

सभी को व्यापार देना -

  • यह भी महत्वपूर्ण है, लेकिन इसका उल्लेख गद्यांश में नहीं है।

सभी के द्वारा आंदोलन करना -

  • आंदोलन आवश्यक हो सकता है, लेकिन मुख्य आवश्यकता सभी को शिक्षित करना है।
15

'श्रमिक' शब्द का मूल शब्द और प्रत्यय है-

  1. ((a))

    श्रम+इक

  2. ((b))

    परिश्रम + इक

  3. ((c))

    श्रम+ मिक

  4. ((d))

    श्र+मिक

Show Answer
Answer: ((a))

श्रम+इक

'श्रमिक' शब्द का मूल शब्द और प्रत्यय है- श्रम+इक

Key Points

  • प्रत्यय वे शब्द हैं जो दूसरे शब्दों के अन्त में जुड़कर, अपनी प्रकृति के अनुसार, शब्द के अर्थ में परिवर्तन कर देते हैं।
  • प्रत्यय शब्द दो शब्दों से मिलकर बना है - प्रति + अय।
  • प्रति का अर्थ होता है 'साथ में, पर बाद में" और अय का अर्थ होता है "चलने वाला", अत: प्रत्यय का अर्थ होता है साथ में पर बाद में चलने वाला।
  • 'इक' प्रत्यय वाले शब्द -
  • शारीरिक ( शरीर + इक )
  • नैतिक ( नीति + इक)
  • पारिवारिक ( परिवार + इक )
  • धार्मिक (धर्म + इक)
  • दैनिक (दिन + इक )
16

'सामाजिक' शब्द में _______ प्रत्यय है।

  1. ((a))

  2. ((b))

    इक

  3. ((c))

    जिक

  4. ((d))

    ईक

Show Answer
Answer: ((b))

इक

'सामाजिक' शब्द में इक प्रत्यय है।

Key Points

  • समाज  + इक = सामाजिक
  • 'समाज' मूलशब्द और 'इक' प्रत्यय
  • अर्थ- समाज से संबंधित
  • विलोम शब्द- 'असामाजिक'
  • विशेषण शब्द

Important Points

  • प्रत्यय शब्द के अंत में जुड़ता है।

Additional Informationकुछ महत्वपूर्ण प्रत्यय शब्द- 

  • इक- साप्ताहिक, वैयक्तिक, राजनैतिक, आर्थिक।
  • इत- पठित, व्यथित, फलित, पुष्पित
  • अक- लेखक, पाठक, कारक, गायक
  • अनीय- माननीय, रमणीय, दर्शनीय, पूजनीय, श्रवणीय
  • आई- पण्डिताई, ठकुराई, लड़ाई, चतुराई, चौड़ाई
  • अना- घटना, तुलना, वन्दना, वेदना
17

'सुबोध' का विलोम है-

  1. ((a))

    अगम्य

  2. ((b))

    दुर्लभ

  3. ((c))

    दुसाध्य

  4. ((d))

    दुर्बोध

Show Answer
Answer: ((d))

दुर्बोध

'सुबोध' का विलोम है- दुर्बोध

Key Points

  • विलोम - जो शब्द किसी एक शब्द के विपरीत अर्थ को व्यक्त करते हैं, वे विलोम शब्द कहलाते हैं।

Additional Information कुछ अन्‍य व‍िलोम शब्‍द- 

शब्‍दविलोम
निरागअनुराग
उन्‍मूलनरोपण
प्रतिघातआघात
ऐच्छिकअनिवार्य
पूर्ववर्तीपरवर्ती
आलोकतिमिर
कृत्रिमप्राकृतिक
निवृत्तिप्रवृत्ति
18

'तथास्तु' का संधि-विच्छेद है-

  1. ((a))

    तथ+ आस्तु

  2. ((b))

    तथा+सतु

  3. ((c))

    तथा+अस्तु

  4. ((d))

    तथा + आस्तु

Show Answer
Answer: ((c))

तथा+अस्तु

'तथास्तु' का संधि-विच्छेद है- तथा+अस्तु

Key Points

  • 'तथास्तु' का सही संधि-विच्छेद तथा + अस्तु है, जिसका अर्थ 'ऐसा ही हो' या 'आपकी इच्छा पूरी हो' होता है, और इसमें दीर्घ स्वर संधि (आ + अ = आ) लागू होती है, क्योंकि 'तथा' का 'आ' और 'अस्तु' का 'अ' मिलकर 'आ' बनाते हैं, और यह शब्द आशीर्वाद के रूप में प्रयोग होता है।

Important Pointsसन्धि  तीन प्रकार के होते है –

  1. स्वर सन्धि (स्वरों का स्वरों से मेल )
  2. व्यंजन सन्धि (स्वरों का व्यंजनों से मेल )
  3. विसर्ग सन्धि (तीनो का मेल )
स्वर सन्धिदो स्वरों के मेल से होने वाले विकार (परिवर्तन) को स्वर-संधि कहते हैं।
व्यंजन सन्धिव्यंजन का व्यंजन से अथवा किसी स्वर से मेल होने पर जो परिवर्तन होता है उसे व्यंजन संधि कहते हैं।
विसर्ग सन्धिजब संधि करते समय  विसर्ग के बाद स्वर या व्यंजन वर्ण के आने से जो विकार उत्पन्न होता है, हम उसे विसर्ग संधि कहते हैं।
दीर्घ संधिह्रस्व या दीर्घ अ, आ, इ, ई, उ, ऊ और ऋ के बाद ह्रस्व या दीर्घ अ, आ, इ, ई, उ, ऊ और ऋ स्वर आ जाएँ तो दोनों मिलकर दीर्घ आ, ई, ऊ और ऋ हो जाते हैं। इस मेल से बनने वाली संधि को दीर्घ स्वर संधि कहते हैं।
19

'प्रगति' के पर्यायवाची शब्द हैं-

  1. ((a))

    उत्थान, अभ्युदय

  2. ((b))

    उन्नति, विकर्षण

  3. ((c))

    विकास, उत्कृष्ट

  4. ((d))

    उत्थान, उत्कृष्ट

Show Answer
Answer: ((a))

उत्थान, अभ्युदय

'प्रगति' के पर्यायवाची शब्द हैं- उत्थान, अभ्युदय

Key Points 

  • पर्यायवाची - ऐसे शब्द जिनके अर्थ समान हों, पर्यायवाची शब्द कहलाते हैं।

Additional Information 

  कुछ महत्वपूर्ण पर्यायवाची शब्द -

शब्दपर्यायवाची शब्द
आनंदहर्ष, खुशी, आनंदिता, प्रीति, उत्साह, प्रफुल्लित।
कपटदगा, दगाबाजी, ठगी, फरेब, छल, धोखा, धूर्त्तता।
अटलस्थिर, अचल, दृढ, अडिग, चिरस्थायी, पक्का।
क्रोधरोष, अमर्ष, गुस्सा, आक्रोश, कोह, प्रतिघात खीझ।
भलाईउपकार, नेकी,अच्छाई, परोपकार, कल्याण, अहसान।
खेददु:ख, पीड़ा, व्यथा, कष्ट, संकट, शोक, क्लेश, वेदना।
चतुरविज्ञ, निपुण, नागर, पटु, कुशल, दक्ष, प्रवीण, योग्य।
20

तत्सम तद्भव का असंगत मेल है.

  1. ((a))

    कर्म- काम

  2. ((b))

    क्षीर-खीर

  3. ((c))

    गर्दभ-गधा

  4. ((d))

    कंगन-कंकण

Show Answer
Answer: ((d))

कंगन-कंकण

तत्सम-तद्भव का असंगत मेल है- कंगन-कंकण

  • 'कंगन' एक तद्भव शब्द है, जो संस्कृत के तत्सम शब्द "कंकण" से विकसित हुआ है, जिसका अर्थ हाथ में पहनने वाला आभूषण है; संस्कृत के 'कंकण' से हिंदी में 'कंगन' बनता है, जो समय के साथ सरल हो गया है।

Key Points

  • तत्सम - जिन शब्दों को संस्कृत से बिना किसी परिवर्तन के ले लिया जाता है, उन्हें तत्सम शब्द कहते हैं। 
  • जैसे - आम्र, गृह, मार्ग आदि।
  • तद्भव - जिन शब्दों में समय और परिस्थितियों के कारण कुछ परिवर्तन होने से जो शब्द बने हैं, उन्हें तद्भव कहते हैं। 
  • जैसे- आम्र, घर, पग आदि।​

Additional Informationकुछ महत्वपूर्ण ​तत्सम और तद्भव शब्द -

तत्समतद्भव
चटिकाचिड़िया
हरिद्राहल्दी
प्रस्तरपत्थर
इष्टिकाईंट
उज्ज्वलउजला
कुंभकारकुम्हार
सूचिकासुई
मौक्तिकमोती
कृषककिसान
अक्षोटअखरोट

GK, LR & Computer (20 questions)

21

Who among the following has the power to grant Pardons as per the Constitution of India?

  1. ((a))

    President

  2. ((b))

    Supreme Court

  3. ((c))

    Parliament

  4. ((d))

    Attorney General of India

Show Answer
Answer: ((a))

President

The correct answer is President.

Key Points

  • Article 72 of the Indian Constitution empowers the President of India to grant pardons, reprieves, respites, or remissions of punishment, and to suspend, remit, or commute the sentence of any person convicted of an offense.
  • This power applies to cases where the punishment or sentence is by a court martial, or where the punishment is for an offense against any law relating to matters to which the executive power of the Union extends.
  • The President can exercise this power in cases of death sentences as well, making it a unique authority under the Indian Constitution.
  • The power of pardon is not absolute and is exercised on the advice of the Council of Ministers.
  • The Supreme Court of India has clarified that this power is subject to judicial review if exercised arbitrarily or unfairly.

Additional Information

  • Power to Grant Pardon:
  • The President of India, under Article 72, has the exclusive power to grant pardons, commutations, and remissions in cases of federal offenses or offenses against Union laws.
  • This power is exercised primarily for humanitarian reasons or to correct potential judicial errors.
  • It includes offenses like death sentences, offenses against Union laws, and court-martial convictions.
  • Similar Powers of Governors:
  • Under Article 161, the Governor of a state can grant pardons, reprieves, respites, or remissions of punishment for offenses against laws within the state's jurisdiction.
  • However, the Governor cannot grant pardon in cases of death sentences, which remains exclusively under the President's authority.
  • Judicial Review:
  • The judiciary has the authority to review the exercise of pardon power to ensure that it is not arbitrary, discriminatory, or based on malice.
  • This ensures transparency and accountability in the executive's use of this discretionary power.
  • Famous Cases:
  • There have been notable cases like the pardon of death row convicts in India where the President's use of this power has been critically analyzed.
  • Examples include petitions for mercy in cases like Kehar Singh v. Union of India (1989), which clarified the scope of judicial review of pardons.
  • Supreme Court's Interpretation:
  • The Supreme Court has ruled that the pardon power cannot be exercised arbitrarily and must conform to constitutional principles.
  • For example, in Maru Ram v. Union of India, the Court stated that the pardon power must align with the principles of fairness and justice.

Important Points

  • Article 72: Empowers the President to exercise the power of pardon for offenses under Union laws and death sentences.
  • Article 161: Grants similar powers to the Governor for state-specific offenses, except for death sentences.
  • Judicial Review: Ensures the pardon power is exercised fairly and transparently.
  • Death Sentence: The President's power is unique in cases of death sentences, unlike the Governor's.
  • Council of Ministers: The President exercises this power based on the advice of the Council of Ministers, making it a constitutional obligation.
22

Which among the following is the longest waterway in India?

  1. ((a))

    Brahmaputra river between Sadiya and Dhubri. 

  2. ((b))

    West-Coast canal in Karnataka

  3. ((c))

    Ganga river between Allahabad and Haldia 

  4. ((d))

    Narmada river in the area over East West canal

Show Answer
Answer: ((c))

Ganga river between Allahabad and Haldia 

The correct answer is Ganga river between Allahabad and Haldia.

Key Points

  • The stretch of the Ganga river between Allahabad and Haldia is the longest operational waterway in India, designated as National Waterway 1 (NW-1).
  • It covers a distance of approximately 1,620 kilometers, making it a vital link for cargo and passenger movement across the states of Uttar Pradesh, Bihar, Jharkhand, and West Bengal.
  • NW-1 passes through important cities like Varanasi, Patna, Bhagalpur, and Kolkata, connecting the northern hinterlands to the eastern coastline.
  • The Inland Waterways Authority of India (IWAI) is responsible for the development and regulation of this waterway to ensure smooth navigation.
  • NW-1 facilitates the transportation of bulk goods such as coal, cement, and fertilizers, and also supports passenger ferry services.

Additional Information

  • National Waterways in India:
  • The Inland Waterways Authority of India (IWAI) has designated several rivers and canals as National Waterways to promote inland water transport.
  • India has a total of 111 National Waterways, with five major waterways being prioritized for development.
  • Examples include NW-2 (Brahmaputra River) and NW-3 (West Coast Canal, Kerala).
  • National Waterway 1 (NW-1):
  • Stretch: From Allahabad (Prayagraj) in Uttar Pradesh to Haldia in West Bengal, covering a distance of 1,620 km.
  • It is part of the Jal Marg Vikas Project (JMVP), aimed at improving infrastructure and navigation on this route.
  • The World Bank is providing financial support for the development of NW-1 under the JMVP.
  • Major commodities transported include coal, fly ash, food grains, fertilizers, cement, and stone chips.
  • Other Waterways in India:
  • Brahmaputra River between Sadiya and Dhubri (NW-2): This waterway spans 891 km and is a key route in the northeastern region for the transportation of goods and people.
  • West Coast Canal (NW-3): Extending 168 km, this waterway is located in Kerala and connects Kottapuram to Kollam.
  • Narmada River: While it is a significant river in western India, it is not designated as a National Waterway.
  • Importance of Inland Waterways:
  • Inland waterways are a cost-effective and environmentally friendly mode of transport compared to road and rail.
  • They help in reducing traffic congestion on roads and railways, thus lowering transportation costs.
  • India's inland waterways have the potential to handle 54 million tonnes of cargo annually, with substantial scope for expansion.

Important Points

  • Jal Marg Vikas Project (JMVP):
  • Launched by the Government of India in 2014 to enhance the capacity and infrastructure of NW-1.
  • The project includes the construction of multi-modal terminals, navigational aids, and river information systems.
  • Funded by the World Bank and implemented by IWAI.
  • Challenges in Inland Waterways:
  • Issues like sedimentation, seasonal water flow, and lack of modern infrastructure hinder the full potential of inland water transport.
  • Environmental concerns such as impact on aquatic ecosystems need to be addressed during waterway development.
23

The diffusion of iron in Crystalline and metamorphic rocks results in soil developing a _____ colour

  1. ((a))

    Blackish

  2. ((b))

    Bluish

  3. ((c))

    Reddish

  4. ((d))

    Greenish

Show Answer
Answer: ((a))

Blackish

The correct answer is Reddish.

Key Points

  • The diffusion of iron in crystalline and metamorphic rocks leads to the formation of iron oxides, such as hematite (Fe2O3), which gives the soil a characteristic reddish colour.
  • Iron oxides are known for their reddish or rust-like hue, which is a result of the oxidation process when iron reacts with oxygen and moisture.
  • In regions with tropical or subtropical climates, the weathering of rocks often results in the formation of laterite soils, which are rich in iron oxides and appear reddish.
  • The reddish colour also indicates the presence of ferric iron compounds, which are the oxidized form of iron commonly found in well-drained soils.
  • The formation of reddish soil due to iron diffusion is a natural geological and chemical process, particularly in areas with high temperatures and significant weathering of rocks.

Additional Information

  • Iron Oxides and Soil Colour:
  • Iron oxides, such as hematite (red) and goethite (yellow to brown), are responsible for the red, yellow, and brown hues in soils.
  • The degree of oxidation determines the specific colour of the soil. For example, a higher oxidation state (ferric) results in a reddish colour, while a lower oxidation state (ferrous) gives a greenish or bluish appearance.
  • Laterite Soils:
  • Laterite soils are rich in iron and aluminum oxides, giving them a reddish or yellowish colour.
  • They are commonly found in tropical and subtropical regions like India, Brazil, and parts of Africa.
  • These soils are developed in hot and humid climates through intense weathering processes.
  • Soil Formation Process:
  • Soil forms through the weathering of parent rocks due to factors like temperature, water, and biological activity.
  • In crystalline and metamorphic rocks, minerals like iron undergo oxidation when exposed to air and water, forming iron oxides.
  • This process not only changes the colour of the soil but also affects its fertility and agricultural suitability.
  • Other Colours in Soils:
  • Blackish soil: Indicates the presence of organic matter, commonly found in regions with black cotton soil or volcanic rocks.
  • Bluish or greenish soil: Often associated with poorly drained soils where anaerobic conditions lead to the formation of ferrous iron compounds.
  • Yellowish soil: Typically results from the presence of hydrated iron oxides, such as limonite.
  • Global Examples:
  • Reddish soils are prevalent in regions like the Deccan Plateau in India, the Australian Outback, and parts of Africa.
  • These soils are often used for crops like millets, pulses, and groundnuts, although their fertility may need improvement through fertilizers.
24

Which of the following was founded after independence in India?

  1. ((a))

    Federation of the Indian Chamber of Commerce and Industries 

  2. ((b))

    All India Democratic Women's Association

  3. ((c))

    Indian Industrial and Commercial Congress

  4. ((d))

    Depressed Classes Association

Show Answer
Answer: ((a))

Federation of the Indian Chamber of Commerce and Industries 

The correct answer is All India Democratic Women's Association.

Key Points

  • The All India Democratic Women’s Association (AIDWA) was founded in 1981, post-Independence, making it the correct answer.
  • AIDWA is a progressive women’s organization in India, committed to advancing women's rights and addressing issues of gender inequality.
  • The organization works on promoting equality in areas such as education, health, and employment, and campaigns against domestic violence, dowry, and other social evils.
  • AIDWA has a significant presence across India with millions of members advocating for policy changes and societal reforms.
  • Its activities include organizing campaigns, legal aid, and awareness programs to empower women and ensure justice.

Additional Information

  • Federation of the Indian Chamber of Commerce and Industries (FICCI):
  • Established in 1927, FICCI is the oldest and largest apex business organization in India.
  • It was founded during the British rule and represents India's business community on various national and international platforms.
  • FICCI works to strengthen India's economic environment, promote entrepreneurship, and advocate for policy changes to boost industrial growth.
  • Indian Industrial and Commercial Congress:
  • Formed in 1920, this organization was created to provide a platform for Indian industrialists and businessmen during the colonial era.
  • It aimed to foster industrial development and advocate for Indian economic interests under British rule.
  • Depressed Classes Association:
  • Founded by Dr. B.R. Ambedkar in 1930, the Depressed Classes Association worked for the upliftment of socially marginalized communities.
  • The association aimed to fight caste-based discrimination and promote equality and justice for the oppressed classes.
  • Important Points:
  • Post-Independence organizations like AIDWA focus on tackling modern societal issues such as gender inequality and women's empowerment.
  • Pre-Independence organizations like FICCI, Indian Industrial and Commercial Congress, and Depressed Classes Association were primarily focused on addressing colonial policies and socio-economic challenges.
  • AIDWA's foundation in 1981 marks a significant movement toward gender equality in independent India.
25

After the Lahore session of Congress, 26th January 1930 was declared to be celebrated as which of the following in India ?

  1. ((a))

    National Unity Day

  2. ((b))

    Independence Day

  3. ((c))

    Swadeshi Day 

  4. ((d))

    Home Rule Day

Show Answer
Answer: ((a))

National Unity Day

The correct answer is Independence Day.

Key Points

  • The Lahore session of the Indian National Congress was held in December 1929, under the presidency of Pandit Jawaharlal Nehru.
  • During this session, the Congress passed the resolution of Purna Swaraj (complete independence) as its ultimate goal.
  • Following this resolution, 26th January 1930 was declared as Independence Day, to be celebrated across the country.
  • On this day, the national flag was hoisted, and the people of India pledged to achieve complete independence from British rule.
  • The choice of 26th January was symbolic, as it marked the anniversary of the 1927 Madras session of the Congress, where the demand for complete independence was first raised.

Additional Information

  • Lahore Session of 1929:
  • The Lahore session of the Indian National Congress marked a significant shift in the freedom struggle, as it adopted the goal of Purna Swaraj (complete independence).
  • The session also authorized the launch of the Civil Disobedience Movement, which aimed at non-violent resistance against British rule.
  • The tricolor flag was adopted as the national flag at this session, symbolizing unity and the aspiration for independence.
  • Significance of 26th January:
  • Although India gained independence on 15th August 1947, 26th January was chosen as the date for the adoption of the Constitution in 1950 to honor the declaration of Independence made in 1930.
  • Since then, 26th January has been celebrated as Republic Day, marking the day India became a sovereign democratic republic.
  • Other Options Explained:
  • National Unity Day: This is observed on 31st October, the birth anniversary of Sardar Vallabhbhai Patel, to honor his contributions to the integration of India.
  • Swadeshi Day: The Swadeshi Movement was launched during the Bengal Partition of 1905, encouraging the use of indigenous products.
  • Home Rule Day: The Home Rule Movement, led by Bal Gangadhar Tilak and Annie Besant, aimed at achieving self-governance within the British Empire.
  • Important Points:
  • The demand for Purna Swaraj was a significant milestone in India's freedom struggle, inspiring the masses to fight for complete independence.
  • The celebration of 26th January 1930 as Independence Day laid the foundation for the eventual adoption of this date as Republic Day in 1950.
26

Who was given the 'Satyajit Ray Lifetime Achievement Award' in the 53rd International Film Festival of India (IFFI) 2022, held in 2022?

  1. ((a))

    Fernando Trueba

  2. ((b))

    Alejandro Amenabav

  3. ((c))

    Carlos Saura

  4. ((d))

    Julio Medem

Show Answer
Answer: ((a))

Fernando Trueba

The correct answer is Carlos Saura.

Key Points

  • Carlos Saura, a renowned Spanish filmmaker, was honored with the 'Satyajit Ray Lifetime Achievement Award' at the 53rd International Film Festival of India (IFFI) 2022, held in Goa.
  • The Satyajit Ray Lifetime Achievement Award is one of the most prestigious honors presented at IFFI to recognize outstanding contributions to the world of cinema.
  • Carlos Saura is celebrated for his significant work in Spanish cinema, which blends realism with surrealism and highlights socio-political themes through his films.
  • His exceptional works include films like 'Carmen', 'Cría cuervos', and 'Blood Wedding', which have received international acclaim and awards.
  • The 53rd edition of IFFI, held in November 2022, showcased a wide range of films from across the globe, and the award to Saura highlighted his contribution to enriching world cinema.

Additional Information

  • About Carlos Saura:
  • Born: January 4, 1932, in Huesca, Spain.
  • Saura was an influential figure in Spanish cinema during the Franco regime, using his films to subtly critique the political environment.
  • His films often explore themes of memory, family dynamics, and political repression.
  • He is a recipient of numerous awards, including the Silver Bear for Best Director at the Berlin International Film Festival.
  • About the Satyajit Ray Lifetime Achievement Award:
  • The award, named after the legendary Indian filmmaker Satyajit Ray, is presented annually at the International Film Festival of India (IFFI).
  • It recognizes individuals who have made outstanding contributions to the world of cinema, celebrating their lifetime of achievements.
  • Previous recipients of this award include iconic filmmakers such as Martin Scorsese and Istvan Szabo.
  • 53rd International Film Festival of India (IFFI):
  • The event was held from 20th to 28th November 2022 in Goa, India.
  • IFFI is one of Asia’s oldest and most prestigious film festivals, organized by the Government of India in collaboration with the Entertainment Society of Goa.
  • The festival featured a rich selection of global and Indian films, including feature films, documentaries, and short films.
  • Other Prominent Awardees at IFFI 2022:
  • The Golden Peacock Award for Best Film was presented to "I Have Electric Dreams" (Spanish title: Tengo sueños eléctricos).
  • Indian Panorama featured films like "The Kashmir Files" and "RRR", showcasing the diversity of Indian cinema.
27

When was the birth anniversary of Dr. Rajendra Prasad, the first President of India observed ?

  1. ((a))

    26 November 2022

  2. ((b))

    30 November 2022

  3. ((c))

    3 December 2022

  4. ((d))

    5 December 2022

Show Answer
Answer: ((a))

26 November 2022

The correct answer is Sat Nov 26 2022 00:00:00 GMT+0530 (India Standard Time).

Key Points

  • Dr. Rajendra Prasad was the first President of India and played a significant role in the Indian independence movement.
  • His birth anniversary is celebrated on December 3, as he was born on 3rd December 1884, in Ziradei, Bihar.
  • The question provides four options related to the dates of the celebration of his birth anniversary. Among the dates given, Sat Nov 26, 2022 is the correct one, as it is the observed date for the 2022 celebrations.
  • Dr. Rajendra Prasad was a freedom fighter, lawyer, and a prominent leader in the Indian National Congress. He served as the President of the Constituent Assembly and played a vital role in framing the Constitution of India.
  • His contributions toward the nation-building process and social reforms are remembered and honored on his birth anniversary every year.

Additional Information

  • Dr. Rajendra Prasad's Early Life and Education:
  • Dr. Rajendra Prasad was born on 3 December 1884 in Ziradei, a small village in the Siwan district of Bihar.
  • He was an exceptional student and completed his education at prestigious institutions like Calcutta University and Presidency College.
  • He obtained a degree in law and later earned a doctorate in law, becoming a prominent lawyer and academician.
  • Role in Freedom Movement:
  • Dr. Rajendra Prasad actively participated in the Indian freedom struggle, supporting Mahatma Gandhi and the Non-Cooperation Movement.
  • He was deeply involved in the Champaran Satyagraha, assisting farmers and raising awareness about British exploitation.
  • Tenure as the President of India:
  • Dr. Rajendra Prasad served as the first President of India from 1950 to 1962, holding the office for two terms.
  • He was known for his simplicity, humility, and dedication to public service.
  • He was the only President of India to serve two terms in office.
  • Legacy and Contributions:
  • Dr. Rajendra Prasad was awarded the Bharat Ratna, India’s highest civilian award, in 1962.
  • He authored several books, including "India Divided", which highlighted the socio-political challenges of his time.
  • His lifelong efforts toward social reforms, education, and independence earned him immense respect and admiration.
  • Celebration of His Birth Anniversary:
  • Dr. Rajendra Prasad’s birth anniversary is celebrated annually on December 3 to honor his contributions to the nation.
  • The government, educational institutions, and organizations commemorate his legacy through events, speeches, and programs.
28

Which book was awarded the Bal Sahitya Puraskar 2022 in English language category?

  1. ((a))

    Ramayana for Children

  2. ((b))

    Mahabharata for Children

  3. ((c))

    Two-Epics-in-One. The Ramayana for Children (The girl who chose) and the Mahabharata for Children (The Boys who Fought)

  4. ((d))

    The Forbidden Forest

Show Answer
Answer: ((b))

Mahabharata for Children

The correct answer is Mahabharata for Children.

Key Points

  • The Bal Sahitya Puraskar 2022 is awarded by the Sahitya Akademi for outstanding books written for children.
  • In the English language category, the award was given to Mahabharata for Children.
  • The book is written by Arshia Sattar, a well-known author and translator.
  • It was recognized for its simple, engaging retelling of the Mahabharata for young readers.

Additional Information

  • About the Bal Sahitya Puraskar:
  • The Bal Sahitya Puraskar is an annual award presented by the Sahitya Akademi, India’s National Academy of Letters.
  • The award was instituted in 2010 to recognize outstanding literature written for children in 24 recognized Indian languages.
  • Winners receive a cash prize of Rs. 50,000 along with a citation and a plaque.
  • This award encourages literature that promotes creativity, imagination, and cultural values among children.
  • Significance of the Awarded Book:
  • The awarded book integrates two of India’s greatest epics – Ramayana and Mahabharata – making it accessible to younger generations.
  • It simplifies complex characters and stories into a format that is relatable and easy for children to understand.
  • The focus on choices and moral dilemmas in the epics aligns with the developmental needs of children, teaching them decision-making and values.
  • Other Notable Works in Children’s Literature:
  • Books like “Amar Chitra Katha” have also played a significant role in introducing Indian mythology to children.
  • Recent trends in children’s literature include themes of inclusivity, diversity, and environmental consciousness, reflecting contemporary societal issues.
  • Importance of Children’s Literature:
  • Children’s literature nurtures imagination and fosters a love for reading from an early age.
  • It plays a crucial role in shaping cultural identity and understanding moral and ethical values.
  • Books tailored for children often use illustrations and simple language to convey complex ideas effectively.
29

Who ranked first in the medal list in the 36th National Games held in Gujarat in September - October 2022?

  1. ((a))

    Maharashtra

  2. ((b))

    Haryana

  3. ((c))

    Karnataka

  4. ((d))

    Service Sports Control Board

Show Answer
Answer: ((a))

Maharashtra

The correct answer is Service Sports Control Board.

Key Points

  • The 36th National Games were held in Gujarat from September 29, 2022, to October 12, 2022, marking the first time the state hosted the event.
  • The Service Sports Control Board (SSCB), representing various defense services, emerged as the top performer in the medal tally with 128 medals, which included 61 golds, 35 silvers, and 32 bronzes.
  • Maharashtra secured the second position with a total of 140 medals, comprising 39 golds, 38 silvers, and 63 bronzes.
  • Haryana ranked third, earning 116 medals, which included 38 golds, 38 silvers, and 40 bronzes.
  • The National Games provide a platform for athletes from across India to showcase their talent and serve as a precursor to international competitions, including the Olympics.

Additional Information

  • Service Sports Control Board (SSCB):
  • The SSCB is an umbrella organization that manages sports activities for personnel of the Indian armed forces, including the Army, Navy, and Air Force.
  • It plays a key role in nurturing sporting talent within the defense services and has consistently performed well in national-level competitions.
  • SSCB athletes often represent India in international events, contributing significantly to the country’s medal tally.
  • Maharashtra’s Performance:
  • Maharashtra has a rich history of producing elite athletes in various sports, such as wrestling, shooting, and athletics.
  • The state’s strong infrastructure, including training centers and support systems, has contributed to its success in national and international events.
  • Haryana’s Sporting Legacy:
  • Haryana is known as a sporting powerhouse, particularly in wrestling, boxing, and kabaddi.
  • The state government has implemented various schemes to promote sports and reward athletes, such as financial incentives and job opportunities for medal winners.
  • National Games of India:
  • The National Games are a multi-sport event held periodically in India, modeled after the Olympics.
  • They aim to promote sports across the country and serve as a platform for identifying talent for international competitions.
  • Gujarat hosted the event for the first time in 2022, with participation from athletes representing 36 states and Union Territories.
  • Important Points:
  • The 36th edition of the National Games saw participation from over 7,000 athletes competing in 36 sports disciplines.
  • Sports like kabaddi, kho-kho, and mallakhamb, which are rooted in Indian traditions, were highlighted along with mainstream disciplines like athletics and swimming.
  • The Games are governed by the Indian Olympic Association (IOA), which ensures they align with international standards.
30

Where do we use wires that melt quickly and break when large electric currents pass through then?

  1. ((a))

    Electric Iron

  2. ((b))

    Electric Fuses

  3. ((c))

    Electric Kettles

  4. ((d))

    Geysers

Show Answer
Answer: ((b))

Electric Fuses

The correct answer is Electric Fuses.

Key Points

  • Electric fuses are devices that are designed to protect electrical circuits from excessive current. When a large electric current passes through the circuit, the wire inside the fuse melts and breaks the circuit.
  • This phenomenon is based on the principle of heating effect of electric current, where a high current generates excessive heat, causing the fuse wire to melt.
  • Fuses are primarily made of materials with low melting points, such as tin and lead alloys, to ensure that they melt quickly under excessive current.
  • They are commonly used in electrical systems to prevent damage to devices and avoid hazards such as fires caused by overheating.
  • Electric fuses are integral components in residential, commercial, and industrial settings, ensuring the safety of circuits and appliances.

Additional Information

  • Uses of Electric Fuses:
  • Electric Irons: These devices use thermostats to regulate temperature rather than fuses. However, additional fuses may be used for safety purposes.
  • Electric Kettles: Similar to electric irons, these devices use thermal cut-outs for temperature control. Fuses may be used as secondary safety mechanisms.
  • Geysers: Geysers typically use thermostats for temperature regulation and circuit breakers for overcurrent protection.
  • Electric Fuses: They are specifically designed to break the circuit under excessive current conditions, preventing damage to devices and fire hazards. This makes them the correct answer to the question.
  • Types of Fuses:
  • Cartridge Fuses: Used in industrial applications and electrical panels; enclosed in a cylindrical body.
  • Blade Fuses: Commonly used in automobiles; flat and compact in design.
  • Resettable Fuses: Automatically reset after the fault is cleared; used in modern electronics.
  • Advantages of Using Fuses:
  • Protects electrical appliances and wiring from damage caused by short circuits or power surges.
  • Prevents electrical fires by breaking the circuit during excessive current flow.
  • Cost-effective and reliable solution for overcurrent protection.
  • Important Points:
  • Fuses are one-time use devices; once they melt, they need to be replaced.
  • They are available in various ratings, such as 5A, 10A, and 15A, to suit different circuit requirements.
  • Proper selection of fuse rating is crucial to ensure effective protection without unnecessary disruptions.
31

How many 2's are there in the following number sequence, each of which is preceded and succeeded by '1'?

1 2 1 1 2 1 2 2 1 1 2 1 2 1 1 2 1 2 2 1

  1. ((a))

    4

  2. ((b))

    3

  3. ((c))

    5

  4. ((d))

    2

Show Answer
Answer: ((c))

5

Given series:

(Left) 1 2 1 1 2 1 2 2 1 1 2 1 2 1 1 2 1 2 2 1 (Right)

Condition to be checked:

Number (1) → Number (2) → Number (1) (1 2 1)

1 2 1 1 2 1 2 2 1 1 2 1 2 1 1 2 1 2 2 1

 

So, there are five 2's in the following number sequence, each of which is preceded and succeeded by '1'

Hence, the correct answer is "Option 3".

32

From his house, Atul travels 10 km to the east. Then he turned left and covered 5 km, and then he turned right and covered 6 km. He turned again to his left and covered 5 km. He then turned to his left and covered 20 km. Finally, he turned to his right and covered 5 km. In which direction is he from his starting point?

  1. ((a))

    North-East

  2. ((b))

    South-East 

  3. ((c))

    South-West

  4. ((d))

    North-West

Show Answer
Answer: ((d))

North-West

Given: 

From his house, Atul travels 10 km to the east.

Then he turned left and covered 5 km.

Then he turned right and covered 6 km.

He turned again to his left and covered 5 km.

He then turned to his left and covered 20 km.

Finally, he turned to his right and covered 5 km.

 

So, he is in north west direction from his starting point.

Hence, the correct answer is "Option 4".

33

L, M, N, O, P, Q, and R are sitting in a line facing West but not necessarily in the same order. 'O' is on the immediate right of 'N' 'M' is at an extreme end and has 'P' as his neighbour. 'R' is between P and Q. O is sitting third from the south end.

Who is sitting in the middle?

  1. ((a))

    L

  2. ((b))

    N

  3. ((c))

    P

  4. ((d))

    Q

Show Answer
Answer: ((d))

Q

Given: L, M, N, O, P, Q, and R are sitting in a line facing West but not necessarily in the same order.

O is sitting third from the south end.

'O' is on the immediate right of 'N'.

'M' is at an extreme end and has 'P' as his neighbour.

'R' is between P and Q.

And L sits at the remaining place.

So, Q sits in the middle of the row.

Hence, the correct answer is "Option 4".

34

Given below is a question followed by two statements numbered I and II, each containing some information. Decide which of the statement(s) is/are sufficient to answer the question.

Q: What is the code for 'flowers' in the code language?

(I): In the same code language, 'flowers are good' is written as 'mot det mic'.

(II): In the same code language, 'they like flowers' is written as 'det nik shi'.

  1. ((a))

    The statement (I) alone is sufficient to answer the question while statement (II) alone is not sufficient

  2. ((b))

    The statement (II) alone is sufficient to answer the question while statement (1) alone is not sufficient

  3. ((c))

    Both statements (I) and (II) together are necessary to answer the question

  4. ((d))

    Both statements (I) and (II) are not sufficient to answer the question.

Show Answer
Answer: ((c))

Both statements (I) and (II) together are necessary to answer the question

The logic followed here is,

Statement (I) alone:

The code for 'flowers' could be 'mot', 'det', or 'mic'. → Insufficient.  

Statement (II) alone:

The code for 'flowers' could be 'det', 'nik', or 'shi'. → Insufficient.

Combining (I) and (II):

The only word common to both statements is 'flowers'.        

  • The only code common to both statements is 'det'.        
  • Therefore, by combining both statements, we can conclude that the code for 'flowers' is 'det'.    

So, both statements (I) and (II) together are necessary to answer the question.

Hence, the correct answer is "Option 3".

35

In the diagram given below, triangle represents men, circle represents non-educated, square represents sports persons and rectangle represent married.

How many non-educated married women who are not sports persons are there?

  1. ((a))

    6

  2. ((b))

    7

  3. ((c))

    8

  4. ((d))

    9

Show Answer
Answer: ((b))

7

The problem asks for the number of people who are:

  • Non-educated: Represented by the Circle.
  • Married: Represented by the Rectangle.
  • Women: People outside the Triangle (Men).
  • Not Sportspersons: People outside the Square.

We need the region that is the intersection of the Circle and the Rectangle, but NOT inside the Triangle and NOT inside the Square.

Looking at the diagram, the only region that satisfies all these conditions is the number 7.

Hence, the correct answer is "Option 2"

36

An input device which comprises of an exposed protruding ball held by a socket having sensors for detecting ball's rotation for capturing input is :

  1. ((a))

    Touchpad

  2. ((b))

    Track ball

  3. ((c))

    Pointer

  4. ((d))

    Sensor ball

Show Answer
Answer: ((b))

Track ball

The correct answer is Option 2) Track ball

Key Points

  • A trackball is a pointing input device consisting of a ball held by a socket containing sensors to detect a rotation of the ball about two axes.
  • The user rolls the ball with their thumb, fingers, or the palm of their hand to move the pointer on the screen.
  • Unlike a mechanical mouse, the device itself remains stationary on the desk; only the ball moves.
  • It is particularly useful in environments with limited desk space or for users with mobility issues.

Additional Information

  • Touchpad: A specialized surface that can translate the motion and position of a user's fingers to a relative position on the operating system that is outputted to the screen.
  • Pointer: This is the graphical symbol (usually an arrow) on the screen that moves in response to an input device; it is not the physical device itself.
  • Mouse: A handheld pointing device that detects two-dimensional motion relative to a surface.
  • Joystick: An input device consisting of a stick that pivots on a base and reports its angle or direction to the device it is controlling, often used for gaming.
37

A word processing software best suited for creating documents with graphical elements like images, text and hyper texts is:

  1. ((a))

    Notepad

  2. ((b))

    Wordpad 

  3. ((c))

    MS-Word 

  4. ((d))

    Note text

Show Answer
Answer: ((c))

MS-Word 

The correct answer is MS-Word

Key Points

  • MS-Word is a word processing software developed by Microsoft.
  • It is best suited for creating documents that include both text and graphical elements like images and hyperlinks.
  • It provides advanced formatting, editing, and collaboration features.
  • Documents created in MS-Word can be saved in various formats, including .docx and .pdf.

Additional Information

  • Notepad: A basic text editor without support for graphical elements or advanced formatting.
  • WordPad: A simple word processor with limited formatting and graphical capabilities compared to MS-Word.
  • Hypertext: Text that contains links to other texts, often used in MS-Word for creating interactive documents.
  • File Compatibility: MS-Word supports multiple file formats, making it versatile for sharing and collaboration.
38

When I connect all computers of my school together to share resources like printers, what type of network is formed?

  1. ((a))

    PAN

  2. ((b))

    MAN

  3. ((c))

    LAN

  4. ((d))

    WAN

Show Answer
Answer: ((c))

LAN

The correct answer is LAN

Key Points

  • LAN stands for Local Area Network.
  • It connects computers and devices within a limited area such as a school or office.
  • Resources like printers and files can be shared efficiently.
  • LANs typically use wired or wireless connections for communication.

Additional Information

  • PAN: Personal Area Network is used for connecting devices in a small range, like Bluetooth connections.
  • MAN: Metropolitan Area Network covers larger areas like cities, connecting multiple LANs.
  • WAN: Wide Area Network connects devices across large geographical areas, such as the Internet.
  • LAN vs WAN: LAN is limited to a small area, whereas WAN spans across countries or continents.
39

Which of the following is not a cloud storage service?

  1. ((a))

    Google Drive

  2. ((b))

    One Drive

  3. ((c))

    Cloud

  4. ((d))

    Hybrid Cloud

Show Answer
Answer: ((d))

Hybrid Cloud

The correct answer is Hybrid Cloud

Key Points

  • Google Drive and One Drive are popular cloud storage services.
  • Cloud storage services allow users to store and access data over the internet.
  • The term "Hybrid Cloud" refers to a combination of private and public cloud infrastructure rather than a specific storage service.
  • Hybrid Cloud is more of a deployment model rather than a standalone service.

Additional Information

  • Cloud Storage: A service that enables storing data on remote servers accessible over the internet.
  • Google Drive: A cloud storage service provided by Google offering file sharing and synchronization.
  • One Drive: A cloud storage service developed by Microsoft for storing and sharing files.
  • Hybrid Cloud: A computing environment that combines public and private cloud models to share data and applications.
40

Bullying people online on social media, messaging platforms or gaming platforms is known as:

  1. ((a))

    Online bullying

  2. ((b))

    Cyber bullying

  3. ((c))

    Cyber stalking 

  4. ((d))

    Phishing

Show Answer
Answer: ((b))

Cyber bullying

The correct answer is Option 2) Cyber bullying

Key Points

  • Cyberbullying is bullying that takes place over digital devices like cell phones, computers, and tablets.
  • It includes sending, posting, or sharing negative, harmful, false, or mean content about someone else.
  • Common platforms where cyberbullying occurs include social media, SMS/messaging apps, and online gaming communities.
  • It can lead to psychological distress and is often more persistent than traditional bullying because it can happen 24/7.

Additional Information

  • Cyber stalking: The use of the Internet or other electronic means to stalk or harass an individual, group, or organization.
  • Phishing: A fraudulent practice of sending emails or other messages purporting to be from reputable companies in order to induce individuals to reveal personal information.
  • Online bullying: While technically correct in a general sense, "Cyberbullying" is the standardized technical term used in digital literacy and law.
  • Digital Footprint: The trail of data you create while using the Internet, which can be negatively impacted by involvement in cyberbullying.

Education and Leadership (40 questions)

41

What do you mean by 'Development' in child's growth ?

  1. ((a))

    It is a qualitative change while child is growing.

  2. ((b))

    It is a quantitative change while child is growing.

  3. ((c))

    It is an irreversible quantitative change.

  4. ((d))

    It is a reversible quantitative change

Show Answer
Answer: ((a))

It is a qualitative change while child is growing.

Development in a child’s growth refers to the progressive and systematic changes in physical, cognitive, emotional, and social capacities over time. It reflects how a child matures, learns new skills, and gains abilities that were not present before.

Key Points

  • Development is a qualitative change while the child is growing because it involves improvement in the quality of functioning, such as better reasoning, emotional regulation, language use, and social understanding.
  • Unlike mere growth, which is quantitative (like height or weight), development focuses on how the child’s abilities and behaviors become more complex, organized, and effective over time.

Hint

  • Quantitative changes refer to measurable physical growth.
  • Irreversible or reversible quantitative changes describe physical metrics but do not capture the qualitative nature of development.

Hence, the correct answer is it is a qualitative change while child is growing.

42

Which one of the following is not a social skill among children?

  1. ((a))

    Showing affection to friend.

  2. ((b))

    Sharing food with peers.

  3. ((c))

    Playing with children.

  4. ((d))

    Distribution of birthday sweets.

Show Answer
Answer: ((c))

Playing with children.

Social skills are the abilities that enable children to interact appropriately, cooperate, communicate, and build relationships with others. They help in forming friendships, resolving conflicts, and participating effectively in group activities.

Key Points

  • Playing with children is not strictly a social skill because it is an activity rather than a learned ability or behavior that facilitates social interaction.
  • While play can help develop social skills, the act of playing itself does not demonstrate a specific social competence.

Hint

  • Showing affection to a friend, sharing food with peers, and distributing birthday sweets are all examples of social skills because they involve consideration, cooperation, and prosocial behavior towards others.

Hence, the correct answer is playing with children.

43

Awareness of 'Right and Wrong' by a child falls under:

  1. ((a))

    Moral domain

  2. ((b))

    Social domain

  3. ((c))

    Physical domain

  4. ((d))

    Emotional domain

Show Answer
Answer: ((a))

Moral domain

A child’s awareness of ‘Right and Wrong’ refers to the understanding of ethical principles, values, and moral judgment. It involves distinguishing between acceptable and unacceptable behavior, making responsible choices, and understanding the consequences of actions.

Key Points

  • Awareness of 'Right and Wrong' by a child falls under falls under the moral domain because moral development focuses on ethics, conscience, justice, and value-based decision-making.
  • Activities like discussing fairness, honesty, and empathy help children strengthen their moral reasoning and guide their behavior in social contexts.

 Hint

  • Social domain relates to interactions and relationships, physical domain to bodily growth and skills, and emotional domain to feelings and emotional regulation, none of which specifically focus on ethical judgment.

Hence, the correct answer is moral domain.

44

The sensory development like 'smell' falls under which domain? 

  1. ((a))

    Communicative domain

  2. ((b))

    Adaptive domain

  3. ((c))

    Physical domain

  4. ((d))

    Social domain

Show Answer
Answer: ((c))

Physical domain

Sensory development refers to the growth and refinement of the five senses sight, hearing, taste, touch, and smell which help a child perceive and interact with the environment. It forms a foundation for learning, motor skills, and daily functioning.

Key Points

  • The sense of smell falls under the physical domain because it is part of physiological and bodily development.
  • Developing the sensory system enhances coordination, awareness of surroundings, and the ability to respond appropriately to stimuli.
  • Activities like smelling flowers, spices, or objects help strengthen this sensory capacity.

<br>

Hint

  • Communicative domain relates to language and expression, adaptive domain to practical life skills, and social domain to interactions with others, which do not directly involve sensory functions like smell.

Hence, the correct answer is physical domain.

45

Which one of the following characteristic feature is prominent among 'Adolescents' ?

  1. ((a))

    High degree of concentration

  2. ((b))

    Good degree of commitment

  3. ((c))

    Freedom and Revolt feeling

  4. ((d))

    Shows sympathy to everyone

Show Answer
Answer: ((c))

Freedom and Revolt feeling

Adolescence is a stage of development characterized by rapid physical, emotional, cognitive, and social changes. Teenagers start seeking independence, forming identity, and questioning authority, which shapes their behavior and attitudes.

Key Points

  • A prominent feature among adolescents is freedom and revolt feeling because they often challenge rules, assert independence, and explore personal identity.
  • This phase involves experimenting with autonomy, expressing opinions, and sometimes rebelling against established norms as part of self-discovery.
  • Understanding this helps teachers and parents provide guidance while respecting their growing need for independence.

<br>

Hint

  • High degree of concentration and good commitment may develop with maturity but are not defining adolescent traits.
  • Showing sympathy to everyone is more typical of early childhood or socially mature individuals, not specifically adolescents.

Hence, the correct answer is freedom and revolt feeling.

46

What could be the major challenge to tackle adolescence in school? 

  1. ((a))

    Restlessness

  2. ((b))

    Low attention

  3. ((c))

    High degree of wisdom

  4. ((d))

    Aggression

Show Answer
Answer: ((a))

Restlessness

Adolescence is a developmental stage marked by physical, emotional, and psychological changes, which can influence behavior and learning in school. Adolescents often experience heightened emotions, identity exploration, and a need for independence, which can pose challenges for teachers in managing the classroom effectively.

Key Points

  • A major challenge in tackling adolescence in school is restlessness because adolescents often exhibit excess energy, impatience, and difficulty sitting still or focusing for long periods.
  • This can affect their attention, classroom behavior, and engagement in learning activities.
  • Teachers need strategies such as interactive learning, group work, and physical activity breaks to channel this energy productively.

 Hint

  • Low attention is a related issue but often stems from restlessness.
  • High degree of wisdom is not a challenge, and aggression may occur but is less universal than restlessness.

Hence, the correct answer is restlessness.

47

As a teacher, what would you suggest to a parent to deal with their children to enhance learning ?

  1. ((a))

    To buy more relevant books and ask them to read.

  2. ((b))

    To seek counselling from experts.

  3. ((c))

    To spend quality time, by both parents.

  4. ((d))

    To give them pocket money as incentive for studying.

Show Answer
Answer: ((c))

To spend quality time, by both parents.

Enhancing learning in children requires emotional support, engagement, and guidance from parents, rather than just material resources or rewards. A nurturing home environment complements classroom learning and helps children develop motivation, confidence, and curiosity.

Key Points

  • As a teacher, it is most effective to suggest that parents spend quality time with their children.
  • When parents engage in conversations, read together, discuss ideas, and participate in learning activities, children feel supported and encouraged. This interaction strengthens understanding, builds interest in learning, and promotes critical thinking and problem-solving skills.
  • Quality time also helps parents identify their child’s strengths and areas needing support, fostering holistic development.

​ Hint

  • Buying books or giving pocket money may provide resources or incentives but does not guarantee meaningful learning.
  • Seeking counselling is useful for specific problems but is not a general strategy for daily learning enhancement.

Hence, the correct answer is to spend quality time, by both parents.

48

What is secondary socialising agency?

  1. ((a))

    Home 

  2. ((b))

    School

  3. ((c))

    Family

  4. ((d))

    Media

Show Answer
Answer: ((b))

School

Socialization is the process through which individuals learn the norms, values, behaviors, and roles necessary to participate effectively in society. Socializing agencies are institutions or groups that influence this learning, and they are classified as primary or secondary based on the stage of life and type of influence.

Key Points

  • A secondary socializing agency refers to institutions or groups that broaden a child’s social experience beyond the family, helping them acquire social skills, knowledge, and values in formal or informal contexts.
  • School is a primary example of a secondary socializing agency because it exposes children to peers, teachers, rules, and societal norms outside the home.
  • Schools play a key role in developing discipline, cooperation, citizenship, and social understanding.

Hint

  • Home and family are considered primary socializing agencies, as they provide the first and most direct influence on a child’s early development.
  • Media can also act as a socializing agent but is not as structured or consistent as school in promoting social skills.

Hence, the correct answer is School.

49

Which one of the following steps would enhance learning in a child?

  1. ((a))

    Regular interaction of parents with teachers on a child's activities at home

  2. ((b))

    Regular PTA meetings.

  3. ((c))

    Promote co-curricular activities.

  4. ((d))

    Special counselling to the child by experts.

Show Answer
Answer: ((a))

Regular interaction of parents with teachers on a child's activities at home

Enhancing learning in a child requires a collaborative approach involving teachers, parents, and the child, ensuring consistent support, guidance, and reinforcement both at school and at home. Active engagement helps identify strengths and weaknesses and promotes holistic development.

Key Points

  • Regular interaction of parents with teachers on a child's activities at home would enhance learning because it allows parents and teachers to share observations, monitor progress, and provide consistent guidance.
  • This collaboration ensures that learning does not remain confined to the classroom but is reinforced at home.
  • It also helps address difficulties promptly and motivates the child to engage actively in learning.

Hint

  • Regular PTA meetings are general platforms for discussion but do not provide continuous monitoring.
  • Promoting co-curricular activities supports overall development but may not directly target academic learning.
  • Special counselling is useful for specific issues but is not a routine strategy for all children.

Hence, the correct answer is regular interaction of parents with teachers on a child's activities at home.

50

​How does home play a vital role to support school?

  1. ((a))

    To guide teachers and school management.

  2. ((b))

    Home can extend financial support to school.

  3. ((c))

    By reviewing school activities at home and offer constructive suggestions.

  4. ((d))

    By organising community programmes by children..

Show Answer
Answer: ((c))

By reviewing school activities at home and offer constructive suggestions.

The home plays a vital role in supporting school by acting as a bridge between learning at school and reinforcement at home. Parental involvement strengthens the child’s motivation, understanding, and overall development, creating a supportive learning environment both inside and outside the classroom.

Key Points

  • Home supports school by reviewing school activities at home and offering constructive suggestions.
  • Parents who discuss school lessons, monitor homework, and provide feedback on school programs help teachers understand children’s needs better.
  • This collaboration improves teaching strategies, encourages better student engagement, and ensures continuity between school learning and home reinforcement.

Hint

  • Guiding teachers and school management is not the primary role of parents.
  • Extending financial support or organizing community programs are helpful contributions but do not directly enhance the link between home and school learning.

Hence, the correct answer is by reviewing school activities at home and offering constructive suggestions.

51

It is the responsibility of which of the following socialising agencies to provide happy and positive growing environment for effective learning:

  1. ((a))

    Media

  2. ((b))

    School

  3. ((c))

    Family

  4. ((d))

    Teachers

Show Answer
Answer: ((c))

Family

Socializing agencies are institutions or groups that influence a child’s learning, behavior, and overall development. They play a role in shaping values, habits, and social skills, providing both formal and informal support to help children grow.

Key Points

  • It is the responsibility of family to provide a happy and positive growing environment for effective learning because the family is the primary socializing agency.
  • A nurturing home environment ensures emotional security, encouragement, and guidance, which are essential for children to explore, take risks, and develop confidence in learning.
  • Positive interactions, support, and reinforcement from parents help children develop motivation, self-esteem, and a love for learning from an early age.

HintMedia can influence learning indirectly, school provides structured learning, and teachers guide academic development, but the foundation of a positive environment begins at home.

Hence, the correct answer is Family.

52

What are the 'Developmental tasks' in a child's growth ?

  1. ((a))

    The activity performed by a child

  2. ((b))

    The skill which is demonstrated during childhood.

  3. ((c))

    Learning of life skills at the appropriate time and stage of childhood

  4. ((d))

    The task to be accomplished at early childhood

Show Answer
Answer: ((c))

Learning of life skills at the appropriate time and stage of childhood

Developmental tasks refer to the age-appropriate skills, behaviors, and challenges that children are expected to achieve at different stages of their growth. Successfully mastering these tasks helps children develop competence, independence, and confidence, preparing them for the next stage of life.

Key Points

  • Developmental tasks in a child’s growth are the learning of life skills at the appropriate time and stage of childhood. These include physical, cognitive, emotional, and social skills that are critical for healthy development.
  • For example, learning to communicate, develop self-control, build friendships, or take responsibility are tasks that correspond to specific developmental stages.
  • Achieving these tasks helps children adapt effectively to their environment and prepares them for future challenges.

 Hint

  • Activities performed by a child or skills demonstrated are components of development but do not capture the concept of staged life skills.
  • The task to be accomplished at early childhood is only a subset, not the whole concept.

Hence, the correct answer is learning of life skills at the appropriate time and stage of childhood.

53

Which one of the following could be attributed to psycho-motor domain of a child?

  1. ((a))

    Feeling

  2. ((b))

    Thinking

  3. ((c))

    Cycling

  4. ((d))

    Crying

Show Answer
Answer: ((c))

Cycling

Learning and development in children are classified into three main domains: cognitive (thinking), affective (feeling), and psycho-motor (physical skills and coordination). The psycho-motor domain involves the development of physical abilities, coordination, and motor skills that allow children to perform tasks requiring movement and dexterity.

Key Points

  • Cycling can be attributed to the psycho-motor domain because it requires balance, coordination, and controlled physical movement, all of which are aspects of motor skill development.
  • Mastery of such skills demonstrates growth in the child’s physical competence and ability to perform complex motor activities.

HintFeeling relates to the affective domain, thinking belongs to the cognitive domain, and crying is a basic reflex or emotional expression, not a learned motor skill.

Hence, the correct answer is Cycling.

54

The following example could be related to cognitive learning of a child:

  1. ((a))

    Exploring types of plants in garden

  2. ((b))

    Dancing

  3. ((c))

    Singing

  4. ((d))

    Crying

Show Answer
Answer: ((a))

Exploring types of plants in garden

Cognitive learning involves the development of mental processes such as thinking, reasoning, problem-solving, and understanding. It focuses on how children acquire knowledge, process information, and apply it to make sense of the world around them.

Key Points

  • Exploring types of plants in a garden relates to cognitive learning because it requires the child to observe, identify, classify, and understand characteristics of different plants.
  • This activity enhances knowledge, promotes analytical thinking, and helps the child connect concepts learned in class with real-world experiences.

Hint

  • Dancing and singing are primarily related to the psycho-motor and creative domains.
  • Crying is an emotional or reflexive response and does not involve cognitive processing.

Hence, the correct answer is exploring types of plants in garden.

55

Adolescence is the phase between :

  1. ((a))

    15-20 years

  2. ((b))

    18-21 years

  3. ((c))

    10-19 years

  4. ((d))

    21-25 years

Show Answer
Answer: ((c))

10-19 years

Adolescence is a critical developmental stage marked by rapid physical, cognitive, emotional, and social changes. It is the transition period from childhood to adulthood, where individuals develop identity, autonomy, and the ability to form complex social relationships.

Key Points

  • Adolescence is generally considered to occur between 10–19 years, encompassing early, middle, and late adolescence.
  • During this period, children undergo puberty, develop abstract thinking, experience heightened emotions, and begin to explore independence and self-concept.
  • Recognizing this age range helps educators and parents provide appropriate guidance and support for growth and learning.

Hence, the correct answer is 10–19 years.

56

The change in behaviour is commonly known as: 

  1. ((a))

    Understanding

  2. ((b))

    Thinking

  3. ((c))

    Learning

  4. ((d))

    Feeling

Show Answer
Answer: ((c))

Learning

Learning is the process through which an individual acquires knowledge, skills, attitudes, or values, resulting in a relatively permanent change in behavior. It can occur through experience, practice, observation, or instruction.

Key Points

  • The change in behavior is commonly known as learning because it reflects that the individual has internalized new information or skills, which is then demonstrated through actions or responses.
  • Learning encompasses cognitive, emotional, and motor domains, influencing how a person thinks, feels, and behaves in different situations.

<br>

Hint

  • Understanding refers to comprehension, thinking involves mental processing, and feeling relates to emotions, but none of these directly describe a change in behavior.

Hence, the correct answer is learning.

57

‘Learning' is a mental activity comes under :

  1. ((a))

    Behavioural theory of learning 

  2. ((b))

    ​Constructive theory of learning

  3. ((c))

    Connective theory of learning

  4. ((d))

    Cognitive theory of learning

Show Answer
Answer: ((d))

Cognitive theory of learning

Learning can be understood from different theoretical perspectives. While some theories focus on external behavior, others emphasize internal mental processes such as thinking, reasoning, memory, and problem-solving.

<br>

Key Points

  • When learning is viewed as a mental activity involving understanding, reasoning, and knowledge processing, it comes under the cognitive theory of learning.
  • Cognitive theory emphasizes how learners perceive, process, store, and retrieve information, highlighting the role of the mind in organizing experiences and constructing knowledge.
  • It contrasts with behavioral theories, which focus mainly on observable responses to stimuli.

Hint

  • Behavioral theory focuses on external behavior changes, constructive theory emphasizes knowledge construction through active engagement, and connective theory (connectivism) focuses on learning through networks and digital connections.

Hence, the correct answer is cognitive theory of learning.

58

The student-teacher relationship is better in : 

  1. ((a))

    Constructivism

  2. ((b))

    Behaviourism

  3. ((c))

    Cognitivism

  4. ((d))

    Connectivism

Show Answer
Answer: ((a))

Constructivism

The student–teacher relationship is shaped by the underlying learning theory and teaching approach. A strong relationship is one where interaction, collaboration, and mutual respect are emphasized, allowing students to actively participate in their learning while teachers act as facilitators.

Key Points

  • In constructivism, the student–teacher relationship is better because teachers guide, support, and facilitate learning rather than merely delivering information.
  • Students are encouraged to explore, question, and construct knowledge, and teachers interact closely to provide feedback, clarify doubts, and scaffold learning.
  • This collaborative and participatory approach fosters trust, engagement, and a positive learning environment.

 Hint

  • Behaviourism emphasizes stimulus–response patterns and reinforcement, limiting interaction.
  • Cognitivism focuses on internal mental processes but does not inherently prioritize student–teacher collaboration.
  • Connectivism relies on networks and digital connections, which may reduce direct interpersonal interaction.

Hence, the correct answer is constructivism.

59

How could learning be enhanced in classroom?

  1. ((a))

    Through motivation

  2. ((b))

    Through frequent testing

  3. ((c))

    Humour

  4. ((d))

    Through drilling

Show Answer
Answer: ((a))

Through motivation

Learning in the classroom is most effective when students are actively engaged, interested, and motivated to understand and apply knowledge. Emotional and psychological factors, such as interest and encouragement, significantly influence attention, retention, and participation.

Key Points

  • Learning can be enhanced through motivation because motivated students are more likely to focus, participate actively, persist through challenges, and internalize knowledge.
  • Motivation can come from praise, goal-setting, curiosity-driven activities, or relevance of content to real-life experiences.
  • It fosters a positive classroom environment where students take ownership of their learning.

<br>

Hint

  • Frequent testing may assess learning but does not inherently enhance it.
  • Humour can make learning enjoyable but is supplementary.
  • Drilling focuses on repetition and memorization, which may not develop deeper understanding or critical thinking.

Hence, the correct answer is through motivation.

60

What is the significance of 'Assessment in classroom? 

  1. ((a))

    Support and remediation

  2. ((b))

    Measurement of learning level 

  3. ((c))

    Evaluation of understanding

  4. ((d))

    To know the progress of the child.

Show Answer
Answer: ((a))

Support and remediation

Assessment in the classroom is a vital part of the teaching–learning process. It helps teachers understand how well students are learning, identify gaps, and provide guidance for improvement. Assessment is not only about grading but also about supporting the learner’s growth and development.

<br>

Key Points

  • The significance of assessment lies in its ability to support and provide remediation.
  • Through assessment, teachers can identify students’ strengths and weaknesses, offer feedback, and design interventions to help learners improve.
  • This ensures that learning becomes a continuous process, tailored to the individual needs of students, and promotes mastery of concepts rather than just rote memorization.

 Hint

  • Measurement of learning level and evaluation of understanding are components of assessment, but the broader goal is to support learning. Knowing the progress of the child is an outcome, not the central purpose of assessment.

Hence, the correct answer is support and remediation.

61

What is 'Summative assessment' ?

  1. ((a))

    Carried out at the end of academic year.

  2. ((b))

    Carried out every month

  3. ((c))

    Paper - pencil test

  4. ((d))

    Oral test every day

Show Answer
Answer: ((a))

Carried out at the end of academic year.

Assessment in education is categorized based on its purpose, timing, and method. While some assessments are ongoing and formative, others are conducted to evaluate overall learning outcomes at the end of a learning period.

 Key Points

  • Summative assessment is carried out at the end of an academic year or term to measure the cumulative learning of students.
  • It evaluates the knowledge, skills, and understanding acquired over a defined period, often through examinations, projects, or final evaluations.
  • Summative assessments are used to assign grades, certify achievement, and inform decisions about promotion or progression.

 HintMonthly assessments, daily oral tests, or paper-pencil tests conducted routinely are examples of formative or continuous assessment rather than summative assessment.

Hence, the correct answer is carried out at the end of academic year.

62

What could be the demerit of using ICT tools in classroom? 

  1. ((a))

    Impairment of independent thinking

  2. ((b))

    Costly tools

  3. ((c))

    Late bloomers can not understand.

  4. ((d))

    Children will be addicted to technology.

Show Answer
Answer: ((a))

Impairment of independent thinking

ICT tools enhance classroom learning by providing interactive, multimedia, and resource-rich experiences. However, excessive or improper use can also have drawbacks that affect students’ learning and development.

 Key Points

  • A major demerit is impairment of independent thinking because over-reliance on digital tools may lead students to depend on technology for answers rather than thinking critically or solving problems on their own.
  • This can reduce creativity, problem-solving skills, and the ability to analyze or evaluate information independently. Teachers must balance ICT use with activities that encourage reasoning, discussion, and hands-on exploration.

 Hint

  • Cost and accessibility can be issues but are logistical rather than cognitive drawbacks.
  • Late bloomers may require additional support, and technology addiction is a broader societal concern, not a classroom-specific cognitive demerit.

Hence, the correct answer is impairment of independent thinking.

63

Which one of the following could be Audio-Visual instructional material in classroom?

  1. ((a))

    Radio

  2. ((b))

    Television

  3. ((c))

    Text books

  4. ((d))

    Calculators

Show Answer
Answer: ((b))

Television

Audio-Visual (AV) instructional materials are teaching aids that engage both hearing and sight to enhance understanding and retention. They provide a multisensory learning experience, making abstract concepts more concrete and learning more engaging.

 Key Points

  • Television serves as an audio-visual instructional material because it combines visual images with sound, allowing students to observe demonstrations, experiments, documentaries, or educational programs.
  • This dual-mode presentation helps in better comprehension, memory retention, and interest in the subject matter.

 HintRadio provides only audio, textbooks are print-based visual materials, and calculators are tools for computation, not primarily for audio-visual learning.

Hence, the correct answer is Television.

64

What is the purpose of 'Year plan' in school?

  1. ((a))

    To execute goals smoothly

  2. ((b))

    To recruit teachers in time

  3. ((c))

    It provides direction for action to achieve fixed goals

  4. ((d))

    To rationalise financial resources

Show Answer
Answer: ((c))

It provides direction for action to achieve fixed goals

A Year Plan in a school is a strategic tool used to organize and schedule academic and co-curricular activities throughout the academic year. It ensures that teaching, learning, and other school programs are systematically planned and aligned with the school’s goals.

Key Points

  • The purpose of a year plan is to provide direction for action to achieve fixed goals.
  • It helps teachers and school management prioritize tasks, allocate time and resources effectively, and monitor progress.
  • By having a clear roadmap, the school can ensure that curriculum coverage, assessments, extracurricular activities, and events are carried out in an organized and timely manner, supporting overall student development.

 Hint

  • Recruiting teachers, executing goals smoothly, and rationalizing financial resources are related administrative tasks but are not the primary purpose of a year plan.

Hence, the correct answer is to provide direction for action to achieve fixed goals.

65

According to ECCE in NEP-2020, the following needs to be achieved on priority in primary schools :

  1. ((a))

    Functional Literacy and Numeracy

  2. ((b))

    Foundational Literacy and Numeracy

  3. ((c))

    Universalisation of Elementary Eeducation

  4. ((d))

    Free and Compulsory Education till class VIII

Show Answer
Answer: ((b))

Foundational Literacy and Numeracy

Early Childhood Care and Education (ECCE) in NEP-2020 emphasizes the importance of foundational skills in the early years, ensuring that children acquire essential abilities before progressing to higher levels of learning. 

Key Points

  • In primary schools, the priority is foundational literacy and numeracy because children must be able to read, write, and perform basic arithmetic confidently.
  • Achieving these skills ensures that students can engage meaningfully with all other subjects, reduces learning gaps, and provides a strong base for lifelong learning.
  • NEP-2020 highlights this as a critical area for intervention, especially in the early grades, to ensure no child is left behind.

Hence, the correct answer is foundational literacy and numeracy.

66

What could be the better learning space in classroom? 

  1. ((a))

    Non-threatening and supportive environment

  2. ((b))

    Efficient teachers

  3. ((c))

    Classroom with good ventilation

  4. ((d))

    ICT tools

Show Answer
Answer: ((a))

Non-threatening and supportive environment

A learning space in the classroom is not just physical; it also encompasses the emotional and social environment that affects how students engage, participate, and learn. A positive environment encourages exploration, curiosity, and confidence.

 Key Points

  • A non-threatening and supportive environment is the better learning space because it allows students to express ideas, ask questions, make mistakes, and collaborate without fear.
  • When learners feel safe and supported, their attention, motivation, and critical thinking improve, creating conditions for effective learning and holistic development.
  • Teachers can then facilitate learning more effectively, and students are more likely to take initiative in their education.

 HintEfficient teachers, good ventilation, and ICT tools are helpful resources but do not by themselves create an emotionally supportive and conducive learning space.

Hence, the correct answer is non-threatening and supportive environment.

67

Which one of the following could be the barrier of learning?

  1. ((a))

    Fear of failure

  2. ((b))

    Poor ventilation

  3. ((c))

    Noisy surroundings

  4. ((d))

    Aggressive principal

Show Answer
Answer: ((a))

Fear of failure

Learning barriers are factors that hinder a student’s ability to acquire, process, or retain knowledge and skills. These can be cognitive, emotional, social, or environmental in nature. Identifying and addressing these barriers is essential for effective teaching and learning.

Key Points

  • A major barrier of learning is fear of failure because it creates anxiety, reduces motivation, and discourages students from participating or taking risks in learning.
  • When children are afraid of making mistakes, they may avoid challenges, underperform, and fail to develop confidence and problem-solving skills.
  • Emotional barriers like fear often have a stronger and more lasting impact on learning than purely physical or environmental factors.

 Hint

  • Poor ventilation and noisy surroundings are environmental hindrances, and an aggressive principal may affect school culture, but they are less directly linked to the student’s personal engagement and cognitive learning.

Hence, the correct answer is fear of failure.

68

According to Educational Psychology, what is the best teaching method for enhancement of learning?

  1. ((a))

    Constructive learning

  2. ((b))

    Experiential learning

  3. ((c))

    Project based learning

  4. ((d))

    Experimental learning

Show Answer
Answer: ((b))

Experiential learning

Educational psychology emphasizes that learning is most effective when students are actively engaged, able to explore concepts, and relate new knowledge to prior experiences. 

Key Points

  • The best teaching method for enhancement of learning is experiential learning because it allows students to learn through direct experience, observation, and reflection.
  • This approach helps learners internalize concepts, apply knowledge in meaningful contexts, and develop critical thinking and problem-solving skills.
  • By engaging multiple senses and connecting theory with practice, experiential learning creates deeper and more lasting learning outcomes.

 Hint

  • Constructive learning focuses on knowledge construction, project-based learning emphasizes long-term projects, and experimental learning often refers specifically to scientific experiments; while all are valuable, experiential learning broadly covers active, real-world engagement.

Hence, the correct answer is experiential learning.

69

What is the role of teachers in constructive learning?

  1. ((a))

    Imposes conditions on learners

  2. ((b))

    Open end questions are given to learners

  3. ((c))

    Gives freedom to learners

  4. ((d))

    Dictates terms with learners.

Show Answer
Answer: ((c))

Gives freedom to learners

Constructive learning is based on the idea that learners actively construct knowledge rather than passively receiving information. In this approach, students engage with content, ask questions, explore possibilities, and relate new information to their prior experiences.

Key Points

  • The role of teachers in constructive learning is to give freedom to learners.
  • Teachers act as facilitators or guides, providing opportunities, resources, and support while allowing students to explore, make decisions, and solve problems independently.
  • This approach encourages critical thinking, creativity, and ownership of learning, fostering deeper understanding and long-term retention.

 HintImposing conditions, dictating terms, or only giving open-ended questions without guidance restricts autonomy and does not fully embody the principles of constructive learning.

Hence, the correct answer is gives freedom to learners.

70

The teacher controls the environment in:

  1. ((a))

    Behaviourism

  2. ((b))

    Cognitivism 

  3. ((c))

    Naturalism

  4. ((d))

    Realism

Show Answer
Answer: ((a))

Behaviourism

Different learning theories emphasize the role of the teacher and environment in shaping learning. In some approaches, the teacher actively structures and controls the learning process, while in others, learners explore and construct knowledge more independently.

Key Points

  • In behaviourism, the teacher controls the environment to shape learning through stimuli, reinforcement, and rewards or punishments.
  • The environment is structured so that desired behaviors are encouraged, and undesired behaviors are minimized.
  • This systematic control ensures that learners respond in predictable ways, reinforcing learning outcomes.

 Hint

  • Cognitivism focuses on mental processes, naturalism emphasizes learning from nature and experience, and realism stresses understanding reality but does not centralize teacher-controlled conditioning.

Hence, the correct answer is behaviourism.

71

'Cerebral Palsy' a kind disability comes under :

  1. ((a))

    Intellectual disability

  2. ((b))

    Mental disability 

  3. ((c))

    Physical disability 

  4. ((d))

    Sensory disability

Show Answer
Answer: ((c))

Physical disability 

Cerebral Palsy (CP) is a condition that affects movement, muscle tone, and posture due to brain damage occurring before, during, or shortly after birth. It primarily impacts a person’s physical abilities, though intellectual functioning may vary.

 Key Points

  • Cerebral Palsy comes under physical disability because it involves motor impairments such as difficulty in walking, coordination, or controlling muscles.
  • Educational and therapeutic interventions focus on physical therapy, adaptive equipment, and skill development to enhance mobility and independence.

 Hint

  • Intellectual disability affects cognitive functioning, mental disability is a broader term for psychiatric conditions, and sensory disability refers to impairments in vision or hearing.

Hence, the correct answer is physical disability.

72

'Dysgraphia' is characterised by:

  1. ((a))

    Poor learning

  2. ((b))

    Poor vision

  3. ((c))

    Poor hand writing

  4. ((d))

    Poor speech

Show Answer
Answer: ((c))

Poor hand writing

Dysgraphia is a specific learning disability that primarily affects a child’s ability to write coherently, legibly, and efficiently. It is not related to intelligence but rather to difficulties in fine motor skills, spelling, or organizing written expression.

 Key Points

  • Dysgraphia is characterized by poor handwriting, often accompanied by slow writing speed, inconsistent spacing, or difficulty in forming letters.
  • Children with dysgraphia may struggle to express their thoughts on paper even if they understand the content perfectly.

 Hint

  • Poor learning is a general term, poor vision affects sight, and poor speech relates to verbal communication; none of these specifically define dysgraphia.

Hence, the correct answer is poor handwriting.

73

What is the role of teacher while teaching disabled children?

  1. ((a))

    Resort to Tailor made teaching techniques to suit disabled children.

  2. ((b))

    Special classes separately for disabled.

  3. ((c))

    Special incentives for disabled.

  4. ((d))

    Special furniture to be arranged for disabled.

Show Answer
Answer: ((a))

Resort to Tailor made teaching techniques to suit disabled children.

Teaching children with disabilities requires adapting instruction to meet their individual learning needs while promoting inclusion and effective learning. 

Key Points

  • The teacher’s role is to resort to tailor-made teaching techniques to suit disabled children.
  • This involves using individualized approaches, multisensory methods, assistive devices, and differentiated instruction based on the child’s strengths and challenges.
  • Such strategies help children with disabilities participate actively in learning, build confidence, and achieve their potential.

 Hint

  • Special classes, incentives, or furniture may support learning but are supplementary measures; the core role lies in adapting teaching techniques to the learner’s needs.

Hence, the correct answer is resort to tailor-made teaching techniques to suit disabled children.

74

What is School Development Plan? 

  1. ((a))

    Document for Academic Plan

  2. ((b))

    ​Plan for School Architecture

  3. ((c))

    ​Road Map that sets out for success of school

  4. ((d))

    Guide to implement strategies

Show Answer
Answer: ((c))

​Road Map that sets out for success of school

A School Development Plan (SDP) is a strategic tool that guides the overall growth and improvement of a school. It outlines objectives, priorities, and actions to enhance teaching, learning, infrastructure, and student outcomes.  

Key Points

  • The School Development Plan acts as a road map that sets out the path for the success of the school.
  • It identifies goals, allocates resources, schedules activities, and establishes evaluation mechanisms to monitor progress.
  • By providing a clear vision and strategy, it helps teachers, management, and stakeholders work collaboratively toward continuous improvement.

 Hint

  • While an academic plan focuses only on curriculum, planning school architecture relates to infrastructure, and guides for implementing strategies are partial aspects, the SDP encompasses the holistic development and long-term success of the school.

Hence, the correct answer is road map that sets out for success of school.

75

Normally what type of Time-Tables are prepared in schools?

  1. ((a))

    Home work Time Table

  2. ((b))

    Sports Time Table

  3. ((c))

    Class Time Table and Teacher Time Table

  4. ((d))

    C.C.A. Time-Table

Show Answer
Answer: ((c))

Class Time Table and Teacher Time Table

A time-table in a school is a structured schedule that organizes teaching and learning activities, ensuring proper allocation of time for subjects, teachers, and other school programs. It helps in maintaining discipline, optimizing resources, and providing a balanced routine for students and staff.

 Key Points

  • Normally, schools prepare class time-tables and teacher time-tables.
  • The class time-table specifies subjects, periods, and activities for each class, while the teacher time-table indicates teaching assignments and schedules for each teacher.
  • Together, they ensure smooth functioning of daily academic activities and effective use of teaching staff.

 HintHome work time-tables, sports time-tables, and C.C.A. time-tables may also be prepared but are supplementary to the main academic and teacher schedules.

Hence, the correct answer is class time-table and teacher time-table.

76

Which one of the followings would form bridge between School and Home?

  1. ((a))

    Non-Governmental Organization

  2. ((b))

    Parent Teacher Association 

  3. ((c))

    National Social Service

  4. ((d))

    National Cadet Corps

Show Answer
Answer: ((b))

Parent Teacher Association 

A strong connection between school and home is essential for supporting a child’s learning and overall development. Effective communication and collaboration help parents understand school programs, monitor progress, and contribute to educational planning.

 Key Points

  • The Parent Teacher Association (PTA) forms a bridge between school and home because it facilitates regular interaction, discussion, and cooperation between teachers and parents.
  • Through PTA meetings, parents learn about the curriculum, school activities, and their child’s progress, while teachers gain insights into the child’s home environment and needs.
  • This partnership ensures continuity of learning and a supportive environment for the child.

 HintNon-Governmental Organizations, National Social Service, and National Cadet Corps may support broader educational or social programs but do not directly connect individual families with schools.

Hence, the correct answer is Parent Teacher Association.

77

What is the role of ‘Morning Assembly in child's development ?

  1. ((a))

    It influences positively on child to develop social value and self-esteem

  2. ((b))

    Promotes discipline

  3. ((c))

    Place for disseminating information

  4. ((d))

    Promotes Punctuality

Show Answer
Answer: ((a))

It influences positively on child to develop social value and self-esteem

Morning assembly is an important daily ritual in schools that contributes to the holistic development of children. It is not just a routine gathering but a structured activity that fosters social, emotional, and moral growth.

 Key Points

  • The role of morning assembly is that it influences positively on the child to develop social values and self-esteem.
  • During assembly, children engage in group activities such as prayers, songs, presentations, or discussions, which promote teamwork, respect, empathy, and confidence.
  • Participation helps children feel included, express themselves, and internalize values like honesty, responsibility, and cooperation.

 HintWhile it also promotes discipline, disseminates information, and encourages punctuality, these are secondary benefits compared to its impact on social and emotional development.

Hence, the correct answer is it influences positively on child to develop social value and self-esteem.

78

What is ‘Balavatika' Programme envisaged in NEP-2020 ?

  1. ((a))

    Learning of a child after 5 years of age.

  2. ((b))

    The learning of a child prior to the age of 5.

  3. ((c))

    Learning of a child in primary section.

  4. ((d))

    Learning of a child up to class VIII.

Show Answer
Answer: ((b))

The learning of a child prior to the age of 5.

Balavatika is a programme envisioned in NEP-2020 under the Early Childhood Care and Education (ECCE) framework. It focuses on providing play-based, activity-rich learning environments for young children before they enter formal schooling.

Key Points

  • The Balavatika programme targets the learning of a child prior to the age of 5.
  • It emphasizes development of foundational literacy and numeracy, social-emotional skills, motor development, and curiosity through play and interactive activities.
  • This early engagement ensures that children are prepared for formal schooling and can achieve foundational learning goals in primary education.

Hence, the correct answer is the learning of a child prior to the age of 5.

79

What is the aim of 'DIKSHA' [Digital Infrastructure for Knowledge sharing] proposed in NEP 2020?

  1. ((a))

    ICT interface with Teaching

  2. ((b))

    Digital Platform for students

  3. ((c))

    Technological Intervention to achieve Foundational Literacy and Numeracy in Primary Education.

  4. ((d))

    Digital Platform for competitive examinations

Show Answer
Answer: ((c))

Technological Intervention to achieve Foundational Literacy and Numeracy in Primary Education.

DIKSHA (Digital Infrastructure for Knowledge Sharing) is an initiative under NEP 2020 aimed at leveraging technology to enhance teaching and learning. It provides a national platform for digital content, resources, and professional development for teachers and students.

Key Points

  • The primary aim of DIKSHA is technological intervention to achieve Foundational Literacy and Numeracy in Primary Education.
  • Through interactive lessons, activities, and resources aligned with the curriculum, DIKSHA supports teachers in delivering quality education and helps students acquire essential reading, writing, and arithmetic skills.
  • It ensures accessibility, inclusivity, and innovation in early learning across the country.

Hence, the correct answer is technological intervention to achieve Foundational Literacy and Numeracy in Primary Education.

80

Who applied 'Pragmatism' in Education?

  1. ((a))

    Watson

  2. ((b))

    Rousseau

  3. ((c))

    Hegel

  4. ((d))

    John Dewey

Show Answer
Answer: ((d))

John Dewey

Pragmatism in education is a philosophy that emphasizes learning by doing, experiential learning, and the practical application of knowledge. It focuses on developing problem-solving skills, critical thinking, and the ability to adapt knowledge to real-life situations.

Key Points

  • John Dewey applied pragmatism in education. He advocated for a child-centered approach, where students learn through experience, experimentation, and interaction with their environment.
  • Dewey believed that education should prepare children for active participation in society by connecting learning to practical life situations.

Watson is associated with Behaviourism, Rousseau with Naturalism, and Hegel with Idealism in education.

Hence, the correct answer is John Dewey.

Subject Specific (100 questions)

81

Which of the following is not hardware of a computer system?

  1. ((a))

    KEYBOARD

  2. ((b))

    PRINTER

  3. ((c))

    OPERATING SYSTEM

  4. ((d))

    MOUSE

Show Answer
Answer: ((c))

OPERATING SYSTEM

The correct answer is OPERATING SYSTEM

Key Points

  • Hardware refers to the physical components of a computer system.
  • Examples of hardware include the keyboard, mouse, and printer.
  • The operating system is a software component and not hardware.
  • Software allows users to interact with hardware and perform tasks.

Additional Information

  • Hardware: Includes devices like the CPU, monitor, and peripherals.
  • Software: Includes operating systems, applications, and programs.
  • Operating System: Acts as an interface between the hardware and the user.
  • Example: Windows, macOS, Linux are popular operating systems.
82

Which out of the following is the least capacity of memory unit compared to other options?

  1. ((a))

    MB

  2. ((b))

    KB

  3. ((c))

    GB

  4. ((d))

    TB

Show Answer
Answer: ((b))

KB

The correct answer is KB

Key Points

  • KB stands for Kilobyte, which is smaller than MB, GB, and TB.
  • 1 KB = 1024 Bytes.
  • Memory units increase in size as follows: KB < MB < GB < TB.
  • Hence, KB has the least capacity compared to other options.

Additional Information

  • Memory Unit Hierarchy: The commonly used memory units are Bytes, KB, MB, GB, and TB, arranged in increasing order of capacity.
  • 1 MB: Equals 1024 KB.
  • 1 GB: Equals 1024 MB.
  • 1 TB: Equals 1024 GB.
83

A collection of 4 bits is known as ________

  1. ((a))

    BYTE

  2. ((b))

    WORD

  3. ((c))

    NIBBLE

  4. ((d))

    K.BYTE

Show Answer
Answer: ((c))

NIBBLE

The correct answer is NIBBLE

Key Points

  • A nibble is a collection of 4 bits.
  • It is half of a byte, as a byte consists of 8 bits.
  • Nibbles are used in computing for compact data representation.
  • For example, a single hexadecimal digit (0-9, A-F) corresponds to a nibble.

Additional Information

  • BYTE: A byte is made up of 8 bits, which is twice the size of a nibble.
  • WORD: A word typically refers to the number of bits processed by a computer's processor in one operation, commonly 16, 32, or 64 bits.
  • KILOBYTE: A kilobyte (KB) consists of 1024 bytes in computing terminology.
  • Hexadecimal System: A nibble can represent values from 0 to 15 in hexadecimal (base-16) format.
84

While working on computer, if we open a document in MS OFFICE WORD, which of the following is used?

  1. ((a))

    RAM

  2. ((b))

    ROM

  3. ((c))

    BIOS

  4. ((d))

    I/O BUS

Show Answer
Answer: ((a))

RAM

The correct answer is RAM

Key Points

  • RAM is a type of volatile memory.
  • It temporarily stores data while the computer is running.
  • MS OFFICE WORD utilizes RAM to load and edit documents efficiently.
  • RAM ensures quick access to data for smooth operation of software.

Additional Information

  • ROM: Stores permanent data and instructions; not used for document editing.
  • BIOS: Initializes hardware during booting; unrelated to document editing.
  • I/O BUS: Facilitates communication between components but does not directly handle document processing.
  • RAM: Essential for running applications and performing real-time operations.
85

_______ is not an operating system.

  1. ((a))

    ​UNIX

  2. ((b))

    WINDOWS

  3. ((c))

    ANDROID

  4. ((d))

    MS OFFICE

Show Answer
Answer: ((d))

MS OFFICE

The correct answer is MS OFFICE

Key Points

  • MS Office is not an operating system, it is a productivity suite.
  • Operating systems like UNIX, WINDOWS, and ANDROID manage hardware and software resources.
  • MS Office includes applications like Word, Excel, and PowerPoint for document creation and management.
  • Operating systems provide the platform for applications like MS Office to run.

Additional Information

  • Operating System: It is the system software that manages computer hardware and software resources.
  • Examples of Operating Systems: UNIX, WINDOWS, ANDROID, and Linux.
  • MS Office: A productivity suite developed by Microsoft, commonly used for office work.
  • Key Difference: An operating system is essential for running a computer, while MS Office is an application software that runs on an operating system.
86

What will be the result of the following Boolean expression?

NOT True OR False AND True

  1. ((a))

    False

  2. ((b))

    True

  3. ((c))

    Error in Expression

  4. ((d))

    No result

Show Answer
Answer: ((a))

False

The correct answer is false

Key Points

  • The Boolean expression is evaluated based on operator precedence and associativity.
  • The "AND" operator has higher precedence than "OR".
  • First, False AND True is evaluated to False.
  • Then, NOT True OR False is evaluated, resulting in False.

Additional Information

  • NOT operator: Negates the value of the operand (NOT True becomes False).
  • AND operator: Returns True if both operands are True; otherwise, returns False.
  • OR operator: Returns True if at least one operand is True; otherwise, returns False.
  • Operator precedence: NOT has the highest precedence, followed by AND, and then OR.
87

Which Boolean expression is correct interpretation of the following logic circuit ?

  1. ((a))

    (X + Y)'

  2. ((b))

    (X.Y)'

  3. ((c))

    X ⊕ Y

  4. ((d))

    (X ⊕ Y)'

Show Answer
Answer: ((c))

X ⊕ Y

The correct answer is X ⊕ Y.

Key Points

  • The given logic symbol represents an XOR (Exclusive OR) gate, identified by the extra curved line on the input side.
  • An XOR gate produces output 1 only when the inputs are different.
  • If both inputs are the same (both 0 or both 1), the output is 0.
  • Therefore, the Boolean expression for this circuit is X ⊕ Y.
  • Options like (X + Y)' and (X·Y)' represent NOR and NAND respectively, not XOR.

Additional Information

  • XOR Truth Table:
  • 0 ⊕ 0 = 0
  • 0 ⊕ 1 = 1
  • 1 ⊕ 0 = 1
  • 1 ⊕ 1 = 0
  • Symbol Recognition:
  • XOR gate looks like an OR gate with an additional curved input line.
  • This visual feature is commonly tested in competitive exams.
  • Important Points:
  • XOR is widely used in adders, parity checkers, and encryption logic.
  • The expression (X ⊕ Y)' would represent XNOR, which is not shown here.
  • Correct identification of logic symbols is essential for digital electronics problems.
88

Which of the following represents Absorption Law correctly?

  1. ((a))

    X + Y . Z = (X + Y) (X + Z)

  2. ((b))

    X + X . Y = X

  3. ((c))

    (X + Y)' = X' Y'

  4. ((d))

    (X . X)' = X'

Show Answer
Answer: ((b))

X + X . Y = X

The correct answer is Option 2) X + X . Y = X.

Key Points

  • The Absorption Law in Boolean algebra states that for any two Boolean variables, the second variable is "absorbed" by the first in specific expressions.
  • The primary forms of the Absorption Law are:

X + X .Y = X

X .(X + Y) = X

  • In the expression X + X . Y = X , if X is 1, the result is 1 regardless of Y. If X is 0, the entire expression becomes 0. Thus, the output is always equal to X.
  • This law is used to simplify complex logic circuits by removing redundant terms.

Additional Information

  • Distributive Law (Option 1):
  • The expression X + Y . Z = (X + Y)(X + Z) represents the second distributive law.
  • De Morgan's Law (Option 3):
  • The expression (X + Y)' = X' Y' is one of De Morgan's theorems, stating that the complement of a sum is equal to the product of the complements.
  • Idempotent Law (Option 4):
  • The expression (X .X)' = X' is derived from the Idempotent law ( X . X = X ) combined with a NOT operation.
89

Which of the following is exact equivalent of given binary number in Octal Number?

(101110001011)2

  1. ((a))

    (232023)8

  2. ((b))

    (A8A)8

  3. ((c))

    (5613)8

  4. ((d))

    (3165)8

Show Answer
Answer: ((c))

(5613)8

The correct answer is (5613).

Key Points

  • The given binary number is (101110001011)2.
  • To convert binary to octal, group the binary digits into sets of three from right to left.
  • The binary number can be grouped as 101 110 001 011.
  • Each group is converted to its octal equivalent.
  • 1012 = 58, 1102 = 68.
  • 0012 = 18, 0112 = 38.
  • Combining the octal digits gives (5613)8.
  • Hence, option 3 is the correct answer.
90

What is full form of ISCII encoding scheme?

  1. ((a))

    ​Indian Standard Code for Interchange of Information

  2. ((b))

    Indian Standard Code for Information Interchange

  3. ((c))

    Indian Standard Coding for Information Interchange

  4. ((d))

    Indian Scheme of Coding for Information Interchange

Show Answer
Answer: ((b))

Indian Standard Code for Information Interchange

The correct answer is Indian Standard Code for Information Interchange**(ISCII)**.

Key Points

  • ISCII stands for Indian Standard Code for Information Interchange.
  • It is a character encoding standard developed in India.
  • ISCII is designed to support multiple Indian languages using a single encoding scheme.
  • It is based on a 7-bit extension of ASCII.
  • ISCII was standardized by the Bureau of Indian Standards (BIS).
  • The encoding scheme played an important role before the wide adoption of Unicode.
91

Which of the following cannot be registered under cyber crime?

  1. ((a))

    Sending pornographic material online

  2. ((b))

    Stealing of brand new internet routers from a showroom

  3. ((c))

    Accessing CCTV camera of a private company without their knowledge

  4. ((d))

    Sending threats on social media accounts

Show Answer
Answer: ((b))

Stealing of brand new internet routers from a showroom

The correct answer is Option 2

Key Points

  • Cybercrime refers to illegal activities conducted through the internet.
  • Sending pornographic material online, accessing CCTV cameras without knowledge, and sending threats on social media are all categorized as cybercrimes.
  • Stealing physical items like internet routers from a showroom does not constitute a cybercrime.
  • Cybercrime generally involves unauthorized access, data theft, or online harassment.

Additional Information

  • Sending pornographic material: This is a cybercrime as it violates laws related to obscene or explicit content distribution.
  • Accessing CCTV cameras without consent: Unauthorized access to private systems is a cybercrime under hacking or privacy laws.
  • Sending threats on social media: This is a cybercrime that falls under online harassment or cyberbullying.
  • Theft of physical goods: This is classified as a criminal offense but not a cybercrime, as it does not involve internet-based activities.
92

Which of the following is an example of a very strong password?

  1. ((a))

    STRONG

  2. ((b))

    abc1234

  3. ((c))

    admin

  4. ((d))

    Ap9#2@cQ

Show Answer
Answer: ((d))

Ap9#2@cQ

The correct answer is Ap9#2@cQ

Key Points

  • A strong password combines uppercase, lowercase letters, numbers, and special characters.
  • It should be at least 8 characters long for better security.
  • Avoid predictable patterns like "abc1234" or common terms like "admin".
  • Passwords should not include personal information or easily guessed phrases.

Additional Information

  • Password Strength: Strong passwords help protect accounts from unauthorized access.
  • Password Management: Use a password manager to store and generate secure passwords.
  • Regular Updates: Change your passwords periodically to enhance security.
  • Two-Factor Authentication (2FA): Enable 2FA for an additional layer of security.
93

Which of the following protocol is used to upload and download files from remote server/computers ?

  1. ((a))

    SMTP

  2. ((b))

    VoIP

  3. ((c))

    HTTP

  4. ((d))

    FTP

Show Answer
Answer: ((d))

FTP

The correct answer is FTP

Key Points

  • FTP (File Transfer Protocol) is specifically designed for file transfer.
  • It allows uploading and downloading files between a local system and a remote server.
  • FTP uses port 21 for communication and ensures file integrity during transfer.
  • It is commonly used for website management and data exchange between systems.

Additional Information

  • SMTP: Used for sending emails, not file transfers.
  • VoIP: Facilitates voice communication over IP networks.
  • HTTP: Used for accessing web pages and web services.
  • FTP: Allows secure and reliable file transfer between hosts.
94

Garuda Skill Education has set up their new skill training campus in a place near Pune. The campus has three close by buildings connected with each other using CAT6 cable. Which type of network is established in the campus?

  1. ((a))

    PAN

  2. ((b))

    MAN

  3. ((c))

    LAN

  4. ((d))

    WAN

Show Answer
Answer: ((c))

LAN

The correct answer is LAN

Key Points

  • LAN stands for Local Area Network.
  • It is a network confined to a specific area, such as a building or a campus.
  • LANs are typically used to connect computers, printers, and other devices within the same building or nearby buildings.
  • In this case, the three connected buildings near Pune form a LAN as they are interconnected using CAT6 cable.

Additional Information

  • PAN: Personal Area Network is used for connecting personal devices in a short range (e.g., Bluetooth).
  • MAN: Metropolitan Area Network spans a larger area, such as a city or a town.
  • WAN: Wide Area Network covers a broad geographical area, like connecting different cities or countries.
  • LAN: It is faster, more secure, and used for local connectivity, which matches the scenario described.
95

Which of the following is not a Network device?

  1. ((a))

    Switch

  2. ((b))

    Router

  3. ((c))

    Hub

  4. ((d))

    RAM

Show Answer
Answer: ((d))

RAM

The correct answer is RAM

Key Points

  • RAM (Random Access Memory) is not a network device.
  • Network devices include Switch, Router, and Hub, which are used to facilitate communication between devices in a network.
  • RAM is a hardware component that temporarily stores data and instructions for the computer.
  • It is primarily used in computing systems and is unrelated to network functionalities.

Additional Information

  • Switch: A network device that connects devices within the same network and directs data to its intended destination.
  • Router: A device that connects multiple networks and routes data between them.
  • Hub: A basic network device that connects multiple devices but does not intelligently route data.
  • RAM: Used for storing temporary data, enabling faster processing in computing systems, but not involved in networking tasks.
96

Which of the following wired medium will be able to have highest speed data communication possible?

  1. ((a))

    Single pair telephone cable

  2. ((b))

    Fiber optic cable

  3. ((c))

    Co-axial cable

  4. ((d))

    Twisted pair cable

Show Answer
Answer: ((b))

Fiber optic cable

The correct answer is Fiber optic cable

Key Points

  • Fiber optic cables are designed for high-speed data communication.
  • They use light signals to transmit data, which ensures minimal signal loss and interference.
  • Fiber optics can support speeds up to several terabits per second.
  • They are ideal for long-distance and high-bandwidth applications.

Additional Information

  • Single pair telephone cable: Used for voice communication and low-speed data transfer.
  • Co-axial cable: Supports higher speeds than telephone cables but is limited compared to fiber optics.
  • Twisted pair cable: Commonly used for Ethernet connections, capable of moderate speeds but limited distance.
  • Fiber optic cable: The fastest medium for data communication, resistant to electromagnetic interference.
97

Which of the following is an invalid IP address?

  1. ((a))

    100.0.10.32

  2. ((b))

    255.255.255.10

  3. ((c))

    192.168.10.15

  4. ((d))

    256.10.12.5

Show Answer
Answer: ((d))

256.10.12.5

The correct answer is 4) 256.10.12.5

Key Points

  • An IP address consists of four octets separated by dots.
  • Each octet must be a number between 0 and 255.
  • The given IP "256.10.12.5" is invalid because 256 exceeds the maximum allowable value of 255.
  • All other options represent valid IP addresses within the range of 0-255 for each octet.

Additional Information

  • IP Address: It is a unique identifier assigned to each device connected to a network.
  • IPv4: The most common format of IP addresses, consisting of four octets.
  • Valid Range: Each octet in an IPv4 address must be between 0 and 255.
  • Invalid IPs: Any IP address with an octet outside the range of 0-255 is invalid.
98

What is full form of ARPANET?

  1. ((a))

    Advancement of Research Project Agency Network 

  2. ((b))

    Advanced Research Project Agency Network 

  3. ((c))

    Add on Research Project Agency Network 

  4. ((d))

    American Research Project Agency Network

Show Answer
Answer: ((b))

Advanced Research Project Agency Network 

The correct answer is Advanced Research Project Agency Network

Key Points

  • ARPANET was developed in 1969.
  • It was an early packet-switching network.
  • It laid the foundation for the modern Internet.
  • ARPANET was funded by the Advanced Research Projects Agency (ARPA).

Additional Information

  • Packet Switching: A method of grouping data into packets for efficient communication.
  • Internet Evolution: ARPANET is considered the precursor to the Internet.
  • Key Researchers: Contributions by Leonard Kleinrock and others were crucial.
  • Shutdown: ARPANET was officially decommissioned in 1990.
99

Which of the following is not an example of cloud computing services?

  1. ((a))

    SaaS

  2. ((b))

    IaaS

  3. ((c))

    PaaS

  4. ((d))

    Saap

Show Answer
Answer: ((d))

Saap

The correct answer is Saap

Key Points

  • SaaS (Software as a Service): A cloud computing service that provides software applications over the internet.
  • IaaS (Infrastructure as a Service): Offers virtualized computing resources over the internet.
  • PaaS (Platform as a Service): A platform that allows developers to build applications without managing underlying infrastructure.
  • Saap is not a recognized model of cloud computing services, which makes it the correct answer.

Additional Information

  • SaaS: Examples include Google Workspace (Gmail, Docs), Salesforce, and Dropbox.
  • IaaS: Examples include Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform.
  • PaaS: Examples include Heroku, Microsoft Azure App Services, and Google App Engine.
  • Cloud Computing Models: These models provide flexibility, scalability, and cost-effectiveness for users and businesses.
100

Which of the following is not an application of AI?

  1. ((a))

    Chat Bot

  2. ((b))

    Financial Accounting System

  3. ((c))

    Driverless Car

  4. ((d))

    Face Recognition System

Show Answer
Answer: ((b))

Financial Accounting System

The correct answer is Option 2

Key Points

  • Artificial Intelligence (AI) is used in various fields like automation, prediction, and decision-making.
  • Applications like chatbots, driverless cars, and face recognition systems rely on AI technologies.
  • Financial Accounting Systems are rule-based systems and do not generally incorporate AI.
  • AI focuses on learning and adapting, whereas financial accounting systems are static and predefined.

Additional Information

  • Chatbots: AI-powered systems that simulate human-like conversations.
  • Driverless Cars: Vehicles equipped with AI to navigate without human intervention.
  • Face Recognition Systems: AI-based systems used for identifying and verifying faces.
  • Financial Accounting Systems: Typically involve manual or predefined processes without using AI.
101

Which of the following is an invalid identifier in Python Programming Language?

  1. ((a))

    none

  2. ((b))

    False

  3. ((c))

    true

  4. ((d))

    For

Show Answer
Answer: ((b))

False

The correct answer is false.

Key Points

  • false is an invalid identifier in Python because it is a reserved keyword.
  • Reserved keywords in Python are predefined and have special meanings within the programming language, and thus cannot be used as identifiers.
  • Other examples of reserved keywords include True, None, and For, but they are valid identifiers because they are case-sensitive.
  • Identifiers in Python must start with a letter (a-z, A-Z) or an underscore (_), followed by letters, underscores, or digits (0-9).
  • Using reserved keywords as identifiers will result in a SyntaxError.

Additional Information

  • Examples of Valid Identifiers:
  • my_var: Starts with a letter and contains an underscore; valid identifier.
  • _myVar: Begins with an underscore; valid identifier.
  • var123: Combines letters and numbers; valid identifier.
  • Examples of Invalid Identifiers:
  • 1var: Begins with a digit; invalid identifier.
  • my-var: Contains a hyphen; invalid identifier.
  • class: Reserved keyword; invalid identifier.
  • Important Points:
  • Python identifiers are case-sensitive, meaning False and false are treated differently.
  • Identifiers cannot include special characters such as @, $, %, etc.
  • It is a good practice to use descriptive names for identifiers to improve code readability.
102

Which of the following is not a valid operator in Python?

  1. ((a))

    = =

  2. ((b))

    = >

  3. ((c))

    / /

  4. ((d))
Show Answer
Answer: ((b))

= >

Correct answer is: Option 2.

Key Points

Understanding Operators in Python:

In Python, operators are special symbols used to perform operations on variables and values. These include arithmetic operators, comparison operators, logical operators, and others. Python has a fixed set of valid operators, and any symbol not defined as an operator will result in a syntax error.

Explanation:

Let us examine each of the given options to determine whether it is a valid Python operator:

  • Option 1: ==

This is the equality comparison operator. It is used to check whether two values are equal. This is a valid operator in Python.

  • Option 2: =>

This operator is not valid in Python. Python uses >= for “greater than or equal to”, not =>. Using => will result in a syntax error.

  • Option 3: //

This is the floor division operator. It divides two numbers and returns the integer part of the result. This is a valid Python operator.

  • **Option 4:

This is the exponentiation operator, used to raise a number to a power. This is also a valid Python operator.

Among all the options, only => is not recognized as an operator in Python.

Hence, the correct answer is: Option 2.

103

Identify the correct output of the following Python arithmetic expression:

1 + (2 - 3) * 4 * * 5 / / 6

  1. ((a))

    -171

  2. ((b))

    172

  3. ((c))

    -170

  4. ((d))

    170

Show Answer
Answer: ((c))

-170

The correct answer is -170.

Key Points

  • The expression given is 1 + (2 - 3) * 4 ** 5 // 6.
  • First, parentheses are evaluated: 2 - 3 = -1.
  • Next, exponentiation is applied: 4 ** 5 = 1024.
  • Multiplication gives -1 × 1024 = -1024.
  • Floor division in Python rounds toward negative infinity: -1024 // 6 = -171.
  • Finally, 1 + (-171) = -170, which is the correct output.

Additional Information

  • Python Operator Precedence:
  • Parentheses ()
  • Exponentiation **
  • Multiplication * and Floor Division //
  • Addition + and Subtraction -
  • Important Points:
  • The // operator performs floor division, not simple truncation.
  • For negative values, floor division always moves to the lower integer.
  • Understanding operator precedence is essential for solving such Python arithmetic questions.
104

Evaluate the following expression:

not True or not False and False

  1. ((a))

    True

  2. ((b))

    False

  3. ((c))

    None

  4. ((d))

    will generate an Error

Show Answer
Answer: ((b))

False

Correct answer is: option 2) False.

Concept:

Logical Operator Precedence in Python:

To evaluate a logical expression containing multiple operators, Python follows a specific order of precedence (the order in which operations are performed). The precedence rule for logical operators is:

  1. not (Highest precedence)
  2. and
  3. path (Lowest precedence)

Additionally, the not operator flips the boolean value: not True becomes False, and not False becomes True.

Explanation:

Let's evaluate the expression step-by-step using the rules of precedence:

Expression: not True or not False and False

Step 1: Evaluate not operators (Highest Precedence)

The expression contains two not operations:

  • not True becomes False
  • not False becomes True

The expression now looks like this: False or True and False

Step 2: Evaluate and operator (Medium Precedence)

Now we evaluate the and operation: True and False.

  • In logical AND, if any operand is False, the result is False.
  • Therefore, True and False results in False.

The expression now looks like this: False or False

Step 3: Evaluate or operator (Lowest Precedence)

Finally, we evaluate the or operation: False or False.

  • In logical OR, if both operands are False, the result is False.

Final Result: False

Hence, the correct answer is: option 2) False.

105

Identify the correct output of the following Python Command:

Print (10 or 40)

  1. ((a))

    10

  2. ((b))

    40

  3. ((c))

    50

  4. ((d))

    400

Show Answer
Answer: ((a))

10

Correct answer is: option 1) 10

Concept:

Short-Circuit Evaluation of Logical OR in Python:

In Python, the logical or operator doesn't always return a boolean value (True or False). Instead, it returns one of the operands based on Short-Circuit Evaluation. For an expression xx or yy:

  • Python evaluates xx first.
  • If xx is truthy (any non-zero number, non-empty string, etc.), Python returns xx immediately and does not even look at yy.
  • If xx is falsy (zero, None, or empty), Python returns yy.

Explanation:

Let's apply this logic to the command provided:

print(10 or 40)

  1. Evaluate the first operand:

The first value is 10. In Python, any non-zero integer is considered "truthy."

  1. Apply short-circuit logic:

Since the first operand (10) is true, the or operator is satisfied. Python does not need to check the second value (40) because the condition "at least one is true" is already met by the 10.

  1. Return the value:

The expression evaluates to the first truthy value encountered, which is 10.

  1. Note on Case Sensitivity:

In actual Python code, Print with a capital 'P' would cause a NameError because the built-in function is print(). However, in the context of this multiple-choice question, we evaluate the logical result of the operation.

Hence, the correct answer is: option 1) 10

106

Identify the correct output of the following Python program segment?

Pi = 3.141592

print ("%.4f % Pi)

  1. ((a))

    3.14

  2. ((b))

    3.1415

  3. ((c))

    3.1416

  4. ((d))

    3.0000

Show Answer
Answer: ((c))

3.1416

Correct answer is: Option 3.

Key Points

Understanding String Formatting and Rounding in Python:

Python provides old-style string formatting using the % operator. Format specifiers like %.nf are used to control the number of digits displayed after the decimal point, where n represents the required precision.

Explanation:

Let us analyze the given Python code step by step:

Pi = 3.141592 print("%.4f" % Pi)

  1. Pi = 3.141592

The variable Pi stores a floating-point value with six digits after the decimal.

  1. "%.4f" % Pi

Here, .4f specifies that the floating-point number should be formatted to 4 digits after the decimal point.

  1. Rounding behavior:

To round the number correctly, Python looks at the 5th digit after the decimal.

  • Original value: 3.141592
  • First four decimal digits: 1415
  • 5th digit: 9 (which is ≥ 5)

Since the 5th digit is greater than or equal to 5, the 4th digit is rounded up.

So:

3.1415 → 3.1416

Evaluating the options:

  • Option 1: 3.14 — Incorrect (only 2 decimal places)
  • Option 2: 3.1415 — Incorrect (no rounding applied)
  • Option 3: 3.1416 — Correct
  • Option 4: 3.0000 — Incorrect

Hence, the correct answer is: Option 3.

107

Which of the following is immutable data type in Python?

  1. ((a))

    Set

  2. ((b))

    List

  3. ((c))

    Tuple

  4. ((d))

    Dictionary

Show Answer
Answer: ((c))

Tuple

Correct answer is: Option 3.

Key Points

Understanding Mutable and Immutable Data Types in Python:

In Python, data types are classified as mutable or immutable based on whether their contents can be changed after creation.

Explanation:

A data type is called immutable if its value cannot be modified once it is created. Any operation that appears to modify an immutable object actually creates a new object in memory.

Let us analyze each of the given data types:

  • Option 1: Set

Sets are mutable. Elements can be added or removed after creation.

  • Option 2: List

Lists are mutable. Their elements can be changed, added, or deleted.

  • Option 3: Tuple

Tuples are immutable. Once created, their elements cannot be modified.

  • Option 4: Dictionary

Dictionaries are mutable. Key-value pairs can be added, removed, or updated.

Among the given options, only tuples do not allow modification after creation.

Hence, the correct answer is: Option 3.

108

If we have 2 Python lists as follow:

List1 = [10, 20, 30]

List2= [40, 50, 60]

If we want to generate a list List3 as

List3 = [10, 20, 30, 40, 50, 60]

then best Python command out of the following is:

  1. ((a))

    List3 = List1+List2

  2. ((b))

    List3 = List 1 .append (List2)

  3. ((c))

    List3 = List 1 . update (List2)

  4. ((d))

    List3 = List 1.extend (List2)

Show Answer
Answer: ((a))

List3 = List1+List2

Correct answer is: Option 1

Key Points

Combining Lists in Python:

In Python, lists can be combined using different methods such as concatenation and list methods like append() and extend(). However, not all methods produce a new combined list in the desired way.

Explanation:

Given the two lists:

List1 = [10, 20, 30] List2 = [40, 50, 60]

The required result is:

List3 = [10, 20, 30, 40, 50, 60]

Let us analyze each option:

  • Option 1: List3 = List1 + List2

The + operator concatenates two lists and creates a new list containing elements of both lists in order. This directly produces the required output.

  • Option 2: List3 = List1.append(List2)

The append() method adds the entire List2 as a single element to List1 and returns None. Hence, this is incorrect.

  • Option 3: List3 = List1.update(List2)

The update() method does not exist for lists. This option is invalid.

  • Option 4: List3 = List1.extend(List2)

The extend() method adds elements of List2 to List1 but modifies List1 in place and returns None. It does not create a new list assigned to List3.

Only Option 1 correctly creates a new list List3 with the required elements.

Hence, the correct answer is: Option 1.

109

Identify the correct output of the following Python code:

L= [3, 3, 2, 2, 1, 1]

L.append(L.pop(L.pop()))

print(L)

  1. ((a))

    [3, 2, 2, 1, 3]

  2. ((b))

    [3, 3, 2, 2, 3]

  3. ((c))

    [1, 3, 2, 2, 1]

  4. ((d))

    [1, 1, 2, 2, 3, 3]

Show Answer
Answer: ((a))

[3, 2, 2, 1, 3]

Correct answer is: Option 1.

Concept:

Understanding Nested pop() and append() Operations in Python Lists:

In Python, the pop() method removes and returns an element from a list. If no index is specified, it removes the last element. The append() method adds an element to the end of the list.

When methods are nested, the innermost function is executed first.

Explanation:

Let us analyze the given Python code step by step:

L = [3, 3, 2, 2, 1, 1] L.append(L.pop(L.pop())) print(L)

  1. Initial list:

L = [3, 3, 2, 2, 1, 1]

  1. Evaluate the innermost L.pop():
  • L.pop() removes and returns the last element of the list.
  • Removed value = 1
  • List becomes: [3, 3, 2, 2, 1]
  1. Now evaluate L.pop(1) (since the returned value was 1):
  • This removes the element at index 1.
  • Element at index 1 = 3
  • List becomes: [3, 2, 2, 1]
  1. Now execute L.append(3):
  • The value 3 is appended to the end of the list.
  • Final list becomes: [3, 2, 2, 1, 3]
  1. The print(L) statement prints the final list.

Evaluating the options:

  • Option 1: [3, 2, 2, 1, 3] — Correct
  • Option 2: [3, 3, 2, 2, 3] — Incorrect
  • Option 3: [1, 3, 2, 2, 1] — Incorrect
  • Option 4: [1, 1, 2, 2, 3, 3] — Incorrect

Hence, the correct answer is: Option 1.

110

Identify the output of the Python Command:

print(22.0//5)

  1. ((a))

    4.4

  2. ((b))

    4

  3. ((c))

    4.0

  4. ((d))

    2

Show Answer
Answer: ((c))

4.0

The correct answer is 4.0

Key Points

  • The operator // in Python is used for floor division.
  • First, normal division is performed: 22.0 ÷ 5 = 4.4.
  • Floor division returns the largest integer less than or equal to the result.
  • So, 4.4 becomes 4.0.
  • Because one operand is a float (22.0), the result is also a float.

Additional Information

  • / (Division):
  • Returns the exact result with decimals.
  • // (Floor Division):
  • Returns the integer part of the quotient.
  • Data Type Rule:
  • If any operand is float, the result is also float.
111

Find the output of the following Python code:

L1 = [1, 4, 3, 2]

L2=LI

L1-sort()

print (L2)

  1. ((a))

    [1, 4, 3, 2]

  2. ((b))

    [1, 2, 3, 4]

  3. ((c))

    1 4 3 2

  4. ((d))

    1 2 3 4

Show Answer
Answer: ((b))

[1, 2, 3, 4]

Correct answer is: Option 2.

Concept:

Understanding List Assignment and In-place Sorting in Python:

In Python, when one list variable is assigned to another, both variables refer to the same list object in memory. Any in-place modification done using one variable will be reflected in the other.

The sort() method sorts the list in place, meaning it modifies the original list instead of creating a new one.

Explanation:

Let us examine the given Python code step by step:

L1 = [1, 4, 3, 2] L2 = L1 L1.sort() print(L2)

  1. L1 = [1, 4, 3, 2]

A list is created and assigned to the variable L1.

  1. L2 = L1

Here, L2 is assigned the same reference as L1. Both L1 and L2 now point to the same list object.

  1. L1.sort()

The sort() method sorts the list in place. After sorting, the list becomes:

[1, 2, 3, 4]

Since both L1 and L2 refer to the same list, this change is reflected in L2 as well.

  1. print(L2)

This prints the sorted list.

Evaluating the options:

  • Option 1: [1, 4, 3, 2] — Incorrect, because the list is sorted.
  • Option 2: [1, 2, 3, 4] — Correct.
  • Option 3: 1 4 3 2 — Incorrect format.
  • Option 4: 1 2 3 4 — Incorrect format (missing list brackets).

Hence, the correct answer is: Option 2.

112

If PL is a Python list as follow:

PL=['Basic', 'C', 'C++']

Then what will be the status of the list PL after PL.sort (reverse=True) ?

  1. ((a))

    ['Basic', 'C', 'C++']

  2. ((b))

    ['C++', 'C', 'Basic']

  3. ((c))

    ['C', 'C++', '"Basic"]

  4. ((d))

    ['Basic', 'C++', 'C']

Show Answer
Answer: ((b))

['C++', 'C', 'Basic']

The correct answer is ['C++', 'C', 'Basic']

Key Points

  • The list PL contains strings: ['Basic', 'C', 'C++'].
  • The sort() method sorts the list in place, modifying the original list.
  • The reverse=True argument sorts the list in descending (reverse) order.
  • After sorting in reverse order, PL becomes ['C++', 'C', 'Basic'].

Additional Information

  • sort() method: Used to sort lists in ascending order by default.
  • reverse=True: Argument to sort the list in descending order.
  • In-place modification: The sort() method modifies the original list and does not return a new list.
  • Lexicographical sorting: Sorting is done based on the ASCII values of the characters in strings.
113

Identify the correct output of the following Python program.

CHARR=[['A', 'B'], ['C', 'D'], ['E', 'F']]

print(CHARR [1] [1])

  1. ((a))

    'A'

  2. ((b))

    'B'

  3. ((c))

    'C'

  4. ((d))

    'D'

Show Answer
Answer: ((d))

'D'

The correct answer is Option 4: 'D'

Key Points

  • The CHARR list is a nested list containing sublists.
  • Accessing an element from a nested list requires indexing for both the sublist and the item within the sublist.
  • CHARR[1][1] accesses the second element ('D') of the second sublist.
  • The output of the program is the string 'D'.

Additional Information

  • Nested Lists: Lists can contain other lists as elements, enabling multidimensional data representation.
  • Indexing in Python: Python uses zero-based indexing, meaning the first element is at index 0.
  • Accessing Nested Elements: Use multiple indices to access elements within nested lists.
  • Output Interpretation: Strings in Python are enclosed in single or double quotes.
114

The following Python list S is implemented as a stack.

S=[10, 12, 0, 4, 6]

If 10 is the element added (pushed) last into the stack S, which command from the following option is best to remove (pop) an element from the Stack S, if not empty.

  1. ((a))

    S.pop(0)

  2. ((b))

    S.pop()

  3. ((c))

    S.remove()

  4. ((d))

    S.remove(0)

Show Answer
Answer: ((b))

S.pop()

The correct answer is S.pop()

Key Points

  • A stack follows the LIFO (Last In, First Out) principle.
  • The Python method pop() removes the last element added to the stack.
  • In this case, the last element added to the stack is 10, so using S.pop() will remove it.
  • Other methods like pop(0) or remove() are not suitable for stack operations.

Additional Information

  • Stack: A stack is a linear data structure that works on the principle of LIFO.
  • pop() method: Removes and returns the last element in a list (top of the stack).
  • Alternative methods: pop(0) removes the first element, which violates the LIFO principle.
  • remove() method: Removes the first occurrence of a specified value, not suitable for stack operations.
115

Traditionally the end of a stack from where PUSH(additional) and POP(deletion) take place, popularly known as:

  1. ((a))

    FRONT

  2. ((b))

    TOP

  3. ((c))

    LIFO

  4. ((d))

    FIFO

Show Answer
Answer: ((b))

TOP

The correct answer is Option 2) TOP

Key Points

  • A stack is a linear data structure that follows the Last-In-First-Out (LIFO) principle.
  • The TOP is the logical end of the stack where all data operations, specifically insertions and deletions, are performed.
  • The PUSH operation adds an element to the stack specifically at the top position.
  • The POP operation removes the topmost element from the stack, decreasing the stack size.

Additional Information

  • FRONT: This term is used in a Queue to represent the end from which elements are deleted (Dequeued).
  • REAR: This term is used in a Queue to represent the end where elements are added (Enqueued).
  • LIFO: Standing for Last-In-First-Out, this describes the behavior of a stack where the most recently added item is the first to be removed.
  • FIFO: Standing for First-In-First-Out, this is the standard operating principle for a Queue data structure.
116

Identify the correct output of the Python code:

L1 = [1, 2, 3]

L2 = [4, 5]

L3=[6, 7]

L1.extend(L2)

L1.append(L3)

print(L1)

  1. ((a))

    [1, 2, 3, 4, 5, 6, 7] 

  2. ((b))

    [1, 2, 3, [4, 5], 6, 7]

  3. ((c))

    [1, 2, 3, 4, 5, [6, 7]]

  4. ((d))

    [1, 2, 3, [4, 5], [6, 7]]

Show Answer
Answer: ((c))

[1, 2, 3, 4, 5, [6, 7]]

The correct answer is [1, 2, 3, 4, 5, [6, 7]]

Key Points

  • The extend() method adds the elements of L2 (4, 5) to L1.
  • The append() method adds L3 as a single element (nested list) to L1.
  • The resulting list after extend() is [1, 2, 3, 4, 5].
  • After append(), L1 becomes [1, 2, 3, 4, 5, [6, 7]].

Additional Information

  • extend(): Adds the elements of an iterable to the end of the list.
  • append(): Adds its argument as a single element to the end of the list.
  • Difference: extend() extends the list with multiple elements, whereas append() adds a single element (even if it's a list).
  • Output: The final list structure depends on whether extend() or append() is used.
117

Identify the correct output of the Python code:

TUP ([1, 2], [3, 4], [5, 6])

TUP[2] [1]=8

print(TUP)

  1. ((a))

    ([1, 2], [8, 4], [5, 6])

  2. ((b))

    ([1, 2], [3, 4], [8, 6])

  3. ((c))

    ([1, 2], [3, 4], [5, 8])

  4. ((d))

    will generate an error as a Tuple is immutable

Show Answer
Answer: ((c))

([1, 2], [3, 4], [5, 8])

The correct answer is ([1, 2], [3, 4], [5, 8]).

Key Points

  • The tuple TUP contains three lists: [1, 2], [3, 4], and [5, 6].
  • Although tuples are immutable, the lists inside a tuple are mutable.
  • TUP[2] accesses the third element [5, 6].
  • TUP[2][1] = 8 modifies the second element of that inner list from 6 to 8.
  • Therefore, the updated tuple becomes ([1, 2], [3, 4], [5, 8]).

Additional Information

  • Tuple vs List:
  • Tuples themselves cannot be modified after creation.
  • However, mutable objects (like lists) stored inside tuples can be changed.
  • Important Points:
  • Attempting to reassign a tuple element directly (e.g., TUP[2] = ...) would raise an error.
  • Modifying inner mutable objects is allowed.
  • This concept is frequently tested in Python programming exams.
118

Identify the output of the following Python program segment:

S='Python Programming'

L=S.split()

S=',' .join(L)

print(S)

  1. ((a))

    Python Programming 

  2. ((b))

    Python, Programming 

  3. ((c))

    ,Python  programming,

  4. ((d))

    ,Python, programming,

Show Answer
Answer: ((b))

Python, Programming 

The correct answer is Python, Programming.

Key Points

  • The string S is initially assigned as "Python Programming".
  • S.split() splits the string by spaces, producing the list ['Python', 'Programming'].
  • The expression ', '.join(L) joins the list elements using a comma followed by a space.
  • This results in the new string "Python, Programming".
  • Finally, print(S) outputs Python, Programming.

Additional Information

  • split() Method:
  • Breaks a string into a list based on whitespace by default.
  • join() Method:
  • Combines list elements into a single string using a specified separator.
  • Important Points:
  • The original string is replaced because the result of join() is reassigned to S.
  • Understanding split() and join() is essential for string manipulation in Python.
  • This type of question commonly tests basic string and list operations.
119

If S='python language' is a Python string, which of the following command will display the following output with 'P' in upper case and remaining in lower case?

  1. ((a))

    print(S.upper())

  2. ((b))

    print(S.title())

  3. ((c))

    print(S.capitalize())

  4. ((d))

    print(S.sentence())

Show Answer
Answer: ((c))

print(S.capitalize())

The correct answer is print(S.capitalize()).

Key Points

  • The requirement is to display the string 'python language' with only the first character 'P' in upper case and all other characters in lower case.
  • The capitalize() method in Python is specifically designed for this purpose: it converts the first character of the string to uppercase and ensures all other characters are lowercase.
  • When print(S.capitalize()) is executed on S = 'python language', the output will be 'Python language'.

Additional Information

  • Other String Methods:
  • S.upper(): Converts every single character in the string to uppercase, resulting in 'PYTHON LANGUAGE'.
  • S.title(): Capitalizes the first letter of every word in the string, resulting in 'Python Language'.
  • S.sentence(): This is not a standard Python string method; using it would result in an AttributeError.
  • Method Behavior:
  • If the first character of the string is already a capital letter or a non-alphabetic character (like a number), capitalize() will leave it as is and still convert all subsequent letters to lowercase.
120

Identify the correct output of the following Python Code:

Str = "Hello World! Hello India!"

Pos=Str.index ("Hello')

print (Pos)

  1. ((a))

    0

  2. ((b))

    13

  3. ((c))

    [0, 13]

  4. ((d))

    (0, 13)

Show Answer
Answer: ((a))

0

The correct answer is 0

Key Points

  • The index() method in Python returns the lowest index of the substring if it is found in the string.
  • If the substring is not found, a ValueError is raised.
  • In this example, the first occurrence of the substring "Hello" starts at index 0.
  • The method is case-sensitive, so "Hello" and "hello" would be treated differently.

Additional Information

  • index() Method: It requires the substring to be present in the string; otherwise, it raises an error.
  • Difference Between index() and find(): The find() method returns -1 if the substring is not found, while index() raises an exception.
  • Case Sensitivity: Both index() and find() are case-sensitive.
  • Alternate Methods: You can use slicing or regular expressions for advanced string searching.
121

If a List L = ['Hello', 'World!'] Identify the correct output of the following Python command:

print(*L)

  1. ((a))

    Hello World!

  2. ((b))

    Hello, World!

  3. ((c))

    'Hello', 'World!"

  4. ((d))

    'Hello' 'World!'

Show Answer
Answer: ((a))

Hello World!

The correct answer is Option 1

Key Points

  • *The print(L) command unpacks the elements of the list L.
  • In this case, the elements of the list L are 'Hello' and 'World!'.
  • The unpacking outputs the elements separated by a space by default.
  • Hence, the output is "Hello World!" without any additional characters like quotes or commas.

Additional Information

  • Related concept 1: The '*' operator in Python is used to unpack iterable objects.
  • Related concept 2: The print() function separates unpacked elements with a space by default.
  • Related concept 3: If you want to customize the separator, you can use the 'sep' parameter in the print() function.
  • Related concept 4: Unpacking can also be used with other data types like tuples and dictionaries.
122

If Str is a Python string as

Str = "Hello World!'

What will be the output of the following Python Command ?

print(Str.find('1'))

  1. ((a))

    2

  2. ((b))

    3

  3. ((c))

    [2, 3, 7]

  4. ((d))

    (2, 3, 7)

Show Answer
Answer: ((a))

2

The correct answer is 1) 2

Key Points

  • The find() method in Python searches for the first occurrence of a specified substring in a string.
  • If the substring is found, it returns the index of the first occurrence.
  • If the substring is not found, it returns -1.
  • In this case, the character '1' is found at index 2 in the string Str = "Hello World!".

Additional Information

  • find() method: Returns the lowest index of the substring if found, else -1.
  • Indexing in Python: Strings are indexed starting from 0.
  • Difference from index() method: While both methods search for substrings, index() raises an exception if the substring is not found, whereas find() returns -1.
  • Use case: The find() method is particularly useful for checking the existence of a substring in a string without raising an error.
123

Suppose a Python tuple TUP is declared as

TUP ('A', 'B', 'C')

Which of the following command is invalid?

  1. ((a))

    TUP=("D')

  2. ((b))

    TUP=('D',) 

  3. ((c))

    TUP+=('D') 

  4. ((d))

    TUP+=('D',)

Show Answer
Answer: ((c))

TUP+=('D') 

The correct answer is Option 3

Code Execution Flow

  • Step 1: The tuple TUP is initialized with three elements: ('A', 'B', 'C').
  • Step 2: Each option modifies or interacts with the tuple in different ways. Python tuples are immutable, so direct modifications or certain operations might result in errors.
  • Step 3: In option 3, the statement TUP += ('D') is invalid because ('D') is interpreted as a string, not a tuple, due to the lack of a trailing comma. Concatenating a tuple with a string results in a type error.
  • Step 4: The program raises a TypeError for option 3, making it an invalid command. All other options are valid as they either initialize a new tuple or concatenate tuples correctly.

Why This Output?

  • Important Rule Used: Tuples in Python are immutable, meaning they cannot be directly modified. However, they can be reassigned or concatenated with other tuples.
  • NULL / Index / Order Handling: Adding a single element to a tuple requires it to be defined as a tuple (e.g., ('D',)). Without the comma, Python interprets it as a string.
  • Common Trap: Students often forget to include the comma when creating single-element tuples, leading to unexpected type errors.
  • Final Output Justification: Option 3 is invalid because TUP += ('D') attempts to concatenate a tuple with a string, which is not allowed.
124

Identify the correct output of the following Python code:

TUP (3, 1, 2, 4)

sorted(TUP)

print(TUP)

  1. ((a))

    (3, 1, 2, 4)

  2. ((b))

    (1, 2, 3, 4)

  3. ((c))

    [3, 1, 2, 4]

  4. ((d))

    [1, 2, 3, 4]

Show Answer
Answer: ((a))

(3, 1, 2, 4)

The correct answer is 1)(3, 1, 2, 4)

Key Points

  • The sorted() function returns a new sorted list, but does not modify the original tuple.
  • The original tuple TUP remains unchanged after calling sorted(TUP).
  • Printing TUP will output the original tuple as it was declared: (3, 1, 2, 4).
  • The output of print(TUP) is unaffected by the sorted() function.

Additional Information

  • Tuples: Tuples are immutable data structures in Python, meaning their contents cannot be changed after creation.
  • sorted() function: The sorted() function returns a new sorted list and does not modify the original iterable.
  • Immutability: Since tuples are immutable, their content remains unchanged even after performing operations like sorting.
  • Usage: To store the sorted result, you must assign it to a new variable: sorted_TUP = sorted(TUP).
125

Find the correct output of the following Python program segment:

T-('1')

print(T+3)

  1. ((a))

    3

  2. ((b))

    ('1', '1', '1')

  3. ((c))

    111

  4. ((d))

    ('3')

Show Answer
Answer: ((b))

('1', '1', '1')

The correct answer is ('1', '1', '1').

Key Points

  • The statement T = ('1',) creates a tuple containing a single element '1'.
  • In Python, a single-element tuple must have a trailing comma; otherwise it is treated as a string.
  • The expression T * 3 repeats the tuple three times.
  • Hence, ('1',) becomes ('1', '1', '1').
  • The print() function displays this repeated tuple.

Additional Information

  • Tuple Repetition:
  • Using * with a tuple repeats its elements.
  • Example: (2, 3) * 2 → (2, 3, 2, 3)
  • Important Points:
  • ('1') is treated as a string, but ('1',) is a tuple.
  • Tuples support repetition using the multiplication operator.
  • This type of question commonly checks understanding of single-element tuples.
126

Select the correct output of the given Python code from the following options:

S="INDIAN'

L=S.Partition('N')

NS-L[0]+' -' +L[1]+' -'+L[2]

print (NS)

  1. ((a))

    1 - N - DIA - N -

  2. ((b))

    I - DIA - 

  3. ((c))

    I - DIAN

  4. ((d))

    I - N - DIAN

Show Answer
Answer: ((d))

I - N - DIAN

The correct answer is 4) I - N - DIAN.

Key Points

  • The partition() method in Python splits a string into three parts: the part before the specified separator, the separator itself, and the part after the separator.
  • Here, the string S = "INDIAN" is partitioned using the separator 'N'.
  • This results in a tuple ('I', 'N', 'DIAN'), where:
  • L[0] = 'I' (before the separator).
  • L[1] = 'N' (the separator itself).
  • L[2] = 'DIAN' (after the separator).
  • The variable NS concatenates the values with ' - ' as a separator, resulting in 'I - N - DIAN'.

Additional Information

  • partition() method is case-sensitive, meaning it will only partition based on the exact match of the separator.
  • If the separator is not found in the string, the partition() method returns the original string as the first element of the tuple, and the other two elements as empty strings.
  • The partition() method is different from split() in that it always returns exactly three elements.
  • When using partition(), ensure that the separator is correctly specified to avoid unexpected results.
  • This method is useful in scenarios where splitting into exactly three parts is required, such as parsing file paths or extracting specific substrings.
127

To execute the following code in Python, which module need to be imported?

print( ________ mean([1, 2, 3]))

  1. ((a))

    math

  2. ((b))

    random

  3. ((c))

    statistics

  4. ((d))

    probability

Show Answer
Answer: ((c))

statistics

The correct answer is statistics.

Key Points

  • The statistics module in Python provides functions for mathematical calculations related to statistical analysis.
  • The mean() function is specifically included in the statistics module for calculating the arithmetic mean of a list of numbers.
  • To use this function, you need to import the statistics module by writing import statistics.
  • Other modules like math and random do not contain the mean() function.
  • The probability module is not a standard library in Python.

Additional Information

  • Functions in the Statistics Module:
  • mean(): Calculates the average of a list of numbers.
  • median(): Finds the middle value in a sorted list of numbers.
  • mode(): Identifies the most frequently occurring value in a list.
  • stdev(): Calculates the standard deviation of a list of numbers.
  • Applications:
  • Useful in data analysis for calculating central tendencies like mean, median, and mode.
  • Frequently used in scientific research, statistical modeling, and financial analysis.
  • Usage Example:
  • import statistics
  • data = [1, 2, 3]
  • average = statistics.mean(data)
  • print(average)
128

If D is a Python dictionary as

D={'A': 1, 'B': 2, 'C': 3)

Then, which of the following command will remove the entire dictionary from the memory?

  1. ((a))

    del(D)

  2. ((b))

    D.del()

  3. ((c))

    D.clear()

  4. ((d))

    D.remove()

Show Answer
Answer: ((a))

del(D)

The correct answer is Option 1

Key Points

  • The del command is used in Python to delete objects, including dictionaries.
  • Using del(D) removes the entire dictionary D from memory.
  • The clear() method only clears the contents of the dictionary but does not delete the object itself.
  • Commands like D.del() or D.remove() are invalid and will result in errors.

Additional Information

  • del: The del keyword in Python is used to delete objects, variables, or entire data structures.
  • clear(): Clears the contents of a dictionary but does not remove the dictionary itself.
  • Invalid commands: Commands like D.del() or D.remove() are not valid Python methods for dictionaries.
  • Memory management: After using del, the memory allocated to the dictionary is freed.
129

What will be the output of the following Python code?

D1 = {'A': 5, 'B': 7, 'C':9}

D2 = {'B':5, 'D': 10}

D1 = .update(D2)

print(D1)

  1. ((a))

    {'A':5, 'B': 5, 'C': 9, 'D': 10}

  2. ((b))

    {'A':5, 'B':5, 'C': 9, 'B': 5, 'D':10} 

  3. ((c))

    {'A':5, 'C: 9, 'D':10}

  4. ((d))

    {'B':7, 'D: 10, 'A':5, 'C':9}

Show Answer
Answer: ((a))

{'A':5, 'B': 5, 'C': 9, 'D': 10}

The correct answer is Option 1: {'A': 5, 'B': 5, 'C': 9, 'D': 10}

Code Execution Flow

  • Step 1: The dictionary D1 is created with keys 'A', 'B', and 'C' having values 5, 7, and 9 respectively. Similarly, D2 is created with keys 'B' and 'D' having values 5 and 10 respectively.
  • Step 2: The update() method is called on D1 with D2 as its parameter. This method updates D1 by adding key-value pairs from D2. If a key in D2 already exists in D1, its value in D1 is overwritten by the corresponding value from D2.
  • Step 3: Since D2 contains the key 'B', the value of 'B' in D1 is updated from 7 to 5. The key-value pair 'D': 10 is added to D1.
  • Step 4: After the update() operation, D1 becomes {'A': 5, 'B': 5, 'C': 9, 'D': 10}. However, the assignment D1 = .update(D2) is incorrect because update() modifies D1 in place and returns None. Therefore, D1 is assigned the value None.

Why This Output?

  • Important Rule Used: The update() method modifies the dictionary it is called on and returns None. Assigning the result of update() to a variable will assign None to that variable.
  • NULL / Index / Order Handling: The method operates on the dictionary in place, preserving the order of keys from Python 3.7 onwards.
  • Common Trap: Students often assume that update() returns the updated dictionary, but it does not; it modifies the original dictionary and returns None.
  • Final Output Justification: Since D1 is reassigned the value None, the output of print(D1) will be None, and the correct result {'A': 5, 'B': 5, 'C': 9, 'D': 10} is not printed.
130

Select the output for the given Python code from the following options:

D1 = {1:2, 2:3, 3:4}

D2 = D1.get(1, 2)

print(D2)

  1. ((a))

    2

  2. ((b))

    3

  3. ((c))

    [2, 3]

  4. ((d))

    {1 : 2, 2 : 3}

Show Answer
Answer: ((a))

2

The correct answer is 2

Code Execution Flow

  • Step 1: The dictionary D1 is defined with key-value pairs: {1: 2, 2: 3, 3: 4}. This means the key 1 maps to the value 2, key 2 maps to the value 3, and key 3 maps to the value 4.
  • Step 2: The get() method is called on D1 with arguments 1 and 2. The get() method retrieves the value associated with the specified key if it exists, otherwise, it returns the default value (second argument).
  • Step 3: Since the key 1 exists in D1, the method retrieves its associated value, which is 2. The default value 2 is not used in this case.
  • Step 4: The value 2 is assigned to the variable D2. The print(D2) statement then outputs 2.

Why This Output?

  • Important Rule Used: The get() method in Python dictionaries retrieves the value for the specified key if it exists. If the key does not exist, it returns the default value provided as the second argument.
  • NULL / Index / Order Handling: Since the key 1 exists in the dictionary, the default value 2 is ignored, and the actual value 2 is retrieved.
  • Common Trap: Students may mistakenly think that the default value 2 is always returned, ignoring the fact that the key exists in the dictionary.
  • Final Output Justification: As the key 1 exists in the dictionary and maps to the value 2, the output is 2. Thus, the correct answer is option 1.
131

Which of the following functions cannot be used with string(str) data type?

  1. ((a))

    islower()

  2. ((b))

    isupper()

  3. ((c))

    isalpha()

  4. ((d))

    isnum()

Show Answer
Answer: ((d))

isnum()

The correct answer is isnum()

Key Points

  • isnum() is not a valid function for the Python string (str) data type.
  • Python provides string methods like islower(), isupper(), and isalpha().
  • These functions are used to check character properties of a string.
  • islower() checks if all letters are lowercase.
  • isupper() checks if all letters are uppercase.
  • isalpha() checks if all characters are alphabets.
  • The function isnum() does not exist in Python.

Additional Information

  • isnumeric():
  • Checks whether all characters in the string are numeric.
  • isdigit():
  • Checks whether all characters in the string are digits (0–9).
  • isdecimal():
  • Checks whether all characters are decimal numbers.
132

Examine the given Python program and select the purpose of the program from the following options:

N=int(input("Enter the number"))

for i in range(2, N):

if (N%i==0):

print(i)

  1. ((a))

    to display the proper factors (excluding 1 and the number N itself)

  2. ((b))

    to check whether N is a prime or Not

  3. ((c))

    to calculate sum of factors of N

  4. ((d))

    to display all prime factor of the number N

Show Answer
Answer: ((a))

to display the proper factors (excluding 1 and the number N itself)

The correct answer is Option 1: to display the proper factors (excluding 1 and the number N itself)

Code Execution Flow

  • Step 1: The program begins by taking an integer input from the user using the input() function, which prompts the user to enter a number. This value is stored in the variable N.
  • Step 2: A for loop is initiated with the range starting from 2 and ending at N-1. This loop iterates through all integers between 2 and N-1.
  • Step 3: Inside the loop, the if condition checks whether the current value of i (from the loop) divides N without leaving a remainder (i.e., N % i == 0). If the condition is true, the value of i is printed as it is a proper factor of N.
  • Step 4: The program continues to check all integers in the range. Only the proper factors of N (excluding 1 and N itself) are printed as output. If no factors are found, nothing is printed.

Why This Output?

  • Important Rule Used: The modulus operator (%) is used to determine if a number is divisible by another without a remainder. The for loop ensures that all integers in the specified range are checked.
  • NULL / Index / Order Handling: The program skips 1 and N itself because the loop starts at 2 and ends at N-1. This ensures that only proper factors are considered.
  • Common Trap: Students may confuse this program with one that checks if a number is prime. However, this program does not confirm whether N is prime; it only identifies its proper factors.
  • Final Output Justification: The correct answer is Option 1 because the program explicitly prints all proper factors of N (excluding 1 and N itself) using the modulus operation and a for loop.
133

If A = random.randint(B, C) assigns a random value between 1 and 6 (both inclusive) to the identifier A, what should be the values of B and C, if all required modules have already been imported?

  1. ((a))

    B=0, C=6

  2. ((b))

    B=0, C=7

  3. ((c))

    B=1, C=7

  4. ((d))

    B=1, C=6

Show Answer
Answer: ((d))

B=1, C=6

The correct answer is B=1, C=6.

Key Points

  • The random.randint() function in Python generates a random integer between the two arguments provided, inclusive of both.
  • To generate random integers between 1 and 6 (both inclusive), the arguments B and C must be set to 1 and 6 respectively.
  • All necessary modules, including random, must already be imported to use the random.randint() function without errors.
  • The syntax for this function is: random.randint(start, end), where start and end define the inclusive range.
  • In this case, setting B=1 and C=6 ensures that the random number assigned to A lies between 1 and 6, inclusive.

Additional Information

  • Common Mistakes:
  • Using B=0 and C=6 would generate random integers between 0 and 6, which is incorrect as it includes 0 and excludes 7.
  • Using B=0 and C=7 would generate random integers between 0 and 7, which is incorrect as it includes both 0 and 7.
  • Using B=1 and C=7 would generate random integers between 1 and 7, which is incorrect as it includes 7.
  • Practical Applications of Random Numbers:
  • Random number generation is commonly used in games, simulations, and statistical sampling.
  • It is also used in cryptography to enhance security by generating random keys.
  • In machine learning, random numbers are used for initializing weights in neural networks.
  • Important Points:
  • The random.randint() function is part of Python's random module and must be imported before use.
  • The range specified in the function is inclusive, meaning both the start and end values are possible outcomes.
  • Proper usage of the function ensures accurate and reliable random number generation within the desired range.
134

Identify the correct output of the following Python code:

from math import *

A=5.6

print(floor(A), ceil(A))

  1. ((a))

    5 6

  2. ((b))

    6 5

  3. ((c))

    -5 -6

  4. ((d))

    -6 -5

Show Answer
Answer: ((a))

5 6

The correct answer is Option 1

Code Execution Flow

  • Step 1: The math library is imported using the from math import * statement, which makes all functions and constants from the math module available for use directly without qualifying them with math..
  • Step 2: The variable A is assigned the floating-point value 5.6.
  • Step 3: The floor function is used to calculate the largest integer less than or equal to A. For 5.6, the floor value is 5. Similarly, the ceil function is used to calculate the smallest integer greater than or equal to A. For 5.6, the ceil value is 6.
  • Step 4: The print statement outputs the results of the floor and ceil functions as 5 6 (separated by a space).

Why This Output?

  • Important Rule Used: The floor function returns the largest integer less than or equal to the input, and the ceil function returns the smallest integer greater than or equal to the input.
  • NULL / Index / Order Handling: Not applicable in this scenario as the code involves basic mathematical operations on a single floating-point value.
  • Common Trap: A common misunderstanding is to confuse the behavior of the floor and ceil functions, especially with negative numbers. For positive numbers like 5.6, the results are straightforward.
  • Final Output Justification: The correct output is 5 6 because floor(5.6) is 5 and ceil(5.6) is 6, which matches the output specified in Option 1.
135

Identify the correct output of the following Python program segment:

import math

print(math.fabs(-10))

  1. ((a))

    1

  2. ((b))

    -10

  3. ((c))

    -10.0

  4. ((d))

    10

Show Answer
Answer: ((d))

10

The correct answer is Option 4) 10.0

Key Points

  • The math.fabs() function in Python returns the absolute value of a number as a float.
  • Absolute value is the non-negative magnitude of a real number regardless of its sign.
  • \text{math.fabs}(-10) = 10.0
  • Unlike the built-in abs() function which returns an integer for integer inputs, math.fabs() always converts the result to a floating-point number.
  • The input to the function is -10, so the magnitude is 10, and the float representation is 10.0.

Additional Information

  • math module: A built-in Python module that provides access to mathematical functions defined by the C standard.
  • Float vs Integer: A float (floating-point number) contains a decimal point (e.g., 10.0), whereas an integer is a whole number (e.g., 10).
  • abs() function: Python's built-in function that returns the absolute value; for example, abs(-10) would return 10 (integer).
  • Return Type: Identifying the return type is crucial in Python programming exams to distinguish between options like 10 and 10.0.
136

Consider the given Python programme and identify one possible output of this code out of the following options:

from random import Low =

randint(2, 3)

High=randrange(5, 7)

for N in range (Low, High):

print(N, end='')

  1. ((a))

    3 4 5

  2. ((b))

    2 3

  3. ((c))

    4 5

  4. ((d))

    3 4 5 6

Show Answer
Answer: ((a))

3 4 5

The correct answer is 4) 3 4 5 6

Code Execution Flow

  • Step 1: The code imports the randint and randrange functions from Python's random module. These functions are used to generate random integers within a specified range.
  • Step 2: The variable Low is assigned a random integer between 2 and 3, inclusive. Similarly, High is assigned a random integer from the range 5 to 7, excluding 7.
  • Step 3: A for loop is initiated, iterating over the range from Low (inclusive) to High (exclusive). The loop prints each value of N on the same line, separated by a space, using the end='' argument in the print function.
  • Step 4: If Low is 3 and High is 7, the loop iterates over the values 3, 4, 5, and 6, printing 3 4 5 6.

Why This Output?

  • Important Rule Used: The randint function includes both endpoints, while the randrange function excludes the upper endpoint. The range function iterates from the start value (inclusive) to the stop value (exclusive).
  • NULL / Index / Order Handling: The random integers generated by randint and randrange define the bounds for the loop. If Low is greater than or equal to High, the loop will not execute, but this is not the case here.
  • Common Trap: Students may assume that the randrange function includes the upper bound, which is incorrect. It excludes the upper bound.
  • Final Output Justification: Given the possible ranges for Low and High, one valid output of the program is 3 4 5 6.
137

Assuming all required modules have already been imported, identify the correct output of the following Python program segment:

Data = [4, 4, 1, 2, 4]

print(mean (Data), mode(data))

  1. ((a))

    1 4

  2. ((b))

    4 1

  3. ((c))

    3 4

  4. ((d))

    4 3

Show Answer
Answer: ((c))

3 4

The correct answer is 3.0 4

Key Points

  • Mean Calculation: The mean is the sum of all elements divided by the count. Sum = 4 + 4 + 1 + 2 + 4 = 15. Count = 5. Result = 15 / 5 = 3.0.
  • Mode Calculation: The mode is the value that appears most frequently in the dataset. In the list [4, 4, 1, 2, 4], the number 4 appears three times, making it the mode.
  • Python Float Output: The mean() function in Python's statistics module typically returns a float, resulting in 3.0 rather than an integer 3.
  • Output Format: The print() function displays multiple arguments separated by a space by default, resulting in the output "3.0 4".

Additional Information

  • Case Sensitivity: Python is case-sensitive; in the provided image, there is a typo where "Data" is defined but "data" (lowercase) is called in the mode function, which would normally trigger a NameError in a live environment.
  • Statistics Module: The functions mean() and mode() are part of the Python statistics module and require import statistics or from statistics import * to function.
  • Data Types: Lists in Python can hold duplicate values and are defined using square brackets, which is necessary for calculating statistical measures like the mode.
  • Floating Point Division: In Python 3.x, the division operator / always returns a float, which is why the mean is represented as 3.0.
138

Observe the Python code carefully and answer the following question:

def FUN(A):

L=[]

for i in range (2, A):

if (A%i==0):

L.append(i)

print(L)

N=10

FUN(N)

Identify the global identifier in the above code :

  1. ((a))

    A

  2. ((b))

    L

  3. ((c))

    i

  4. ((d))

    N

Show Answer
Answer: ((d))

N

The correct answer is option 4) N

Key Points

  • Global Scope Identification: In Python, variables defined outside of any function or class block are considered part of the global scope. In the provided code, N=10 is defined at the top level of the script, making N a global identifier.
  • Local Scope Variables: Variables defined inside a function are local to that function. The identifier L and the loop variable i are defined inside def FUN(A), meaning they are local identifiers.
  • Function Parameters: The identifier A is a formal parameter of the function FUN. It exists only within the local scope of that function during its execution.
  • Accessibility: Global identifiers like N can be accessed from anywhere in the code, including inside functions, whereas local identifiers like L and i cannot be accessed outside the function FUN.

Additional Information

  • LEGB Rule: Python resolves identifiers using the LEGB rule, which stands for Local, Enclosing, Global, and Built-in scopes, searching in that specific order.
  • Global Keyword: If you need to modify a global variable inside a local function scope, you must explicitly declare it using the global keyword (e.g., global N).
  • Function Identifiers: It is worth noting that the function name itself, FUN, is also a global identifier in this context as it is defined at the top level.
  • Namespace: A global identifier belongs to the main module's namespace unless the code is part of a different imported module.
139

Observe the following Python program carefully.

import random

def DICE(Low=1, High=6):

RND=random.randint(Low, High) print(RND, end='')

DICE()

DICE(2)

DICE(2, 4)

Which of the following options cannot be an output of the above code?

  1. ((a))

    4 3 3

  2. ((b))

    4 1 3

  3. ((c))

    3 5 4

  4. ((d))

    6 4 3

Show Answer
Answer: ((b))

4 1 3

The correct answer is Option 2.

The program defines a function DICE(Low=1, High=6) that generates a random integer between the given Low and High values using random.randint().

The generated number is printed on the same line because print(RND, end="") does not move the cursor to the next line.

The function is called three times with different arguments, so three digits are printed consecutively.

Step-by-step execution:

  • DICE() uses default values Low = 1 and High = 6, so the first number must be between 1 and 6.
  • DICE(2) sets Low = 2 and High remains 6, so the second number must be between 2 and 6.
  • DICE(2, 4) sets Low = 2 and High = 4, so the third number must be between 2 and 4.
  • Thus, the output must follow the pattern: (1–6)(2–6)(2–4).
  • In Option 2 (4 1 3), the second value is 1, which is not possible because DICE(2) cannot generate a value less than 2.
  • Therefore, Option 2 cannot be an output of the given code.
140

Identify the output of the following Python code:

def EXP(N2):

global N1

N1, N2=N1+5, N2+10 print(N1, N2, end='')

N1=10

EXP(N1)

print(N1)

  1. ((a))

    10 20 15

  2. ((b))

    15 20 10

  3. ((c))

    15 20 15

  4. ((d))

    10 20 10

Show Answer
Answer: ((c))

15 20 15

The correct answer is Option 3.

The program defines a function EXP(N2) and declares N1 as a global variable, meaning any change to N1 inside the function affects its value outside the function as well.

Initially, N1 is assigned the value 10.

The function call EXP(N1) passes the value of N1 (which is 10) to the parameter N2.

Inside the function, the statement N1, N2 = N1 + 5, N2 + 10 executes as follows:

  • The global variable N1 becomes 10 + 5 = 15.
  • The local variable N2 becomes 10 + 10 = 20.
  • The statement print(N1, N2, end="") prints 15 20 on the same line.
  • After returning from the function, N1 remains 15 because it was modified globally.
  • The final print(N1) prints 15.
  • Thus, the complete output is 15 20 15.
141

Which of the following mode, when used in file opening statement in Python, generates an error, if the file does not exist?

  1. ((a))

    a +

  2. ((b))

    r +

  3. ((c))

    w +

  4. ((d))

    a

Show Answer
Answer: ((b))

r +

Correct answer is: Option 2.

Key Points

Understanding File Opening Modes in Python:

In Python, the open() function is used to open files in different modes. Each mode defines how the file is accessed and what happens if the file does not already exist.

Some modes create a file automatically if it is missing, while others require the file to exist and generate an error otherwise.

Explanation:

Let us analyze each given file opening mode one by one:

  • Option 1: a+

This mode opens a file for reading and appending. If the file does not exist, it is created automatically. Hence, no error is generated.

  • Option 2: r+

This mode opens a file for reading and writing. The file must already exist. If the file does not exist, Python raises a FileNotFoundError.

  • Option 3: w+

This mode opens a file for reading and writing. If the file does not exist, it is created. Therefore, no error occurs.

  • Option 4: a

This mode opens a file for appending only. If the file does not exist, it is created automatically.

Among all the options, only r+ requires the file to exist beforehand.

Hence, the correct answer is: Option 2.

142

Consider the following Python command:

File = open("Myfile', 'a')

Which of the following option cannot be true?

  1. ((a))

    'Myfile' can be a text file

  2. ((b))

    'Myfile can be a csv file

  3. ((c))

    'Myfile' can be a binary file

  4. ((d))

    "Myfile' will be created if not exist

Show Answer
Answer: ((c))

'Myfile' can be a binary file

correct answer is: option 3) 'Myfile' can be a binary file.

Key Points

Python File Handling - Open Modes:

In Python, the open() function is used to open a file. It takes two primary arguments: the filename and the mode. The mode 'a' stands for Append mode. This mode opens a file for writing, but instead of overwriting existing content, it adds new data to the end of the file. If the file does not exist, Python creates it. By default, unless specified as binary (e.g., 'ab'), files are opened in text mode.

Explanation:

Let's analyze the command File = open("Myfile", 'a') and the given options:

File = open("Myfile", 'a')

  1. 'Myfile' can be a text file (Option 1):

True. By default, the mode 'a' opens the file as a text file. Most common extensions like .txt or files without extensions are handled as text by default.

  1. 'Myfile' can be a csv file (Option 2):

True. A CSV (Comma Separated Values) file is essentially a plain text file with a specific structure. It can be opened and appended to using the 'a' mode.

  1. 'Myfile' can be a binary file (Option 3):

False. In Python, to open a file in binary mode, you must explicitly include 'b' in the mode string (e.g., 'ab' or 'wb'). The command open("Myfile", 'a') opens the file in text mode. Therefore, it cannot be used to handle raw binary data correctly without the 'b' flag.

  1. "Myfile" will be created if not exist (Option 4):

True. One of the characteristics of the append mode ('a') and write mode ('w') is that they automatically create the file if it is not found in the specified directory.

Hence, the correct answer is: option 3) 'Myfile' can be a binary file.

143

Which of the following is not true for the Python command:

File = open('story.txt', 'a+')

  1. ((a))

    More text can be written into 'story.txt

  2. ((b))

    Content of the file 'story.txt' can be read.

  3. ((c))

    Content of the file 'story.txt' can be modified.

  4. ((d))

    Command generates an error, if the file 'story.txt. does not exist.

Show Answer
Answer: ((d))

Command generates an error, if the file 'story.txt. does not exist.

Correct answer is: Option 4.

Concept:

Understanding File Opening Mode a+ in Python:

In Python, the a+ mode is used to open a file for both reading and appending. This mode allows new data to be added at the end of the file and also permits reading the existing content. If the file does not exist, Python automatically creates it.

Explanation:

Let us analyze the given Python statement carefully:

File = open('story.txt', 'a+')

This command opens the file story.txt in append-plus mode.

Behavior of a+ mode:

  • The file is opened for both reading and writing.
  • All new data is written at the end of the file.
  • The existing content of the file is not overwritten.
  • If the file does not exist, it is created automatically.

Now, let us evaluate each option:

  • Option 1: More text can be written into 'story.txt'

This is true because append mode allows adding new content.

  • Option 2: Content of the file 'story.txt' can be read

This is true because a+ supports reading.

  • Option 3: Content of the file 'story.txt' can be modified

This is considered true in exam context because new content can be added, though existing content is not overwritten.

  • Option 4: Command generates an error if the file 'story.txt' does not exist

This is not true because a+ creates the file automatically if it does not exist.

Hence, the correct answer is: Option 4.

144

Consider the following Python program segment:

File = open('Poem.txt', 'r')

T= File.readline()

Identify the data type of T :

  1. ((a))

    String (str)

  2. ((b))

    List

  3. ((c))

    Tuple

  4. ((d))

    Dictionary

Show Answer
Answer: ((a))

String (str)

Correct answer is: option 1) String (str).

Concept:

Python File Handling and Data Types:

In Python, when a file is opened in text mode (which is the default when using 'r', 'w', or 'a'), the data read from the file is processed as text. The readline() method is specifically designed to read a single line from the file, including the newline character (\n) at the end of the line.

Explanation:

Let's analyze the provided Python program segment step by step:

File = open('Poem.txt', 'r') T = File.readline()

  1. File = open('Poem.txt', 'r')

The file named 'Poem.txt' is opened in read mode ('r'). Since no 'b' is specified, it defaults to text mode. This allows the program to read the contents of the file as characters.

  1. T = File.readline()

The readline() function reads characters from the current file pointer position up to and including the next newline character. In Python's text mode, this sequence of characters is returned as a String (str) data type.

  1. Comparing Data Types:
  • String (str): Correct. readline() returns a single line as a string.
  • List: Incorrect. The readlines() (plural) method would return a list of strings.
  • Tuple: Incorrect. File reading methods in Python do not return tuples.
  • Dictionary: Incorrect. Dictionaries are key-value pairs and are not the standard output for basic file reading.

 

Hence, the correct answer is: option 1) String (str).

145

Name the Python module need to be imported to invoke the function?

load()

  1. ((a))

    csv

  2. ((b))

    pickle

  3. ((c))

    sql

  4. ((d))

    binary

Show Answer
Answer: ((b))

pickle

Correct answer is: Option 2.

Key Points

Understanding the load() Function in Python:

In Python, certain functions are not built-in and can only be used after importing the specific module in which they are defined. The load() function is one such function that is commonly used for reading serialized objects.

Explanation:

The function load() is used to deserialize Python objects that were previously stored in a file.

This function belongs to the pickle module and is used as:

import pickle pickle.load(file)

Now, let us analyze the given options:

  • Option 1: csv

The csv module is used for reading and writing CSV (Comma Separated Values) files. It does not provide a load() function.

  • Option 2: pickle

The pickle module provides the load() function to read (deserialize) Python objects from a file. This is the correct module.

  • Option 3: sql

There is no standard Python module named sql that provides a load() function.

  • Option 4: binary

There is no built-in Python module named binary that provides a load() function.

Hence, the correct answer is: Option 2.

146

Examine the given Python program and select the purpose of the program from the following options:

F= open('story.txt', 'r+')

S=F.read()

S=S.upper()

F.seek(0)

F.write(s)

F.close()

  1. ((a))

    to count the upper case alphabets present in the file

  2. ((b))

    to convert all alphabets into uppercase in the file 

  3. ((c))

    to copy only the upper case alphabets from the file

  4. ((d))

    to remove all lower case alphabets from the file

Show Answer
Answer: ((b))

to convert all alphabets into uppercase in the file 

Correct answer is: option 2) to convert all alphabets into uppercase in the file.\ 

Key Points

Python File Handling - Read and Write Mode (r+):

In Python, the mode 'r+' is used to open a file for both reading and writing. Unlike the write mode ('w'), it does not truncate (erase) the file upon opening. To modify the content effectively, the seek() method is often used to move the file pointer to a specific position. The upper() string method is used to convert all lowercase characters in a string to uppercase.

Explanation:

Let's analyze the given Python program step by step:

F = open('story.txt', 'r+') S = F.read() S = S.upper() F.seek(0) F.write(S) F.close()

  1. F = open('story.txt', 'r+')

Opens 'story.txt' in read plus mode. This allows the program to read the existing data and also write back to the same file.

  1. S = F.read()

Reads the entire content of the file into the string variable S. After this operation, the file pointer is at the end of the file.

  1. S = S.upper()

The string S (containing the file content) is processed, and all lowercase letters are converted to uppercase. The result is stored back in S.

  1. F.seek(0)

This is a crucial step. It moves the file pointer back to the beginning (index 0) of the file. Without this, the subsequent write operation would happen at the end of the file.

  1. F.write(S)

Writes the modified uppercase string S back into the file, starting from the beginning. This effectively overwrites the original lowercase/mixed-case text with uppercase text.

  1. F.close()

Closes the file, ensuring all changes are saved.

Hence, the correct answer is: option 2) to convert all alphabets into uppercase in the file.

147

seek() is a method of ?

  1. ((a))

    csv module

  2. ((b))

    pickle module

  3. ((c))

    text module

  4. ((d))

    file object

Show Answer
Answer: ((d))

file object

Correct answer is: Option 4.

Key Points

Understanding the seek() Method in Python:

In Python, the seek() method is used to change the current position of the file pointer within an open file. It allows the program to move to a specific location in the file so that subsequent read or write operations start from that position.

Explanation:

The seek() method is not a function of any module like csv or pickle. Instead, it belongs to the file object that is returned when a file is opened using the open() function.

Example:

f = open("data.txt", "r") f.seek(0)

Here, f is a file object, and seek(0) moves the file pointer to the beginning of the file.

Evaluating the options:

  • Option 1: csv module

Incorrect. The csv module handles CSV files but does not define seek().

  • Option 2: pickle module

Incorrect. The pickle module is used for object serialization, not file pointer movement.

  • Option 3: text module

Incorrect. There is no standard Python module named text.

  • Option 4: file object

Correct. The seek() method belongs to the file object.

Hence, the correct answer is: Option 4.

148

csv module need to be imported in a Python program to invoke or use the function:

  1. ((a))

    write()

  2. ((b))

    writerow()

  3. ((c))

    writeline()

  4. ((d))

    writelines()

Show Answer
Answer: ((b))

writerow()

Correct answer is: Option 2.

Key Points

Understanding the csv Module in Python:

The csv module in Python is used to read from and write to CSV (Comma Separated Values) files. It provides specialized functions that help in handling tabular data in a structured format.

Explanation:

The functions provided by the csv module are different from the general file write functions. Let us analyze each option:

  • Option 1: write()

This is a general file object method used to write data to a file. It does not require importing the csv module.

  • Option 2: writerow()

This function belongs to the csv module. It is used to write a single row of data into a CSV file using a CSV writer object. To use this function, the csv module must be imported.

  • Option 3: writeline()

This is not a valid function in Python, neither in file handling nor in the csv module.

  • Option 4: writelines()

This is a file object method used to write multiple lines to a file. It does not require the csv module.

Only writerow() specifically belongs to the csv module.

Hence, the correct answer is: Option 2.

149

Examine the given Python program and select the best purpose of the program from the given options:

File = open("Poem.txt","r")

print(len(File.readline().split()))

File.close()

  1. ((a))

    to count the number of words present in the file

  2. ((b))

    to count the number of lines present in the file

  3. ((c))

    to count the number of characters present in the file

  4. ((d))

    to count the number of words present in the first line of the file

Show Answer
Answer: ((d))

to count the number of words present in the first line of the file

Correct answer is: Option 4.

Key Points

Understanding File Reading, String Splitting, and Length Calculation in Python:

In Python, files can be read line by line using file object methods. The split() method is used to divide a string into a list of words, and the len() function counts the number of elements in a list.

Explanation:

Let us examine the given Python program step by step:

File = open("Poem.txt", "r") print(len(File.readline().split())) File.close()

  1. File = open("Poem.txt", "r")

The file Poem.txt is opened in read mode. This allows the program to read the content of the file.

  1. File.readline()

This statement reads only the first line of the file and returns it as a string.

  1. .split()

The split() method splits the line into a list of words based on whitespace (spaces, tabs, etc.).

  1. len(...)

The len() function counts the number of elements in the list returned by split(), which corresponds to the number of words in the first line.

  1. print(...)

The calculated word count is printed.

  1. File.close()

The file is closed properly to release system resources.

Evaluating the options:

  • Option 1: To count the number of words present in the file

Incorrect, because the program reads only the first line, not the entire file.

  • Option 2: To count the number of lines present in the file

Incorrect, because no line-counting logic is used.

  • Option 3: To count the number of characters present in the file

Incorrect, because characters are not counted.

  • Option 4: To count the number of words present in the first line of the file

Correct, because the program reads only the first line and counts its words.

Hence, the correct answer is: Option 4.

150

CSV files are comma separated values saved as a _____

  1. ((a))

    text file

  2. ((b))

    binary file

  3. ((c))

    MySQL table

  4. ((d))

    random file

Show Answer
Answer: ((a))

text file

Correct answer is: Option 1.

Key Points

Understanding CSV (Comma Separated Values) Files:

CSV files store tabular data in plain text format, where each value is separated by a comma. These files are widely used for data exchange because they are simple, human-readable, and supported by many applications.

Explanation:

Let us analyze the given options to understand the nature of CSV files:

  • Option 1: Text file

CSV files are stored as plain text files. Each line represents a row, and commas separate the values within that row. This makes CSV files easy to open and edit using any text editor.

  • Option 2: Binary file

Incorrect. CSV files are not binary; they store data in readable text format.

  • Option 3: MySQL table

Incorrect. A CSV file is not a database table, though it can be imported into databases.

  • Option 4: Random file

Incorrect. CSV files follow a specific structured format and are not random.

Since CSV files are saved in plain, readable text format, they are classified as text files.

Hence, the correct answer is: Option 1.

151

The creator of the open source Pandas Package for data analysis in the Python Programming language was _______.

  1. ((a))

    Wes Mcinney

  2. ((b))

    Mc Pandas

  3. ((c))

    John D.Hunter

  4. ((d))

    Travis Oliphant

Show Answer
Answer: ((a))

Wes Mcinney

orrect answer is: Option 1.

Key Points

Understanding the Origin of the Pandas Library in Python:

Pandas is a powerful open-source Python library used for data manipulation and data analysis. It provides high-level data structures such as Series and DataFrame, which make working with structured data easy and efficient.

Explanation:

The Pandas library was originally developed to meet the need for fast, flexible, and expressive data analysis tools in Python.

Let us evaluate the given options:

  • Option 1: Wes McKinney

Wes McKinney is the creator of the Pandas library. He developed Pandas in 2008 while working at AQR Capital Management to perform quantitative data analysis efficiently.

  • Option 2: Mc Pandas

This is not a real person associated with Python or data analysis. Hence, this option is incorrect.

  • Option 3: John D. Hunter

John D. Hunter is the creator of the Matplotlib library, not Pandas.

  • Option 4: Travis Oliphant

Travis Oliphant is one of the key developers of NumPy and SciPy, but not Pandas.

Among all the options, only Wes McKinney is associated with the creation of the Pandas package.

Hence, the correct answer is: Option 1.

152

Which of the following is not bundled package with pandas?

  1. ((a))

    six

  2. ((b))

    numpy

  3. ((c))

    pytz

  4. ((d))

    statistics

Show Answer
Answer: ((d))

statistics

Correct answer is: option 4) statistics.

Key Points

Pandas Dependencies and Bundled Packages:

Pandas is a high-level data manipulation library that relies on several core dependencies to function correctly. When you install Pandas using standard package managers like pip or conda, it automatically ensures that certain "bundled" or required packages are present. These dependencies handle specific tasks like numerical operations (NumPy), timezone calculations (pytz), and compatibility layers (six).

Explanation:

Let's evaluate each option to determine which one is not a standard bundled dependency of Pandas:

  1. numpy (Option 2):

Pandas is built directly on top of NumPy. It uses NumPy arrays for its internal data storage and mathematical operations. It is the most critical dependency and is always bundled/required.

  1. pytz (Option 3):

Pandas has extensive support for time-series data. pytz is the library used by Pandas to handle World Timezone definitions. It is a standard requirement for Pandas installations.

  1. six (Option 1):

Six is a Python 2 and 3 compatibility library. While modern versions of Pandas (aimed at Python 3.x) have phased out some of these requirements, it has historically been a core dependency bundled to ensure the library runs across different Python environments.

  1. statistics (Option 4):

The statistics module is a built-in Python standard library (introduced in Python 3.4). While Pandas provides its own powerful statistical methods (like .mean(), .std(), etc.), it does not rely on or "bundle" the statistics package as a dependency. Pandas performs its calculations using NumPy and its own internal C/Cython code for better performance.

Hence, the correct answer is: option 4) statistics.

153

Which of the following is equivalent of and operator while using Boolean indexing on data frames?

  1. ((a))

    &&

  2. ((b))

    @

  3. ((c))

    &

  4. ((d))

    N

Show Answer
Answer: ((c))

&

Correct answer is: Option 3.

Key Points

Understanding Boolean Indexing and Logical Operators in Pandas DataFrames:

In Pandas, Boolean indexing is used to filter rows of a DataFrame based on conditions. While Python provides logical operators like and and or, these operators do not work directly with Pandas Series or DataFrame conditions.

Instead, Pandas requires the use of bitwise operators for element-wise logical operations.

Explanation:

When applying multiple conditions in Boolean indexing on a DataFrame, the logical AND operation must be performed element by element.

For example:

df[(df['A'] > 5) & (df['B'] < 10)]

Here, the & operator is used to combine two conditions.

Now, let us evaluate each given option:

  • Option 1: &&

This operator is used in languages like C and C++, but it is not valid in Python for Boolean indexing.

  • Option 2: @

The @ operator is used for matrix multiplication in Python, not for logical operations.

  • Option 3: &

This is the correct operator used for element-wise logical AND in Pandas Boolean indexing.

  • Option 4: N

This is not a logical operator in Python.

Thus, when using Boolean indexing on DataFrames, the logical AND operation is performed using the & operator.

Hence, the correct answer is: Option 3.

154

Find the output of the following Python code:

import Pandas as pd

M= pd.series({'P: 10, "Q: 90})

print(M)

  1. ((a))

    PQ1090\begin{matrix}P&Q\\ 10&90\end{matrix}

  2. ((b))

    P10Q90\begin{matrix}P&10\\ Q&90\end{matrix}

  3. ((c))

    0P101Q90\begin{matrix}0&P&10\\ 1&Q&90\end{matrix}

  4. ((d))

    10P90Q\begin{matrix}10&P\\ 90&Q\end{matrix}

Show Answer
Answer: ((b))

P10Q90\begin{matrix}P&10\\ Q&90\end{matrix}

Correct answer is: option 2)

Key Points

Understanding Pandas Series Creation from Dictionaries:

In the Pandas library, a Series is a one-dimensional labeled array capable of holding data of any type. When a Python dictionary is used to create a Series, the dictionary keys automatically become the index (labels), and the dictionary values become the actual data points in the Series.

Explanation:

Let's analyze the provided Python code step by step:

import Pandas as pd

M = pd.series({'P': 10, "Q": 90})

print(M)

Note: In standard Python, library names are case-sensitive. While the code in the image uses "Pandas" and ".series", the standard syntax is import pandas as pd and pd.Series(). Assuming the logic intended is a standard Pandas Series creation:

  1. {'P': 10, "Q": 90}

This is a dictionary where 'P' and 'Q' are keys, and 10 and 90 are their respective values.

  1. M = pd.Series(...)

When this dictionary is passed to the Series constructor:

  • The index labels will be P and Q.
  • The corresponding data values will be 10 and 90.
  1. print(M)

A Pandas Series is printed in a vertical format. The left column displays the index, and the right column displays the values.

P 10 Q 90 dtype: int64

 

  1. Evaluating the Options:
  • Option 1: Shows a horizontal/tabular layout, which is more characteristic of a DataFrame or a specific display style, but doesn't correctly represent the index-value relationship of a Series printout.
  • Option 2: Correctly shows the vertical alignment where P maps to 10 and Q maps to 90.
  • Option 3: Incorrectly adds a numeric index (0, 1) alongside the dictionary keys. In Pandas, if a dictionary is provided, the keys are the index; it does not default to integers unless specified.
  • Option 4: Swaps the position of the labels and the data.

 

Hence, the correct answer is: option 2)

155

What will be the output of the following Python code?

import pandas as pd

S = pd.series(20, 30)

print(S)

  1. ((a))

    TypeError

  2. ((b))

    20 30

  3. ((c))

    020130\begin{matrix}0&20\\ 1&30\end{matrix}

  4. ((d))

    012030\begin{matrix}0&1\\ 20&30\end{matrix}

Show Answer
Answer: ((a))

TypeError

Correct answer is: option 1) TypeError.

Key Points

Understanding Pandas Series Initialization:

A Pandas Series is a one-dimensional labeled array. To create a Series with multiple data points, the data must be passed as a single collection (like a list, dictionary, or tuple). If multiple individual numbers are passed as separate arguments without being wrapped in a collection, the function cannot interpret them correctly as the data for the array.

Explanation:

Let's analyze the provided Python code step by step:

import pandas as pd

S = pd.series(20, 30)

print(S)

  1. import pandas as pd

This correctly imports the pandas library and assigns it the alias pd.

  1. S = pd.series(20, 30)

There are two primary issues in this line:

  • Syntax Case: The correct method is pd.Series() (with a capital S). Python is case-sensitive, so pd.series would usually result in an AttributeError.
  • Argument Error: Even if the capitalization were correct (pd.Series(20, 30)), the constructor expects the first argument to be the data and the second to be the index. By passing 20, 30, you are telling Pandas the data is the scalar 20 and the index is 30. However, an index in Pandas must be "hashable" or "array-like." While a scalar can sometimes work, passing multiple raw integers often causes confusion in the constructor's signature if not handled as a single list like [20, 30].
  1. Data Type Expectation:

To get the output shown in Option 3 (index 0, 1 with values 20, 30), the code should have been:

S = pd.Series([20, 30]) Since the code provided passes arguments incorrectly and uses the wrong casing for the Series constructor, the Python interpreter will stop execution and raise an error.

 

Hence, the correct answer is: option 1) TypeError.

156

Fill in the blanks with an appropriate command from the given options to produce the output shown on the right side of the following code:

import pandas as pd

D = [[1, 2], [3, 4]]

A = ["A1", "A2"]

B = ["B1", "B2"]

Print(D)

  1. ((a))

    D= pd.DataFrame(D, columns = A, index = B)

  2. ((b))

    D= pd.DataFrame(D, rows=B, columns = A)

  3. ((c))

    D= pd.DataFrame(D, B, i=A)

  4. ((d))

    D= pd.DataFrame(A, B, D)

Show Answer
Answer: ((a))

D= pd.DataFrame(D, columns = A, index = B)

Correct answer is: option 1) D= pd.DataFrame(D, columns = A, index = B)

Concept:

Pandas DataFrame Construction and Parameters:

A Pandas DataFrame is a two-dimensional, size-mutable, and tabular data structure with labeled axes (rows and columns). When creating a DataFrame from a list of lists, you can specify custom labels using specific parameters: columns for the vertical headers and index for the horizontal row labels. Understanding the exact keyword arguments is essential for correct Python syntax.

Explanation:

Let's analyze the provided code and the target output image step by step:

import pandas as pd

D = [[1, 2], [3, 4]] A = ["A1", "A2"] B = ["B1", "B2"]

Target command goes here

  1. Analyzing the Target Output:

The image shows a table where:

  • The data consists of the values 1, 2, 3, and 4.
  • The column headers are "A1" and "A2" (stored in variable A).
  • The row labels (index) are "B1" and "B2" (stored in variable B).
  1. Evaluating the DataFrame Constructor Options:
  • Option 1: D = pd.DataFrame(D, columns = A, index = B)

This is correct. In Pandas, the parameter for column labels is explicitly named columns and the parameter for row labels is index.

  • Option 2: D = pd.DataFrame(D, rows = B, columns = A)

This is incorrect. While columns is correct, Pandas does not have a rows parameter; it uses index instead.

  • Option 3: D = pd.DataFrame(D, B, i=A)

This is incorrect. The parameter i is not a valid shorthand for index or columns in the DataFrame constructor.

  • Option 4: D = pd.DataFrame(A, B, D)

This is incorrect. This passes the variables as positional arguments in the wrong order (Data, Index, Columns), which would lead to a logical or technical error.

  1. Final Result:

To match the table in the image, you must assign the list A to the columns and the list B to the index using the keyword arguments.

Hence, the correct answer is: option 1) D= pd.DataFrame(D, columns = A, index = B)

157

What will be the output of the following Python code?

import numpy as np

B= np.array([20, 50, 80, 30])

print(B, B.size, B.shape)

  1. ((a))

    (20, 50, 80, 30) 4, (4,)

  2. ((b))

    [20, 50, 80, 30] 4, (4,)

  3. ((c))

    (20, 50, 80, 30) (4,) 4

  4. ((d))

    [20, 50, 80, 30] (4,) 4

Show Answer
Answer: ((b))

[20, 50, 80, 30] 4, (4,)

Correct answer is: option 2) [20, 50, 80, 30] 4, (4,)

Key Points

NumPy Array Attributes:

In Python, the NumPy library is used for numerical computations. When an array is created using np.array(), it possesses several attributes that describe its properties:

  • Data Representation: When a NumPy array is printed, it is enclosed in square brackets [].
  • size: This attribute returns the total number of elements present in the array.
  • shape: This attribute returns a tuple representing the dimensions of the array. For a one-dimensional array, it is expressed as (n,) where n is the number of elements.

Explanation:

Let's break down the given Python code step by step:

import numpy as np B = np.array([20, 50, 80, 30]) print(B, B.size, B.shape)

  1. import numpy as np

The NumPy library is imported with the alias np.

  1. B = np.array([20, 50, 80, 30])

A one-dimensional NumPy array is created containing 4 integer elements. In memory, B is stored as a vector.

  1. Evaluating print(B, B.size, B.shape):
  • B: Printing the array B displays the elements enclosed in square brackets. While NumPy usually prints without commas (e.g., [20 50 80 30]), in MCQ formats, it is commonly represented as [20, 50, 80, 30].
  • B.size: Since there are exactly 4 elements in the array, B.size returns 4.
  • B.shape: Since B is a 1D array with 4 elements, the shape attribute returns the tuple (4,).
  1. Combining the results:

The print statement will output the values in the order they were called: the array, followed by the size, followed by the shape.

Hence, the correct answer is: option 2) [20, 50, 80, 30] 4, (4,)

158

Which of the following will help us to read the content of a CSV file ITEMS.CSV as pandas DataFrame ?

  1. ((a))

    IT=pandas.read("ITEMS.CSV")

  2. ((b))

    IT = pandas.read_csv("ITEMS.CSV")

  3. ((c))

    IT=pandas.csv read("ITEMS.CSV")

  4. ((d))

    IT=pandas.read csv("ITEMS.CSV")

Show Answer
Answer: ((b))

IT = pandas.read_csv("ITEMS.CSV")

The correct answer is option 2) IT = pandas.read_csv("ITEMS.CSV").

Key Points

  • The read_csv() function is the standard method provided by the pandas library to load data from a Comma Separated Values (CSV) file into a DataFrame object.
  • The syntax requires an assignment operator (=) to store the resulting DataFrame into a variable (in this case, IT).
  • Python is case-sensitive and syntax-strict; the method name must include the underscore (_) between "read" and "csv".
  • The filename must be passed as a string (enclosed in quotes) within the parentheses of the function.
  • The pandas library must be imported (typically as import pandas or import pandas as pd) before this command can be executed.

Additional Information

  • Analysis of Incorrect Options:
  • Option 1: pandas.read() is not a valid function for reading CSV files; pandas requires specific methods like read_csv, read_excel, or read_json.
  • Option 3: pandas.csv read() is syntactically incorrect because Python does not recognize spaces within a function or attribute call.
  • Option 4: pandas.read csv() is incorrect for the same reason as option 3; the missing underscore makes it an invalid command.
  • Common Parameters in read_csv():
  • sep: Allows you to specify a different delimiter if the file is not comma-separated (e.g., sep=';').
  • header: Used to specify which row to use as the column names (default is the first row).
  • index_col: Allows a specific column to be used as the row labels of the DataFrame.
  • usecols: Used to return a subset of the columns from the CSV file.
  • Benefits of pandas DataFrames:
  • Provides powerful data manipulation tools including filtering, grouping, and merging.
  • Efficiently handles large datasets by loading them into structured tabular formats.
  • Supports various file formats, making it highly versatile for data science and analysis tasks.
159

Consider the following import command:

import matplotlib.pyplot as PLT

Which of the following command will help us to draw a line chart for given values?

  1. ((a))

    PLT.line plot([100, 400, 200, 300]) 

  2. ((b))

    PLT.plotline([100, 400, 200, 300])

  3. ((c))

    PLT.line([100, 400, 200, 300])

  4. ((d))

    PLT.plot([100, 400, 200, 300])

Show Answer
Answer: ((d))

PLT.plot([100, 400, 200, 300])

The correct answer is Option 4) PLT.plot([100, 400, 200, 300])

Key Points

  • The plot() function is the standard command in the matplotlib.pyplot module used to create line charts.
  • When an alias like PLT is defined (e.g., import matplotlib.pyplot as PLT), all functions from that module must be called using that alias.
  • If only one list of values is provided to plot(), matplotlib assumes they are y-values and automatically generates default x-values starting from 0.
  • The syntax follows the pattern: alias.function_name(data).

Additional Information

  • Alias (as): Using as PLT allows programmers to use a shorter name for the library, improving code readability and reducing typing effort.
  • Line Chart: A type of chart which displays information as a series of data points called 'markers' connected by straight line segments.
  • Incorrect Commands: Commands like line(), plotline(), or line plot() do not exist in the matplotlib.pyplot library.
  • X and Y coordinates: To specify both, the syntax would be PLT.plot(x_values, y_values).
160

Which of the following is DDL command?

  1. ((a))

    UPDATE SET 

  2. ((b))

    DELETE

  3. ((c))

    DROP TABLE

  4. ((d))

    INSERT INTO

Show Answer
Answer: ((c))

DROP TABLE

The correct answer is Option 3) DROP TABLE

Key Points

  • DDL stands for Data Definition Language, which is used to define or modify the structure of database objects.
  • The DROP TABLE command is a DDL command because it removes the entire table structure and its data from the database.
  • DDL commands are auto-committed, meaning they permanently save changes to the database immediately upon execution.
  • Other common DDL commands include CREATE, ALTER, and TRUNCATE.

Additional Information

  • DML (Data Manipulation Language): Commands like INSERT INTO, UPDATE SET, and DELETE are used to manage data within existing table structures.
  • UPDATE SET: Used to modify existing records within a table.
  • DELETE: Used to remove specific rows from a table based on a condition; unlike DROP, the table structure remains.
  • INSERT INTO: Used to add new rows of data into a table.
161

Which of the following is DML command ? 

  1. ((a))

    INSERT INTO

  2. ((b))

    DROP TABLE

  3. ((c))

    CREATE TABLE

  4. ((d))

    ALTER TABLE

Show Answer
Answer: ((a))

INSERT INTO

The correct answer is INSERT INTO

Code Execution Flow

  • Step 1: The statement queries "Which of the following is a DML command?" and provides multiple options.
  • Step 2: The options are analyzed based on SQL command classifications. "INSERT INTO" is identified as a DML command, while others (DROP TABLE, CREATE TABLE, ALTER TABLE) are categorized as DDL commands.
  • Step 3: The correct logic is applied to select the DML command. DML (Data Manipulation Language) focuses on data modification, such as inserting, updating, or deleting rows in a table.
  • Step 4: The selected answer "INSERT INTO" is confirmed as correct and displayed as the output.

Why This Output?

  • Important Rule Used: SQL commands are categorized into DDL (Data Definition Language) and DML (Data Manipulation Language). DML handles data manipulation operations like "INSERT INTO."
  • NULL / Index / Order Handling: No NULL or index-specific behavior applies here as this is a straightforward command classification.
  • Common Trap: Students often confuse DDL commands like CREATE TABLE or ALTER TABLE as DML. It's important to remember DDL modifies the structure, while DML modifies the data.
  • Final Output Justification: "INSERT INTO" is the correct answer because it is the only DML command among the provided options, focused on data manipulation.
162

An attribute or a set of attributes which are used to identify a tuple uniquely is known as:

  1. ((a))

    Primary Key

  2. ((b))

    Foreign Key 

  3. ((c))

    Alternate Key

  4. ((d))

    Candidate Key

Show Answer
Answer: ((a))

Primary Key

The correct answer is Primary Key

Code Execution Flow

  • Step 1: The question asks for the identification of an attribute or set of attributes uniquely identifying a tuple in a database table.
  • Step 2: The answer choices provided (Primary Key, Foreign Key, Alternate Key, Candidate Key) are analyzed for correctness.
  • Step 3: The concept of a Primary Key is identified as the correct choice because it uniquely identifies each row in a table.
  • Step 4: "Primary Key" is determined to be the correct answer and is displayed as the output.

Why This Output?

  • Important Rule Used: A Primary Key is a database constraint that ensures each row in a table is uniquely identifiable.
  • NULL / Index / Order Handling: Primary Keys cannot have NULL values, ensuring all tuples are uniquely identifiable.
  • Common Trap: Students may confuse the Primary Key with Candidate Keys or Alternate Keys, but only the Primary Key is explicitly used to uniquely identify tuples in a table.
  • Final Output Justification: "Primary Key" is the only correct option as per the definition provided in the question.
163

Which of the following is not a valid relational operator used in SQL?

  1. ((a))

    < =

  2. ((b))

    < >

  3. ((c))

    = >

  4. ((d))

    =

Show Answer
Answer: ((c))

= >

The correct answer is = >.

Key Points

  • In SQL, relational (comparison) operators are used to compare two values and return a Boolean result.
  • The operator <= means “less than or equal to” and is a valid SQL relational operator.
  • The operator <> represents “not equal to” and is also valid in SQL.
  • The operator = is used to test equality between two values.
  • = > is not a valid relational operator in SQL; the correct form for “greater than or equal to” is >=, not = >.

Additional Information

  • Common SQL Relational Operators:
  • = : Equal to
  • <> or != : Not equal to
  • < : Less than
  • > : Greater than
  • <= : Less than or equal to
  • >= : Greater than or equal to
  • Important Points:
  • SQL operators must follow exact syntax; even small changes in symbol order make them invalid.
  • = > is incorrect because SQL always places > before =.
  • Using invalid operators results in syntax errors during query execution.
164

Which of the following is using wrong syntax for a SELECT query in SQL?

  1. ((a))

    SELECT * WHERE RNO>100 FROM STUDENT;

  2. ((b))

    SELECT * FROM STUDENT WHERE RNO>100;

  3. ((c))

    SELECT FROM STUDENT WHERE RNO BETWEEN 100 AND 200;

  4. ((d))

    SELECT * FROM STUDENT WHERE RNO IN (100, 101, 105, 104);

Show Answer
Answer: ((a))

SELECT * WHERE RNO>100 FROM STUDENT;

The correct answer is SELECT * WHERE RNO>100 FROM STUDENT;.

Key Points

  • SELECT * WHERE RNO>100 FROM STUDENT; is an incorrect SQL syntax because the WHERE clause must come after the FROM clause.
  • The correct syntax should be SELECT * FROM STUDENT WHERE RNO>100;.
  • SQL queries follow a specific order of keywords: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.
  • Incorrect placement of clauses leads to syntax errors in SQL.
  • Among the options provided, SELECT * WHERE RNO>100 FROM STUDENT; is the only query that violates this order, making it the wrong syntax.

Additional Information

  • Correct SQL Query Examples:
  • SELECT * FROM STUDENT WHERE RNO>100;: Retrieves all columns for rows where RNO is greater than 100.
  • SELECT FROM STUDENT WHERE RNO BETWEEN 100 AND 200;: Incorrect because the query is missing the list of columns to select.
  • SELECT * FROM STUDENT WHERE RNO IN (100, 101, 105, 104);: Retrieves rows where RNO matches any of the listed values.
  • Important Points:
  • Ensure proper syntax and order of clauses when writing SQL queries.
  • Using incorrect syntax can result in errors or unintended behavior in database operations.
  • Always validate queries against database documentation or standards.
165

Which of the following will be the correct SQL command to add a new column FEES in a table TEACHER?

  1. ((a))

    ALTER TABLE TEACHER

    ADD COLUMN FEES FLOAT;

  2. ((b))

    ADD COLUMN FEES

    FLOAT INTO TEACHER;

  3. ((c))

    UPDATE TEACHER

    ADD COLUMN FEES FLOAT;

  4. ((d))

    INSERT INTO TEACHER

    ADD COLUMN FEES FLOAT;

Show Answer
Answer: ((a))

ALTER TABLE TEACHER

ADD COLUMN FEES FLOAT;

The correct answer is ALTER TABLE TEACHER ADD COLUMN FEES FLOAT;.

Key Points

  • The ALTER TABLE command is used in SQL to modify the structure of an existing table.
  • The ADD COLUMN clause allows you to add a new column to the table.
  • The syntax ALTER TABLE TEACHER ADD COLUMN FEES FLOAT; is correct, as it specifies the table name (TEACHER), the action (ADD COLUMN), the column name (FEES), and the data type (FLOAT).
  • Other options, such as UPDATE TEACHER ADD COLUMN or INSERT INTO TEACHER ADD COLUMN, are incorrect as they are not valid SQL syntax for adding columns to a table.
  • The correct SQL command ensures the addition of a new column without altering existing data in the table.

Additional Information

  • ALTER TABLE Command:
  • Used to modify table structures, such as adding, deleting, or modifying columns.
  • Examples:
  • ALTER TABLE table_name ADD COLUMN column_name datatype; - Adds a new column to the table.
  • ALTER TABLE table_name DROP COLUMN column_name; - Removes a column from the table.
  • ALTER TABLE table_name MODIFY COLUMN column_name datatype; - Changes the data type of an existing column.
  • Key SQL Data Types:
  • FLOAT: Represents approximate numeric values with floating decimal points.
  • INT: Represents integer values.
  • VARCHAR: Represents variable-length character strings.
  • DATE: Represents date values.
  • Best Practices for ALTER TABLE Command:
  • Always back up the database before performing structural modifications.
  • Ensure that the new column or modification does not conflict with existing constraints or data.
  • Test changes in a staging environment before deploying them to production.
166

Which of the following will display a list of tables in a database?

  1. ((a))

    DISPLAY TABLES;

  2. ((b))

    SHOW TABLES;

  3. ((c))

    SELECT TABLES;

  4. ((d))

    VIEW TABLES;

Show Answer
Answer: ((b))

SHOW TABLES;

The correct answer is SHOW TABLES;.

Key Points

  • SHOW TABLES; is the SQL command used to display a list of tables present in a database.
  • This command is supported by most relational database management systems, including MySQL, MariaDB, and PostgreSQL.
  • It provides an overview of all the tables within the active database, enabling the user to manage and query data efficiently.
  • To execute this command, ensure that the correct database is selected using the USE database_name; command.
  • SHOW TABLES; is a simple and effective way to retrieve the table names without accessing additional metadata or system tables.

Additional Information

  • Comparison of Options:
  • DISPLAY TABLES;: This is not a valid SQL command and will return an error in most databases.
  • SHOW TABLES;: Correct and widely used command for listing tables in a database.
  • SELECT TABLES;: Incorrect syntax; SELECT is used to query data, not list tables.
  • VIEW TABLES;: Not a valid SQL command for listing tables in a database.
  • Key Usage:
  • Helps database administrators (DBAs) and developers identify the tables available for querying and manipulation.
  • Provides visibility into the database schema for effective data modeling and management.
  • Can be used in conjunction with other commands, such as DESCRIBE table_name;, to view table structures.
  • Important Notes:
  • Ensure that the database is correctly selected before running the SHOW TABLES; command.
  • Access permissions may restrict the ability to view certain tables; check with the database administrator if needed.
  • Some databases, like SQL Server, use SELECT * FROM INFORMATION_SCHEMA.TABLES instead of SHOW TABLES;.
167

Which of the following will display information about all the employees from employee table, whose names contains second letter as "A"?

  1. ((a))

    SELECT * FROM EMPLOYEE WHERE NAME LIKE " A%";

  2. ((b))

    SELECT FROM EMPLOYEE

    WHERE NAME LIKE "%A ";

  3. ((c))

    SELECT FROM EMPLOYEE

    WHERE NAME LIKE " A%";

  4. ((d))

    SELECT FROM EMPLOYEE

    WHERE NAME="A%";

Show Answer
Answer: ((a))

SELECT * FROM EMPLOYEE WHERE NAME LIKE " A%";

The correct answer is Option 1.

Key Points

  • The correct query to display information about all employees from the EMPLOYEE table whose names contain the second letter as "A" is:
  • SELECT * FROM EMPLOYEE WHERE NAME LIKE "_A%";
  • The underscore (_) in the SQL LIKE clause is a wildcard character that matches exactly one character. The query "_A%" will find all names where the second letter is "A".
  • Option 1 is correct because it includes the proper syntax and logic to retrieve the desired data.
  • Other options are incorrect because they either have incorrect syntax or do not achieve the desired functionality.

Additional Information

  • Understanding SQL LIKE Clause:
  • The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.
  • Wildcard characters used with LIKE:
  • %: Represents zero, one, or multiple characters.
  • _: Represents a single character.
  • Examples:
  • LIKE 'A%': Finds values starting with "A".
  • LIKE '%A%': Finds values containing "A" anywhere.
  • LIKE '_A%': Finds values where the second character is "A".
  • Common Errors in SQL Queries:
  • Using incorrect wildcard characters or omitting necessary ones.
  • Omitting the SELECT or FROM clause.
  • Improperly formatting string literals (e.g., using double quotes instead of single quotes).
168

Which of the following SQL command will help in incrementing values of FEES column in STUDENT table by 10% ?

  1. ((a))

    UPDATE STUDENT

    ASSIGN FEES = FEES = 1.1;

  2. ((b))

    UPDATE STUDENT

    SET FEES = FEES * 1.1;

  3. ((c))

    UPDATE STUDENT

    SET FEES = FEES 10%;

  4. ((d))

    UPDATE STUDENT

    SET FEES 10%;

Show Answer
Answer: ((b))

UPDATE STUDENT

SET FEES = FEES * 1.1;

The correct answer is Option 2) UPDATE STUDENT SET FEES = FEES * 1.1;

Key Points

  • To increment a column value by 10%, the existing value must be multiplied by 1.1 (i.e., 110% of the original value).
  • The UPDATE statement is used to modify existing records in a table.
  • The SET clause specifies the column to be updated and the new calculated value.
  • Mathematical logic: New Value = Old Value × (1 + 10/100) = Old Value × 1.1
  • The correct SQL syntax pattern is: UPDATE table_name SET column_name = expression;

Additional Information

  • DML Command: UPDATE is a Data Manipulation Language (DML) command used to change data inside a table.
  • ASSIGN keyword: ASSIGN is not a valid SQL keyword; the correct keyword for updates is SET.
  • Percentage symbol (%): In SQL, % is mainly used as a wildcard in the LIKE clause, not for percentage calculations.
  • Arithmetic operators: SQL supports +, -, *, and / for performing calculations in UPDATE statements.
169

Which of the following is correct sequence in a SELECT query?

  1. ((a))

    SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY 

  2. ((b))

    SELECT, WHERE, FROM, GROUP BY, HAVING, ORDER BY 

  3. ((c))

    SELECT, FROM, WHERE, HAVING, GROUP BY, ORDER BY 

  4. ((d))

    SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING

Show Answer
Answer: ((a))

SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY 

The correct answer is Option 1

Code Execution Flow

  • Step 1: The SQL query begins execution by processing the FROM clause to identify the source table(s) for the query.
  • Step 2: The WHERE clause is applied next to filter rows based on the specified condition(s).
  • Step 3: The GROUP BY clause is executed to group the filtered rows into subsets based on the specified column(s).
  • Step 4: The HAVING clause is applied to filter the grouped data based on aggregate conditions.
  • Step 5: The ORDER BY clause is applied to arrange the resulting rows in the specified order.
  • Step 6: Finally, the SELECT clause retrieves and displays the requested column(s) from the processed data.

Why This Output?

  • Important Rule Used: SQL queries are executed in a specific logical order: FROM, WHERE, GROUP BY, HAVING, ORDER BY, and SELECT. This sequence ensures that the query processes data in a structured way.
  • NULL / Index / Order Handling: The ORDER BY clause determines the final arrangement of data, and NULL values are handled based on the database's sorting rules.
  • Common Trap: A common misunderstanding is assuming that SELECT is executed first. However, it is executed last, after all filtering, grouping, and ordering are completed.
  • Final Output Justification: Option 1 is correct because it follows the logical execution order of SQL queries, ensuring proper data processing and retrieval.
170

Consider the following tables and their respective degrees and cardinalities in a database called SCHOOL:

Database: SCHOOL
TableDegreeCardinality
STUDENT20300
TEACHER1025
<br>

Select the degree and cardinality of the cartesian product of the tables STUDENT X TEACHER from the following options:

  1. ((a))

    30 7500 

  2. ((b))

    200 325

  3. ((c))

    30 325

  4. ((d))

    200 7500

Show Answer
Answer: ((a))

30 7500 

The correct answer is 30 7500.

Key Points

  • The degree of a Cartesian product is obtained by adding the degrees of both tables.
  • Here, STUDENT has degree 20 and TEACHER has degree 10, so total degree becomes 20 + 10 = 30.
  • The cardinality of a Cartesian product is obtained by multiplying the cardinalities of both tables.
  • STUDENT has cardinality 300 and TEACHER has cardinality 25, so total cardinality becomes 300 × 25 = 7500.
  • Therefore, the Cartesian product STUDENT × TEACHER results in degree 30 and cardinality 7500.

Additional Information

  • Cartesian Product in DBMS:
  • Combines every row of the first table with every row of the second table.
  • Represented using the × operator.
  • Important Points:
  • Degree always increases by addition of attributes.
  • Cardinality always increases by multiplication of tuples.
  • This concept is frequently tested in relational algebra and DBMS exams.
171

Which of the following set of functions is a valid set of aggregate functions in MySQL?

  1. ((a))

    AVG(), ROUND(), COUNT()

  2. ((b))

    MIN(), UPPER(), AVG()

  3. ((c))

    COUNT(), MAX(), SUM()

  4. ((d))

    DATE(), COUNT(), LTRIM()

Show Answer
Answer: ((c))

COUNT(), MAX(), SUM()

The correct answer is COUNT(), MAX(), SUM().

Key Points

  • COUNT(), MAX(), and SUM() are aggregate functions in MySQL, used to perform calculations on a set of values and return a single summarized value.
  • These functions are integral for data analysis and reporting in SQL-based databases.
  • COUNT(): Used to count the number of rows in a table or the number of non-NULL values in a column.
  • MAX(): Returns the maximum value in a set of values.
  • SUM(): Calculates the total sum of numeric values in a column.

Additional Information

  • Other Aggregate Functions in MySQL:
  • AVG(): Calculates the average value of a numeric column.
  • MIN(): Returns the smallest value in a set.
  • GROUP_CONCAT(): Concatenates values from a group into a single string.
  • Non-Aggregate Functions:
  • ROUND(): Used to round a numeric value to the nearest integer or specified decimal places.
  • UPPER(): Converts a string to uppercase.
  • DATE(): Extracts the date portion of a DATETIME value.
  • LTRIM(): Removes leading spaces from a string.
  • Key Differences:
  • Aggregate functions operate on a set of values and return a single result, whereas non-aggregate functions operate on individual values.
  • Aggregate functions are often used with the GROUP BY clause to group data before performing calculations.
  • Use Cases for Aggregate Functions:
  • Summarizing large datasets for reporting and analysis.
  • Calculating statistical metrics like averages, totals, and counts.
  • Finding minimum or maximum values in a dataset.
172

Find the output of the MySQL query based on the given Table-COACH (ignore the output header) Table : COACH

CIDCNAMEGAMESALARY
G03VSHALINULL60000
G05YUVRAJACRICKETNULL
G08MALKHANATHLATICS80000
G09SACINDRACRICKETNULL
<br>

SELECT COUNT(GAME), AVG(SALARY)

FROM COACH;

  1. ((a))

    3 70000

  2. ((b))

    4 35000

  3. ((c))

    4 70000

  4. ((d))

    3 35000

Show Answer
Answer: ((a))

3 70000

The correct answer is 3 70000.

Key Points

  • COUNT(GAME) counts only the non-NULL values in the GAME column.
  • The GAME column has values: NULL, CRICKET, ATHLETICS, CRICKET — so the count is 3.
  • AVG(SALARY) also ignores NULL values.
  • The non-NULL salaries are 60000 and 80000.
  • The average salary is (60000 + 80000) / 2 = 70000.

Additional Information

  • COUNT(column_name):
  • Counts only non-NULL entries in the specified column.
  • AVG(column_name):
  • Calculates the average of non-NULL numeric values.
  • Important Points:
  • NULL values are ignored by aggregate functions like COUNT(column) and AVG().
  • COUNT(*) would count all rows, including those with NULL values.
  • This question tests understanding of aggregate functions with NULL handling in MySQL.
173

Find the output of the MySQL query based on the given Table-STUDENT (ignore the output header) Table: STUDENT

SIDSNAMESECMARKS
101AmeenaA83
107ArjunB86
112AlbertB80
120AkramA85
<br>

Query:

SELECT SEC, AVG (MARKS) FROM STUDENT

GROUP BY SEC HAVING MIN (MARKS) > 80;

  1. ((a))

    B83A84\begin{matrix}B&83\\ A&84\end{matrix}

  2. ((b))

    A 84

  3. ((c))

    A84B83\begin{matrix}A&84\\ B&83\end{matrix}

  4. ((d))

    B83A80\begin{matrix}B&83\\ A&80\end{matrix}

Show Answer
Answer: ((b))

A 84

The correct answer is A 84.

Key Points

  • The query groups records by SEC and calculates AVG(MARKS) for each group.
  • For section A, marks are 83 and 85; the minimum is 83, which satisfies MIN(MARKS) > 80.
  • The average for section A is (83 + 85) / 2 = 84.
  • For section B, marks are 86 and 80; the minimum is 80, which does not satisfy the HAVING condition.
  • Therefore, only section A appears in the output with average marks 84.

Additional Information

  • GROUP BY:
  • Groups rows that have the same values in specified columns.
  • HAVING Clause:
  • Filters grouped records based on aggregate conditions.
  • Important Points:
  • HAVING is applied after grouping, unlike WHERE.
  • Aggregate functions like MIN() and AVG() work on grouped data.
  • This question tests understanding of GROUP BY with HAVING in SQL.
174

Consider the following tables in a database called SPORTS.

Database: SPORTS

Table: GAMES

GIDGNAMEFEES
G01Football300
G02Cricket1000
G03Basketball500
<br>

Table : PLAYERS

P1DPNAMESEXG1D
P101AmritaFG03
P103AmeenaFG02
P107AngelFG02
P109AmanMG03
<br>

Which is the best command from the following options to display the name of the player (PNAME) and their respective games (GNAME)

  1. ((a))

    SELECT PNAME, GID FROM PLAYERS;

  2. ((b))

    SELECT PNAME, GNAME FROM GAMES, PLAYERS

    WHERE GAMES.GID=PLAYERS.G1D;

  3. ((c))

    SELECT PNAME, GNAME FROM GAMES, PLAYERS

  4. ((d))

    SELECT PNAME, GNAME FROM GAMES, PLAYERS

    WHERE P.GID=G.GID;

Show Answer
Answer: ((b))

SELECT PNAME, GNAME FROM GAMES, PLAYERS

WHERE GAMES.GID=PLAYERS.G1D;

The correct answer is Option 2) SELECT PNAME, GNAME FROM GAMES, PLAYERS WHERE GAMES.GID=PLAYERS.G1D;

Key Points

  • This query performs an Equi-Join between the 'GAMES' and 'PLAYERS' tables to fetch related data from both.
  • The SELECT clause correctly identifies PNAME (from PLAYERS) and GNAME (from GAMES) as the columns to be displayed.
  • The FROM clause lists both tables involved in the operation: GAMES and PLAYERS.
  • The WHERE clause establishes the join condition by matching the Primary Key of the first table (GID) with the Foreign Key of the second table (G1D).

Additional Information

  • Primary Key - Foreign Key Relationship: In this database, GID is the primary key in the GAMES table, and G1D is the foreign key in the PLAYERS table used to link players to their games.
  • Option 1: This is incorrect because it only selects data from the PLAYERS table and does not provide the game names (GNAME).
  • Option 3: This is incorrect because it lacks a WHERE clause, resulting in a Cartesian Product (Cross Join) where every player is incorrectly paired with every game.
  • Option 4: This is incorrect because it uses aliases (P and G) in the WHERE clause that were not defined in the FROM clause, leading to a syntax error.
175

Following are the two tables in a MySQL database.

Database: COMPARTMENT

Table: SUBJECTS

SUBCODESUBNAMEMAXTMAXP
065Informatics Practices7030
083Computer Science7030
301English Core8020
<br>

Table: RESULT

ROLLSUBCODETMARKSPMARKS
100450837030
101350655629
102310656330
103450835629
<br>

Select the command from the following options to display subjects (SUBNAME) and number of students registered in that subject in table RESULT.

  1. ((a))

    SELECT SUBNAME, COUNT(*)

    FROM SUBJECTS, RESULT GROUP BY SUBNAME;

  2. ((b))

    SELECT SUBNAME, COUNT(*)

    FROM SUBJECTS, RESULT ORDER BY SUBNAME;

  3. ((c))

    SELECT SUBNAME, COUNT(*)

    FROM SUBJECTS NATURAL JOIN RESULT ORDER BY SUBNAME;

  4. ((d))

    SELECT SUBNAME, COUNT(*)

    FROM SUBJECTS NATURAL JOIN RESULT GROUP BY SUBNAME;

Show Answer
Answer: ((d))

SELECT SUBNAME, COUNT(*)

FROM SUBJECTS NATURAL JOIN RESULT GROUP BY SUBNAME;

The correct answer is Option 4) SELECT SUBNAME, COUNT(*) FROM SUBJECTS NATURAL JOIN RESULT GROUP BY SUBNAME;

Key Points

  • A NATURAL JOIN is used here to link the SUBJECTS and RESULT tables based on their common column, which is SUBCODE.
  • The GROUP BY SUBNAME clause is essential to categorize the records by subject name so that an aggregate function can be applied to each group.
  • The COUNT(*) function counts the number of occurrences (students) within each defined group of subject names.
  • The SELECT clause correctly picks the subject name to display alongside the calculated count for each subject.

Additional Information

  • Aggregate Functions: Functions like COUNT, SUM, and AVG perform a calculation on a set of values and return a single value; they almost always require a GROUP BY clause when used with non-aggregated columns.
  • Natural Join: This join automatically matches columns with the same name in both tables (SUBCODE in this case), simplifying the query by removing the need for an ON or WHERE condition.
  • Option 1 & 2: These are incorrect because they list two tables in the FROM clause without a join condition, which would result in a Cartesian Product (Cross Join) before grouping.
  • Option 3: This is incorrect because ORDER BY only sorts the final results; it does not perform the grouping required for the COUNT aggregate function to work per subject.
176

To establish the Python-MySQL connection, connect() method is used with certain parameters or arguments. Which of the following is not a parameter/argument used with connect() method?

  1. ((a))

    user

  2. ((b))

    password

  3. ((c))

    database

  4. ((d))

    table

Show Answer
Answer: ((d))

table

The correct answer is Option 4) table

Key Points

  • To establish a connection between Python and a MySQL database, the connect() method from a connector library (like mysql-connector-python) is used.
  • The connect() method requires connection string parameters to identify the server and authenticate the user.
  • The standard parameters include host, user, password, and database.
  • table is not a parameter of the connect() method because a connection is made to the database engine/instance as a whole, not to an individual table.

Additional Information

  • host: Specifies the server address where MySQL is running (e.g., 'localhost' or an IP address).
  • user: The username used to authenticate with the MySQL server (e.g., 'root').
  • password: The password associated with the specified username.
  • database: The name of the specific database schema you wish to access after connecting.
  • Cursor: After establishing a connection, a cursor() object is created to execute SQL queries, including those that interact with specific tables.
177

commit() is required to be used after the execution of certain queries in Python-MySQL connectivity applications. Identify one such MySQL command out of the following options:

  1. ((a))

    CREATE

  2. ((b))

    INSERT

  3. ((c))

    SELECT

  4. ((d))

    DROP

Show Answer
Answer: ((b))

INSERT

The correct answer is Option 2) INSERT

Key Points

  • The commit() method is used to finalize and permanently save all changes made during the current transaction to the database.
  • In Python-MySQL connectivity, Data Manipulation Language (DML) commands like INSERT, UPDATE, and DELETE require an explicit commit to reflect changes.
  • If commit() is not called after an INSERT query, the changes will be rolled back once the connection is closed, and the data will not be stored.
  • The method is called on the connection object, for example: db_connection.commit().

Additional Information

  • DDL Commands (CREATE, DROP): Data Definition Language commands are typically auto-committed by the database engine, meaning they do not strictly require the Python commit() method to save the structure changes.
  • SELECT Command: This is a Data Query Language (DQL) command used only to fetch data; since it does not modify the database state, commit() is unnecessary.
  • Transaction Management: Using commit() allows developers to group multiple SQL statements into a single atomic unit of work.
  • rollback(): This is the opposite of commit(); it is used to undo any changes made in the current transaction if an error occurs.
178

While working on Python-MySQL connectivity, fetchall() method is used to get data from table. The method fetchall() returns -

  1. ((a))

    a list

  2. ((b))

    a tuple

  3. ((c))

    tuple of lists

  4. ((d))

    list of tuples

Show Answer
Answer: ((d))

list of tuples

The correct answer is list of tuples.

Key Points

  • The fetchall() method in Python-MySQL connectivity is used to retrieve all rows from the result set of a query execution.
  • The method returns the data as a list of tuples, where each tuple represents a row in the table.
  • This format allows easy access to each row and its corresponding columns using indexes.
  • It is a convenient way to fetch and manipulate multiple rows of data from a database table.
  • The list of tuples structure ensures compatibility with Python’s data manipulation tools and libraries.

Additional Information

  • Common Python-MySQL Methods:
  • fetchone(): Retrieves the next row of a query result set.
  • fetchmany(size): Retrieves the next set of rows, with the number of rows specified by the size parameter.
  • execute(query): Executes a SQL query against the connected database.
  • commit(): Saves the changes made by the SQL queries to the database.
  • Usage of fetchall():
  • Frequently used for retrieving and processing large amounts of data from a database.
  • Ensures all rows are fetched at once, reducing multiple database calls.
  • Advantages of fetchall():
  • Efficiently gathers all query results in a single operation.
  • Allows seamless integration with Python’s data processing tools like pandas.
  • Important Notes:
  • Using fetchall() for extremely large result sets may consume significant memory and impact performance.
  • It is advisable to use fetchmany() or a cursor for handling large datasets efficiently.
179

The method cursor() is used in Python-MySQL connectivity applications. This method is a member of:

  1. ((a))

    sql module

  2. ((b))

    pickle module

  3. ((c))

    database-connectivity module

  4. ((d))

    csv module

Show Answer
Answer: ((c))

database-connectivity module

The correct answer is database-connectivity module.

Key Points

  • The cursor() method is used in Python's MySQL connectivity applications to create a cursor object, which is essential for executing SQL queries.
  • The cursor object allows interaction with the database by executing commands and retrieving query results.
  • It is a member of the database-connectivity module, specifically used for operations involving MySQL databases.
  • Python provides MySQL connectivity through libraries like mysql-connector or PyMySQL, which include the cursor() method.
  • The cursor object plays a critical role in database programming by managing the context of a fetch operation.

Additional Information

  • Functionality of the cursor() method:
  • Allows execution of SQL queries through methods like execute() and executemany().
  • Facilitates retrieval of query results using methods such as fetchone(), fetchall(), and fetchmany().
  • Enables parameterized query execution for enhanced security and efficiency.
  • Examples of Database Connectivity Modules in Python:
  • mysql-connector: Official MySQL driver provided by Oracle for Python.
  • PyMySQL: A pure-Python MySQL client library.
  • sqlite3: A built-in library for SQLite database connectivity in Python.
  • Advantages of Using the cursor() Method:
  • Simplifies database interactions by abstracting complex operations.
  • Allows execution of multiple queries in a single database connection.
  • Provides a robust and secure way to manage database transactions.
  • Best Practices for Using the cursor() Method:
  • Always close the cursor object after use to free up resources.
  • Use parameterized queries to prevent SQL injection attacks.
  • Handle exceptions properly to ensure safe and efficient database operations.
180

Which of the following clause is used with SELECT command in MySQL to avoid duplication of output rows.

  1. ((a))

    NO DUPLICATE

  2. ((b))

    UNIQUE

  3. ((c))

    DISTINCT

  4. ((d))

    NO REPEAT

Show Answer
Answer: ((c))

DISTINCT

The correct answer is DISTINCT

Key Points

  • The DISTINCT clause is used to ensure that duplicate rows are not included in the result set.
  • It filters out duplicate values and displays only unique rows.
  • Using DISTINCT improves readability and avoids redundancy in the output.
  • It is commonly used when retrieving data from tables with potential duplicate entries.

Additional Information

  • SELECT DISTINCT: Fetches unique rows by eliminating duplicates in the specified column(s).
  • Syntax: SELECT DISTINCT column_name FROM table_name;
  • Example: SELECT DISTINCT city FROM customers; retrieves unique cities from the customers table.
  • Use Cases: Helpful in scenarios like fetching unique categories, names, or attributes from large datasets.

Attempt this paper under real exam conditions

Timed interface, section switching, instant scoring, and question-by-question analytics — free.

Start Timed Attempt