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 .
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?
- Data warehouse
- Data structure
- Data model
- 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?
- Master file
- Transaction file
- Backup file
- None of these
5. SQL is a(n)
- Unstructured Language
- Structured language
- Object oriented language
- 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.
- Data Independence
- Data Integration
- Data Integrity
- Data Model
27. Which of the following data models is the most commonly used.
- Hierarchical Model
- Network Model
- Relational Model
- None of above
28. Which of the following is a computerized record keeping system choose which one is correct?
- Data system
- Database
- File System
- DBMS
29. DBA Stands for
- Data Business Adminstrator
- Database Administrator
- Data Basic Applicaiton
- Database Application
30. Which of the following are the components of DBMS choose which one is correct?
- Hardware
- Software
- Personnel
- All of above
31. Which of the following contain data definitions choose which one is correct?
- Data Dictionary
- Database
- Database Integrity
- All of above
32. Which of the following is a query language choose which one is correct?
- DBMS
- Utilities
- Report
- SQL
33. The name of person represents choose which one is correct:
- Field
- Record
- File
- None of these
34. A complete information about a particular entity represents a choose which one is correct:
- Field
- Record
- File
- None of these
35. Each column in a table represents a choose which one is correct:
- Field
- Record
- File
- None of these
36. Each row of a table represents a choose which one is correct:
- Field
- Record
- File
- None of these
37. A table with related records is referred to as choose which one is correct:
- Field
- Record
- File
- None of these
38. The process of making the copy of original is called
- Storage
- Retrieval
- Backup
- None of above
39. Arrangement of data in a particular order is
- Searching
- Sorting
- Storing
- Summarizing
40. The file extension of a program file is
- EXE
- Com
- prog
- both a and b
41. Which is not true about data
- Facts
- Figures
- Meaningful
- Cannot be used for decision making
42. Using information managers can create
- Useful Reports
- Graphs
- Statistics
- All of Above
43. To convert data into information we need some
- Input
- Output
- Processing
- All of Above
44. Which one refers data capturing
- Getting Data
- Calculation
- Placing
- Sorting
45. Reproduction refers to
- Making Data Readable
- Making Data Clear
- Making Data Presentable
- Making Data Duplicate
46. Which one is not a file type with reference to usage point of view
- Transaction File
- Master File
- Program File
- Backup File
47. Which one is a file type with reference to usage point of view
- Transaction File
- Data File
- Program File
- Sequential File
48. ⎯⎯⎯⎯ is also called data set choose which one is correct:
- Field
- Record
- File
- All
49. ⎯⎯⎯⎯ contains only one type of data choose which one is correct:
- Field
- Record
- File
- Database
50. ⎯⎯⎯⎯ files contains information that remains constant over a long period of time choose which one is correct:
- Master file
- Backup file
- Transaction file
- 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:
- Data security
- Data independence
- Data integrity
- All of these
95. ⎯⎯⎯⎯ is the feature of DBMS choose which one is correct:
- Data dictionary
- Backup & Recovery
- Query language
- All of these
96. DBMS stands for
- Databasics Methodology System
- Database Managerial System
- Database Management System
- None of Above