Sikkim Cbse Class 12 Informatics Practices — Real Previous-Year Papers

Rohini has developed a new kind of water purifier that uses a unique filtration method. Which type of Intellectual Property Right should she apply to protect her invention ? (A) Trademark (B) Copyright (C) Patent (D) Both Copyright Trademark

Aditya is working on a DataFrame named df. He has written the statement : print(df.loc['S2']) What will the above statement do ? (A) Display the data of the row having label 'S2'. (B) Display the columns of the DataFrame. (C) Display the data type of the column having label 'S2'. (D) Display the index numbers of the DataFrame.

What will be the result of the following SQL command ? SELECT LENGTH ('Data Base'); (Note : There is single space between the words Data and Base.) (A) 7 (B) 8 (C) 9 (D) Error

Which of the following is a key feature of a Static Web Page ? (A) Its content updates very frequently. (B) It displays different content to different users. (C) It loads slower than a Dynamic Web Page. (D) It shows the same content unless the code is manually updated.

Which of the following is the correct expanded form of DML ? (A) Device Management Language (B) Device Manipulation Language (C) Data Management Language (D) Data Manipulation Language

CSV stands for ___ Separated Values. (A) Colon (B) CTRL (C) Comma (D) Caret

Which of the following is an example of maintaining good net etiquette ? (A) Spamming emails or messages to strangers. (B) Ignoring other's opinions in online discussions. (C) Not using copyrighted materials without permission of the owner. (D) Sharing someone's private information publicly.

In the context of creating a Pandas Series from a dictionary, which of the following statement is correct ? (A) The values of the dictionary become the indices of the Series. (B) The keys of the dictionary become the values of the Series. (C) The keys of the dictionary become the indices of the Series. (D) The Series will have default integer indices starting from 0, ignoring the dictionary keys.

In Pandas, when extracting a portion of a Series ser1 using ser1[start:end] with positional indices start and end, which of the following statements is true ? (A) The element at the end index is included in the output. (B) The element at the end index is excluded from the output. (C) The elements at both the start and end indices are excluded from the output. (D) The element at the start index is excluded from the output.

Nisha is using an Android app to make a voice call over the internet to her friend in another country. Which protocol is being used in this case ? (A) Chat (B) VoIP (C) Email (D) TV

State whether the following statement is True or False : The INSTR(string1, string2) function in SQL returns 0 if string2 is not present as a substring in string1.

In a Pandas DataFrame, which value for axis will be used to delete a column ? (A) axis = -1 (B) axis = 0 (C) axis = 1 (D) axis = 2

What will be the result of the following SQL command ? SELECT ROUND(15.678, 2); (A) 15.00 (B) 15.67 (C) 15.68 (D) 16.00

Q. 20 and Q. 21 are Assertion (A) and Reason (R) Type questions. Choose the correct option as : (A) Both (A) and (R) are True, and (R) correctly explains (A). (B) Both (A) and (R) are True, but (R) does not correctly explain (A). (C) (A) is True, but (R) is False. (D) (A) is False, but (R) is True. Assertion (A) : Pandas DataFrame can store values of multiple data types in multiple Columns. Reason (R) : DataFrames are implemented using 2D arrays, which allows only numeric values.

Q. 20 and Q. 21 are Assertion (A) and Reason (R) Type questions. Choose the correct option as : (A) Both (A) and (R) are True, and (R) correctly explains (A). (B) Both (A) and (R) are True, but (R) does not correctly explain (A). (C) (A) is True, but (R) is False. (D) (A) is False, but (R) is True. Assertion (A) : The output of the SQL query SELECT COUNT (name) FROM students; will differ from the output of SELECT COUNT (*) FROM students; if there are some NULL values in the name column. Reason (R) : COUNT(columnₙame) returns the count of NON NULL values in that column, whereas COUNT(*) returns the number of records in the table.

(a) List any two characteristics of Pandas library in Python. OR (b) Briefly explain the purpose of Boolean Indexing with respect to DataFrames. Support your answer with a suitable example.

Anjana had created a website using free design elements sourced from different creators online. She then published the site for public access but did not mention the source of the design elements used. (i) Identify one possible violation of IPR in this situation. (ii) Name any two licensing models that allow legal reuse of digital creative work with conditions.

Define the following terms with respect to RDBMS : a. Domain b. Tuple

(a) Explain the role of the following network devices in a network : (I) Modem (II) Gateway OR (b) Differentiate between add-ons and plug-ins in a web browser.

Write SQL queries to perform the following : (I) Display the month (in numeric form) of the date '2026-01-01'. (II) Display only the year part from the date '2026-01-01'.

(a) What is data protection ? (b) Mention any two precautionary measures one can take to avoid the risk of cybercrime.

