Data Visualisation — Computer Science STD 12 Science — Question

What is the purpose of pyplot?

Name the protocols which are the parts of Application Layer.

What is Data Visualization?

What is Tuple?

Write the output of the following statements:

What do you understand by open source software?

Write a statement in Python to open a text file STORY.TXT so that new contents can be added at the end of it.

Write the few tools which are available now a days for the students with special needs.

Choose the correct answer for the following questions on the basis of given table:

Table: Persons

FirstName	LastName
Naveen	Gupta
Ram	Sharma
Mohan	Kumar
Aayu	Chugh

(a) With SQL, how do you select a column named "FirstName "from a table named "Persons "?

(b) With SQL, how do we select all the columns from a table named "Persons "?

(c) With SQL, how do we select all the records from a table named "Persons "where the value of the column "FirstName "is "Naveen "?

(d) With SQL, how do we select all the records from a table named "Persons "where the value of the column "FirstName "starts with an "a "?

(e) With SQL, how do we select all the records from a table named "Persons "where the "FirstName "is "Aayu "and the "LastName "is "Chugh "?

(f) With SQL, how do we select all the records from a table named "Persons "where the "LastName "is alphabetically between (and including) "Sharma "and "Chugh "?

(g) With SQL, how can we return all the records from a table named "Persons "sorted descending by "FirstName "?

(h) With SQL, how can we insert a new record into the "Persons "table?

(i) With SQL, how can we insert "Mehta "as the "LastName "in the "Persons "table?

(j) How can we change "Chugh "into "Bajaj "in the "LastName "column in the Persons table?

(k) With SQL, how can you delete the records where the "FirstName "is "Gupta "in the Persons Table?

(l) With SQL, how can you return the number of records in the "Persons "table?

Write a few points, why we have to recycle the e-waste?