Question 1

Question 1A ............... is a device that connects the organization's network with the outside world of the Internet.HubModemGatewayRepeater

Accepted Answer

GatewayReason — A gateway is a node on a network that serves as an entrance to another network. In an organization, the gateway is a device that connects the organization's network with the outside world, including the Internet.

Question 2

Question 2When e-waste such as electronic circuit boards are burnt for disposal, the elements contained in them create a harmful chemical called ............... which causes skin diseases, allergies and an increased risk of lung cancer.HydrogenBerylliumChlorineOxygen

Accepted Answer

BerylliumReason — When electronic circuit boards containing beryllium are burnt for disposal, they release beryllium oxide, a harmful chemical compound. Inhalation or skin contact with beryllium oxide can lead to skin diseases, allergies, and an increased risk of lung cancer.

Question 3

Question 3Copyright, Patent and Trademark comes under :Intellectual Property RightIndividual Property RightIndustrial Property RightNone of the above

Accepted Answer

Intellectual Property RightReason — Copyright, patent, and trademark are all forms of intellectual property rights.

Question 4

Question 4Predict the output of the following query :SELECT MOD(9, 0);0NULLNaN9

Accepted Answer

NULLReason — The MOD() function returns NULL when the divisor is zero because division by zero is undefined in SQL.

Question 5

Question 5Which of the following SQL functions does not belong to the Math functions category ?POWER()ROUND()LENGTH()MOD()

Accepted Answer

LENGTH()Reason — LENGTH() is a text/string function that returns the length of a given string in bytes.

Question 6

Question 6............... is not a FOSS tool.Libre OfficeMozilla FirefoxGoogle ChromePython

Accepted Answer

Google ChromeReason — Google Chrome is not a Free and Open Source Software (FOSS) tool. It is a web browser developed by Google, which means its source code is not openly available for users to view, modify, or distribute. In contrast, LibreOffice, Mozilla Firefox, and Python are all examples of FOSS tools with open-source code that can be freely used, modified, and distributed by anyone.

Question 7

Question 7CSV stands for :Column Separated ValueClass Separated ValueComma Separated ValueNone of the above

Accepted Answer

Comma Separated ValueReason — The acronym CSV is short for Comma-Separated Value.

Question 8

Question 8Raj, a Database Administrator, needs to display the average pay of workers from those departments which have more than five employees. He is experiencing a problem while running the following query :SELECT DEPT, AVG(SAL) FROM EMP WHERE COUNT(*) > 5 GROUP BY DEPT;Which of the following is a correct query to perform the given task ?(i) SELECT DEPT, AVG(SAL) FROM EMP WHERE COUNT(*) > 5 GROUP BY DEPT;(ii) SELECT DEPT, AVG(SAL) FROM EMP HAVING COUNT(*) > 5 GROUP BY DEPT;(iii) SELECT DEPT, AVG(SAL) FROM EMP GROUP BY DEPT WHERE COUNT(*) > 5;(iv) SELECT DEPT, AVG(SAL) FROM EMP GROUP BY DEPT HAVING COUNT(*) > 5;

Accepted Answer

SELECT DEPT, AVG(SAL) FROM EMP GROUP BY DEPT HAVING COUNT(*) > 5;Reason — In the above query, the WHERE clause cannot be used with aggregate functions like COUNT(*) because it is meant to filter individual rows before the aggregation. On the other hand, the HAVING clause filters the groups created by the GROUP BY clause to include only those departments (DEPT) that have more than five employees.

Question 9

Question 9Predict the output of the following query :SELECT LCASE(MONTHNAME('2023-03-05'));MayMarchmaymarch

Accepted Answer

marchReason — The MONTHNAME() function in MySQL returns the name of the month for a given date. In this case, the date '2023-03-05' corresponds to March, so MONTHNAME('2023-03-05') will return "March". Then LCASE() function is used to convert the result to lowercase, resulting in "march" as the output.

Question 10

Question 10Which of the following command will show the last 3 rows from a Pandas Series named NP ?NP.Tail()NP.tail(3)NP.TAIL(3)All of the above

Accepted Answer

NP.tail(3)Reason — The syntax to display the last n rows of a Series object is <Series Object>.tail([n]). Therefore, according to this syntax, NP.tail(3) will display last three rows of a Series object NP.

Question 11