(a) Niharika wants to create a Pandas Series using a NumPy array with three elements 'a', 'b', and 'c', and assign custom indexes 'first', 'second' and 'third'. Help her complete the code below. import pandas as pd import ___ as np arr = np.___ (['a' , 'b' , 'c']) s = pd.___(arr,___=['first','second','third']) print(s) OR (b) Write the output of the following code : import pandas as pd s1 = pd.Series ([1, 2, 3], index = ['a','b','c']) s2 = pd.Series ([4, 5, 6], index = ['b','c','d']) print(s1 + S2)

Mandeep received an email stating he won a lottery though he had never participated in any such event. He was asked to provide bank details to process the amount. Mandeep provided the required details but within next few minutes ₹ One lakh was debited from his account. Answer the following questions based on the given case study : (i) Mandeep is the victim of which type of cybercrime ? (ii) Other than email, mention any two common methods through which this type of cybercrime is being committed these days. (iii) Name one law that safeguards the rights of Internet users in India.

(a) Write a Python program to create and display a Pandas Series as shown below : July 31 Aug 31 Sept 30 Oct 31 The index labels are the names of the months – July, Aug, Sept, Oct. The corresponding scalar values are the number of days in these respective months – 31, 31, 30, 31. OR (b) A CSV file named customer.csv contains records of customers. The first row of the file represents the header. Sample data from the file is shown below : Name, Age, City Rudra,17,Kolkata Divya,19,Dehradun Nabeel,22,Lucknow Write a Python program to import data from the CSV file into a Pandas DataFrame named DF and display the last two rows.

(i) Write an SQL statement to create a table named PRODUCTS with the following specifications : | Column Name | Data Type | Key | | --- | --- | --- | | PID | Integer | Primary Key | | PName | Varchar of size 30 | | | PCat | Char of size 15 | | | Price | Decimal Number | | (ii) Write an SQL query to increase the price of all items by 100, whose product category is Grocery, in the table PRODUCTS.

(a) Consider the following tables : Table 1 : TEACHER, which stores Teacher ID (TID), Teacher Name (TName), Experience (Experience) and City (City) that they live in. | TID | TName | Experience | City | | --- | --- | --- | --- | | 1 | Kartik | 5 | Bhopal | | 2 | Shahnaz | 6 | Nagpur | | 3 | Rajendra | 7 | Delhi | | 4 | Tanvi | 4 | Bhopal | | 5 | Alam | 9 | Delhi | Table 2 : SUBJECT, which stores Subject ID (SID), Subject Name (SubName) and ID of the teacher(TID) teaching that Subject. | SID | SubName | TID | | --- | --- | --- | | 101 | Physics | 1 | | 102 | Chemistry | 2 | | 103 | Mathematics | 3 | | 104 | Informatics Practices | 4 | | 105 | Computer Science | 5 | Write appropriate SQL query for the following : (I) Delete the record of the subject whose TID is equal to 4. (II) Display the names of teachers who have more than 5 years of experience and who stay in Nagpur. (III) Display subject names along with their teacher names. OR (b) Consider the table LIBRARY as given below. | BookId | Title | Genre | Price | | --- | --- | --- | --- | | 101 | Python Basics | Technology | 278 | | 201 | The Silent Patient | Fiction | 340 | | 301 | Data Science | Technology | 291 | | 401 | Oceans | Marine Life | NULL | (I) Which attribute(s) can be considered as the Candidate keys(s) ? Justify your answer. (II) Write an SQL query to insert a new record with the following values : BookId : 501 Title : AI for ALL Genre : Technology Price : 589 (III) Write an SQL query to add a new column Author that is a character data type of size 20.

Ms. Anjali, a data analyst, has been assigned the task of creating a histogram to display the age distribution of ten participants in a workshop. She has been provided with the following list of their ages : Ages = [22, 25, 24, 28, 30, 24, 29, 27, 21, 23] She has started writing a Python program for it. However, the code is incomplete. Help her complete the program by filling in the missing parts, so that the histogram as shown below is displayed. [Histogram figure titled "Age Distribution"; x-axis "Age" (20 to 30, bins of width 2), y-axis "Number of Participants" (0.0 to 3.0); legend labelled "Participants"; bar heights: 20-22 = 1, 22-24 = 2, 24-26 = 3, 26-28 = 1, 28-30 = 3] import matplotlib.pyplot as plt Ages = [22, 25, 24, 28, 30, 24, 29, 27, 21, 23] binsize=[20,22,24,26,28,30] plt.____(Ages, bins=binsize, edgecolor = 'black', label = 'Participants') # Statement-1 ___.xlabel('Age') # Statement-2 plt.ylabel('Number of Participants') plt.title("Age Distribution") plt.____ # Statement-3 _____ # Statement-4 I. Write the suitable code for the blank space in the line marked as Statement-1 which plots the histogram. II. Fill in the blank in Statement-2 to use the correct alias of the required module to set the label on x axis. III. Fill in the blank in Statement-3 with the correct Python code to display the legend on the graph. IV. Fill in the blank in Statement-4 with the appropriate Python code to display the graph.

