Theory Assignment (1).pdf

Managed By Vidyamandir Trust Smt. Tanuben & Dr. Manubhai Trivedi College for Information Science, Surat Affiliated to Veer Narmad South Gujarat University, Surat Theory Assignment (1)...

Managed By Vidyamandir Trust Smt. Tanuben & Dr. Manubhai Trivedi College for Information Science, Surat Affiliated to Veer Narmad South Gujarat University, Surat Theory Assignment (1) Subject: 303 – Database Handling Using Python Q-1: Answer Following Questions (5 Marks each) (A) Write features of SQLite in detail. (B) Explain Backup and Restore techniques of SQLite using proper Example (C) What is SQLite? Explain its features in brief. (D) Explain Datatypes with type affinity in detail. (E) How SQLite is transactional? Explain transactions with Example. (F) In what circumstances Trigger is used? Explain types of triggers with proper example. (G) Explain Dump Command with all options. Also write down steps to Import and Export CSV file using SQLite. Q-2: Answer Following Questions (2 Marks each) 1. What is affinity type? 2. How many types of triggers are there in SQLite? 3. What is the use of EXCEPT in SELECT Query? 4. When we can use CASE statement in SELECT Query? 5. What is sub-query? Give one example of it. 6. What is a difference between where clause and having clause? 7. When we use natural join how it differs from Inner Join? 8. What is the use of LIMIT and OFFSET? 9. What is dynamic typing in sqlite? 10. Which commands are used to create transaction in sqlite? 11. Define the use of USING in Select statement. 12. Provide 2 reasons for aliasing table. 13. List out the types of COLLATION are there in SQLite. 14. Provide one example of using subquery in select clause (not in where clause). 15. Differentiate Union and UnionAll. 16. How we can fire trigger for update on particular column. 17. When triggers are dropped? 18. Define the use of WHEN in Triggers. 19. What is the use of NEW and OLD Keyword in Trigger. 20. Write down the syntax of all DDL Statements of SQLite.  Managed By Vidyamandir Trust Smt. Tanuben & Dr. Manubhai Trivedi College for Information Science, Surat Affiliated to Veer Narmad South Gujarat University, Surat Theory Assignment (2) Subject: 303 – Database Handling Using Python Q-1: Answer Following Questions (5 Marks each) 1. What is Module? Explain Modules and Packages in Python with Import. 2. Explain SQLite3 Module with its Options 3. What is cursor? When we need to use cursor in Python? Explain with Example. 4. Write in detail about File Handling in Python? How we can read & Write CSV File. 5. Explain: Open(), reader(), writer(), writerows(), DictReader(), DictWriter(). Q-2: Answer the Following (2 Marks Each) 1. Write down the significance of PYTHONPATH. 2. What is Module is Python. What a module can contain? 3. List out different methods of importing modules and definition in python file 4. Define packages in python. 5. How a module is located by python interpreter? 6. What is sqlite3 module? How we can create database using it? 7. What do you mean by sqlite3.connect(“:memory:”)? 8. Define execute, executemany and executescript functions of sqlite3 module. 9. What are the different constants available in SQLite Module? 10. Write a code lines to fetch all records from user defined table. 11. What total_changes constant returns? 12. Provide difference between fetchone(), fetchmany() and fetchall()? 13. Write a code for inserting user defined data into table. 14. Write a code to fetch single record from database table. 15. Define date() function and list out all possible parameters. 16. How I can fetch current year, current month and current day from sqlite? 17. What is the difference between r+ and w+ file mode? 18. What are the two ways to read file line by line? 19. Write down the significance of CSV module and reader function. 20. Differentiate writerow and writerows with example.