12th Class Class Computer Mcqs Chapter No 1 | 2nd Year Computer Mcqs Chapter Wise Pdf

written by Assad Javaid | August 6, 2021

MCQsFoundry.com brings to you all 12th Standard Computer Mcqs / Mcq For Class 12 Computer Science Pdf which are new and latest. These Class 12 Computer Science Chapter Wise Questions are never published on internet so far. For full information about all PPSC / FPSC / CSS / PMS latest jobs visit theiteducation.com


We are providing accurate 2nd year computer mcqs chapter wise pdf. You can read 2nd year computer science mcqs with answers.

Moreover from this platform you are able to read 2nd year computer mcqs pdf and if you want to test your self or want to take any quiz related to these 2nd year computer science mcqs chapters then you are also able to take 12th computer science mcqs chapter wise test .

12th Class Class Computer Mcqs Chapter No 1 | 2nd Year Computer Mcqs Chapter Wise Pdf
12th Computer Science MCQ’s with Answers Chapter no 1 12th Computer Science MCQ’s with Answers Chapter no 2
12th Computer Science MCQ’s with Answers Chapter no 3 12th Computer Science MCQ’s with Answers Chapter no 4
12th Computer Science MCQ’s with Answers Chapter no 5 12th Computer Science MCQ’s with Answers Chapter no 6
12th Computer Science MCQ’s with Answers Chapter no 7 12th Computer Science MCQ’s with Answers Chapter no 8
12th Computer Science MCQ’s with Answers Chapter no 9 12th Computer Science MCQ’s with Answers Chapter no 10
12th Computer Science MCQ’s with Answers Chapter no 11 12th Computer Science MCQ’s with Answers Chapter no 12
12th Computer Science MCQ’s with Answers Chapter no 13 12th Computer Science MCQ’s with Answers Chapter no 14
12th Computer Science MCQ’s with Answers Chapter no 1 | 2nd Year Computer Science Mcqs

Chapter No 1

Data basics

1. Which of the following represents a collection of concepts that are used to describe the structure of a database choose which one is correct? 

  1. Data warehouse
  2. Data structure 
  3. Data model
  4. Data type 

2. Which of the following data model is more flexible choose which one is correct? 

  • Network data model
  • Hierarchical data model  
  • Relational data model
  • Object data model 

3. Which of the following type of file require largest processing time choose which one is correct?  

  • Sequential file
  • Random file
  • Indexed sequential file
  • Direct access file 

4. Which of the following may be a temporary file choose which one is correct? 

  1. Master file
  2. Transaction file 
  3. Backup file
  4. None of these 

5. SQL is a(n) 

  1. Unstructured Language
  2. Structured language 
  3. Object oriented language
  4. Software 

6. A collection of raw facts and figures is called choose which one is correct: 

  • Data
  • Information 
  • Database
  • Data capturing

7. Which of the following is not related to data manipulation choose which one is correct? 

  • Summarizing
  • Data capturing
  • Classifying
  • Calculations 

8. ⎯⎯⎯⎯ represents an object choose which one is correct: 

  • Person
  • Organization 
  • An event
  • All of these

9. The manipulated and processed data is called choose which one is correct: 

  • Raw data
  • Information
  • Object
  • None of these 

10. A series of actions that are performed on raw data achieve the required objective  and results are called choose which one is correct: 

  • Operation
  • Data processing 
  • Processes
  • Both (a) and (b)

11. In ⎯⎯⎯⎯ activity data is collected and recorded choose which one is correct: 

  • Data capturing
  • Data Manipulating 
  • Managing result
  • None of these 

12. In a school the record of cricket and hockey team organized into two groups is  referred as 

  • Classifying
  • Summarizing 
  • Sorting
  • Searching 

13. A set of related characters that represent a unit of data is called  

  • File
  • Record 
  • Field
  • Database 

14. A set of related fields that represent a unit of data is called 

  • File
  • Record
  • Field
  • Database 

