# Science (English Medium) Class 12 - CBSE Question Bank Solutions for Informatics Practices

Subjects
Topics
Subjects
Popular subjects
Topics
Informatics Practices
< prev  1 to 20 of 52  next >

Mention any four networking goals.

[0.05] Internet and Web
Chapter: [0.05] Internet and Web
Concept: Introduction to Computer Networks

Write a Python code to create a DataFrame with appropriate column headings from the list given below:

[[101,'Gurman',98], [102,'Rajveer',95], [103,'Samar' ,96], [104,'Yuvraj',88]]

[0.02] Data Handling using Pandas - I
Chapter: [0.02] Data Handling using Pandas - I
Concept: Introduction to Python Libraries

The television cable network is an example of ______

[0.05] Internet and Web
Chapter: [0.05] Internet and Web
Concept: Types of Computer Networks

Which type of values will not be considered by SQL while executing the following statement?

SELECT COUNT(column name) FROM inventory;

[0.01] Querying and SQL Functions
Chapter: [0.01] Querying and SQL Functions
Concept: Functions in SQL

If column “Fees” contains the data set (5000,8000,7500,5000,8000), what will be the output after the execution of the given query?

SELECT SUM (DISTINCT Fees) FROM student;

[0.01] Querying and SQL Functions
Chapter: [0.01] Querying and SQL Functions
Concept: Functions in SQL

Which one of the following is not an aggregate function?

[0.01] Querying and SQL Functions
Chapter: [0.01] Querying and SQL Functions
Concept: Functions in SQL

Which one of the following functions are used to find the largest value from the given data in MySQL?

[0.01] Querying and SQL Functions
Chapter: [0.01] Querying and SQL Functions
Concept: Functions in SQL

To display the last five rows of a series object ‘S’, you may write ______

[0.02] Data Handling using Pandas - I
Chapter: [0.02] Data Handling using Pandas - I
Concept: A Series

Which of the following statement will import pandas library?

[0.02] Data Handling using Pandas - I
Chapter: [0.02] Data Handling using Pandas - I
Concept: A Series

In SQL, which function is used to display the current date and time?

[0.01] Querying and SQL Functions
Chapter: [0.01] Querying and SQL Functions
Concept: Functions in SQL

______ is the trail of data we leave behind when we visit any website (or use any online application or portal) to fill in data or perform any transaction.

[0.06] Societal Impacts
Chapter: [0.06] Societal Impacts
Concept: Digital Footprints

Write a program to create a series of objects using a dictionary that stores the number of students in each house of class 12D of your school.

Note: Assume four house names are Beas, Chenab, Ravi, and Satluj having 18, 2, 20, and 18 students respectively and pandas library has been imported as pd.

[0.02] Data Handling using Pandas - I
Chapter: [0.02] Data Handling using Pandas - I
Concept: A Series

What will be the output of the following code:

>>>import pandas as pd
>>>A = pd.Series(data = [35, 45, 55, 40])
>>>print(A > 45)

[0.02] Data Handling using Pandas - I
Chapter: [0.02] Data Handling using Pandas - I
Concept: A Series

Write outputs for SQL queries that are based on the given table PURCHASE:

 TABLE: PURCHASE CNO CNAME CITY QUANTITY DOP C01 GURPREET NEW DELHI 150 2022-06-11 C02 MALIKA HYDERABAD 10 2022-02-19 C03 NADAR DALHOUSIE 100 2021-12-04 C04 SAHIB CHANDIGARH 50 2021-10-10 C05 MEHAK CHANDIGARH 15 2021-10-20
1. SELECT LENGTH(CNAME) FROM PURCHASE WHERE QUANTITY>100;
2. SELECT CNAME FROM PURCHASE WHERE MONTH(DOP) = 3;
3. SELECT MOD (QUANTITY, DAY(DOP)) FROM PURCHASE WHERE CITY = ‘CHANDIGARH’;
[0.01] Querying and SQL Functions
Chapter: [0.01] Querying and SQL Functions
Concept: Functions in SQL

Based on the table STUDENT given here, write suitable SQL queries for the following:

 Roll No Name Class Gender City Marks 1 Abhishek XI M Agra 430 2 Prateek XII M Mumbai 440 3 Sneha XI F Agra 470 4 Nancy XII F Mumbai 492 5 Himanshu XII M Delhi 360 6 Anchal XI F Dubai 256 7 Mehar X F Moscow 324 8 Nishant X M Moscow 429
1. Display gender-wise highest marks.
2. Display city-wise lowest marks.
3. Display the total number of male and female students.
[0.01] Querying and SQL Functions
Chapter: [0.01] Querying and SQL Functions
Concept: Functions in SQL

Write suitable SQL query for the following:

Display 7 characters extracted from the 7th left character onwards from the string ‘INDIA SHINING’.

[0.01] Querying and SQL Functions
Chapter: [0.01] Querying and SQL Functions
Concept: Functions in SQL

Write suitable SQL query for the following:

Display the position of occurrence of the string ‘COME’ in the string ‘WELCOME WORLD’.

[0.01] Querying and SQL Functions
Chapter: [0.01] Querying and SQL Functions
Concept: Functions in SQL

Write suitable SQL query for the following:

Round off the value 23.78 to one decimal place.

[0.01] Querying and SQL Functions
Chapter: [0.01] Querying and SQL Functions
Concept: Functions in SQL

Write suitable SQL query for the following:

Display the remainder of 100 divided by 9.

[0.01] Querying and SQL Functions
Chapter: [0.01] Querying and SQL Functions
Concept: Functions in SQL

Write suitable SQL query for the following:

Remove all the expected leading and trailing spaces from a column userid of the table ‘USERS’.

[0.01] Querying and SQL Functions
Chapter: [0.01] Querying and SQL Functions
Concept: Functions in SQL
< prev  1 to 20 of 52  next >