Q: Question 10What will be the correct output of the following code:a, b = '30', '5' c = a+b print(c)19305ValueErrorTypeError

305Reason — In the above code, a and b are strings as they are enclosed in quotes. When using the + operator with strings, it performs concatenation rather than arithmetic addition. Therefore, a + b results in the concatenation of '30' and '5', producing '305'.

Q: Question 12If a < b and a < c thena is the greatest numbera is the smallest numberb is the greatest numberc is the greatest number

a is the smallest numberReason — If a < b and a < c, it means a is less than both b and c. Therefore, a is the smallest number among a, b, and c.

Q: Question 16Shikha has written the following SQL statement:Select Name, Dept, Salary*12 as "Annual Salary" from EMP;What is "Annual Salary" in the above statement?

In the given SQL statement, "Annual Salary" is an alias for the calculated column Salary*12. An alias is a temporary name given to a column or table in an SQL query, making it easier to reference and display the results.

Q: Question 17Consider the following dictionaryBook = {1 : "Informatics Practices", 2 : "Computer Science ", 3 : "Information Technology"}Jaya executes statement: 2 in BookAssertion (A): For the above dictionary Book, the output of the statement 2 in Book is True.Reasoning (R): For Dictionary, the ‘in’ and ‘not in’ operators return True or False.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Both A and R are true and R is the correct explanation of A.ExplanationThe statement 2 in Book checks if the key 2 exists in the dictionary Book. Since 2 is a key in the dictionary with the value "Computer Science ", the statement returns True. The in and not in operators in Python dictionaries return True or False depending on whether the specified key exists in the dictionary or not.

Q: Question 18For a given listL = [1, 2, 3, 4, 5, 6]the index of element 4 will be:Assertion (A): The index of element 4 will be 3 or -3.Reasoning (R): Python list supports forward and backward indexing with -1 to given to left most and 0 to right most element.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

A is true but R is false.ExplanationThe index of element 4 in the list L = [1, 2, 3, 4, 5, 6] is 3. Additionally, the index -3 refers to the element 4 when counting from the end of the list. Python lists support both forward (positive) and backward (negative) indexing with -1 referring to the rightmost element and 0 referring to the leftmost element.

Q: Question 20What will be the output of the following code?for k in range(-10, 0, 2): print(k)

Output-10 -8 -6 -4 -2 ExplanationThe for loop generates a sequence of numbers starting from -10, stopping before 0 (i.e., 2), and incrementing by 2 each time, resulting in the sequence -10, -8, -6, -4, -2.

Q: Question 21Differentiate between cloud computing and grid computing?

Cloud ComputingGrid ComputingCloud computing is used for virtualization of servers, where one server computes several tasks or services concurrently.Grid computing allocates multiple servers onto a single application.It supports long-running services (Service Oriented).It is typically used for job execution, where a program runs for a limited time (Application-Oriented).Cloud computing is used for multiple services.Grid computing is used for a single application.Its computation service is on-demand.Its computation service provides maximum computing power for one application.It involves virtualization of hardware, software, and storage platforms.It involves virtualization of data and computing resources.Examples : GoogleDrive, OneDrive, Mobile Office Applications (e.g., Office 365, Google Docs), SharePoint, Microsoft Azure, iCloud, AWS etc.Examples : GridGain, JPPF, JBossCache, EhCache etc.

Q: Question 23What will be the output of the following code?Country=["India", "Australia", "USA", "China", "Russia", "Ukraine" ] print(Country[2:5]) print(Country[-5:-2])

Output['USA', 'China', 'Russia'] ['Australia', 'USA', 'China'] ExplanationIn the given Python code, Country[2:5] returns ["USA", "China", "Russia"], slicing from index 2 up to index 4. Then, Country[-5:-2] retrieves a sublist starting from index -5 up to index -3. This results in ["Australia", "USA", "China"].The indexing table is:ElementPositive IndexNegative Index"India"0-6"Australia"1-5"USA"2-4"China"3-3"Russia"4-2"Ukraine"5-1

