This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 29 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 29 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. A database cannot be organised. A) TRUE. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 2. Database ..... which is the logical design of the database, and the database ..... which is a snapshot of the data in the database at a given instant in time. A) Instance, Schema. B) Relation, Schema. C) Relation, Domain. D) Schema, Instance. Show Answer Correct Answer: D) Schema, Instance. 3. In a database, what does the term 'row' refer to? A) A single entry of data. B) A category of data. C) A method of data retrieval. D) A type of database. Show Answer Correct Answer: A) A single entry of data. 4. Berdasarkan tugas yang diberikan di awal video, database 'Kasir' seharusnya memiliki tabel-tabel berikut, kecuali ..... A) Penjualan. B) Pelanggan. C) Barang. D) Karyawan. Show Answer Correct Answer: D) Karyawan. 5. Which of the following data types is automatically generated and incremented by Access? A) AutoNumber. B) Memo. C) Yes/No. D) Text. Show Answer Correct Answer: A) AutoNumber. 6. Which ACID property is best described as 'a transaction must bring the database from one valid state to another, following all defined rules and constraints'? A) Atomicity. B) Isolation. C) Durability. D) Consistency. Show Answer Correct Answer: D) Consistency. 7. What is a one-to-many relationship? A) One record relates to many records. B) One record relates to one record. C) No relationship exists. D) Many records relate to one record. Show Answer Correct Answer: A) One record relates to many records. 8. What does a one-to-one relationship in a relational database imply? A) One record from one table can link to multiple records in another table. B) One record from one table links to one record in another table. C) Multiple records from one table link to one record in another table. D) No records are linked between tables. Show Answer Correct Answer: B) One record from one table links to one record in another table. 9. Which component of a database is similar to a spreadsheet? A) Table. B) Record. C) Field. D) Database. Show Answer Correct Answer: A) Table. 10. What does WHERE clause do in an SQL SELECT statement? A) Deletes specific data. B) Filters records based on conditions. C) Creates a new column. D) Sorts the data by date. Show Answer Correct Answer: B) Filters records based on conditions. 11. Which of the following is NOT an ACID property of a transaction? A) Atomicity. B) Consistency. C) Integrity. D) Durability. Show Answer Correct Answer: C) Integrity. 12. Berikan contoh SQL query untuk menampilkan semua data dari tabel 'mahasiswa'. A) SHOW mahasiswa;. B) SELECT * FROM mahasiswa;. C) SELECT * FROM data mahasiswa;. D) SELECT * FROM students;. Show Answer Correct Answer: B) SELECT * FROM mahasiswa;. 13. What would be a strategic reason to use a flat-file database instead of a relational database for a small startup's employee records? A) It requires less technical skill to manage. B) It can handle more complex queries. C) It offers better connectivity with web applications. D) It provides automatic backup featuresTagsDOK Level 3:Strategic Thinking. Show Answer Correct Answer: A) It requires less technical skill to manage. 14. The Database Management System can be divided into ..... major components A) Five. B) Six. C) Two. D) Three. Show Answer Correct Answer: A) Five. 15. What is the role of data consistency? A) To distribute data across systems. B) To allow for multiple, conflicting standards. C) To ensure data is in a uniform format across systems. D) None of the above. Show Answer Correct Answer: C) To ensure data is in a uniform format across systems. 16. What is the role of OLAP in data warehousing? A) OLAP focuses on real-time data processing and transaction management. B) OLAP is primarily used for data storage in warehouses. C) OLAP is a tool for data entry and data cleansing in databases. D) OLAP enables complex data analysis and multidimensional querying in data warehousing. Show Answer Correct Answer: D) OLAP enables complex data analysis and multidimensional querying in data warehousing. 17. What is data abstraction in database systems? A) Hiding irrelevant details from users. B) Deleting old data. C) Encrypting data. D) Backing up data. Show Answer Correct Answer: A) Hiding irrelevant details from users. 18. Database can be ..... based with one sole purpose of storing data. A) Software. B) Hardware. C) A (or) b. D) A (and) b. Show Answer Correct Answer: C) A (or) b. 19. What is the main difference between a database and a table? A) A database is smaller than a table. B) A table can contain multiple databases. C) A database can contain multiple tables. D) There is no difference. Show Answer Correct Answer: C) A database can contain multiple tables. 20. News of 1991? A) Microsoft releases MS access, a custom DBMS that replaces all other custom DBMS products. B) Charles Bachman created the first DBMS system. C) Object-oriented DBMS are being developed. D) The first internet applications for databases. E) None. Show Answer Correct Answer: A) Microsoft releases MS access, a custom DBMS that replaces all other custom DBMS products. 21. DBMS A) DATABASE MANAGEMENT SYSTEM. B) DATA MANAGEMENT SYSTEM. C) DATABASE MANAGEMENTS SYSTEM. D) DATABASE MANAGEMENT SYSTEMS. Show Answer Correct Answer: A) DATABASE MANAGEMENT SYSTEM. 22. How do you represent relationships in an ER diagram? A) Relationships are represented by squares in an ER diagram. B) Relationships are represented by circles connecting entities in an ER diagram. C) Relationships are represented by arrows pointing to entities in an ER diagram. D) Relationships are represented by diamonds connecting entities in an ER diagram. Show Answer Correct Answer: D) Relationships are represented by diamonds connecting entities in an ER diagram. 23. What is a transaction in database terminology? A) A monetary exchange. B) A type of database user. C) A logical unit of database processing including one or more operations. D) A hardware component. Show Answer Correct Answer: C) A logical unit of database processing including one or more operations. 24. Apa kepanjangan dari DBMS? A) Sistem Model Basis Data. B) Sistem Manajemen Basis Data. C) Sistem Manajemen Cadangan Data. D) Sistem Manajemen Bisnis Data. E) Sistem Manajemen Buffer Data. Show Answer Correct Answer: B) Sistem Manajemen Basis Data. 25. Can an entity have multiple attributes? A) Yes, an entity can have multiple attributes. B) An entity can only have one attribute. C) Entities cannot have any attributes. D) Attributes are not applicable to entities. Show Answer Correct Answer: A) Yes, an entity can have multiple attributes. ← PreviousNext →Related 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 8Class 11 Computer Science Chapter 7 Database Concepts Quiz 9Class 11 Computer Science Chapter 7 Database Concepts Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books