IP QP 2023-24

A ____________is a device that connects the organisation’s network with the outside world of the Internet.

• Hub

• Modem

• Gateway

• Repeater

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

• Hydrogen

• Beryllium

• Chlorine

• Oxygen

Copyright, Patent and Trademark comes under:

• Intellectual Property Right

• Individual Property Right

• Industrial Property Right

• None of the above

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

• 0

• NULL

• NaN

• 9

Which of the following SQL functions does not belong to the Math functions category?

• POWER()

• ROUND()

• LENGTH()

• MOD()

________ is not a FOSS tool.

• Libre Office

• Mozilla Firefox

• Google Chrome

• Python

CSV stands for:

• Column Separated Value

• Class Separated Value

• Comma Separated Value

• None of the above

Raj, 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?

• SELECT DEPT, AVG(SAL) FROM EMP WHERE COUNT(*) > 5 GROUP BY DEPT;

• SELECT DEPT, AVG(SAL) FROM EMP HAVING COUNT(*) > 5 GROUP BY DEPT;

• SELECT DEPT, AVG(SAL) FROM EMP GROUP BY DEPT WHERE COUNT(*) > 5;

• SELECT DEPT, AVG(SAL) FROM EMP GROUP BY DEPT HAVING COUNT(*) > 5;

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

• May

• March

• may

• march

Which 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