Class 11th IP MCQ
Unit 1: Introduction to Computer System MCQs (Class XI – CBSE IP/CS)
Q1. Which of the following computing devices was primarily used for performing arithmetic calculations using beads?
A. Pascaline
B. Abacus
C. ENIAC
D. Analytical Engine
Q2. The first general-purpose electronic digital computer was:
A. UNIVAC
B. EDVAC
C. ENIAC
D. IBM 701
Q3. Which generation of computers introduced transistors?
A. First Generation
B. Second Generation
C. Third Generation
D. Fourth Generation
Q4. Which component of a computer system is known as the “brain” of the computer?
A. Input Unit
B. Output Unit
C. Control Unit
D. Central Processing Unit
Q5. The Control Unit (CU) of a computer:
A. Performs arithmetic operations
B. Stores data permanently
C. Directs and coordinates all operations
D. Displays output
Q6. Which of the following is not a part of the CPU?
A. ALU
B. Control Unit
C. Registers
D. RAM
Q7. Which of the following is an input device?
A. Monitor
B. Printer
C. Keyboard
D. Plotter
Q8. A device that converts digital signals into printed hard copy is called:
A. Scanner
B. Plotter
C. Monitor
D. Printer
Q9. Which device is used both as an input and an output device?
A. Mouse
B. Touch Screen
C. Speaker
D. Keyboard
Q10. Which of the following memory units is the largest?
A. Kilobyte
B. Megabyte
C. Gigabyte
D. Terabyte
Q11. Which memory is volatile in nature?
A. ROM
B. Hard Disk
C. RAM
D. DVD
Q12. Which of the following is an example of secondary memory?
A. Cache
B. Register
C. RAM
D. Hard Disk
Q13. When a file is deleted from a computer, it is:
A. Permanently destroyed immediately
B. Moved to recycle bin
C. Converted into a backup file
D. Encrypted automatically
Q14. Data recovery refers to:
A. Encrypting data
B. Backing up data
C. Retrieving deleted or lost data
D. Deleting unwanted data
Q15. Which of the following is a major security concern related to data recovery?
A. Faster system performance
B. Unauthorized access to sensitive data
C. Increased storage capacity
D. Better file organization
END………………………
Unit 2: Introduction to Python
Q1. Python is a ________
A. Machine language
B. Assembly language
C. High-level programming language
D. Low-level language
Q2. Python code is executed by:
A. Compiler only
B. Interpreter only
C. Compiler and Interpreter
D. Assembler
Q3. Interactive mode in Python is mainly used for:
A. Writing large programs
B. Testing small pieces of code
C. Creating executable files
D. Debugging hardware
Q4. Script mode in Python is used to:
A. Execute commands line by line
B. Write and execute complete programs
C. Debug syntax errors only
D. Store data permanently
Q5. Which symbol is used for indentation in Python?
A. Curly braces {}
B. Parentheses ()
C. Tabs or spaces
D. Semicolon ;
Q6. Which of the following is a valid identifier?
A. total-marks
B. for
C. _sum1
D. 1value
Q7. Keywords in Python are:
A. User-defined words
B. Reserved words
C. Variables
D. Constants
Q8. Which of the following is a constant?
A. x
B. x = 10
C. 10
D. input()
Q9. Which operator is used for exponentiation?
A. ^
B. **
C. //
D. %
Q10. Which operator has the highest precedence?
A. +
B. *
C. **
D. //
Q11. Which of the following is a mutable data type?
A. Tuple
B. String
C. List
D. Integer
Q12. Which data type is immutable?
A. List
B. Dictionary
C. Set
D. Tuple
Q13. Expression evaluation in Python follows:
A. Left to right rule only
B. Operator precedence
C. Random order
D. Alphabetical order
Q14. Which symbol is used for comments in Python?
A. //
B. /* */
C. #
D. <!– –>
Q15. Debugging is the process of:
A. Writing programs
B. Executing programs
C. Removing errors from programs
D. Compiling programs
Q16. Which function is used to take input from the user?
A. read()
B. input()
C. scan()
D. get()
Q17. The default data type of input() is:
A. Integer
B. Float
C. String
D. Boolean
Q18. Which function converts a value into float?
A. int()
B. str()
C. float()
D. eval()
Q19. Which statement is used for output in Python?
A. show()
B. display()
C. print()
D. output()
Q20. Explicit type conversion is also known as:
A. Implicit casting
B. Type coercion
C. Manual type conversion
D. Automatic conversion
Q21. Which function can evaluate expressions entered as input?
A. int()
B. float()
C. eval()
D. str()
Q22. Syntax errors are detected:
A. During execution
B. After output
C. Before execution
D. After debugging
Q23. Which statement is used for decision making?
A. loop
B. if
C. break
D. continue
Q24. Which statement checks multiple conditions?
A. if
B. if-else
C. if-elif-else
D. switch
Q25. Which loop executes as long as condition is true?
A. for
B. while
C. do-while
D. repeat
Q26. Which loop is used when number of iterations is known?
A. while
B. for
C. Infinite loop
D. Nested loop
Q27. Which keyword is used to terminate a loop?
A. stop
B. exit
C. break
D. pass
Q28. Which keyword skips the current iteration?
A. break
B. pass
C. continue
D. skip
Q29. Which keyword is used when no action is required?
A. stop
B. pass
C. null
D. break
Q30. Indentation is mandatory in:
A. Only loops
B. Only if statements
C. All Python blocks
D. Functions only
Q31. Lists in Python are enclosed in:
A. ()
B. {}
C. []
D. <>
Q32. Which function returns number of elements in a list?
A. count()
B. size()
C. len()
D. sum()
Q33. Which method adds an element at the end of the list?
A. add()
B. insert()
C. append()
D. extend()
Q34. Which method inserts element at specific position?
A. append()
B. insert()
C. add()
D. push()
Q35. Which method removes first occurrence of element?
A. pop()
B. del()
C. remove()
D. clear()
Answer: C
Q36. Which method removes element using index?
A. remove()
B. pop()
C. delete()
D. discard()
Answer: B
Q37. Which method reverses a list?
A. sort()
B. reverse()
C. swap()
D. change()
Q38. Which function returns smallest element of list?
A. low()
B. min()
C. small()
D. least()
Q39. Which function returns sum of numeric list elements?
A. total()
B. add()
C. sum()
D. plus()
Q40. Lists are:
A. Immutable
B. Fixed size
C. Mutable
D. Homogeneous only
Q41. Dictionary stores data as:
A. Index-value pairs
B. Key-value pairs
C. Value-value pairs
D. Key-index pairs
Q42. Dictionary elements are enclosed in:
A. ()
B. []
C. {}
D. <>
Answer: C
Q43. Which method returns all keys of dictionary?
A. values()
B. items()
C. keys()
D. get()
Q44. Which method returns key-value pairs?
A. keys()
B. values()
C. items()
D. pairs()
Q45. Which statement deletes a specific key?
A. remove d[key]
B. delete d[key]
C. del d[key]
D. clear d[key]
Q46. Which method removes all elements from dictionary?
A. del()
B. remove()
C. clear()
D. empty()
Q47. Dictionaries are:
A. Ordered and immutable
B. Mutable and unordered
C. Immutable and unordered
D. Fixed size
Q48. NumPy stands for:
A. Numerical Python
B. Network Python
C. New Python
D. Numeric Program
Q49. NumPy is mainly used for:
A. Web development
B. Data storage
C. Numerical computations
D. Game design
Q50. Which function creates NumPy array from list?
A. list()
B. array()
C. numpy.array()
D. np.list()
END……………..
Unit 3: Database Concepts and SQL
Q1. A database is:
A. A collection of unrelated files
B. A collection of programs
C. An organized collection of related data
D. A software package
Q2. The main purpose of a database is to:
A. Reduce hardware cost
B. Store data randomly
C. Organize and manage data efficiently
D. Increase processing speed only
Q3. DBMS stands for:
A. Data Backup Management System
B. Database Management System
C. Data Base Machine Software
D. Database Model System
Q4. Which of the following is NOT an advantage of DBMS?
A. Data redundancy control
B. Improved data security
C. Data inconsistency
D. Data sharing
Q5. DBMS helps in:
A. Program execution
B. Data storage and retrieval
C. Image editing
D. Web browsing
Q6. Which of the following is an example of DBMS software?
A. MS Word
B. MS Excel
C. MySQL
D. PowerPoint
Q7. A table in a database is also known as:
A. Field
B. Tuple
C. Relation
D. Domain
Q8. A row in a table is called:
A. Attribute
B. Field
C. Tuple
D. Domain
Q9. A column in a table is called:
A. Record
B. Tuple
C. Attribute
D. File
Q10. The set of allowed values for an attribute is called:
A. Relation
B. Tuple
C. Domain
D. Schema
Q11. A candidate key is:
A. Any attribute in table
B. A field with duplicate values
C. A minimal set of attributes that uniquely identifies a record
D. A foreign key
Q12. A primary key:
A. Can contain NULL values
B. Can have duplicate values
C. Uniquely identifies each record
D. Is optional
Q13. How many primary keys can a table have?
A. One
B. Two
C. Three
D. Many
Q14. An alternate key is:
A. A key not selected as primary key
B. A foreign key
C. A composite key
D. A duplicate key
Q15. Which key can have duplicate values?
A. Primary key
B. Candidate key
C. Alternate key
D. Non-key attribute
Q16. A relation consists of:
A. Rows only
B. Columns only
C. Rows and columns
D. Files
Q17. Which of the following can be a primary key?
A. Student name
B. Roll number
C. Age
D. Address
Q18. Which key ensures entity integrity?
A. Alternate key
B. Candidate key
C. Primary key
D. Foreign key
Q19. A table with no rows is called:
A. Empty relation
B. Null relation
C. Undefined table
D. Schema
Q20. Attributes are also known as:
A. Records
B. Fields
C. Tuples
D. Files
Q21. SQL stands for:
A. Structured Query Language
B. Simple Query Language
C. Sequential Query Language
D. Structured Question Language
Q22. SQL is used for:
A. Designing web pages
B. Managing databases
C. Editing images
D. Writing programs
Q23. Which of the following is a DDL command?
A. SELECT
B. INSERT
C. CREATE
D. UPDATE
Q24. Which command is used to create a database?
A. CREATE TABLE
B. CREATE DATABASE
C. NEW DATABASE
D. MAKE DATABASE
Q25. Which SQL command is used to delete a table permanently?
A. DELETE
B. REMOVE
C. DROP
D. CLEAR
Q26. ALTER command is used to:
A. Delete records
B. Modify table structure
C. Insert records
D. Display data
Q27. Which data type is used to store whole numbers?
A. CHAR
B. VARCHAR
C. INT
D. FLOAT
Q28. Which data type is used to store decimal values?
A. INT
B. CHAR
C. FLOAT
D. DATE
Q29. Which SQL category does SELECT belong to?
A. DDL
B. DML
C. DQL
D. TCL
Q30. Which command is used to view data from a table?
A. SHOW
B. VIEW
C. SELECT
D. DISPLAY
Q31. The WHERE clause is used to:
A. Sort data
B. Filter records
C. Insert data
D. Delete table
Q32. Which operator is used to check range of values?
A. IN
B. BETWEEN
C. LIKE
D. IS
Q33. Which operator checks multiple conditions?
A. BETWEEN
B. AND
C. IS
D. NULL
Q34. Which operator is used to check missing values?
A. =
B. !=
C. IS NULL
D. LIKE
Q35. Which operator is used to check non-missing values?
A. NOT NULL
B. != NULL
C. IS NOT NULL
D. <> NULL
Q36. Which relational operator means “not equal to”?
A. =
B. <>
C. <=
D. >=
Q37. Logical OR returns TRUE when:
A. Both conditions are true
B. Any one condition is true
C. Both conditions are false
D. None is true
Q38. Which clause is mandatory in SELECT statement?
A. WHERE
B. FROM
C. ORDER BY
D. GROUP BY
Q39. Which keyword selects all columns?
A. ALL
B. EVERYTHING
C. *
D. %
Q40. SELECT * FROM student; means:
A. Select student names
B. Select all rows
C. Select all columns and rows
D. Select database
Q41. INSERT command is used to:
A. Modify data
B. Delete data
C. Add new records
D. View records
Q42. Which command modifies existing records?
A. INSERT
B. DELETE
C. UPDATE
D. ALTER
Q43. DELETE command removes:
A. Table structure
B. Database
C. Records from table
D. Columns only
Q44. DELETE without WHERE clause will:
A. Delete specific records
B. Delete table
C. Delete all records
D. Show error
Q45. UPDATE command always uses:
A. FROM clause
B. SET clause
C. VALUES clause
D. INTO clause
Q46. Which command removes database permanently?
A. DELETE DATABASE
B. REMOVE DATABASE
C. DROP DATABASE
D. CLEAR DATABASE
Q47. Which SQL command is irreversible?
A. SELECT
B. UPDATE
C. INSERT
D. DROP
Q48. Which clause is used to specify condition in UPDATE?
A. FROM
B. WHERE
C. SET
D. INTO
Q49. Which command adds a new column to a table?
A. INSERT
B. MODIFY
C. ALTER
D. UPDATE
Q50. DML commands affect:
A. Database structure
B. Table structure
C. Data stored in tables
D. Database software
END…………………………..