15. A set of related records that represent a unit of data is called 

  • File
  • Record 
  • Field
  • Database

16. A set of related files that represent a unit of data is called 

  • File
  • Record 
  • Field
  • Database

17. Which of the following refers to the correctness and consistency of data choose which one is correct?  

  • Data Independence
  • Data Integration 
  • Data Integrity
  • Data Structure 

18. Which of the following database model has the shape like and organizational  chart choose which one is correct? 

  • Network Model
  • Hierarchical Model 
  • Relational Model
  • Data Model 

19. In a college, organizing the record of Science and Arts students into two groups,  this activity is referred to as 

  • Sorting
  • Summarizing 
  • Classifying
  • None of these 

20. The process of arranging data in a proper order is called choose which one is correct: 

  • Sorting
  • Summarizing 
  • Classifying
  • Data capturing 

21. Storage and retrieval of data is related to choose which one is correct: 

  • Data capturing
  • Data Manipulation 
  • Managing output result
  • None of these 

22. The process of making duplicate copies of output result is called choose which one is correct: 

  • Storage and retrieval
  • Reproduction
  • backup copy
  • Data processing 

23. ⎯⎯⎯⎯ is related to managing output result choose which one is correct: 

  • Storage and retrieval
  • Communications 
  • Reproduction
  • All of these

24. Communicating the information through internet is related to choose which one is correct:  

  • Managing output result
  • Data capturing 
  • Data Manipulation
  • None of these 

25. The term “inverted tree” is used in 

  • Network Model
  • Hierarchical Model 
  • Relational Model
  • None of above

26. The separation of the data structure of database from the application program is  called. 

  1. Data Independence
  2. Data Integration 
  3. Data Integrity
  4. Data Model 

27. Which of the following data models is the most commonly used. 

  1. Hierarchical Model
  2. Network Model 
  3. Relational Model
  4. None of above 

28. Which of the following is a computerized record keeping system choose which one is correct?  

  1. Data system
  2. Database 
  3. File System
  4. DBMS 

29. DBA Stands for 

  1. Data Business Adminstrator
  2. Database Administrator 
  3. Data Basic Applicaiton
  4. Database Application 

30. Which of the following are the components of DBMS choose which one is correct? 

  1. Hardware
  2. Software 
  3. Personnel
  4. All of above

31. Which of the following contain data definitions choose which one is correct? 

  1. Data Dictionary
  2. Database 
  3. Database Integrity
  4. All of above 

32. Which of the following is a query language choose which one is correct? 

  1. DBMS
  2. Utilities 
  3. Report
  4. SQL

33. The name of person represents choose which one is correct: 

  1. Field
  2. Record 
  3. File
  4. None of these 

34. A complete information about a particular entity represents a choose which one is correct: 

  1. Field
  2. Record
  3. File
  4. None of these 

35. Each column in a table represents a choose which one is correct: 

  1. Field
  2. Record 
  3. File
  4. None of these

36. Each row of a table represents a choose which one is correct: 

  1. Field
  2. Record
  3. File
  4. None of these 

37. A table with related records is referred to as choose which one is correct: 

  1. Field
  2. Record 
  3. File
  4. None of these 

38. The process of making the copy of original is called 

  1. Storage
  2. Retrieval 
  3. Backup
  4. None of above 

39. Arrangement of data in a particular order is 

  1. Searching
  2. Sorting
  3. Storing
  4. Summarizing 

40. The file extension of a program file is 

  1. EXE
  2. Com 
  3. prog
  4. both a and b 

41. Which is not true about data 

  1. Facts
  2. Figures 
  3. Meaningful
  4. Cannot be used for decision making 

42. Using information managers can create 

  1. Useful Reports
  2. Graphs 
  3. Statistics
  4. All of Above

43. To convert data into information we need some 

  1. Input
  2. Output 
  3. Processing
  4. All of Above 

