DBP Assignment Unit 1 & 2 PDF
Document Details
Vimal Tormal Poddar BCA College
2024
Tags
Summary
This document is a database programming assignment for students. It contains short and long questions about SQLite and database handling. It covers topics such as data types, clauses, transactions, and commands. The assignment is for a third-semester computer science course.
Full Transcript
ASSIGNMENT Class : SYBCA-3rd Sem Date : 24-07-2024 Subject : Database Handling Using Python Submission Date : 31-07-2024 Units : 1 and 2 Submitted To : Ms. Donika Mali Short Questions: 1...
ASSIGNMENT Class : SYBCA-3rd Sem Date : 24-07-2024 Subject : Database Handling Using Python Submission Date : 31-07-2024 Units : 1 and 2 Submitted To : Ms. Donika Mali Short Questions: 1. What datatype does SQLite supports? Define Static & dynamic datatype. 2. What is the use of DISTINCT clause in SQLite? 3. What is the use of LIMIT & OFFSET clause? Explain with example. 4. Explain Group by, Having and Order by in SQLite. 5. Define Manifest Typing and Type Affinity. 6. What is Transaction? Explain its properties. 7. Explain Transaction control commands. 8. Define.dump command. 9. What is CSV file? 10. Write commands for export table structure into file. Long Questions: 1. What is SQLite? Give difference between SQL and SQLite. 2. Explain features of SQLite in detail. and Write steps to install SQLite on windows. 3. What is Affinity? Explain SQLite storage classes and SQLite Affinity type. 4. Explain Data Filtering in SQLite. 5. Explain UNION, INTERSECT and EXCEPT in SQLite. 6. Explain types of SQLite Joins. 7. What is Trigger? Explain Concept of Trigger. 8. How to take a backup of a multiple tables using the SQLite dump command. 9. What is the use of.mode command? Explain how to import a CSV file into a table. 10. Write steps to exports data from the SQLite databases to a csv file. 1 V.T.Poddar BCA College By Ms. Donika Mali
