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

Advertisements
Subjects
Topics
Subjects
Popular subjects
Topics
Advertisements
Advertisements
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

Advertisements

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 > 
Advertisements
Advertisements
CBSE Science (English Medium) Class 12 Question Bank Solutions
Question Bank Solutions for CBSE Science (English Medium) Class 12 Biology
Question Bank Solutions for CBSE Science (English Medium) Class 12 Chemistry
Question Bank Solutions for CBSE Science (English Medium) Class 12 Computer Science (C++)
Question Bank Solutions for CBSE Science (English Medium) Class 12 Computer Science (Python)
Question Bank Solutions for CBSE Science (English Medium) Class 12 English Core
Question Bank Solutions for CBSE Science (English Medium) Class 12 English Elective - NCERT
Question Bank Solutions for CBSE Science (English Medium) Class 12 Entrepreneurship
Question Bank Solutions for CBSE Science (English Medium) Class 12 Geography
Question Bank Solutions for CBSE Science (English Medium) Class 12 Hindi (Core)
Question Bank Solutions for CBSE Science (English Medium) Class 12 Hindi (Elective)
Question Bank Solutions for CBSE Science (English Medium) Class 12 History
Question Bank Solutions for CBSE Science (English Medium) Class 12 Informatics Practices
Question Bank Solutions for CBSE Science (English Medium) Class 12 Mathematics
Question Bank Solutions for CBSE Science (English Medium) Class 12 Physical Education
Question Bank Solutions for CBSE Science (English Medium) Class 12 Physics
Question Bank Solutions for CBSE Science (English Medium) Class 12 Political Science
Question Bank Solutions for CBSE Science (English Medium) Class 12 Psychology
Question Bank Solutions for CBSE Science (English Medium) Class 12 Sanskrit (Core)
Question Bank Solutions for CBSE Science (English Medium) Class 12 Sanskrit (Elective)
Question Bank Solutions for CBSE Science (English Medium) Class 12 Sociology
Share
Notifications



      Forgot password?
Use app×