(a) Shalini, who works as a database designer in the hotel industry, has created a table named Guest to keep track of guest details as shown below : Table : Guest | GuestID | GuestName | RoomNumber | CheckInDate | Charges | | --- | --- | --- | --- | --- | | G101 | Harish | 101 | 2025-04-03 | 3000 | | G102 | Sunita | 101 | 2025-04-03 | 3000 | | G103 | Ramesh | 102 | 2025-05-04 | 5000 | | G104 | Bhumika | 103 | 2025-06-02 | 3500 | Write a suitable SQL query for the following : I. Display last 3 characters of guest name in upper case. II. Display the name of the guest along with the day name of check-in date. III. Display the remainder when charges are divided by 1000. IV. Extract and display three characters, starting from the second character, of each guest name. OR (b) Consider the following table and write the output of the following SQL Queries. Table : ORDERS | ORDERID | CUSTOMERNAME | TOTALAMOUNT | DISCOUNT | ORDERDATE | | --- | --- | --- | --- | --- | | 101 | Hemant | 5000 | 10 | 2024-03-01 | | 102 | Neha | 7000 | 15 | NULL | | 103 | Keshav | 3000 | 5 | 2024-01-20 | | 104 | Sandhya | 4500 | NULL | 2023-12-25 | Write the output of the following SQL Queries : I. SELECT CUSTOMERNAME FROM ORDERS WHERE DISCOUNT IS NOT NULL; II. SELECT CUSTOMERNAME, DISCOUNT FROM ORDERS WHERE DISCOUNT BETWEEN 5 AND 10; III. SELECT MONTHNAME(ORDERDATE) FROM ORDERS WHERE ORDERDATE IS NOT NULL; IV. SELECT ORDERID, DAY(ORDERDATE) FROM ORDERS;

My Solutions Pvt. Ltd. is a reputed software development and IT consulting firm. The company's head office is located in Mysuru, and it has a regional office in Chennai. The Mysuru office comprises four departments: Human Resources, Research, Design and Technical Support. [Layout diagram: Mysuru Head Office block containing four departments — Human Resources, Research, Design, Technical Support — and a separate Chennai Regional Office.] The distances between these departments and between Mysuru and Chennai are as follows : | | | | --- | --- | | Human Resources to Research | 55 metres | | Human Resources to Design | 75 metres | | Human Resources to Technical Support | 140 metres | | Research to Design | 40 metres | | Research to Technical Support | 80 metres | | Design to Technical Support | 60 metres | | Mysuru Office to Chennai Office | 350 kilometres | The number of computers in each department/office is as follows : | | | | --- | --- | | Human Resources | 30 | | Research | 80 | | Design | 50 | | Technical Support | 20 | | Chennai Office | 35 | As a network engineer, you have to propose solutions for various queries listed from I to V. I. Identify the most suitable department to install the main server in the Mysuru office. Justify your answer with a valid reason. II. Create a cable layout design to establish Wired network connectivity between the departments in the Mysuru Office. III. Suggest the appropriate network device to connect multiple computers within the Research department. IV. What type of network (LAN, MAN, WAN) would best connect the Mysuru and Chennai office ? V. Which device should be used if the signal strength weakens while transmitting data between the Human Resources and Technical Support departments due to the long distance between them ?

Consider the DataFrame Scholarship shown below : (3 + 1 + 1 = 5) Name Course Amount 0 Ananya B.Sc. 62000 1 Karan B.Tech 67000 2 Simran MCA 64000 3 Rahul BCA 70000 4 Priya BA 69000 Answer the following questions : I. Write Python code to create and display the given DataFrame using the Dictionary of Series method. II. Rename row indexes to ['a', 'b', 'c', 'd', 'e'] III. Write Python statement to remove the last row of the given DataFrame

(a) Write suitable SQL query for the following : I. To display only the date part from the date/time expression '2026-01-01 10:10:10' II. To convert all customer names from the CustName column to lowercase in the Customer table. III. To extract the first 4 characters from the CityName column in Location table. IV. To display the name of the city from the CITY column in EVENT table, after removing leading spaces. V. To find the average salary from Salary column in Employees table. OR (b) Write suitable SQL query for the following : I. To display the value of 17² . II. To display the day part of the dates in the HireDate column of the Employee table. III. To display the maximum value of the BillAmount column in the Bill table. IV. To remove leading and trailing spaces from the Location column in the Branch table. V. To display total salary from totsal column in Employees table.