This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 8 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 8 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Explain the role of ACID properties in ensuring data integrity in database transactions. A) ACID properties have no impact on data integrity in database transactions. B) ACID properties ensure data consistency, isolation, durability, and atomicity in database transactions, thereby maintaining data integrity. C) ACID properties only focus on data redundancy in database transactions. D) ACID properties are not relevant in database transactions. Show Answer Correct Answer: B) ACID properties ensure data consistency, isolation, durability, and atomicity in database transactions, thereby maintaining data integrity. 2. In a database, data is stored in A) Tables. B) Forms. C) Reports. D) Queries. Show Answer Correct Answer: A) Tables. 3. Which of the following is a benefit of using a relational database? A) Increased data redundancy. B) Easier data retrieval and management. C) More complex data structures. D) Limited data integrity. Show Answer Correct Answer: B) Easier data retrieval and management. 4. In a school database, why are 'Forename' and 'Surname' typically unsuitable to serve as primary keys? A) They are alphanumeric, and primary keys must always be numeric. B) They take up too much internal memory compared to IDs. C) Multiple people can have the same name, which violates the requirement for unique data. D) Access only allows IDs like 'Teacher ID' to be used as keys. Show Answer Correct Answer: C) Multiple people can have the same name, which violates the requirement for unique data. 5. Which of the following is an example of a candidate key in a database? A) An order's date. B) A student's last name. C) A product's name. D) A customer's name. Show Answer Correct Answer: B) A student's last name. 6. Explain the concept of a join in SQL. A) A join in SQL is used to create new tables from existing ones. B) A join in SQL combines rows from two or more tables based on a related column. C) A join in SQL is a method to sort data within a single table. D) A join in SQL deletes rows from one table based on another. Show Answer Correct Answer: B) A join in SQL combines rows from two or more tables based on a related column. 7. PostgreSQL is an example of: A) Document database. B) Relational database. C) NoSQL database. D) Graph database. Show Answer Correct Answer: B) Relational database. 8. In a database system, what is a "file" ? A) A data type. B) A software program used for database management. C) A collection of related records. D) A single record in a table. Show Answer Correct Answer: C) A collection of related records. 9. What is an advantage of placing computations in SQL views? A) To save users from having to write an expression. B) To ensure that the results are consistent. C) To accomplish both of the above. D) None of the above is correct-computations cannot be placed in a view. Show Answer Correct Answer: C) To accomplish both of the above. 10. Which of the following commands will delete the table from MYSQL database? A) REMOVE TABLE. B) DROP TABLE. C) ALTER TABLE. D) DELETE TABLE. Show Answer Correct Answer: B) DROP TABLE. 11. When all non-key attributes are fully functionally dependent on the primary key, a table is in A) First Normal Form (1NF). B) Second Normal Form (2NF). C) Third Normal Form (3NF). D) None of these. Show Answer Correct Answer: B) Second Normal Form (2NF). 12. Which is a key advantage of NoSQL databases? A) Strong consistency. B) High flexibility and scalability. C) Fixed schemas. D) Complex joins support. Show Answer Correct Answer: B) High flexibility and scalability. 13. What operations can be performed using relational query languages? A) Inserting, updating, deleting, and retrieving. B) Creating, modifying, exporting, and importing. C) Selection, projection, joining, union, and aggregation. D) Sorting, filtering, grouping, and indexing. Show Answer Correct Answer: C) Selection, projection, joining, union, and aggregation. 14. What is the purpose of forms in a database? A) To play music. B) To edit videos. C) To provide a user-friendly interface. D) To print documents. Show Answer Correct Answer: C) To provide a user-friendly interface. 15. Why is it important to have a primary key in a database table? A) To save disk space. B) To enforce referential integrity. C) To improve query performance. D) To uniquely identify each record and ensure data integrity. Show Answer Correct Answer: D) To uniquely identify each record and ensure data integrity. 16. What is a common method used in predictive analysis? A) Descriptive statistics. B) Data warehousing. C) Data cleaning. D) Regression analysis. Show Answer Correct Answer: D) Regression analysis. 17. How can views improve data security? A) Views can delete sensitive data automatically. B) Views enhance performance but do not affect security. C) Views allow unrestricted access to all data. D) Views improve data security by restricting access to sensitive data and enforcing data access policies. Show Answer Correct Answer: D) Views improve data security by restricting access to sensitive data and enforcing data access policies. 18. What is an example of a one-to-one (1:1) relationship? A) Students can enroll in multiple courses. B) A class can have multiple teachers. C) Each person has one unique passport. D) A teacher can teach multiple classes. Show Answer Correct Answer: C) Each person has one unique passport. 19. ..... allows us to have relationship between tables which makes the data more meaningful and connected. A) Software. B) Hardware. C) Program. D) DBMS. Show Answer Correct Answer: D) DBMS. 20. What is a primary reason for using a relational database instead of a flat file? A) Easier data deletion. B) Simpler data structure. C) Faster data retrieval. D) Improving data consistency. Show Answer Correct Answer: D) Improving data consistency. 21. What happens if atomicity is not maintained in a bank transaction? A) User login fails. B) One account may be debited but the other not credited. C) The system slows down. D) Data remains permanently saved. Show Answer Correct Answer: B) One account may be debited but the other not credited. 22. According to the text, why is this 'flat-file' approach considered inefficient? A) It makes the data too secure for daily use. B) It requires data to be entered many times, increasing the risk of entry errors. C) It prevents the use of alphanumeric data types. D) It makes the database too small to be searched effectively. Show Answer Correct Answer: B) It requires data to be entered many times, increasing the risk of entry errors. 23. Dalam diagram ERD, hubungan antara entitas diwakili oleh: A) Belah ketupat (rhombus). B) Segitiga. C) Persegi panjang. D) Garis penghubung. E) Oval. Show Answer Correct Answer: D) Garis penghubung. 24. If a student's section is changed from A to B but updated only in one record, it leads to: A) Data Sharing. B) Data Security. C) Data Integrity. D) Data Inconsistency. Show Answer Correct Answer: D) Data Inconsistency. 25. What is the 'AutoNumber' data type used for? A) To store text data. B) To store large amounts of text. C) To store monetary data. D) To generate unique values for records. Show Answer Correct Answer: D) To generate unique values for records. 26. Discuss the process of denormalization in database design. A) Denormalization has no impact on data integrity and duplication. B) Denormalization is the process of increasing redundancy in a database to ensure data accuracy. C) Denormalization involves combining multiple tables into one to simplify the database structure. D) Denormalization in database design is the process of adding redundant data to a database to improve read performance for large tables. Show Answer Correct Answer: D) Denormalization in database design is the process of adding redundant data to a database to improve read performance for large tables. 27. What term is used in databases instead of 'rows' in spreadsheets? A) Records. B) Fields. C) Tables. D) Columns. Show Answer Correct Answer: A) Records. 28. The view of total database contents is A) Physical view. B) Conceptual view. C) Internal view. D) External view. Show Answer Correct Answer: B) Conceptual view. 29. The manipulative part of a data model mainly specifies: A) The operations that can be performed on the data. B) The job descriptions of DBMS users. C) The graphical notation of ER diagrams. D) The physical devices used to store data. Show Answer Correct Answer: A) The operations that can be performed on the data. 30. What is an entity in an Entity-Relationship model? A) An entity is a process that describes how data is manipulated. B) An entity is a collection of attributes without any distinct identity. C) An entity is a type of relationship between two objects. D) An entity is a distinct object or thing in the real world that can be identified and has attributes. Show Answer Correct Answer: D) An entity is a distinct object or thing in the real world that can be identified and has attributes. 31. Which of the following is a specialized language that programmers use to add and change data in the database? A) Data definition language. B) Data access language. C) Database language. D) Data manipulation language. Show Answer Correct Answer: D) Data manipulation language. 32. What does the term 'referential integrity' mean? A) Ensuring that data is encrypted. B) Ensuring that data is backed up. C) Ensuring that foreign keys correctly reference primary keys. D) Ensuring that all data is unique. Show Answer Correct Answer: C) Ensuring that foreign keys correctly reference primary keys. 33. Which relationship type ensures that each record in the first table is linked to only one record in the second table? A) One-to-One. B) Many-to-Many. C) Many-to-One. D) One-to-Many. Show Answer Correct Answer: A) One-to-One. 34. Which SQL data type is used to store numerical values with fixed precision and scale? A) VARCHAR. B) DATE. C) DECIMAL. D) INTEGER. Show Answer Correct Answer: C) DECIMAL. 35. What is the main function of a database? A) To store data. B) To delete data. C) To encrypt data. D) To visualize data. Show Answer Correct Answer: A) To store data. 36. The logical view of a database ..... A) Displays the organization and structure of data on the physical storage media. B) Includes a digital dashboard. C) Allows the creation of supplementary reports. D) Presents data as they would be perceived by end users. Show Answer Correct Answer: D) Presents data as they would be perceived by end users. 37. Dalam perintah SQL, apa fungsi dari 'JOIN'? A) Menggabungkan dua atau lebih tabel berdasarkan kolom yang terkait. B) Menghapus data dari tabel. C) Membuat salinan tabel baru. D) Menampilkan struktur tabel. Show Answer Correct Answer: A) Menggabungkan dua atau lebih tabel berdasarkan kolom yang terkait. 38. Imagine you are designing a database for a library. Which type of database would be most suitable and why? A) Flat-file database, because it is easier to set up. B) Relational database, because it allows for complex relationships between books, borrowers, and loans. C) Flat-file database, because it supports larger data sets. D) Relational database, because it is faster for simple queriesTagsDOK Level 3:Strategic Thinking. Show Answer Correct Answer: B) Relational database, because it allows for complex relationships between books, borrowers, and loans. 39. Which validation method checks that a field is not left blank? A) Lookup Check. B) Type Check. C) Range Check. D) Presence Check. Show Answer Correct Answer: D) Presence Check. 40. A 2NF table can exhibit ..... dependency. A) Partial. B) Transitive. C) Complete. D) Indirect. Show Answer Correct Answer: B) Transitive. 41. Which of the following constraints ensures that a column cannot have NULL values, but does not imply uniqueness? A) NOT NULL. B) PRIMARY KEY. C) UNIQUE. D) CHECK. Show Answer Correct Answer: A) NOT NULL. 42. A database ..... is a sketch of design of a planned data. A) Schema. B) Relation. C) Metadata. D) Instance. Show Answer Correct Answer: A) Schema. 43. ASSERTION:-Primary Key is a set of attributes (or attribute) which uniquely identify the tuples in relation or table. REASON:-There may be more than one primary key in a table. A) Both A and R are true and R is the correct explanation for A. B) Both A and R are true and R is not the correct explanation for A. C) A is True but R is False. D) A is false but R is True. Show Answer Correct Answer: C) A is True but R is False. 44. Which of the following best describes data integrity? A) The speed at which data can be accessed. B) The overall completeness, accuracy, and consistency of data. C) The ability to recover data after a system crash. D) The process of organizing data into tables. Show Answer Correct Answer: B) The overall completeness, accuracy, and consistency of data. 45. Importance of data types in table design A) Data types specify the kind of data that can be stored and affect storage requirements. B) Data types are irrelevant to table design. C) Data types only affect the visual representation of data. D) Data types determine the speed of data retrieval. Show Answer Correct Answer: A) Data types specify the kind of data that can be stored and affect storage requirements. 46. Which type of serializability depends on conflict rules? A) View serializability. B) Cascaded. C) Recoverable. D) Conflict serializability. Show Answer Correct Answer: D) Conflict serializability. 47. Dibawah ini perintah yang digunakan untuk membuat database PTS adalah ..... A) Create database PTS:. B) Create PTS;. C) Create database PTS;. D) Database PTS;. E) Create databases PTS;. Show Answer Correct Answer: C) Create database PTS;. 48. Define a field in a database. A) A field is a column in a database table that stores a specific attribute of the data. B) A field is a command used to query data from a database. C) A field is a type of database that stores entire datasets. D) A field is a row in a database table that contains multiple attributes. Show Answer Correct Answer: A) A field is a column in a database table that stores a specific attribute of the data. 49. What is the purpose of a DBMS in a school setting? A) To store student information. B) To track student attendance. C) To track student grades. D) All of the above. Show Answer Correct Answer: D) All of the above. 50. What distinguishes a primary key from a regular field? A) A primary key is unique and identifies records, while a regular field can have duplicate values. B) A primary key is used for indexing, while a regular field is not. C) A primary key is a type of regular field that can be null. D) A primary key can have duplicate values, while a regular field is always unique. Show Answer Correct Answer: A) A primary key is unique and identifies records, while a regular field can have duplicate values. 51. What is the main issue with a file-based approach to data management? A) It requires less storage space. B) It can lead to data integrity problems. C) It allows for easy data sharing. D) It is always more secure than databases. Show Answer Correct Answer: B) It can lead to data integrity problems. 52. Which data model uses records and sets to define multiple relationships? A) Hierarchical. B) Object-oriented. C) Relational. D) Network. Show Answer Correct Answer: D) Network. 53. In an input mask, what does the character '0' represent? A) User can enter a digit (0 to 9). B) User must enter either a character or a space. C) User can enter a letter or a digit. D) User must enter a digit (0 to 9). Show Answer Correct Answer: D) User must enter a digit (0 to 9). 54. Tujuan penggunaan basis data adalah, kecuali ..... A) Berbagi. B) Kekuatan. C) Kecepatan. D) Akurasi. E) Keamanan. Show Answer Correct Answer: B) Kekuatan. 55. Which of these is a correct rule for designing a database? A) Combine multiple values in a single field. B) Use calculated fields whenever possible. C) Always enter duplicate records. D) Use dropdown lists instead of repeated values. Show Answer Correct Answer: D) Use dropdown lists instead of repeated values. 56. What does the term 'normalization' refer to in database design? A) The process of backing up data. B) The process of querying data. C) The process of organizing data to reduce redundancy. D) The process of creating a database. Show Answer Correct Answer: C) The process of organizing data to reduce redundancy. 57. The first phase of DBLC is: A) Implementation. B) Initial Study. C) Maintenance. D) Design. Show Answer Correct Answer: B) Initial Study. 58. What is a set of rules that define valid data called? A) Constraints. B) Data dictionary. C) Query. D) All of these. Show Answer Correct Answer: A) Constraints. 59. Apa itu tag dalam HTML dan bagaimana cara menggunakannya? A) Tag digunakan untuk membuat daftar di halaman web. B) Tag digunakan untuk membuat gambar di halaman web. C) Tag dalam HTML digunakan untuk membuat tabel di halaman web. Untuk menggunakan tag, kita harus menuliskan tag diikuti dengan tag untuk baris, tag untuk sel data, dan tag untuk sel header. D) Tag digunakan untuk membuat formulir di halaman web. Show Answer Correct Answer: C) Tag dalam HTML digunakan untuk membuat tabel di halaman web. Untuk menggunakan tag, kita harus menuliskan tag diikuti dengan tag untuk baris, tag untuk sel data, dan tag untuk sel header. 60. What is the difference between importing and entering data? A) Importing data is always faster than entering data. B) Entering data requires special software tools. C) Importing data is bulk transfer from external sources, while entering data is manual input. D) Importing data is only for large datasets. Show Answer Correct Answer: C) Importing data is bulk transfer from external sources, while entering data is manual input. ← 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 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books