Q: Question 29Rohit, a Librarian has created a Table Book with the following fields:Bookid, Bookname, Author and Price. He has entered 20 records in the table.Which command should he use to do the following:(i) To change the price of Computer Science book from 450 to 500.(ii) To insert Primary Key in the table.(iii) What is the difference between delete and drop command.

(i)UPDATE Book SET Price = 500 WHERE Bookname = 'Computer Science' AND Price = 450;(ii)ALTER TABLE Book ADD CONSTRAINT pk_Bookid PRIMARY KEY (Bookid);(iii) DELETE command is used to remove all the contents from the table, leaving it empty. On the other hand, the DROP command is used to delete the table from the database along with all its data and structure.

Q: Question 30The data type list is an ordered sequence which is mutable and made up of one or more elements. Unlike a string which consists of only characters, a list can have elements of different data types such as integer, float, string, tuple or even another list. A list is very useful to group elements of mixed data types. Elements of a list are enclosed in square brackets and are separated by comma.(i) How is a list different from a dictionary?(ii) Find the values of y and z after execution:x=[2, 3] y=[30, 40] z=[88, 99] y.extend(x) z.append(x) print (y) print (z)

(i) A list in Python is an ordered collection of elements that can be accessed by their index. In contrast, a dictionary is an unordered collection of key-value pairs, where values are accessed using unique keys. Elements of a list are enclosed in square brackets and are separated by comma while dictionaries are enclosed in curly brackets, with keys and values separated by colons and key-value pairs separated by commas.(ii)Output[30, 40, 2, 3] [88, 99, [2, 3]] Explanationy.extend(x) modifies the list y by adding the elements of x to the end of y. So, y becomes [30, 40, 2, 3].z.append(x) adds the entire list x as a single element to the end of z. So, z becomes [88, 99, [2, 3]].

Question 1

Question 8The superimposition of computer-generated perceptual information over the existing physical surrounding is called ............... .

Accepted Answer

Augmented Reality

Source: This question is from Practice Paper, Informatics Practices &mdash; Class 11, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Practice Paper: Question, Superimposition, Computer, Generated, Perceptual, Information. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 11 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from Practice PaperQ1: Question 33(i) Find out the errors in the following code snippet and rewrite the code by...
Q10: Question 10 What will be the correct output of the following code: a , b = &#x27;30&#x27; , &#x27;5&#x27; c = a + b...
Q12: Question 12 If a < b and a < c then a is the greatest number a is the smallest number b is the...
Q13: Question 13 Mismatched redundant copies of data is known as Data ............... . Dependence...
Q14: Question 14 ............... is a subfield of linguistics, Computer Science and Artificial...
Practice more questions from Practice Paper &mdash; Informatics Practices, Class 11 CBSE

Question 2

Question 9Seema is collecting data for her science project from science blogs, e-newspapers and various websites this process is known as ............... .Data CapturingData RetrievalData StorageAll of these

Accepted Answer

Data RetrievalReason — Data retrieval involves obtaining and collecting data from various sources, such as science blogs, e-newspapers, and websites.

Source: This question is from Practice Paper, Informatics Practices &mdash; Class 11, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Practice Paper: Question, Seema, Collecting, Data, Science, Project. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 11 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from Practice PaperQ1: Question 33(i) Find out the errors in the following code snippet and rewrite the code by...
Q10: Question 10 What will be the correct output of the following code: a , b = &#x27;30&#x27; , &#x27;5&#x27; c = a + b...
Q12: Question 12 If a < b and a < c then a is the greatest number a is the smallest number b is the...
Q13: Question 13 Mismatched redundant copies of data is known as Data ............... . Dependence...
Q14: Question 14 ............... is a subfield of linguistics, Computer Science and Artificial...
Practice more questions from Practice Paper &mdash; Informatics Practices, Class 11 CBSE

