List of practice Questions

Identify the incorrect statement in the context of measures of variability:

Identify type of data being collected/generated in the scenario of recording a video:

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.

Match List-I with List-II.

List-I	List-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.

In SQL table, the set of values which a column can take in each row is called __________.

Which of the following is synonym for Meta-data?

Single row functions are also known as ________ functions.

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()

Match List-I with List-II.

List-I	List-II
(A) ROUTER	(II) Network Device
(B) ETHERNET CARD	(IV) Network Interface Card
(C) RING	(I) Network Topology
(D) PAN	(III) Network Type

____________ is a language used to design web pages.

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.

Bandwidth of a channel is:

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

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.”

The term Cookie is defined as:

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 HTTPS based websites require:

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

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

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);} \]

Diksha Ltd. invited applications for issuing 1,00,000 equity shares of ₹ 10 each at a premium of 10%. The whole amount was payable on application. Applications were received for 3,00,000 equity shares. The company decided to allot the shares on pro-rata basis to all the applicants. The amount refunded by the company was: