2nd Year Computer Science Chapter 1 – Data Basics Notes MCQs Bank

computer 12th notes chapter No 1

1. In ⎯⎯⎯⎯ data base models, a complex diagram may be used to represent the  structure of database:

 
 
 
 

2. Which of the following is not related to data manipulation:

 
 
 
 

3. The process in which the contents are accessed in a sequence is called:

 
 
 
 

4. ⎯⎯⎯⎯ identifies the data items to be stored into database and the relationships  between them:

 
 
 
 

5. ⎯⎯⎯⎯ files contains information that remains constant over a long period of  time:

 
 
 
 

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

 
 
 
 

7. The extension for a video file is

 
 
 
 

8. Communicating the information through internet is related to: 

 
 
 
 

9. A collection of logically related data is called. 

 
 
 
 

10. ⎯⎯⎯⎯ file type is executable file and contains the set of program’s  instructions:

 
 
 
 

11. The type of files from storage point of view may include:

 
 
 
 

12. ⎯⎯⎯⎯ is related to personnel, a component of DBMS:

 
 
 
 

13. The techniques used to write and retrieve data to and from the storage devices are  called:

 
 
 
 

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

 
 
 
 

15. ⎯⎯⎯⎯ is also called data set:

 
 
 
 

16. Database file has a file extension:

 
 
 
 

17. Which one is not an SQL statement 

 
 
 
 

18. DBA Stands for 

 
 
 
 

19. Arrangement of data in a particular order is 

 
 
 
 

20. ⎯⎯⎯⎯ data base models has the shape like an organization chart:

 
 
 
 

21. In ⎯⎯⎯⎯ activity data is collected and recorded:

 
 
 
 

22. ⎯⎯⎯⎯ is the component of DBMS:

 
 
 
 

23. Which of the following represents a collection of concepts that are used to describe the structure of a database:

 
 
 
 

24. The Latest update files are 

 
 
 
 

25. SQL is a(n)

 
 
 
 

26. Which of the following may be a temporary file

 
 
 
 

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

 
 
 
 

28. The manipulated and processed data is called:

 
 
 
 

29. A collection of data that include name, address, NIC number, phone number etc.  of an employee represents:

 
 
 
 

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

 
 
 
 

31. SQL can be used to:

 
 
 
 

32. ⎯⎯⎯⎯ files type is used to update data in master file:

 
 
 
 

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

 
 
 
 

34. The file name and the extension are separated by a:

 
 
 
 

35. Which one is not advanced capability of DBMS 

 
 
 
 

36. A table with related records is referred to as:

 
 
 
 

37. ⎯⎯⎯⎯ represents an object:

 
 
 
 

38. The process of arranging data in a logical sequence is called:

 
 
 
 

39. Which of the following data model is more flexible:

 
 
 
 

40. Which file is used to store information that remains constant for a long time?

 
 
 
 

41. Information sharing means that:

 
 
 
 

42. Which of the following refers to the correctness and consistency of data: 

 
 
 
 

43. DBMS stands for 

 
 
 
 

44. A database containing all students in a class would store basic data of students in

 
 
 
 

45. To convert data into information we need some 

 
 
 
 

46. Which of the following data model has general shape of an organization chart?

 
 
 
 

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

 
 
 
 

48. Storage and retrieval of data is related to:

 
 
 
 

49. Which one refers data capturing 

 
 
 
 

50. SQL is a(n) 

 
 
 
 

51. Which of the following file contains the software instructions?

 
 
 
 

52. A collection of related fields is called:

 
 
 
 

53. A collection of data that consists of name, address and email of a person is called:

 
 
 
 

54. Collection of programs used to manage database 

 
 
 
 

55. The file extension of a program file is 

 
 
 
 

56. Which of the following are the components of DBMS:

 
 
 
 

57. ⎯⎯⎯⎯ problems occurs in traditional file system:

 
 
 
 

58. Multiple copies of the same data is referred to as:

 
 
 
 

59. The objectives of database may include:

 
 
 
 

60. Which of the following is an image file extension?

 
 
 
 

61. A collection of raw facts and figure is called:

 
 
 
 

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

 
 
 
 

63. ⎯⎯⎯⎯ contains data definitions used in the database:

 
 
 
 

64. The printed or onscreen display of data or information in the database is called:

 
 
 
 

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

 
 
 
 

66. Each column in a table represents a:

 
 
 
 

67. Which of the following contain data definitions:

 
 
 
 

68. Which of the following is a query language:

 
 
 
 

69. The objectives of database system or DBMS may include:

 
 
 
 

70. ⎯⎯⎯⎯ is handled by database system or DBMS:

 
 
 
 

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

 
 
 
 

72. Which is not true about data 

 
 
 
 

73. The name of person represents:

 
 
 
 

74. ⎯⎯⎯⎯ data base models is commonly used today:

 
 
 
 

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

 
 
 
 

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

 
 
 
 

77. .doc represents:

 
 
 
 

78. Each row of a table represents a:

 
 
 
 

79. The type of files from functional point of view may include:

 
 
 
 

80. ⎯⎯⎯⎯ is the feature of DBMS:

 
 
 
 

81. Video file has a file extension:

 
 
 
 

82. The extension of a file created in Notepad is:

 
 
 
 