Question 3

Question 10What will be the correct output of the following code:a, b = '30', '5'
c = a+b
print(c)19305ValueErrorTypeError

Accepted Answer

305Reason — In the above code, a and b are strings as they are enclosed in quotes. When using the + operator with strings, it performs concatenation rather than arithmetic addition. Therefore, a + b results in the concatenation of '30' and '5', producing '305'.

Question 4

Question 11If you add a new column in a table using the Alter Table command, which value is inserted in the new column for the existing rows?

Accepted Answer

If we add a new column in a table using the Alter Table command, the new column will be filled with NULL for all existing rows.

Source: This question is from Practice Paper, Informatics Practices &mdash; Class 11, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Practice Paper: Question, Add, New, Column, Table, Alter. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 11 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from Practice PaperQ1: Question 33(i) Find out the errors in the following code snippet and rewrite the code by...
Q10: Question 10 What will be the correct output of the following code: a , b = &#x27;30&#x27; , &#x27;5&#x27; c = a + b...
Q12: Question 12 If a < b and a < c then a is the greatest number a is the smallest number b is the...
Q13: Question 13 Mismatched redundant copies of data is known as Data ............... . Dependence...
Q14: Question 14 ............... is a subfield of linguistics, Computer Science and Artificial...
Practice more questions from Practice Paper &mdash; Informatics Practices, Class 11 CBSE

Question 5

Question 12If a < b and a < c thena is the greatest numbera is the smallest numberb is the greatest numberc is the greatest number

Accepted Answer

a is the smallest numberReason — If a < b and a < c, it means a is less than both b and c. Therefore, a is the smallest number among a, b, and c.

Question 6

Question 13Mismatched redundant copies of data is known as Data ............... .DependenceRedundancyInconsistencyIsolation

Accepted Answer

InconsistencyReason — Mismatched redundant copies of data is known as Data Inconsistency.

Source: This question is from Practice Paper, Informatics Practices &mdash; Class 11, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Practice Paper: Question, Mismatched, Redundant, Copies, Data, Dependence. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 11 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from Practice PaperQ1: Question 33(i) Find out the errors in the following code snippet and rewrite the code by...
Q10: Question 10 What will be the correct output of the following code: a , b = &#x27;30&#x27; , &#x27;5&#x27; c = a + b...
Q12: Question 12 If a < b and a < c then a is the greatest number a is the smallest number b is the...
Q14: Question 14 ............... is a subfield of linguistics, Computer Science and Artificial...
Q15: Question 15 Convert 1 GB to 1 Kilobytes.
Practice more questions from Practice Paper &mdash; Informatics Practices, Class 11 CBSE

Question 7

Question 14............... is a subfield of linguistics, Computer Science and Artificial Intelligence concerned with the interaction between computer and human language.

Accepted Answer

NLP (Natural Language Processing)

Source: This question is from Practice Paper, Informatics Practices &mdash; Class 11, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Practice Paper: Question, Subfield, Linguistics, Computer, Science, Artificial. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 11 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from Practice PaperQ1: Question 33(i) Find out the errors in the following code snippet and rewrite the code by...
Q10: Question 10 What will be the correct output of the following code: a , b = &#x27;30&#x27; , &#x27;5&#x27; c = a + b...
Q12: Question 12 If a < b and a < c then a is the greatest number a is the smallest number b is the...
Q13: Question 13 Mismatched redundant copies of data is known as Data ............... . Dependence...
Q15: Question 15 Convert 1 GB to 1 Kilobytes.
Practice more questions from Practice Paper &mdash; Informatics Practices, Class 11 CBSE

Question 8

Question 15Convert 1 GB to 1 Kilobytes.

Accepted Answer

1 GB = 1024 megabytes (MB) and 1 MB = 1024 kilobytes (KB).Therefore:1 GB = 1024 MB * 1024 KB/MB = 1,048,576 KBSo, 1 GB is equal to 1,048,576 KB.

