This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 43 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 43 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is NOT a type of database query language? A) SQL. B) XML. C) PL/SQL. D) DB2. Show Answer Correct Answer: B) XML. 2. A bank has two tables- "Customers" and "Accounts." If each customer can have multiple accounts, they are related through a: A) Primary Key. B) Foreign Key. C) Candidate Key. D) Schema Key. Show Answer Correct Answer: B) Foreign Key. 3. A field in a database is: A) A column that holds one type of information. B) A row describing one item. C) A whole table. D) A binary number. Show Answer Correct Answer: A) A column that holds one type of information. 4. Perintah SQL yang digunakan untuk menampilkan semua data dari tabel 'pelanggan' adalah ..... A) SHOW DATA FROM pelanggan;. B) DISPLAY ALL FROM pelanggan;. C) SELECT * FROM pelanggan;. D) GET ALL FROM pelanggan;. Show Answer Correct Answer: C) SELECT * FROM pelanggan;. 5. Which of the following rule is NOT followed by a transaction in a database? A) All transactions are independent. B) All committed transactions survive a system crash. C) Multiple transactions might affect each other during run time. D) All of the above. Show Answer Correct Answer: A) All transactions are independent. 6. What is database? A) Collection of data. B) Collection of facts. C) Collection of Information. D) Collection of organized data. Show Answer Correct Answer: D) Collection of organized data. 7. Serves as an interface between the database and its end-users or programs, allowing users to retrieve, update, and manage how the information is organized and optimized. A) RDBMS. B) DBMS. C) MySQL. D) Microsoft SQL Server Management. Show Answer Correct Answer: B) DBMS. 8. What is the purpose of normalisation? A) To reduce data redundancy and improve consistency. B) To increase data redundancy. C) To prevent data relationships. D) To make data retrieval slower. Show Answer Correct Answer: A) To reduce data redundancy and improve consistency. 9. Hierarchical Structure A) A database structure that organizes data in a parent-child relationship. B) A flat database structure with no relationships. C) A network of interconnected databases. D) A structure that only allows one parent per child. Show Answer Correct Answer: A) A database structure that organizes data in a parent-child relationship. 10. How do you establish a one-to-many relationship in Access? A) Use a foreign key in both tables referencing each other. B) Establish a relationship by merging the two tables into one. C) Create a single table with multiple primary keys. D) Create two tables, define a primary key in the primary table, and a foreign key in the related table that references the primary key. Show Answer Correct Answer: D) Create two tables, define a primary key in the primary table, and a foreign key in the related table that references the primary key. 11. What type of relationship is represented by a one-to-many (1:N) relationship? A) A record in Table A can relate to multiple records in Table B. B) Each record in Table A relates to one record in Table B. C) Records in Table A can relate to each other. D) Each record in Table A relates to multiple records in Table A. Show Answer Correct Answer: A) A record in Table A can relate to multiple records in Table B. 12. Which types of databases have you accessed before? A) Relational and non-relational. B) Only relational. C) Only non-relational. D) None. Show Answer Correct Answer: A) Relational and non-relational. 13. What is the role of a data warehouse in business intelligence? A) The role of a data warehouse in business intelligence is to provide a centralized repository for data that supports reporting, analysis, and decision-making. B) A data warehouse is a tool for managing customer relationships. C) The data warehouse is primarily used for real-time data processing. D) A data warehouse stores only transactional data for operational use. Show Answer Correct Answer: A) The role of a data warehouse in business intelligence is to provide a centralized repository for data that supports reporting, analysis, and decision-making. 14. Which of the following SQL queries is used to retrieve records having open ..... bal between 15000 to 20000 by selecting the right command: A) Select total from customer having open bal between 15000 and 20000;;. B) Select count(*) from customer where open bal between 15000 to 20000;;. C) Select * from customer where open bal between 15000 and 20000;. D) Select count(*) from customer order by open bal;. Show Answer Correct Answer: C) Select * from customer where open bal between 15000 and 20000;. 15. What is a key benefit of using offline databases? A) They are accessible from anywhere. B) They are managed by cloud providers. C) They offer 99.9% availability. D) They reduce the risk of cyber attacks. Show Answer Correct Answer: D) They reduce the risk of cyber attacks. 16. What are the advantages of using views in a database? A) Advantages of using views include simplified queries, enhanced security, improved data abstraction, easier maintenance, and specific data presentation. B) Limited access to data updates. C) Slower query performance. D) Increased data redundancy. Show Answer Correct Answer: A) Advantages of using views include simplified queries, enhanced security, improved data abstraction, easier maintenance, and specific data presentation. 17. A row in a database. A) Record. B) Field. C) Entity. D) Table. Show Answer Correct Answer: A) Record. 18. Which of the following is NOT a feature of a relational database? A) Data is stored in files. B) Data integrity is maintained. C) Data can be easily queried. D) Data is stored in tables. Show Answer Correct Answer: A) Data is stored in files. 19. Apa kepanjangan dari ERD? A) Diagram Entitas-Relasi. B) Diagram Entitas-Peran. C) Diagram Sumber-Daya Perusahaan. D) Diagram Relasi-Diperluas. E) Diagram Pengarah Entitas. Show Answer Correct Answer: A) Diagram Entitas-Relasi. 20. What can Select Queries do with data? A) Filter and specify fields for display. B) Delete records. C) Create new tables. D) Append data to another table. Show Answer Correct Answer: A) Filter and specify fields for display. 21. What does a record (or row) in a database table represent? A) A calculation used. B) A unique identifier. C) A collection of data for one item or person. D) A specific name. Show Answer Correct Answer: C) A collection of data for one item or person. 22. Which data type is appropriate for storing long paragraphs of text? A) Text. B) Memo. C) Number. D) Yes/No. Show Answer Correct Answer: B) Memo. 23. What does the 'I' in ACID properties stand for? A) Integrity. B) Isolation. C) Indexing. D) Inconsistency. Show Answer Correct Answer: B) Isolation. 24. A primary key A) Is a unique identifier for the table. It cannot be null. B) Is a unique identifier for the table. It can be null. C) Is an identifier that always connects to a foreign key. D) Is used in flat file databases. Show Answer Correct Answer: A) Is a unique identifier for the table. It cannot be null. 25. Which of the following is a feature of NoSQL databases? A) Requires complex joins. B) Dynamic schema for unstructured data. C) Fixed schema for data. D) Only supports SQL queries. Show Answer Correct Answer: B) Dynamic schema for unstructured data. ← 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