Class 12th IP (065)

Computer Science Question Bank – Python, Pandas, Networking, SQL

Python Fundamentals

1. Who developed Python?

Python was developed by Guido van Rossum.

2. What is Python? What are its benefits?

Python is a programming language with objects, modules, threads, exceptions, and automatic memory management. Benefits include simplicity, portability, extensibility, built-in data structures, and open-source nature.

3. How is Python interpreted?

Python is an interpreted language where source code is converted into intermediate code and then executed as machine code.

NumPy

4. What is array slicing?

Array slicing extracts a subset of elements from an array and returns them as another array.

5. What are NumPy arrays?

NumPy arrays (ndarrays) are homogeneous collections of elements stored in contiguous memory.

6. Why are NumPy arrays preferred over lists?

They use less memory, execute faster, and are more convenient for numerical operations.

7. Is NumPy better than lists?

Yes, because NumPy arrays are memory-efficient, faster, and more convenient.

Pandas

8. Who developed Pandas and why is it used?

Pandas was developed by Wes McKinney and is used for data manipulation and analysis.

9. What is a Pandas Series?

A one-dimensional labeled data structure capable of holding any data type.

10. What is a DataFrame?

A two-dimensional labeled data structure with rows and columns.

11. Difference between DataFrame and NumPy 2D array?

DataFrames store heterogeneous data with labels, whereas NumPy arrays store homogeneous data without labels.

12. How to create an empty DataFrame?

Using DataFrame() function.

13. Relationship between Series and DataFrame?

Columns of a DataFrame are Series objects.

14. What does size attribute return?

It returns the total number of elements.

15. Standard missing value marker in Pandas?

NaN

16. How to fill missing values?

Using fillna() method.

17. Attribute to modify or add row?

loc[]

18. Error when index and data length differ in Series?

ValueError

19. Parameter used in rename() to specify row/column?

index

20. Does drop() permanently delete data?

No, unless inplace=True is used.

21. What is Reindexing?

Changing row and column labels, inserting NaN where data is missing.

22. Difference between del and pop?

del deletes silently; pop deletes and returns the column.

23. Which Pandas object cannot grow?

Series

24. Attribute to check NaN in Series?

hasnans

25. Functions to display first and last rows?

head() and tail()

Data Visualization

26. Importance of Data Visualization?

It helps in understanding large datasets visually.

27. Library used for plotting?

Matplotlib

28. Purpose of plot()?

To draw different types of graphs.

29. What are subplots?

Multiple plots within a single figure.

Networking

30. What is a Network?

Interconnected computers sharing resources.

31. Types of Networks?

PAN, LAN, MAN, WAN

32. What is Topology?

Arrangement of computers in a network.

33. What is TCP/IP?

A communication protocol used on the Internet.

Database

34. What is RDBMS?

A database system that stores data in tables.

35. What is MySQL?

An open-source relational database.

36. What is a Primary Key?

Uniquely identifies a record.

Cyber Safety

37. What are Digital Footprints?

Data traces left online.

38. What is Phishing?

Fraudulent attempt to steal sensitive data.

39. What is Identity Theft?

Using someone’s identity illegally.

Important Expansions

AbbreviationExpansion
CSVComma Separated Values
SQLStructured Query Language
DBMSDatabase Management System
RDBMSRelational Database Management System
DDLData Definition Language
DMLData Manipulation Language
DCLData Control Language
TCLTransaction Control Language
DQLData Query Language
FOSSFree and Open-Source Software

Leave a Reply

Your email address will not be published. Required fields are marked *

sign up!

We’ll send you the hottest deals straight to your inbox so you’re always in on the best-kept software secrets.