Scribd
Upload
4 views3 pages

Python Question Bank

The document outlines key concepts and questions related to exception handling, database connectivity, and the Pandas library in Python. It includes definitions, differences, examples, and programming tasks for each topic, categorized into 2-mark and 5-mark questions. The content serves as a study guide for understanding these fundamental programming concepts.

Uploaded by

brahhh352
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views3 pages

Python Question Bank

The document outlines key concepts and questions related to exception handling, database connectivity, and the Pandas library in Python. It includes definitions, differences, examples, and programming tasks for each topic, categorized into 2-mark and 5-mark questions. The content serves as a study guide for understanding these fundamental programming concepts.

Uploaded by

brahhh352
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

EXCEPTION HANDLING

2 MARKS
1. Define exception in Python.
2. Difference between error and exception.
3. List two built-in exceptions.
4. Purpose of try and except.
5. What is generic exception?
6. Use of finally block.
7. Define assert.
8. What is raise statement?
9. Define user-defined exception.
10. What is exception handling?
11. What is else block?
12. Syntax of try-except.
13. What is AssertionError?
14. Importance of exception handling.

5 MARKS
1. Explain types of exceptions with examples.
2. Explain try-except-else-finally.
3. Program for multiple exceptions.
4. Explain assert with example.
5. User-defined exceptions program.
6. Raising exceptions using raise.
7. Logging exceptions.
8. Program for division handling.
9. Best practices.

DATABASE CONNECTIVITY

2 MARKS
1. Define database connectivity.
2. Name two databases.
3. What is MySQL?
4. Define cursor.
5. What is SQL?
6. Use of commit().
7. Define fetchall().
8. Define fetchone().
9. Define primary key.
10. What is table?
11. What is CRUD?
12. Define executemany().
13. Parameterized query.
14. Role of connector.

5 MARKS
1. Steps to connect MySQL with Python.
2. Program to create database and table.
3. Insert data example.
4. Retrieve data example.
5. Update and delete program.
6. CRUD operations explanation.
7. Complete connectivity program.
8. Parameterized queries importance.
9. Advantages.

PANDAS

2 MARKS
1. Define Pandas.
2. Define DataFrame.
3. Define Series.
4. What is time series?
5. Creating DataFrame.
6. head() function.
7. tail() function.
8. iloc.
9. loc.
10. drop().
11. fillna().
12. grouping.
13. describe().
14. missing data.

5 MARKS
1. Explain Pandas and features.
2. DataFrame and Series examples.
3. Creating DataFrames methods.
4. Time series explanation.
5. DataFrame operations.
6. Program example.
7. Handling missing data.
8. Pandas vs NumPy.
9. Grouping and aggregation.

You might also like