MCQ – Practice Paper for IP (Paper – 2)
Prepare for your CBSE Class 12 Information Practice exam with these 18 carefully crafted multiple-choice questions. Before this you can also attempt “MCQ – Practice Paper for IP (Paper – I)“. This practice test covers essential topics including Python Pandas, Matplotlib, Networking, and MySQL. Take this quiz to test your understanding and boost your confidence for the final boards.
| 1. Which of the following is an example of absolute URL? | |||||||||||||
| a) Studytrigger.com | b) https://www.studytrigger.com | c) /art/Asesment-1.html | d) All of these | ||||||||||
| Answer : b) https://www.studytrigger.com | |||||||||||||
| 2. Kanan is working on MySQL. She wants to count the employees not earning commission from the table emp. Which of the following is correct statement for her? | |||||||||||||
| a) Select Count(empno) from emp where commission is not null; | |||||||||||||
| b) Select Count(empno) from emp where commission is null; | |||||||||||||
| c) Select Count(empno) from emp where commission = null; | |||||||||||||
| d) Select Count(empno) from emp where commission = ‘null’; | |||||||||||||
| Answer : b) Select Count(empno) from emp where commission is null; | |||||||||||||
| 3. Nirmal has written following code to get the last five records from Series Object S, but he is not getting the correct output
print(S.bottom(5)) Help him by selecting an appropriate option from the following to get his desired result? |
|||||||||||||
| a) S.last() | b) S.tail() | ||||||||||||
| c) S.trail() | d) S.end() | ||||||||||||
| Answer : b) S.tail() | |||||||||||||
| 4. Which of the following functions is used to import a dataframe from csv file? | |||||||||||||
| a) read_csv() | b) import_csv() | c) to_csv() | d) export_csv() | ||||||||||
| Answer : a) read_csv() | |||||||||||||
| 5. Cookies are used to do which of the following | |||||||||||||
| a) Store your id and password for subsequent logins to the site. | |||||||||||||
| b) Store contents of electronic shopping cart | |||||||||||||
| c) Track web activity | |||||||||||||
| d) All of these | |||||||||||||
| Answer : d) All of these | |||||||||||||
| 6. Which of the following is not an attribute of series | |||||||||||||
| a) count | b) index | c) columns | d) hasnan | ||||||||||
| Answer : a) count | |||||||||||||
| 7. Which of the following is not an numeric function? | |||||||||||||
| a) Round( ) | b) SQRT( ) | c) Count( ) | d) Mod( ) | ||||||||||
| Answer : c) Count() : it is an aggregate function. | |||||||||||||
8. Consider the following series object Named ‘Ser’
What will be the output of following statement : print(Ser.index) |
|||||||||||||
| a) 0,1,2,3,4 | b) [578, 235, 560, 897, 118] | c) Both a and b) | d) None of these | ||||||||||
| Answer: a) 0,1,2,3,4 | |||||||||||||
| 9. ‘V’ in VoIP stands for: | |||||||||||||
| a) Volume | b) Voice | c) Virtual | d) Video | ||||||||||
| Answer : b) Voice | |||||||||||||
| 10. Linux, MySQL and Mozilla Firefox software come under which category | |||||||||||||
| a) Propriety | b) FOSS | c) Freeware | d) Shareware | ||||||||||
| Answer : b) FOSS : FOSS (Free and Open-Source Software) allows users to freely use, modify, and distribute the software. The source code is open for everyone. Freeware, on the other hand, is free to use but does not provide access to the source code, meaning users cannot modify or redistribute it. |
|||||||||||||
| 11. Which one of the following functions is used to find the weekday name for a given date in MySQL | |||||||||||||
| a) Weekday() | b) Week() | c) Day() | d) Dayname() | ||||||||||
| Answer : Dayname() | |||||||||||||
| 12. Which attribute is used to get total number of elements in Series? | |||||||||||||
| a) Values | b) Shape | c) NDIM | d) SIZE | ||||||||||
| Answer : d) Size | |||||||||||||
| 13. Which of the following is not an example of a network device? | |||||||||||||
| a) Router | b) Repeater | c) Hub | d) None | ||||||||||
| Answer: d) None | |||||||||||||
| 14. Soham uploaded one video in his youtube channel where he used one background music downloaded from somewhere on internet without giving credit to the source. He is violating | |||||||||||||
| a) IPR | b) Patent | c) Copyright | d) None | ||||||||||
| Answer : c) Copyright | |||||||||||||
| 15. Which function in sql, we can use similarly as substr() | |||||||||||||
| a) instr() | b) mid() | c) middle() | d) between | ||||||||||
| Answer : b) mid() | |||||||||||||
| 16. Which of the following is a type of cyber crime? | |||||||||||||
| a) Data theft | b) laptop theft | c) installing antivirus | d) None | ||||||||||
| Answer : a) Data theft | |||||||||||||
| Q17 and Q 18 are ASSERTION and REASONING based questions. Mark the correct choice as | |||||||||||||
| Both A and R are True and R is the correct explanation for A. | |||||||||||||
| Both A and R are True and R is not the correct explanation for A. | |||||||||||||
| A is True but R is False | |||||||||||||
| A is False but R is True | |||||||||||||
| 17. Assertion (A) : DataFrame has both a row and column index. | |||||||||||||
| Reasoning (R) : A DataFrame is a 2-D labelled data structure like a table of MySQL. | |||||||||||||
| Answer : a) Both A and R are True and R is the correct explanation for A. | |||||||||||||
| 18. Assertion (A) : Social media are websites or applications that enable their users to partipate in social networking but they cannot create and share content with others in the community. | |||||||||||||
| Reasoning (R) : We should not waste precious time in responding to unnecessary emails ot comments unless they have some relevance for us. | |||||||||||||
| Answer : d) A is False but R is True | |||||||||||||
I hope these MCQs have helped you in your preparation for the CBSE Class 12 Information Practice exam. If you haven’t already, I recommend practicing MCQ – Practice Paper for IP (Paper – I) first to build a strong foundation. If you feel the need for more practice, don’t worry! You can continue to the next part of this series with MCQ – Practice Paper for IP (Paper – 3), where you’ll find additional MCQs to further strengthen your skills. Keep practicing, and best of luck with your exams!
