Chapter-1: Computer System: Multiple Choice Questions

IP_IMPORTANT QUESTIONS
Chapter-1: Computer system

Multiple choice questions
1. Which of the following components is the main memory of computer?
a)CD b)DVD c)Internal hard drive d)RAM
2. The physical component of a computer are called----------
a) Software b) Hardware c) ALU d) CPU
3. Which of the following is available without any payment?
a) Freeware b) Free software c) OSS d) Hard disk
Fill in the Blanks
4. The ___________memory is special high-speed memory storing the most
recently accessed data.
5. Antivirus software is a type of …………….
6. Windows OS is type of ………………..
Shot Answer Questions /Conceptual Questions.
7. What is the function of memory? What are its measuring units?
8. Give example for each system software and application software. Explain
the function of each type
9. What is the difference between RAM and ROM?
10. What is cache memory? Why is it considered crucial for a
microprocessor’s performance?
11. What is the difference between an interpreter and a compiler?
12. Describe the terms free software and open software.
13. Convert following into bytes.
a)2MB b)3.7GB c)1.7 TB
14. Identify the category (system, application, programming tool) of the
following software.
a) compiler b) Assembler c) Ubuntu d) Text editor.
15. Mention any browsers used for browsing the internet.
Chapter-2: GETTING STARTED WITH PYTHON

16. Python is a/an ______________language.
a) High level b) Object oriented c) Procedural d) difficult
17. Python uses a/an __________to convert source code to object code.
a) Interpreter b) compiler
c)combination of Interpreter and compiler d) special virtual engine
18. The _______mode of Python gives instant result of typed statement.
a) Interactive Mode b) Script mode
c) A combination of interactive mode and script modes. d)All of these
19. Which of the following is not a Python IDE?

a)IDLE b)Spyder c)Jupyter Notes d)Sublime Text.
Fill in the Blanks
20. Python is a __________level language
21. Python’s two working modes are :_____mode and ___mode
22. The shortcut key to run a Python program from script mode is________
True/False Questions
23. Python is the fastest language
24. Python code is compiled before running.
25. You can create programs in Python’s interactive mode.
26. Who developed Python programming language?
27. Is python an object-oriented language?
28. Python is an interpreted high-level language’, What does it mean to
you?
29. What does a cross platform language mean?
30. Which of the following are not valid strings in Python?
a) ” Hello” b) ’Hello’ c)” Hello’ d) ’Hello” e) {Hello }
Chapter-3:- PYTHON FUNDAMENTALS.
31. Special meaning words of Python, fixed for specific functionality are
called __________________
a) Identifier b) functions c) Keywords d) literals
32. Names given to different parts of a Python program are______________
33. Data items having fixed value are called__________________
34. Which of the following are literals?
a)myname b)”Radha” c)24.5 d)24A
35. Which of the following is an escape sequence for a tab character?

a)\a b)\t c)\n d)\b
36. Which of the following is an escape sequence for a newline character?
a)\a b)\t c)\n d)\b
37. Value 17.25 is equivalent to
a)0.1725E-2 b) 0.1725E+2 c) 1725E2 d) 0.1725E2
Fill in the Blanks
38. A_________is a reserved word carrying special meaning and purpose
39. _____are the user defined names for different parts of a program
40. _____are the fixed values.
41. ________are the symbols that trigger some computation or action
42. Keyword can be used a identifier names.
43. You can rename a keyword
44. A variable can contain values of different types at different times.
45. Print ( ) without any argument adds an invisible newline character.
46. What is the difference between keyword and an identifier?
47. What will be the sizes of following constants?
‘\a’, “\a”, \” Reema\’s”, “it’s”, “xy\, ””” XY
48. How many types of strings are supported in Python?
49. What is following code giving errors ?
name=”Rehman”
print(“Greeting !!!!”)
print(“Hello “,name)
print(“How do you do?”)
50. Which of the following identifier names are invalid and why?
a)Seril_no, b)1st_room c)Hundred$ d)Total Marks e)Total-
marks f)_Percentage h)True
51. Write a program to find the average of 3 numbers
52. What are tokens in Python? How many tokens are allowed in Python?
Chapter-8:- DATABASE CONCEPTS.

