STUDENT
INFORMATICS PRACTICES
Total Q: 21
Time: 21 Mins
Q 1.
For web pages where the information is changed frequently, for example, stock prices, weather information which out of the following options would you advise ?
Static web page
Dynamic web page
-
-
Q 2.
_______is the practice of taking someone else's work or ideas and passing them off as one's own:
Plagiarism
Copyright
Patent
All of these
Q 3.
CSV stands for:
Column Separated Value
Class Separated Value
Comma Separated Value
None of these
Q 4.
With reference to SQL, identify the invalid data type.
Date
Integer
Year
Month
Q 5.
State whether the following statement is True or False: The index of a Series must be unique.
True
False
-
-
Q 6.
In which topology each communicating device is connected with every other device in the network
Star
Bus
Tree
Mesh
Q 7.
Linux, MySQL and Mozilla Firefox software come under_______ category.
Proprietary
FOSS
Freeware
Shareware
Q 8.
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 9.
You were not able to create the IP project, therefore you downloaded a project from the internet and submitted it to your teacher by your name. This wrong/unethical act is considered as __________
Copyright
Hacking
Plagiarism
Trademark
Q 10.
Which of the following is not a network topology :
Star
Mesh
Tree
Bug
Q 11.
Which of the following Python statements is used to change a column label in a DataFrame, df?
df = df.rename({old_name : new_name}, axis='columns')
df = df.rename(old_name, new_name, axis='columns')
df = df.change_name(old_name, new_name, axis='bar')
df = df.update({old_name : new_name}, axis='bar')
Q 12.
Expand the term DBMS.
Database Management Software
Data Backup Management System
Database Management System
Digital Business Management Suite
Q 13.
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 14.
State whether the following statement is True or False:
The 'BETWEEN' operator in SQL is inclusive, meaning it includes the starting and ending values in the range.
True
False
-
-
Q 15.
State whether the following statement is True or False:
We can add a row in DataFrame using iloc.
True
False
-
-
Q 16.
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 17.
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 18.
The ____________command can be used to makes changes in the rows of a table in SQL.
Alter
Update
Insert
Modify
Q 19.
Assertion (A) : In order to be able to use Python's data visualization library, we need to import the pyplot module from matplot library.
Reason (R) : The pyplot module houses a variety of functions required to create and customize charts or graphs.
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 20.
Which of the following command is used to display first ten rows of a DataFrame 'DF' ?
DF.head()
DF.header()
DF.head(10)
DF.Head(10)
Q 21.
In Python Pandas, head(n) method returns the first n members of the series. What is the default value of n ?
2
3
4
5