 |
| Computer Science 12th Chapter 1 - Data Basics Questions Bank |
Computer Science 2nd Year Chapter 1 - Data Basics Solved MCQs, Important Short Questions and Long Questions Bank
MCQs
Please select the right answer.
1. .doc represents:
2. ⎯⎯⎯⎯ contains data definitions used in the database:
3. ⎯⎯⎯⎯ contains only one type of data:
4. ⎯⎯⎯⎯ data base models has the shape like an organization chart:
5. ⎯⎯⎯⎯ data base models is commonly used today:
6. ⎯⎯⎯⎯ database models has no physical connections between entities:
7. ⎯⎯⎯⎯ file type is executable file and contains the set of program’s instructions:
8. ⎯⎯⎯⎯ files contains information that remains constant over a long period of time:
9. ⎯⎯⎯⎯ files requires largest processing time:
10. ⎯⎯⎯⎯ files type is used to update data in master file:
11. ⎯⎯⎯⎯ identifies the data items to be stored into database and the relationships between them:
12. ⎯⎯⎯⎯ is also called data set:
13. ⎯⎯⎯⎯ is handled by database system or DBMS:
14. ⎯⎯⎯⎯ is related to managing output result:
15. ⎯⎯⎯⎯ is related to personnel, a component of DBMS:
16. ⎯⎯⎯⎯ is the component of DBMS:
17. ⎯⎯⎯⎯ is the feature of DBMS:
18. ⎯⎯⎯⎯ may be a temporary file:
19. ⎯⎯⎯⎯ problems occurs in traditional file system:
20. ⎯⎯⎯⎯ refers to the correctness and consistency of data:
21. ⎯⎯⎯⎯ represents a collection of concepts that are used to describe the structure of a databas:
22. ⎯⎯⎯⎯ represents an object:
23. A collection of data that consists of name, address and email of a person is called:
24. A collection of data that include name, address, NIC number, phone number etc. of an employee represents:
25. A collection of logically related data is called.
26. A collection of raw facts and figure is called:
27. A collection of related fields is called:
28. A complete information about a particular entity represents a:
29. A database containing all students in a class would store basic data of students in
30. A file that is used to keep a copy of important data is called:
31. A series of actions that are performed on raw data achieve the required objective and results are called:
32. A set of related characters that represent a unit of data is called
33. A set of related fields that represent a unit of data is called
34. A set of related files that represent a unit of data is called
35. A set of related records that represent a unit of data is called
36. A table with related records is referred to as:
37. Arrangement of data in a particular order is
38. Audio file has a file extension:
39. Batabase is an organized collection of related data
40. Collection of programs used to manage database
41. Communicating the information through internet is related to:
42. database containing all students in a class would store Roll No of a student in:
43. Database file has a file extension:
44. DBA Stands for
45. DBMS stands for
46. Each column in a table represents a:
47. Each row of a table represents a:
48. Hardware refers to the
49. In ""program.bxt"", ""txt"" is the location
50. In a college, organizing the record of Science and Arts students into two groups, this activity is referred to as
51. In a school the record of cricket and hockey team organized into two groups is referred as
52. In which type of file key fields are stored separately
53. In ⎯⎯⎯⎯ activity data is collected and recorded:
54. In ⎯⎯⎯⎯ data base models, a complex diagram may be used to represent the structure of database:
55. Information sharing means that:
56. Manipulation of data to achieve the required objectives and result is called
57. Multiple copies of the same data is referred to as:
58. Program files contain
59. Reproduction refers to
60. SQL can be used to:
61. SQL is a(n)
62. SQL is a(n)
63. Storage and retrieval of data is related to:
64. The data can be recovered in case of loss by using:
65. The extension for a video file is
66. The extension of a file created in Notepad is:
67. The file extension of a program file is
68. The file name and the extension are separated by a:
69. The Latest update files are
70. The manipulated and processed data is called:
71. The name of person represents:
72. The objectives of database may include:
73. The objectives of database system or DBMS may include:
74. The printed or onscreen display of data or information in the database is called:
75. The process in which the contents are accessed in a sequence is called:
76. The process of arranging data in a logical sequence is called:
77. The process of arranging data in a proper order is called:
78. The process of making duplicate copies of output result is called:
79. The process of making the copy of original is called
80. The separation of the data structure of database from the application program is called.
81. The techniques used to write and retrieve data to and from the storage devices are called:
82. The term “inverted tree” is used in
83. The type of files from functional point of view may include:
84. The type of files from storage point of view may include:
85. To convert data into information we need some
86. Using information managers can create
87. Video file has a file extension:
88. Which file contains the data prior to the stage of processing
89. Which file is used to store information that remains constant for a long time?
90. Which files organization uses the magnetic storage media:
91. Which is not true about data
92. Which of the following are the components of DBMS:
93. Which of the following contain data definitions:
94. Which of the following data model has general shape of an organization chart?
95. Which of the following data model is more flexible:
96. Which of the following data models is the most commonly used.
97. Which of the following database model has the shape like and organizational chart:
98. Which of the following file contains the software instructions?
99. Which of the following file extensions represents the image file:
100. Which of the following is a computerized record keeping system:
101. Which of the following is a query language:
102. Which of the following is an image file extension?
103. Which of the following is handled by DBMS?
104. Which of the following is not related to data manipulation:
105. Which of the following may be a temporary file
106. Which of the following refers to the correctness and consistency of data:
107. Which of the following represents a collection of concepts that are used to describe the structure of a database:
108. Which of the following type of file require largest processing time:
109. Which one is a file type with reference to usage point of view
110. Which one is not a file type with reference to usage point of view
111. Which one is not advanced capability of DBMS
112. Which one is not an SQL statement
113. Which one is not the feature of DBMS
114. Which one refers data capturing
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.