Model Test Paper for Class XII

Which protocol is used for sending and receiving email messages?

• PPP

• SMTP

• POP3

• VoIP

Using someone else’s Facebook account to post something will be termed as:

• Fraud

• Online stealing

• Violation

• Identity theft

Which of the following measures should not be adopted to recycle e-waste safely?

• Donate to NGO

• Sell your old electronics

• Burn your e-waste

• Give your e-waste to a certified e-waste recycler

In a table named ‘Student’, if a column “Name” contains the data set (“Rashi”, “Shreyas”, “Nitya”, “Rashi”, “Nitya”, “Nityam”, “Kavya”, “Rashi”), what will be the output after the execution of the given query? SELECT COUNT(DISTINCT Name) FROM student;

• Error – cannot work on char data type

• 5

• "Five"

• No output

What will be the order of the data being sorted after the execution of given SQL query? SELECT * From School Order by Class;

• Order of inserting records in a table

• Ascending order

• Descending order

• None of these

The term ‘Intellectual Property Rights’ covers:

• Copyrights

• Trademarks

• Patents

• All of these

Consider a table named Employees with columns – EName, Age, Salary and Designation. Which SQL statement do we use to find out the total salary given to employees?

• Select SUM(Salary) From Employees;

• Select COUNT (*) From Employees;

• Select FIND (*) From Employees;

• Select SUM () From Employees;

Which clause in SQL is used to apply a condition on a group?

• Where

• Having

• As

• On

In SQL, which of the following functions is used to display an average of a given number?

• Average()

• Aver()

• Avg()

• Avge()

The function to create a Series in Pandas is:

• Series[]

• Series{ }

• Series()

• .Series