53. ______is a an organized collection of structured data.
54. A database _________is the snapshot/state of a database at an instance
of a time
55. __________refers to the data about data
56. Special legal empty value allowed in a database is____________
57. __________is a field in a database table (or a combination of fields) that
has a unique value.
58. If defines the structures of database components
a)SQL b)DDL c)DML d)TCL
59. It gives commands to manipulate data in database.
a)SQL b)DDL c)DML d)TCL
60. _________is a free and opensource relational database.
a)MS-Access b)SQL server c)MySQL d)All of these
Fill in the Blanks

61. A_________is a software program that maintains a database.
62. A database _____________is a skeleton of design of database.
63. Metadata is stored in _______ ___________
64. A________is a type of command used to retrieve data from a database
65. SQL’s Full form is ------- ------- --------
66. Full form of DDL is…………………….
67. Full form of DML is………………
68. Full form of TCL is………………
69. Number of columns in relation is called its ____________
70. Data redundancy may lead to data inconsistency
71. Organized collection of data is called DBMS
72. A software that manages and maintains a database is called DBMS
73. All candidate keys are primary keys
74. Each primary key is also a candidate key, but there may be candidate
keys that are not primary keys.
75. What is database system? What is its need?
76. List three significant differences between a file processing system and a
DBMS.
77. Define terms
a) Relation b) Tuple c) Attribute d) degree e) cardinality
f) Alternate key g) Primary key h) Foreign key i) composite key
78. What is purpose of using MySQL
79. Differentiate between DDL and DML commands
Chapter-9: - STRUCTURED QUERY LANGUAGE(SQL).

80. An attribute in a relation is a foreign key if it is the _________key in any
other relation
81. Consider the table with statement as:
Student(ID, name, dept name, tot_cred)
In the above table, which attribute will form the primary key?
a)Name b)Dept c)Total_cred e)ID
82. Which of the following sublanguage of SQL is used to query information
form the database and to insert tuples into, delete tupels from , and
modify tupels in the database ?
a)DML b)DDL c)DCL d)Relational schema
83. The data types CHAR(n) and VARCHAR(n) are used to create_____and
_______types of string/text fields in a database.
a) Fixed equal b) Equal variable c) Fixed, Variable d) Variable, equal
84. In the given query which keyword has to be inserted.
ISNERT INTO employee_______(1002,’Kumar’,2000)
a)Table b)values c)relation d)field
85. Which operator performs pattern matching?
a)BETWEEN operator b)LIKE operator c)Exists operator d)None of these
86. The condition in a WHERE clause in a SELECT query can refer to only
one value.
87. SELECT DISTINCT is used if a user wishes to see duplicate columns in
a query.
88. ORDER BY can be combined with the SELECT statements.
89. The keyword BETWEEN can be used in a WHERE clause to refer to a
range of values.
90. Differentiate between CHAR and VARCHAR datatypes
91. A database is create with the following SQL commands to store the
subject scores of a class of students in an examination. REG_NO and
SUB_CODE represents the registration number of a student and the
code of a subject respectively

Chapter-1: Computer System: Multiple Choice Questions

Uploaded by

Copyright:

Available Formats

Chapter-1: Computer System: Multiple Choice Questions

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Chapter-1: Computer System: Multiple Choice Questions

Uploaded by

Copyright:

Available Formats

IP_IMPORTANT QUESTIONS

Chapter-1: Computer system

Chapter-2: GETTING STARTED WITH PYTHON

c) A combination of interactive mode and script modes. d)All of these

19. Which of the following is not a Python IDE?

a)myname b)”Radha” c)24.5 d)24A

35. Which of the following is an escape sequence for a tab character?

Chapter-8:- DATABASE CONCEPTS.

Fill in the Blanks

Chapter-9: - STRUCTURED QUERY LANGUAGE(SQL).

You might also like