List of top Computer Science Questions

Dataframe.quantile() is used to get the quartiles. The second quantile is known as ..............

Put the following statistical measures in order starting from the simplest measure of data to the most complex one that describes data spread: (A) Mode,
(B) Mean,
(C) Median,
(D) Range,
(E) Standard Deviation

After establishing the connection to fetch the data from the table of a database in SQL into a DataFrame, which of the following function will be used?
(A) pandas.read__sql__query()
(B) pandas.read__sql__table()
(C) pandas.read__sql__query__table()
(D) pandas.read__sql()

The process of changing the structure of a DataFrame using function pivot() is known as .............

While transferring the data from a DataFrame to a CSV file, if we do not want the column names to be saved to the file on disk, the parameter to be used in \texttt{to__csv()} is __________.

Match List-I with List-II.

List-I	List-II
(A) SUBSTR()	(II) To extract a substring from a string.
(B) TRIM()	(IV) To remove spaces from both sides of the string.
(C) INSTR()	(I) To find the position of a substring in a string.
(D) LEFT()	(III) To extract characters from the left side of the string.

Arrange the following statements to create a series from a dictionary.
(A) Print the series
(B) Import the pandas library
(C) Create the series
(D) Create a dictionary

Which of the following is the correct command to display the top 2 records of Series \texttt{tail}?

The HTTPS based websites require:

Match List-I with List-II:

List-I	List-II
(A) group by	(III) having
(B) mid()	(IV) text function
(C) count()	(II) aggregate function
(D) mod()	(I) math function

State the output of the following query: \[ \text{SELECT LENGTH(MID('INFORMATICS PRACTICES',5,-5));} \]

What will be the format of the output of the NOW() function?

State the output of the following query: \[ \text{SELECT ROUND(9873.567,-2);} \]

Match List-I with List-II. \

List-I	List-II
(A) Modem	(II) Modulator-Demodulator
(B) RJ45	(I) An eight pin connector used with Ethernet cables for networking.
(C) Network interface unit	(IV) Ethernet card
(D) ISP	(III) An organization that provides services for accessing the internet.

The term Cookie is defined as:

Identify the wired transmission media for the following: “They are less expensive and commonly used in telephone lines and LANs. These cables are of two types: Unshielded and shielded.”

Data Transfer Rate 1 Gbps is equal to: (A) 1024 Mbps
(B) 1024 Kbps
(C) $2^{30}$ bps
(D) $2^{20}$ bps

Bandwidth of a channel is:

Identify the concept behind the below-given scenario: “If an attacker limits or stops an authorized user to access a service, device or any such resource by overloading that resource with illegitimate requests.”

Ms Ritika wants to delete the table 'sports' permanently. Help her in selecting the correct SQL command from the following.

Which of the following are text functions? (A) MID()
(B) INSTR()
(C) SUBSTR()
(D) LENGTH()