PTA model question paper

1. Define database.
2. Define DBMS.
3. What is cursor in SQL?
4. Why SQL command is defined with triple quotes in python?
5. What happened if a column of table is declared as integer primary key?
6. Write note on SELECT statement in SQL.
7. Write not on COUNT() function.
8. What is the difference between MAX() and MIN() functions?
9. Write about execute() function. Execute (sql[, Parameter]):
10. What is the operation of cursor. Description?
11. Write note on master table.
12. Write note on SQLite.
13. Write down the steps to use SQLite
14. Explain how a connection to be made to a database through python sqlite3?
15. What is the difference between fetchall(), fetchone() and fetchmany() methods?
16. Write a program to display the content of tuples in newline without using loops.
17. Explain the usage of DISTINCT and WHERE clauses.
18. Explain the usage of group by, ORDER BY and HAVING clauses.
19. Write a python code for opening the CSG file through MS- Excel and view the result.
20. Define Infographics.
21. What do you mean by scatter plot?
22. Write note on Box plot.
23. What is scripting language?
24. List popular scripting languages.
25. What do you mean by garbage collection?
26. Write short note on python language.
27. What are the processing skill of SQL?
28. How will you insert a record in a table? Explain suitable example.
29. Explain UPDATE command with suitable example.
30. Explain briefly about ALTER command.
31. Explain sorting records with ORDER BY clause.
32. Explain GROUP BY clause with an example.
33. What is an object?
34. Write the syntax for class definition.
35. What do you mean by statement in a class definition?
36. Differentiate public and private data members.
37. What do you mean by class variable, methods and members related to a class?
38. Explain the method of creation of object for a class and accessing its members.
39. Explain class method in python.
40. Write a menu driven program that keeps record of books available in you school library.
41. Write a program to accept a string and print the number of uppercase,, lowercase, vowels, consonants and spaces in the given string..
42. How will you create a list with series of values?
43. Write about various list functions in python.
44. Explain the methods of creating a tuple with suitable example.
45. Write note on len () function.
46. How will you access list elements using for statement?
47. How will you change the list elements?
48. Write note on list comprehension.
49. Write about dictionary in python.
50. Write the syntax for defining a dictionary with an example.
51. Write note on dictionary comprehension.
52. How will you create a string in python?
53. How will you access characters in a string?
54. Write note on replace function.
55. Write note on append operator.
56. Give any 6 formatting characters with their usage?
57. Write a short note on modifying and deleting string.
58. What is known as stride when slicing string?
59. Explain various function arguments with suitable example.
60. Write any 5 built and mathematical in function.

The pdf is given below. Kindly download and make it useful.

[pdf-embedder url=”https://csknowledgeopener.com/wp-content/uploads/2023/01/XII-STD-CS-PTA.pdf” title=”XII STD CS PTA”]