This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 31 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 31 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is a prerequisite for creating a distributed database? A) SQL Server must be uninstalled. B) SQL Server must be installed as Express. C) The Agent must be set to Manual. D) The Agent must be Automatic. Show Answer Correct Answer: D) The Agent must be Automatic. 2. A ..... is an organized pool of logically related data. A) Database. B) Wisdom. C) Information system. D) Data. Show Answer Correct Answer: A) Database. 3. What is the role of end users? A) To design the database. B) To access the database. C) To manage the DBMS. D) To write the software. Show Answer Correct Answer: B) To access the database. 4. Section B:Multiple Choice (5 marks)-Circle or write the correct letter (A, B, C, or D). One use of a database in a school is: A) To store and manage student grades. B) To play music for events. C) To send text messages. D) To design posters. Show Answer Correct Answer: A) To store and manage student grades. 5. A database ..... describes a database entity. A) Byte. B) Record. C) Value. D) Field. Show Answer Correct Answer: B) Record. 6. What is the primary purpose of data independence? A) To allow changes at one level without affecting others. B) To ensure data is always accurate. C) To simplify data retrieval. D) To increase data redundancy. Show Answer Correct Answer: A) To allow changes at one level without affecting others. 7. Which of the following removes the duplicate rows in database? A. B. C. D. A) INTERSECTION. B) PROJECT. C) PRODUCT. D) SELECT. Show Answer Correct Answer: B) PROJECT. 8. How do you modify a database schema? A) You modify a database schema by deleting all existing tables. B) You can only modify a database schema through a graphical user interface. C) You modify a database schema by creating and executing migration scripts. D) You modify a database schema by copying the entire database to a new server. Show Answer Correct Answer: C) You modify a database schema by creating and executing migration scripts. 9. What distinguishes a network database structure? A) Uses a linear data format. B) Allows many-to-many relationships using graph structure. C) Stores data only in tables. D) Uses no indexing. Show Answer Correct Answer: B) Allows many-to-many relationships using graph structure. 10. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity? A) Archetype entity. B) Supertype entity. C) Subtype entity. D) Instance entity. Show Answer Correct Answer: B) Supertype entity. 11. Which property ensures committed transactions survive system failures? A) Durability. B) Isolation. C) Atomicity. D) Consistency. Show Answer Correct Answer: A) Durability. 12. Which method brings data into the database from an existing file? A) Input. B) Export. C) Output. D) Import. Show Answer Correct Answer: D) Import. 13. Komponen berikut adalah bagian dari sistem basis data, kecuali ..... A) Sistem Informasi. B) Perangkat keras. C) Ransomware. D) Brainware (pengguna). E) Perangkat Lunak. Show Answer Correct Answer: C) Ransomware. 14. What distinguishes a centralized database from a distributed database? A) Centralized databases require more servers. B) Centralized databases are faster. C) Centralized databases are located in one location. D) Distributed databases are easier to manage. Show Answer Correct Answer: C) Centralized databases are located in one location. 15. Explain what an entity is in a database. A) An entity is a type of database query. B) An entity is a method for data retrieval. C) An entity refers to a database user. D) An entity is a distinct object or concept in a database, defined by its attributes. Show Answer Correct Answer: D) An entity is a distinct object or concept in a database, defined by its attributes. 16. What is the function of an index in a database? A) To increase data redundancy. B) To enforce data integrity. C) To speed up data retrieval. D) To store large amounts of data. Show Answer Correct Answer: C) To speed up data retrieval. 17. Which type of entity represents an actual occurrence of an associated generalized entity? A) Subtype entity. B) Instance entity. C) Archetype entity. D) Supertype entity. Show Answer Correct Answer: B) Instance entity. 18. Which of the following is an example of a primary key in a student database? A) Student Age. B) Student Name. C) Student ID. D) Student Grade. Show Answer Correct Answer: C) Student ID. 19. The SQL statement 'Select mod (10, 4) from dual' will display 2 as the result A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 20. What is the purpose of a school database? A) To store and manage student information. B) To create video games. C) To perform calculations. D) To write stories. Show Answer Correct Answer: A) To store and manage student information. 21. What is the significance of transaction management in databases? A) Transaction management is only important for performance optimization. B) Transaction management is significant for ensuring data integrity and consistency in databases. C) Transaction management is irrelevant in distributed databases. D) Transaction management is solely focused on user access control. Show Answer Correct Answer: B) Transaction management is significant for ensuring data integrity and consistency in databases. 22. What are the main responsibilities of a database administrator? A) Designing user interfaces. B) Managing and maintaining databases, ensuring data security, optimizing database performance, troubleshooting issues, implementing backup and recovery plans. C) Writing code for applications. D) Managing social media accounts. Show Answer Correct Answer: B) Managing and maintaining databases, ensuring data security, optimizing database performance, troubleshooting issues, implementing backup and recovery plans. 23. Data dictionary includes the actual data values of the database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 24. Which of these software helps manage a computerized database? A) MS Excel. B) DBMS. C) MS Word. D) Tally. Show Answer Correct Answer: B) DBMS. 25. Which of the following is NOT a typical data manipulation operation? A) Inserting rows into a table. B) Changing the physical file organization on disk. C) Deleting rows from a table. D) Updating existing rows. Show Answer Correct Answer: B) Changing the physical file organization on disk. 26. What does a thick line represent in referential integrity? A) A connection between unrelated tables. B) A connection between the parent and child table. C) A deletion of records. D) An update of records. Show Answer Correct Answer: B) A connection between the parent and child table. 27. Section D:Fill in the Blanks (5 marks)-Write the correct word or term in each blank space. A ..... is a collection of related information organized into tables. A) Database. B) Record. C) Field. D) Spreadsheet. Show Answer Correct Answer: A) Database. 28. What is the problem in file-based system? A) Data is easily managed. B) Data is organized. C) Data is redundant. D) Data is consistent. Show Answer Correct Answer: C) Data is redundant. 29. Which data type is appropriate for storing dates and times in a database? A) Real. B) IntegerTagsLO2. C) Character. D) Date/time. Show Answer Correct Answer: D) Date/time. 30. Name three common data types used for storing text in databases. A) BLOB, CLOB, XML. B) VARCHAR, TEXT, CHAR. C) DATE, TIME, TIMESTAMP. D) INT, FLOAT, BOOLEAN. Show Answer Correct Answer: B) VARCHAR, TEXT, CHAR. 31. What data type would you use in SQL to store a date and time value together? A) DATE. B) DATETIME. C) TIME. D) TIMESTAMP. Show Answer Correct Answer: B) DATETIME. 32. Which one of the following should be taken as a primary key? A) DepartmentID. B) Street. C) Department. D) Name. Show Answer Correct Answer: A) DepartmentID. 33. A table can be created without a primary key. A) TRUE. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 34. What do we call the number of records in a relation? A) Cardinality. B) Degree. C) Domain. D) Tuple. Show Answer Correct Answer: A) Cardinality. 35. What do you mean by consistent data in a database? A) All users view the same data. B) Providing different access levels to users. C) Information sharing between users. D) Customising data according to user's requirements. Show Answer Correct Answer: A) All users view the same data. 36. Which operator checks if a value matches one of a set of values? A) ANY. B) EXISTS. C) IN. D) ALL. Show Answer Correct Answer: C) IN. 37. What does a row in a database table represent? A) A collection of related fields. B) The header or title of a table. C) A command in SQL. D) The collection of data for a specific entry in the table. Show Answer Correct Answer: D) The collection of data for a specific entry in the table. 38. An atomic transaction is a set of SQL statements where A) All succeed. B) All fail. C) All succeed or fail. D) None succeed of fail. Show Answer Correct Answer: C) All succeed or fail. 39. The entity integrity rule requires that ..... A) All primary key entries are unique. B) A part of the key may be null. C) Foreign key values do not reference primary key values. D) Duplicate object values are allowed. Show Answer Correct Answer: A) All primary key entries are unique. 40. Microsoft SQL Server is a(n) ..... A) DBMS for both desktops and mobile devices. B) Internet DBMS. C) Desktop relational DBMS. D) DBMS for midrange computers. Show Answer Correct Answer: D) DBMS for midrange computers. 41. Which SQL query shows the names of employees who have not been assigned to any department? A) SELECT name FROM employees WHERE department id = ' ';. B) SELECT name FROM employees WHERE department id = NULL;. C) SELECT name FROM employees WHERE department id = 0;. D) SELECT name FROM employees WHERE department id IS NULL;. Show Answer Correct Answer: D) SELECT name FROM employees WHERE department id IS NULL;. 42. In an E-R diagram the uses Crows Foot Notation an entity set is represent by a A) Diamond box. B) Ellipse. C) Circle. D) Rectangle. Show Answer Correct Answer: D) Rectangle. 43. ..... is the process of ensuring that a program operates on clean, correct and useful data. A) Data consistency. B) Data concurrency. C) Data verification. D) Data validation. Show Answer Correct Answer: D) Data validation. 44. In a table of library books, each row represents a: A) Schema. B) Attribute. C) Tuple/Record. D) Domain. Show Answer Correct Answer: C) Tuple/Record. 45. Which of the following is NOT an advantage of using a database system? A) Increased data inconsistency. B) Controlled data inconsistency. C) Reduced data redundancy. D) Secured data. Show Answer Correct Answer: A) Increased data inconsistency. 46. What is the Ribbon in MS Access? A) A type of field. B) A part of the database file. C) A menu that allows navigation. D) A tool used for printing. Show Answer Correct Answer: C) A menu that allows navigation. 47. Which of the following statements best defines the word 'database'? A) A database is a collection of data or information which is stored in a logical and structured way. B) A database is a collection of statistics stored only for computers. C) A database does not collect data or information. D) None of the above. Show Answer Correct Answer: A) A database is a collection of data or information which is stored in a logical and structured way. 48. Which SQL structure correctly deletes a record? A) DELETE RECORD = ;. B) CLEAR FROM WHEN ;. C) DELETE FROM WHERE ;. D) REMOVE IF ;. Show Answer Correct Answer: C) DELETE FROM WHERE ;. 49. Apa fungsi utama dari 'PRIMARY KEY' pada sebuah tabel database? A) Menghubungkan dua tabel yang berbeda. B) Mengatur urutan data dalam tabel. C) Memastikan setiap baris memiliki nilai unik untuk kolom tersebut. D) Mengizinkan nilai duplikat dalam kolom. Show Answer Correct Answer: C) Memastikan setiap baris memiliki nilai unik untuk kolom tersebut. 50. Suggest Suitable Basic Data Types:Which data type is suitable for storing names, addresses, or product descriptions in a database? A) Boolean. B) Integer. C) RealTagsLO2. D) Text/alphanumeric. Show Answer Correct Answer: D) Text/alphanumeric. 51. A field which has a unique value for each record of a table is called: A) Attribute. B) Data type. C) Foreign key. D) Primary key. Show Answer Correct Answer: D) Primary key. 52. Which of the following is a common database management system? A) SQLite. B) PostgreSQL. C) MongoDB. D) MySQL. Show Answer Correct Answer: D) MySQL. 53. A table in a database consists of: A) Images and text. B) Columns and rows. C) Only numbers. D) Only text. Show Answer Correct Answer: B) Columns and rows. 54. Dalam cardinality, apa itu relasi many to many A) Entitas dari tabel yang berbeda tidak dapat terkait. B) Hanya hubungan satu arah yang diizinkan. C) Sebuah entitas dapat terkait dengan banyak entitas di set lain, dan sebaliknya. D) Sebuah entitas dalam satu set hanya terkait dengan satu entitas di set lain. Show Answer Correct Answer: C) Sebuah entitas dapat terkait dengan banyak entitas di set lain, dan sebaliknya. 55. This is the language used to communicate with DBMS. A) Structured Query Language. B) Standard Query Language. C) Super Query Language. D) None of these. Show Answer Correct Answer: A) Structured Query Language. 56. A query retrieves specific data based on criteria from one or more tables. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 57. What is metadata in the context of databases? A) Data about users. B) Data about applications. C) Data about hardware. D) Data about data-describes structure, constraints, and properties. Show Answer Correct Answer: D) Data about data-describes structure, constraints, and properties. 58. Data about data is ..... A) Data Description. B) Data redundancy. C) Data inconsistency. D) Metadata. Show Answer Correct Answer: D) Metadata. 59. .... is the example for the DBMS . A) Python. B) Excel. C) FoxPro. D) Java. Show Answer Correct Answer: C) FoxPro. 60. Why do relational databases improve data integrity? A) They allow inconsistent data to be stored. B) They duplicate fields across tables. C) They update related data automatically through relationships. D) They require more storage space. Show Answer Correct Answer: C) They update related data automatically through relationships. ← PreviousNext →Related QuizzesScience QuizzesClass 11 QuizzesClass 11 Computer Science Chapter 7 Database Concepts Quiz 1Class 11 Computer Science Chapter 7 Database Concepts Quiz 2Class 11 Computer Science Chapter 7 Database Concepts Quiz 3Class 11 Computer Science Chapter 7 Database Concepts Quiz 4Class 11 Computer Science Chapter 7 Database Concepts Quiz 5Class 11 Computer Science Chapter 7 Database Concepts Quiz 6Class 11 Computer Science Chapter 7 Database Concepts Quiz 7Class 11 Computer Science Chapter 7 Database Concepts Quiz 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books