STUDENT
INFORMATICS PRACTICES
Total Q: 21
Time: 21 Mins
Q 1.
To display last five rows of a series object 'S', you may write:
S.Head()
S.Tail(5)
S.Head(5)
S.tail()
Q 2.
Every web page on the Internet has a unique address. This address is known as:
Domain Name
Protocol
Uniform Resource Locator
Network Topology
Q 3.
GPL stands for
Guided Public License
General Public License
Global Public License
General Public Letter
Q 4.
What is a domain in SQL?
A web address used to connect databases
A set of allowable values for a column
The main server that hosts the database
A specific SQL keyword for joining tables
Q 5.
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 6.
Which of the following libraries defines an ndarray in Python?
pandas
numpy
matplotlib
scipy
Q 7.
What is the type of network for long distance communication ?
LAN
MAN
PAN
WAN
Q 8.
Which of the following function returns a string type value?
mod( )
instr( )
substr( )
month( )
Q 9.
Which one of the following would arrange the rows in ascending order in SQL ?
SORT BY
ALIGN BY
GROUP BY
ORDER BY
Q 10.
Consider the following data frame name df
Write the output of the given command:
print(df.marks/2)
Q 11.
Which of the following is a web browser ?
Microsoft Windows
Android
Microsoft Edge
Ubuntu
Q 12.
What can an individual do to enhance the privacy of data stored digitally?
Share sensitive information on social media platforms.
Use your date of birth as your password.
Regularly update software installed on your device.
Download and install software from unknown sources
Q 13.
In a DataFrame, Axis= 1 represents the_____________ elements.
Indexes
Rows
Columns
Attributes
Q 14.
The ____________command can be used to makes changes in the rows of a table in SQL.
Alter
Update
Insert
Modify
Q 15.
In Python Pandas, while performing mathematical operations on series, index matching is implemented and all missing values are filled in with _____by default.
Null
Blank
NaN
Zero
Q 16.
What is a relation in SQL?
A link between two databases
A type of user permission
A table in the database
A keyword used to filter records
Q 17.
Predict the output of the following query:
SELECT MOD (9,0);
0
NULL
NaN
9
Q 18.
While creating a Series using a dictionary, the keys of the dictionary become:
Values of the Series
Indices of the Series
Data type of the Series
Name of the Series
Q 19.
On the basis of the dataframe DF, which command will delete the row of science marks?
DF.drop('Science', axis=1)
DF.drop('Science', axis=0)
DF.drop('Science', axis=-1)
DF.drop('Science', axis==0)
Q 20.
What will be the output of the following program ?
import pandas as pd
x=6
S1=pd.Series(x,index=[1,2,4,6,8,9])
print(S1)
None of these
Q 21.
Which Python package is used for 2D graphics ?
matplotlib.pyplot
pyplot.lib
matplotlib.py
matplotlib.plt