Source: This question is from Practice Paper, Informatics Practices &mdash; Class 11, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Practice Paper: Question, Convert, Kilobytes, Practice Paper, Informatics Practices. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 11 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from Practice PaperQ1: Question 33(i) Find out the errors in the following code snippet and rewrite the code by...
Q10: Question 10 What will be the correct output of the following code: a , b = &#x27;30&#x27; , &#x27;5&#x27; c = a + b...
Q12: Question 12 If a < b and a < c then a is the greatest number a is the smallest number b is the...
Q13: Question 13 Mismatched redundant copies of data is known as Data ............... . Dependence...
Q14: Question 14 ............... is a subfield of linguistics, Computer Science and Artificial...
Practice more questions from Practice Paper &mdash; Informatics Practices, Class 11 CBSE

Question 9

Question 16Shikha has written the following SQL statement:Select Name, Dept, Salary*12 as "Annual Salary" from EMP;What is "Annual Salary" in the above statement?

Accepted Answer

In the given SQL statement, "Annual Salary" is an alias for the calculated column Salary*12. An alias is a temporary name given to a column or table in an SQL query, making it easier to reference and display the results.

Question 10

Question 17Consider the following dictionaryBook = {1 : "Informatics Practices", 
        2 : "Computer Science ",
        3 : "Information Technology"}Jaya executes statement: 2 in BookAssertion (A): For the above dictionary Book, the output of the statement 2 in Book is True.Reasoning (R): For Dictionary, the ‘in’ and ‘not in’ operators return True or False.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

Both A and R are true and R is the correct explanation of A.ExplanationThe statement 2 in Book checks if the key 2 exists in the dictionary Book. Since 2 is a key in the dictionary with the value "Computer Science ", the statement returns True. The in and not in operators in Python dictionaries return True or False depending on whether the specified key exists in the dictionary or not.

Question 11

Question 18For a given listL = [1, 2, 3, 4, 5, 6]the index of element 4 will be:Assertion (A): The index of element 4 will be 3 or -3.Reasoning (R): Python list supports forward and backward indexing with -1 to given to left most and 0 to right most element.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

A is true but R is false.ExplanationThe index of element 4 in the list L = [1, 2, 3, 4, 5, 6] is 3. Additionally, the index -3 refers to the element 4 when counting from the end of the list. Python lists support both forward (positive) and backward (negative) indexing with -1 referring to the rightmost element and 0 referring to the leftmost element.

Question 12

Question 20What will be the output of the following code?for k in range(-10, 0, 2):  
    print(k)

Accepted Answer

Output-10
-8
-6
-4
-2
ExplanationThe for loop generates a sequence of numbers starting from -10, stopping before 0 (i.e., 2), and incrementing by 2 each time, resulting in the sequence -10, -8, -6, -4, -2.

Question 13

Question 21Differentiate between cloud computing and grid computing?

Accepted Answer

Cloud ComputingGrid ComputingCloud computing is used for virtualization of servers, where one server computes several tasks or services concurrently.Grid computing allocates multiple servers onto a single application.It supports long-running services (Service Oriented).It is typically used for job execution, where a program runs for a limited time (Application-Oriented).Cloud computing is used for multiple services.Grid computing is used for a single application.Its computation service is on-demand.Its computation service provides maximum computing power for one application.It involves virtualization of hardware, software, and storage platforms.It involves virtualization of data and computing resources.Examples : GoogleDrive, OneDrive, Mobile Office Applications (e.g., Office 365, Google Docs), SharePoint, Microsoft Azure, iCloud, AWS etc.Examples : GridGain, JPPF, JBossCache, EhCache etc.

Question 14

Question 23What will be the output of the following code?Country=["India", "Australia", "USA", "China", "Russia", "Ukraine" ]  
print(Country[2:5])  
print(Country[-5:-2])

Accepted Answer