83. A complete information about a particular entity represents a:

 
 
 
 

84. Hardware refers to the 

 
 
 
 

85. ⎯⎯⎯⎯ contains only one type of data:

 
 
 
 

86. Reproduction refers to 

 
 
 
 

87. Which one is not the feature of DBMS 

 
 
 
 

88. In “program.bxt”, “txt” is the location

 
 
 
 

89. ⎯⎯⎯⎯ represents a collection of concepts that are used to describe the  structure of a databas:

 
 
 
 

90. Using information managers can create 

 
 
 
 

91. ⎯⎯⎯⎯ is related to managing output result:

 
 
 
 

92. A file that is used to keep a copy of important data is called:

 
 
 
 

93. The process of arranging data in a proper order is called:

 
 
 
 

94. The term “inverted tree” is used in 

 
 
 
 

95. Batabase is an organized collection of related data

 
 
 
 

96. Which of the following is a computerized record keeping system: 

 
 
 
 

97. A series of actions that are performed on raw data achieve the required objective  and results are called:

 
 
 
 

98. ⎯⎯⎯⎯ database models has no physical connections between entities:

 
 
 
 

99. Which of the following database model has the shape like and organizational  chart:

 
 
 
 

100. Which of the following file extensions represents the image file:

 
 
 
 

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

 
 
 
 

102. Which of the following type of file require largest processing time: 

 
 
 
 

103. Program files contain 

 
 
 
 

104. ⎯⎯⎯⎯ refers to the correctness and consistency of data:

 
 
 
 

105. database containing all students in a class would store Roll No of a student in:

 
 
 
 

106. Audio file has a file extension:

 
 
 
 

107. The data can be recovered in case of loss by using:

 
 
 
 

108. ⎯⎯⎯⎯ files requires largest processing time:

 
 
 
 

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

 
 
 
 

110. Which of the following is handled by DBMS?

 
 
 
 

111. ⎯⎯⎯⎯ may be a temporary file:

 
 
 
 

112. Manipulation of data to achieve the required objectives and result is called

 
 
 
 

113. Which files organization uses the magnetic storage media:

 
 
 
 

114. The process of making duplicate copies of output result is called:

 
 
 
 

Short Questions

1. Define communication and reproduction?
2. Define data inconsistency.
3. Define data redundancy.
4. Define data.
5. Define database.
6. Define field.
7. Define file.
8. Define information.
9. Define record.
10. Differentiate between data and information.
11. Differentiate between data redundancy and data inconsistency.
12. Differentiate between master file and transaction file.
13. Give an example of data and its corresponding information.
14. Give one example for master and transaction file.
15. How are records stored in indexed sequential file organization?
16. How data is useful for an organization?
17. How does the sequential file organization store files?
18. How the records are stored in direct or random file organization?
19. Is there any disadvantage of sequential access?
20. List different activities in data processing>
21. List the file types from usage point of view.
22. Name different types of file organization?
23. Name the file types from usage point of view.
24. Name three file organizations from storage point of view.
25. What are backup files?
26. What are data files?
27. What are direct or random access files?
28. What are indexed files?
29. What are program files?
30. What are sequential files?
31. What are the activities performed on data?
32. What are the major components of the database?
33. What are the master files?
34. What are the objectives of the Database Management System (DBMS)?
35. What are transaction files?
36. What do you mean by consistency constraint?
37. What do you mean by data manipulation?
38. What do you mean by file organization?
39. What is a data dictionary?
40. What is a database?
41. What is a field?
42. What is a file extension?
43. What is a file?
44. What is a network model?
45. What is a record?
46. What is availability?
47. What is data integration?
48. What is data integrity?
49. What is data interdependence?
50. What is data manipulation?
51. What is data processing?
52. What is database integrity?
53. What is database management system?
54. What is DBMS?
55. What is direct or random files?
56. What is evolvability?
57. What is hierarchical?
58. What is meant by “access security”?
59. What is meant by a record?
60. What is meant by data independence?
61. What is program file?
62. What is shareability?
63. What is SQL?
64. What is storing/retrieval?
65. What is the difference between data and information?
66. What is the manipulation of data?
67. What is the relational model?
68. Which problems occur due to data redundancy?
69. Why is it important to specify data type and size of a field?
70. Write some advantages of database systems?
71. Write some disadvantages of database systems?
72. Write some features of DBMS?
73. Write some types of operations that may be performed on data?
74. Write the advantage of random access as compared to sequential access.
75. Write the file types from functional point of view.
76. Write the names of files regarding usage point of view?
77. Write the names of files storage point of view?
78. Write the objectives of the database?
79. Write types of files functional point of view?

Long Questions

1. What is data and information also discuss different operations performed on data?
2. How data is stored and retrieved in FMS?
3. Discuss different types of files.
4. What is a database and DBMS? Give examples of database and facilities of databases.
5. What are the objectives of databases?
6. What are different types of database models? Explain with the help of diagrams.
7. Write down the advantages and disadvantages of a Database system.
8. What is a DBMS? Also discuss its objectives and features.
9. What are the objects or components of database system?
10. What is a traditional file system? What are the problems faced in traditional file system? Briefly describe the basic units of information.

Leave a Reply

Your email address will not be published. Required fields are marked *