44. Which one refers data capturing 

  1. Getting Data
  2. Calculation 
  3. Placing
  4. Sorting 

45. Reproduction refers to 

  1. Making Data Readable
  2. Making Data Clear  
  3. Making Data Presentable
  4. Making Data Duplicate

46. Which one is not a file type with reference to usage point of view 

  1. Transaction File
  2. Master File 
  3. Program File
  4. Backup File

47. Which one is a file type with reference to usage point of view 

  1. Transaction File
  2. Data File 
  3. Program File
  4. Sequential File 

48. ⎯⎯⎯⎯ is also called data set choose which one is correct: 

  1. Field
  2. Record 
  3. File
  4. All 

49. ⎯⎯⎯⎯ contains only one type of data choose which one is correct: 

  1. Field
  2. Record 
  3. File
  4. Database 

50. ⎯⎯⎯⎯ files contains information that remains constant over a long period of  time choose which one is correct: 

  1. Master file
  2.  Backup file 
  3. Transaction file
  4. None of these 

51. ⎯⎯⎯⎯ files type is used to update data in master file choose which one is correct: 

  • Backup file
  • Transaction file
  • Sequential file
  • Data file 

52. A file that is used to keep a copy of important data is called choose which one is correct: 

  • Master file
  • Transaction file 
  • Backup file
  • Data file 

53. The data can be recovered in case of loss by using choose which one is correct? 

  • Master file
  • Program file 
  • Backup file
  • Data file 

54. ⎯⎯⎯⎯ file type is executable file and contains the set of program’s  instructions choose which one is correct: 

  • Backup file
  • Program file 
  • Master file
  • Data file 

55. ⎯⎯⎯⎯ may be a temporary file choose which one is correct: 

  • Master file
  • Transaction file
  • Backup file
  • None of these

56. Which file contains the data prior to the stage of processing 

  • Data File
  • Transaction File 
  • Program File
  • Backup File 

57. The Latest update files are 

57. The Latest update files are 

  • Data File
  • Transaction File 
  • Master File
  • Backup File 

58. Program files contain 

  • Data about program
  • Instructions
  • Data about Transactions
  • Records 

59. In which type of file key fields are stored separately 

  • Program File
  • Indexed Sequential File
  • Sequential File
  • Random File 

60. Hardware refers to the 

  • Database Components
  • Logical Components  
  • Data Components
  • Physical Components

61. Collection of programs used to manage database 

  • Database System
  • DBMS
  • Data System
  • Database Manager

  •  

62. Which one is not advanced capability of DBMS 

  • Online
  • Ad-hoc Reporting 
  • Backup / Recover
  • Speed

63. The extension of a file created in Notepad is choose which one is correct: 

  • .doc
  • .txt 
  • .exe
  • .pad

64. Database file has a file extension choose which one is correct: 

  • .xls
  • .txt 
  • .mdb
  • .mpg 

65. Which of the following file extensions represents the image file choose which one is correct? 

  • .gif
  • .jpg 
  • .bmp
  • All of these 

66. The techniques used to write and retrieve data to and from the storage devices are  called choose which one is correct: 

  • Storage Methods
  • Access Methods
  • None of these
  • Index Methods 

67. Which files organization uses the magnetic storage media choose which one is correct? 

  • Direct
  • Random 
  • Indexed Sequential
  • Sequential 

68. ⎯⎯⎯⎯ files requires largest processing time choose which one is correct: 

  • Sequential file
  • Random file 
  • Indexed sequential files
  • Direct access file 

69. Multiple copies of the same data is referred to as choose which one is correct: 

  • Data integrity
  • Data Redundancy
  • Data inconsistency
  • Both (a) and (b) 

70. Which one is not the feature of DBMS 

  • Utilities
  • Storage
  • Data Dictionary
  • Report Generator 

71. Which one is not an SQL statement 

  • CREATE
  • INSERT 
  • GET
  • SELECT 