Question 11With reference to SQL, identify the invalid data type.DateIntegerYearMonth

Accepted Answer

Year, MonthReason — In SQL, 'Year' and 'Month' are not valid data types.

Question 12

Question 12In Python Pandas, while performing mathematical operations on series, index matching is implemented and all missing values are filled in with ............... by default.NullBlankNaNZero

Accepted Answer

NaNReason — When performing mathematical operations on pandas Series objects, index matching is implemented (this is called data alignment in Pandas objects), and missing values are filled with NaN (Not a Number) by default.

Question 13

Question 13By restricting the server and encrypting the data, a software company's server is unethically accessed in order to obtain sensitive information. The attacker blackmails the company to pay money for getting access to the data, and threatens to publish sensitive information unless price is paid. This kind of attack is known as :PhishingIdentity TheftPlagiarismRansomware

Accepted Answer

RansomwareReason — Ransomware is a type of malicious attack where an attacker gains unauthorized access to a system or server, encrypts the data, and demands a ransom in exchange for the information. In this scenario, the attacker is threatening to publish sensitive information unless the company pays the ransom, which is a characteristic of a ransomware attack.

Question 14

Question 14In SQL, the equivalent of UCASE() is :UPPERCASE()CAPITALCASE()UPPER()TITLE()

Accepted Answer

UPPER()Reason — The equivalent function in SQL to UCASE() is UPPER(). Both perform the same operation, which is to convert all characters in a string to uppercase.

Question 15

Question 15Collection of hyper linked documents available on the internet is known as ............... .WebsiteWebpageWeb ServerWeb Hosting

Accepted Answer

WebsiteReason — A website or a site is a group of related web pages hosted on a web server and are linked together (through hyperlinks and hypertext) and share a common interface and design.

Question 16

Question 16............... is a non-profit organization that aims to build a publicly accessible global platform where a range of creative and academic work is shared freely.Creative CostCritical CommonsCreative CommonsCreative Common

Accepted Answer

Creative CommonsReason — Creative Commons is a non-profit organization that aims to build a publicly accessible global platform where a range of creative and academic work is shared freely.

Question 17

Question 17Assertion (A). MODEM stands for modulator-demodulator.Reasoning (R). It is a computer hardware device that converts data from a digital format to analog and vice versa.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

Both A and R are true and R is the correct explanation of A.ExplanationMODEM stands for modulator-demodulator. It is a computer hardware device that allows connecting and communicating with other computers via telephone lines. It converts digital data from a computer into analog signals suitable for transmission over telephone lines, and vice versa, converting incoming analog signals back into digital data that the computer can understand.

Question 18

Question 18Assertion (A). To use the Pandas library in a Python program, one must import it.Reasoning (R). The only alias name that can be used with the Pandas library is pd.Both A and R are true and R is the correct explanation of A.Both A and R are true but R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

A is true but R is false.ExplanationIn order to work with Pandas in Python, we need to import the Pandas library into our Python environment using the statement import pandas as pd. While pd is a common alias used with the Pandas library, it's not the only alias that can be used. We can import Pandas using other alias names as well.

Question 19

Question 19(a)Briefly explain the basic concepts of a web server and web hosting.

Accepted Answer

A web server is a WWW server that stores web documents and responds to requests made by web browsers. Some examples are Apache, IIS, Nginx, GWS, and Netsite.A website is physically located on a web host. A group of linked web pages qualifies to be called a website only when hosted on a web server. When the user specifies the address of the website, the web pages are transmitted to the user's computer from the web host.

Question 20

Question 19(b)Rati is doing a course in networking. She is unable to understand the concept of URL. Help her by explaining it with the help of suitable example.

Accepted Answer

A URL (Uniform Resource Locator) is a location on a net server. The Internet structure of the World Wide Web is built on a set of rules called Hypertext Transfer Protocol (HTTP), which uses Internet addresses in a special format called a URL.URLs look like this : type://address/path, where type: specifies the type of server in which the file is located, address is the address of server, and path tells the location of file on the server.For example, in the following URL http://encycle.msn.com/getinfo/styles.asp, http: specifies the type of server, encycle.msn.com is the address of server and getinfo/style.asp is the path of the file styles.asp.

Practice Paper

Section A 1 Mark Each

Section B 2 Marks Each

Section C 3 Marks Each

Section D 4 Marks Each

Section E 5 Marks Each