Output['USA', 'China', 'Russia']
['Australia', 'USA', 'China']
ExplanationIn the given Python code, Country[2:5] returns ["USA", "China", "Russia"], slicing from index 2 up to index 4. Then, Country[-5:-2] retrieves a sublist starting from index -5 up to index -3. This results in ["Australia", "USA", "China"].The indexing table is:ElementPositive IndexNegative Index"India"0-6"Australia"1-5"USA"2-4"China"3-3"Russia"4-2"Ukraine"5-1

Question 15

Question 29Rohit, a Librarian has created a Table Book with the following fields:Bookid, Bookname, Author and Price. He has entered 20 records in the table.Which command should he use to do the following:(i) To change the price of Computer Science book from 450 to 500.(ii) To insert Primary Key in the table.(iii) What is the difference between delete and drop command.

Accepted Answer

(i)UPDATE Book
SET Price = 500
WHERE Bookname = 'Computer Science' AND Price = 450;(ii)ALTER TABLE Book
ADD CONSTRAINT pk_Bookid PRIMARY KEY (Bookid);(iii) DELETE command is used to remove all the contents from the table, leaving it empty. On the other hand, the DROP command is used to delete the table from the database along with all its data and structure.

Question 16

Question 30The data type list is an ordered sequence which is mutable and made up of one or more elements. Unlike a string which consists of only characters, a list can have elements of different data types such as integer, float, string, tuple or even another list. A list is very useful to group elements of mixed data types. Elements of a list are enclosed in square brackets and are separated by comma.(i) How is a list different from a dictionary?(ii) Find the values of y and z after execution:x=[2, 3]
y=[30, 40]
z=[88, 99]
y.extend(x)
z.append(x)
print (y)
print (z)

Accepted Answer

(i) A list in Python is an ordered collection of elements that can be accessed by their index. In contrast, a dictionary is an unordered collection of key-value pairs, where values are accessed using unique keys. Elements of a list are enclosed in square brackets and are separated by comma while dictionaries are enclosed in curly brackets, with keys and values separated by colons and key-value pairs separated by commas.(ii)Output[30, 40, 2, 3]
[88, 99, [2, 3]]
Explanationy.extend(x) modifies the list y by adding the elements of x to the end of y. So, y becomes [30, 40, 2, 3].z.append(x) adds the entire list x as a single element to the end of z. So, z becomes [88, 99, [2, 3]].

Question 17

Question 33(i)Find out the errors in the following code snippet and rewrite the code by underlining the corrections made.30=y
for i in range (2, 6)
    print (true)
else:
print ("Loop over")

Accepted Answer

30=y #Error 1
for i in range (2, 6) #Error 2
    print(true) #Error 3
else:
print ("Loop over") #Error 4Error 1 — This is an invalid assignment statement. The variable should be on the left side.Error 2 — The for loop header is missing a colon at the end.Error 3 — 'true' should be 'True' to be a valid boolean value in Python.Error 4 — The else block is not properly indented.The corrected code is:y = 30
for i in range(2, 6):
    print(True)
else:
    print("Loop over")

Question 18

Question 34Consider the following table BANK. Write commands of SQL for (i) to (v):Table: BANKAcct_NoAcct_HolderAcct_typeOpening_BalContact_no11001AtulSaving5000921624583311002ManshaCurrent10000946661567511003RahulCurrent2000941682201211004MehakSavingNULL780563405611005AkshayFixed Deposit500008732216155(i) Show the details of AccountHolders who have opened a Current Account.(ii) Display the Account Holder and Contact No. of those who have not deposited any opening balance.(iii) Display the unique Account type available in the table Bank.(iv) Display all the details of those Accounts whose Account Holder name’s 2nd character is "a".(v) Add a new record with the following data.11006, "Tamanna", "Fixed", 70000, 9255617800

Accepted Answer

Practice Paper

Section A 1 Mark Each

Section B 2 Marks Each

Section C 3 Marks Each

Section E 5 Marks Each