72. ⎯⎯⎯⎯ problems occurs in traditional file system choose which one is correct: 

  • Data Redundancy
  • Data inconsistency 
  • Data security
  • All of these 

73. A collection of logically related data is called. 

  • Record
  • Data file 
  • Database
  • None of these

74. A collection of data that include name, address, NIC number, phone number etc.  of an employee represents choose which one is correct: 

  • Data base
  • Field
  • Data set
  • Record 

75. ⎯⎯⎯⎯ refers to the correctness and consistency of data choose which one is correct: 

  • Data independence
  • Data integration 
  • Data integrity
  • Data model 

76. ⎯⎯⎯⎯ identifies the data items to be stored into database and the relationships  between them choose which one is correct: 

  • Data independence
  • Data integration 
  • Data integrity
  • Data model 

77. ⎯⎯⎯⎯ represents a collection of concepts that are used to describe the  structure of a databas choose which one is correct: 

  • Data warehouse
  • Data model 
  • Data structure
  • Data type 

78. ⎯⎯⎯⎯ data base models has the shape like an organization chart choose which one is correct: 

  • Network Model
  • Relational Model 
  • Hierarchical Model
  • None of these 

79. The term “inverted tree” is used in choose which one is correct:

  • Network Model
  • Relational Model 
  • Hierarchical Model
  • None of these

80. In ⎯⎯⎯⎯ data base models, a complex diagram may be used to represent the  structure of database choose which one is correct: 

  • Network Model
  • Relational Model 
  • Hierarchical Model
  • None the these 

81. ⎯⎯⎯⎯ data base models is commonly used today choose which one is correct: 

  • Network Model
  • Relational Model 
  • Hierarchical Model
  • None of these 

82. ⎯⎯⎯⎯ database models has no physical connections between entities choose which one is correct: 

  • Network Model
  • Relational Model
  • Hierarchical Model
  • None of these

83. ⎯⎯⎯⎯ is the component of DBMS choose which one is correct: 

  • Data
  • Hardware 
  • Software
  • All of these 

84. ⎯⎯⎯⎯ is related to personnel, a component of DBMS choose which one is correct: 

  • Application Programmer
  • End users 
  • Database Administrator
  • All of these 

85. ⎯⎯⎯⎯ contains data definitions used in the database choose which one is correct: 

  • Utilities
  • Data Dictionary
  • Database integrity
  • All of these 

86. The printed or onscreen display of data or information in the database is called choose which one is correct: 

  • Entity
  • Report
  • Query
  • Screen 

87. The type of files from functional point of view may include choose which one is correct: 

  • Program file
  • Backup file 
  • Transaction file
  • None of these 

88. The type of files from storage point of view may include choose which one is correct: 

  • Transaction file
  • Sequential file
  • Backup file
  • Data file 

89. Video file has a file extension choose which one is correct: 

  • avi
  • wav 
  • .mpg
  • both (a) & (c)

90. Audio file has a file extension choose which one is correct: 

  • .avi
  • .wav 
  • mid
  • both (b) & (c) 

91. .doc represents choose which one is correct: 

  • File name
  • File extension
  • File type
  • None of these 

92. The objectives of database may include choose which one is correct: 

  • data integration
  • data independence 
  • data integrity
  • All of these

93. The objectives of database system or DBMS may include choose which one is correct: 

  • Database integrity
  • Availability 
  • Evolveability
  • All of these 

94. ⎯⎯⎯⎯ is handled by database system or DBMS choose which one is correct: 

  1. Data security
  2. Data independence 
  3. Data integrity
  4. All of these

95. ⎯⎯⎯⎯ is the feature of DBMS choose which one is correct: 

  1. Data dictionary
  2. Backup & Recovery 
  3. Query language
  4. All of these

96. DBMS stands for 

  1. Databasics Methodology System
  2. Database Managerial System 
  3. Database Management System
  4. None of Above 

<Previous Chapter

Take Quiz No 1

Next Chapter >