List of top Informatics Practice Questions

Consider the DataFrame Doctor shown below:

Write suitable Python statements for the following:
(i) To print the last three rows of the DataFrame Doctor.
(ii) To display the names of all doctors.
(iii) To add a new column 'Discount' with value of 200 for all doctors.
(iv) To display rows with index 2 and 3.
(v) To delete the column 'Department'.

XYZ Technologies, Hyderabad is a company that deals with data science and AI projects. They have different divisions: ADMIN, SALES, PRODUCTION and SERVICE. The layout of the Hyderabad branch is:

The management wants to connect all the devisions as well as the computers of each devision (ADMIN, SALES, PRODUCTION and SERVICE.

Based on the above specifications, answer the following questions:
(i) Suggest the topology and draw the most suitable cable layout for connecting all the divisions in the Hyderabad office.
(ii) XYZ Technologies is having its head office in the USA. Out of LAN, MAN and WAN, which kind of network will be created to connect Hyderabad office with USA Office? Justify your answer.
(iii) Suggest the division for the placement of server. Explain the reason for your selection.
(iv) Suggest the placement of Switch/Hub with justification.
(v) Where will a repeater be placed in the suggested network layout? Justify your answer.

Ashutosh, who is a manager, has created a database to manage employee records. The database includes a table named EMPLOYEE whose attribute names are mentioned below:
EID : Stores the unique ID for each employee.
EMP_NAME : Stores the name of the employee.
DEPT : Stores the department of the employee.
SALARY : Stores the salary of the employee.
JOIN_DATE : Stores the employee’s joining date.

Write the output of the following SQL Queries:
(i) SELECT SUBSTRING(EMP_NAME, 1, 5) FROM EMPLOYEE WHERE DEPT = 'ENGINEERING';
(ii) SELECT EMP_NAME FROM EMPLOYEE WHERE MONTH(JOIN_DATE) = 8;
(iii) SELECT EMP_NAME FROM EMPLOYEE WHERE SALARY>60000;
(iv) SELECT COUNT(DEPT) FROM EMPLOYEE;

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.

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

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.

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 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

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)

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.

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(_______)

Give any two impacts on environment that are caused when e-waste is carelessly thrown or dumped in landfills or dumping grounds.

What is a Database Management System (DBMS)? Mention any two examples of DBMS.

Describe the role of a router in a network.

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.

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.

Give any two points of difference between Static web page and Dynamic web page.

Assertion (A) : The ROUND() function in SQL can be used to round off a number to a specified number of decimal places.
Reason (R) : The ROUND() function is a string function that accepts character values as input and returns numerical values as output.