List of top Questions asked in CBSE CLASS XII

An educational institution is maintaining a database for storing the details of courses being offered. The database includes a table COURSE with the following attributes:
C_ID : Stores the unique ID for each course.
C_NAME : Stores the course’s name.
INSTRUCTOR : Stores the name of the course instructor.
DURATION : Stores the duration of the course in hours.

Write SQL queries for the following:
(i) To add a new record with following specifications: 
C_ID : C106 
C_NAME : Introduction to AI 
INSTRUCTOR : Ms. Preeti 
DURATION : 55 
(ii) To display the longest duration among all courses.
(iii) To count total number of courses run by the institution.
(iv) To display the instructors’ name in lower case.
 

Gurkirat has to fill in the blanks in the given Python program that generates a line plot as shown below. The given line plot represents the temperature (in degree Celsius) over five days as given in the table:

Write the missing statements according to the given specifications:
(i) Write the suitable code to import the required module in the blank space in the line marked as Statement-1.
(ii) Fill in the blank in Statement-2 with a suitable Python function name to create a line plot.
(iii) Refer to the graph shown and fill in the blank in Statement-3 to display the appropriate label for x-axis.
(iv) Refer to the graph shown and fill in the blank in Statement-4 to display the suitable chart title.
 

Consider the following tables:

Write SQL queries for the following:
(i) To delete those records from table SALES whose UnitsSold is less than 80.
(ii) To display names of all products whose category is not known.
(iii) To display the product names along with their corresponding units sold.
 

Given the following tables:

Write SQL queries for the following:
(i) To display the number of students from each city.
(ii) To find the average age of all students.
(iii) To list the names of students and their grades.
 

(i) Write the SQL statement to create a table, Customer with the following specifications:

(ii) Write the SQL query to display all records in descending order of LName from the Table Customer.
 

Find: \[ \int \frac{2x}{(x^2 + 3)(x^2 - 5)} \, dx \]

With respect to SQL, match the function given in column-II with categories given in column-I :

Write SQL query for the following:
(i) To display sum total of all the values of the Score column, from STUDENTS table.
(ii) To display the first five characters of the Name column from STUDENTS table.
(iii) To display the values of Name column from the STUDENTS table, after removing the trailing spaces.
(iv) To retrieve the lowest score from the Score column of GRADES table.
(v) To increase the fee of all students by 100, in the STUDENTS table. (The name of the column is FEE)
Write SQL queries for the following:
(i) To calculate the square of 15.
(ii) To round the number 456.789 to the nearest integer.
(iii) To display the position of first occurrence of 'com' in the string 'mycommercial.com'.
(iv) To display the name of the day for the date '2024-11-07'.
(v) To display the current date and time.
Rohit is trying to create a Pandas Series from scalar values. His code has some mistakes. Rewrite the correct code and mention the corrections made.
Given code with mistakes:
import pandas

data = [50, 15, 40]

series = pd.series(data, Index=['x', 'y', 'z'])

Print(series)

Complete the given Python code to generate the following output:
Expected output:
   COLOUR  NAME  QTY
0     Red  Apple   10
1    Blue  Berry   15
2   Green  Guava   20

Given incomplete code:
import _______ as pd
data = [
    {'COLOUR': 'Red', 'NAME': 'Apple', 'QTY': 10},
    {'COLOUR': 'Blue', 'NAME': 'Berry', 'QTY': 15},
    {_______, 'NAME': 'Guava', 'QTY': 20}
]
df = pd.DataFrame(_______)
print(_______)

Ravi is a student studying in grade 12. He frequently uses the internet for various activities such as social networking, online shopping, and to research for school projects. Recently, he noticed that he receives targeted advertisements based on his browsing history and is concerned about his digital footprint. Additionally, Ravi has encountered instances of cyberbullying and is unsure how to handle them. Help Ravi by answering the following questions:
(i) What are digital footprints, and how are they created?
(ii) Write any two net etiquettes that Ravi should follow to ensure respectful and responsible online behavior.
(iii) How can Ravi protect himself from cyberbullying? Mention any one protective measure.
Write a Python program to create the following DataFrame using a Dictionary of Series:
Expected DataFrame:
   City         State
0  Mumbai       Maharashtra
1  Dehradun     Uttarakhand
2  Bengaluru    Karnataka
3  Hyderabad    Telangana

Write a Python program to create a Pandas Series as shown below from an ndarray containing the numbers 10, 20, 30, 40, 50 with corresponding indices 'A', 'B', 'C', 'D', 'E'.
Expected Series:
A    10
B    20
C    30
D    40
E    50
dtype: int64

Describe the role of a router in a network.
What is a Database Management System (DBMS)? Mention any two examples of DBMS.
Give any two impacts on environment that are caused when e-waste is carelessly thrown or dumped in landfills or dumping grounds.
Mention any two main points of difference between Series and DataFrame of Python Pandas.
Explain how we can access elements of a Series using slicing. Give an example to support your answer.
A small tech startup is considering using open source software to develop their new project management tool. They are evaluating the benefits and potential challenges of adopting open source solutions.
(i) Identify one key benefit of using open source software for the development of project management tool.
(ii) Give any two examples of open source software.
Consider the string "Informatics Practices". Write suitable SQL queries for the following :
(i) To convert the entire string to uppercase.
(ii) To display the total number of characters in the given string.
Give any two points of difference between Static web page and Dynamic web page.
In Python Pandas, DataFrame.......... [] is used for label indexing with DataFrames.
Every web page on the Internet has a unique address. This address is known as :
Assertion (A) : The drop() method in Pandas can be used to delete rows and columns from a DataFrame.
Reason (R) : The axis parameter in the drop() method specifies whether to delete rows (axis=0) or columns (axis=1).