STUDENT
INFORMATICS PRACTICES
Total Q: 21
Time: 21 Mins
Q 1.
The practice of taking someone else's work or ideas and passing them off as one's own is known as _____________
Plagiarism
Copyright Violation
Copyright
Trademark Infringement
Q 2.
Consider the following data frame name df
Write the output of the given command:
print(df.marks/2)
Q 3.
Which of the following is not an aggregate function in MYSQL ?
AVG ()
MAX ()
LCASE ()
MIN ()
Q 4.
Temporary data files stored by websites in our computer can be used to track our online activities and also to personalize browsing experience. These files are known as:
Plug-ins
Add-ons
Cookies
Bookmarks
Q 5.
e-waste refers to:
Software that has become obsolete
Data that has been deleted from a storage device
Viruses that infect computers
Electronic devices that are no longer in use
Q 6.
We can analyse the data in pandas with
Series
Data Frame
Both Series and DataFrame
None of these
Q 7.
What is the type of network for long distance communication ?
LAN
MAN
PAN
WAN
Q 8.
Which one of the following would arrange the rows in ascending order in SQL ?
SORT BY
ALIGN BY
GROUP BY
ORDER BY
Q 9.
___ serves as the entry and exit point of a network
Router
Firewall
Gateway
Switch
Q 10.
Which type of values will not be considered by SQL while executing the following statement?
SELECT COUNT(column name) FROM inventory;
Numeric value
text value
Null value
Date value
Q 11.
Assertion (A) : Hacking is a cyber crime.
Reason (R) : To avoid hacking, one should not share the password with anyone.
Both Assertion (A) and Reason (R) are true and Reason (R) is the correct explanation of Assertion (A).
Both Assertion (A) and Reason (R) are true, but Reason (R) is not the correct explanation of Assertion (A).
Assertion (A) is true, but Reason (R) is false.
Assertion (A) is false, but Reason (R) is true.
Q 12.
Which of the following statement will import pandas library?
Import pandas as pd
import Pandas as py
import pandas as pd
import panda as pd
Q 13.
Predict the output of the following query:
SELECT LCASE (MONTHNAME ('2023-03-05'));
May
March
may
march
Q 14.
Which of the following Python statements is used to import data from a CSV file into a Pandas DataFrame (Note: pd is an alias for pandas)?
pd.open_csv('filename.csv')
pd.read_csv('filename.csv')
pd.load_csv('filename.csv')
pd.import_csv('filename.csv')
Q 15.
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 16.
Which of the following is a DBMS?
MS Word
MySQL
Python
SQL
Q 17.
Pandas Series is:
2 Dimensional
3 Dimensional
1 Dimensional
Multidimensional
Q 18.
Which one of the following functions is used to find the largest value from the given data in MySQL?
MAX( )
MAXIMUM( )
BIG( )
LARGE( )
Q 19.
Fill in the Blank:
When we create Dataframe from dictionary of Series, then number of columns in DataFrame is equal to the ___________ .
Number indexes in the Series
Number of keys in the dictionary
Maximum number data values in the series
None of these
Q 20.
State whether the following statement is True or False:
We can add a row in DataFrame using iloc.
True
False
-
-
Q 21.
On the basis of the dataframe DF, which command will add a new column with name of student 'Prem' in the dataframe
DF['Prem']=[89,78,76]
df['Prem']=[89,78,76]
DF['Prem']=[89,78,76,67]
DF['Name']=[89,78,76]