CBSE Class 12 Informatics Practices Practice Test

Q 1.

The Metropolitan Area Network have range of ______

10-20 kms 20-30 kms 30-40 kms 40-50 kms

Q 2.

Companies get their Trademark registered to protect?

Logos, names and brands Word, phrases or symbol slogans, stylized fonts, and colors Company furniture, worker, brands

Q 3.

Which of the following Python statements will be used to select a specific element having index as points, from a Pandas Series named ser?

ser.element(points) ser.select(points) ser[points] ser.show[points]

Q 4.

What is a tuple in SQL?

A type of SQL command for updating data A single row of a table A function used to sort data A constraint applied to primary keys

Q 5.

Which of the following is a DBMS?

Oracle MS PowerPoint MS Excel WhatsApp

Q 6.

Which Matplotlib plot is best suited to represent changes in data over time?

Bar plot Histogram Line plot Histogram & Bar plot

Q 7.

A __________ is a network device that can receive the data, analyse it and transmit it to other networks.

Modem Switch Repeater Router

Q 8.

Ramandeep is a young woman with great aspirations and has a good team of like-minded people. She along with her team members started a company to sell handicrafts online and also designed a logo for their company. What type of intellectual property does this logo represent?

Patents Copyright Design Trademark

Q 9.

'O' in FOSS stands for:

Outsource Open Original Outstanding

Q 10.

Method or function to add a new row in a data frame is:

.loc[ ] .iloc[ ] join add()

Q 11.

To prevent unauthorized access to and / or from the network, a system known as ____________, can be implemented by hardware and / or software.

Firewall Router Modem Repeater

Q 12.

Which of the following is a DBMS?

PostgreSQL Microsoft Word TikTok FileZilla

Q 13.

Which of the following command will not show first five rows from the Pandas series named S1 ?

S1[0: 5] S1.head() S1.head(5) S1.head[0:5]

Q 14.

Predict the output of the following query:
SELECT MOD (9,0);

0 NULL NaN 9

Q 15.

Which of the following is a category of DML (Data Manipulation Language)?

DROP ALTER INSERT GRANT

Q 16.

Ritika is a new learner for the python pandas, and she is aware of some concepts of python. She has created some lists, but is unable to create the data frame from the same. Help her by identifying the statement which will create the data frame.
import pandas as pd
Name=['Manpreet','Kavil','Manu','Ria']
Phy=[70,60,76,89]
Chem=[30,70,50,65]

df=pd.DataFrame({"Name":Name,"Phy":Phy,"Chem":Chem}) d=("Name":Name,"Phy":Phy,"Chem":Chem)
df=pd.DataFrame(d) df=pd.DataFrame([Name,Phy,Chem],columns=['Name',"Phy","Chem","Total"]) df=pd.DataFrame({Name:"Name", Phy :"Phy",Chem: "Chem"})

Q 17.

What will be the output of the following SQL command?
SELECT MONTHNAME('2024-08-02');

08 02 February August

Q 18.

Fill in the Blank
Boolean indexing in Pandas DataFrame can be used for _______.

Creating a new DataFrame Sorting data based on index labels Joining data using labels Filtering data based on condition

Q 19.

Write the output of the given command:
df1.loc[:0,'Sal']
Consider the given dataframe.

0 Kavita 50000 3000 50000 3000 55000

Q 20.

In Python Pandas, DataFrame._____[] is used for label indexing with DataFrames.

label index labindex loc

Q 21.

The command used to give a heading to a graph is _________

plt.show() plt.plot() plt.xlabel() plt.title()

Q 1.

The Metropolitan Area Network have range of ______

Q 2.

Companies get their Trademark registered to protect?

Q 3.

Which of the following Python statements will be used to select a specific element having index as points, from a Pandas Series named ser?

Q 4.

What is a tuple in SQL?

Q 5.

Which of the following is a DBMS?

Q 6.

Which Matplotlib plot is best suited to represent changes in data over time?

Q 7.

A __________ is a network device that can receive the data, analyse it and transmit it to other networks.

Q 8.

Ramandeep is a young woman with great aspirations and has a good team of like-minded people. She along with her team members started a company to sell handicrafts online and also designed a logo for their company. What type of intellectual property does this logo represent?

Q 9.

'O' in FOSS stands for:

Q 10.

Method or function to add a new row in a data frame is:

Q 11.

To prevent unauthorized access to and / or from the network, a system known as ____________, can be implemented by hardware and / or software.

Q 12.

Which of the following is a DBMS?

Q 13.

Which of the following command will not show first five rows from the Pandas series named S1 ?

Q 14.

Predict the output of the following query: SELECT MOD (9,0);

Q 15.

Which of the following is a category of DML (Data Manipulation Language)?

Q 16.

Q 17.

What will be the output of the following SQL command? SELECT MONTHNAME('2024-08-02');

Q 18.

Fill in the Blank Boolean indexing in Pandas DataFrame can be used for _______.

Q 19.

Write the output of the given command: df1.loc[:0,'Sal'] Consider the given dataframe.

Q 20.

In Python Pandas, DataFrame._____[] is used for label indexing with DataFrames.

Q 21.

The command used to give a heading to a graph is _________

Predict the output of the following query:
SELECT MOD (9,0);

What will be the output of the following SQL command?
SELECT MONTHNAME('2024-08-02');

Fill in the Blank
Boolean indexing in Pandas DataFrame can be used for _______.

Write the output of the given command:
df1.loc[:0,'Sal']
Consider the given dataframe.