1. Define socket? Writ a python program that makes a connection to a webserver and follows the rules of HTTP protocol to request a plain test document and display what server sends back. (06 Marks) (Dec.2019/Jan.2020)

---

---

2. What is XML? How is it used is python? Explain parsing of XML with example. (05 Marks) (Dec.2019/Jan.2020)

3. Define cursor? Explain connect, execute and close command of databases with suitable example. (05 Marks) (Dec.2019/Jan.2020)

4. Write a python code to read the file from web using urelib and retrieve the data of the file. Also compute the frequency of each word in the file. (06 Marks) (Dec.2019/Jan.2020)

5. What is JSON? Illustrate the concept of parsing JSON python code. (05 Marks) (Dec.2019/Jan.2020)

6. Explain the concept of using JOIN to retrieve data in python. (05 Marks) (Dec.2019/Jan.2020)

---

---

7. Demonstrate with the help of Python construct

i. how to retrieve an image over HTTP.

ii. how to retrieve web pages with urllib. (08 Marks) (June/July.2019)

8. Compare and contrast the JavaScript object Notation (JSON) and XML. (04 Marks) (June/July.2019)

9. What is Service - Oriented Architecture? List the advantages of the same. (04 Marks) (June/July.2019)

10. Write a Python program that retrieve an user's Twitter friends, Parse the returned JSON and extract some of the information about the friends. (08 Marks) (June/July.2019)

11. Create a simple spidering program that will go through Twitter accounts and build a database of them. (08 Marks) (June/July.2019)

12. Explain any 2 socket functions. Explain support for parsing HTML using regular expression with an example program. (08 Marks) (Dec.2018/Jan.2019)

---

---

13. Describe a support of security mechanism employed in Internet application with support of API usage with an example program to get four strings and put them in "hidden.PY" (08 Marks) (Dec.2018/Jan.2019)

14. Write a note on XML. Design python program to retrieve a node present in XML tree. (08 Marks) (Dec.2018/Jan.2019)

15. Brief on structured Query language, with suitable python program explain functions involved in creation of database table in python. (08 Marks) (Dec.2018/Jan.2019)

16. What is socket? Explain how socket connection can be established to the internet using Python code over the TCP/IP connection and the http protocol to Be the web document. (08 Marks) (June/July.2018)

17. Explain the significance of XML over the web development. Illustrate with an example. (08 Marks) (June/July.2018)

---

---

18. Write a note on Google Geocoding web service. Using Python supported libraries, demonstrate with a Snippet code. (08 Marks) (June/July.2018)

19. What is embedded SQL? Explain the importance of SQLite database. Write a Python code to establish a database connection to 'EmpDb' and display the total gross salary paid to the employees working in the 'Quality Control' department. Assume the employee table has been already created and exist in the 'EmpDb'. The fields of Employee table are (EmpID, DeptName, GrossSalary) (08 Marks) (June/July.2018)