List of practice Questions

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
Match List-I with List-II.
List-IList-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.

Given the following table:

ENOSALARY
A1014000
B109NULL
C5086000
A3052000

State the output of the following query:

SELECT COUNT(SALARY) FROM EMPLOYEE;  

State the output of the following query: \[ \text{SELECT ROUND(9873.567,-2);} \]
What will be the format of the output of the NOW() function?
Match List-I with List-II:
List-IList-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));} \]
The HTTPS based websites require:
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.”
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:
Match List-I with List-II. \
List-IList-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.
____________ is a language used to design web pages.
Match List-I with List-II.
List-IList-II
(A) ROUTER(II) Network Device
(B) ETHERNET CARD(IV) Network Interface Card
(C) RING(I) Network Topology
(D) PAN(III) Network Type
Which of the following are text functions? (A) MID()
(B) INSTR()
(C) SUBSTR()
(D) LENGTH()
Ms Ritika wants to delete the table 'sports' permanently. Help her in selecting the correct SQL command from the following.
Single row functions are also known as ________ functions.
Which of the following is synonym for Meta-data?
In SQL table, the set of values which a column can take in each row is called __________.
Match List-I with List-II.
List-IList-II
(A) Primary key(III) Attribute used to uniquely identify a tuple.
(B) Degree(I) Total number of attributes in a table.
(C) Foreign key(II) Attribute used to relate two tables.
(D) Constraint(IV) A restriction on the type of data that can be inserted in a column.
Given data: Weight of 20 students in kgs = [35, 35, 40, 40, 40, 50, 50, 50, 50, 50, 60, 65, 65, 70, 70, 72, 75, 75, 78, 78] Find the mode.
Identify type of data being collected/generated in the scenario of recording a video:
Identify the incorrect statement in the context of measures of variability: