CBSE CLASS XII · 2026–27

Computer subjects, practised one concept at a time.

Original ExamForge MCQs aligned to the current CBSE subject listing. Use them for concept practice; the latest CBSE syllabus, sample paper and marking scheme remain authoritative.

Informatics Practices (065)12 questions shown
01

IP-01 · Pandas SeriesWhich Pandas object represents one-dimensional labelled data?

+
  1. SeriesCorrect answer
  2. DataFrame
  3. IndexFrame
  4. ArrayTable

Explanation: A Pandas Series is a one-dimensional labelled array capable of storing values of a common or mixed compatible type.

02

IP-02 · DataFrameWhich attribute returns the number of rows and columns of a DataFrame?

+
  1. size
  2. shapeCorrect answer
  3. axes
  4. ndimensions

Explanation: The shape attribute returns a tuple containing the row count followed by the column count of the DataFrame.

03

IP-03 · Data selectionWhich accessor is primarily label-based in Pandas?

+
  1. iloc
  2. locCorrect answer
  3. iat only
  4. position

Explanation: The loc accessor selects rows and columns using labels, while iloc is intended for integer-position based selection.

04

IP-04 · Data importWhich function commonly reads a comma-separated file into a DataFrame?

+
  1. pd.read_csv()Correct answer
  2. pd.open_csv()
  3. pd.import_rows()
  4. pd.file_frame()

Explanation: The pandas read_csv function reads delimited text data and returns it as a DataFrame for further processing.

05

IP-05 · SQL aggregate functionsWhich SQL function returns the number of rows matching a query?

+
  1. TOTAL()
  2. NUMBER()
  3. COUNT()Correct answer
  4. ROWS()

Explanation: COUNT() is the SQL aggregate function used to count rows or non-null values selected by a query.

06

IP-06 · SQL groupingWhich clause filters groups after GROUP BY has been applied?

+
  1. WHERE
  2. HAVINGCorrect answer
  3. ORDER BY
  4. DISTINCT

Explanation: HAVING applies a condition to grouped results, whereas WHERE filters individual rows before grouping occurs.

07

IP-07 · SQL joinsWhich join returns only rows having matching values in both joined tables?

+
  1. INNER JOINCorrect answer
  2. LEFT JOIN
  3. CROSS JOIN
  4. FULL OUTER JOIN

Explanation: An INNER JOIN retains rows for which the specified join condition finds a match in both participating tables.

08

IP-08 · Data visualizationWhich Matplotlib function is most suitable for comparing values across categories?

+
  1. plot()
  2. bar()Correct answer
  3. hist()
  4. scatter()

Explanation: A bar chart represents each category with a rectangular bar, making categorical value comparison straightforward.

09

IP-09 · NetworksWhich protocol is used to securely transfer web pages through encrypted HTTP communication?

+
  1. FTP
  2. SMTP
  3. HTTPSCorrect answer
  4. POP3

Explanation: HTTPS combines HTTP communication with transport encryption to protect data exchanged between browser and server.

10

IP-10 · Societal impactsWhich practice best protects personal privacy on a public computer?

+
  1. Saving every password
  2. Leaving the session open
  3. Signing out and clearing sensitive session dataCorrect answer
  4. Sharing an OTP

Explanation: Signing out and removing sensitive session information reduces the chance that a later user can access the account.

11

IP-11 · Digital footprintWhat is a digital footprint?

+
  1. A computer's physical weight
  2. A trail of data created through online activityCorrect answer
  3. A printer setting
  4. A type of network cable

Explanation: A digital footprint is the data trail produced by online actions such as searches, posts, visits and account activity.

12

IP-12 · Intellectual propertyWhich protection generally applies to an original computer program as a creative work?

+
  1. CopyrightCorrect answer
  2. Traffic law
  3. Weather regulation
  4. Network topology

Explanation: Copyright generally protects the original expression contained in software code, subject to applicable law and exceptions.