This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 14 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 14 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is a characteristic of a flat file database? A) Uses multiple tables. B) Allows for relationships between data. C) Supports complex queries. D) Data is organized in a single table. Show Answer Correct Answer: D) Data is organized in a single table. 2. Which of the following data is NOT alphanumeric? A) "ABC123". B) "Fadi2025". C) "#####". D) "MathsExam2024". Show Answer Correct Answer: C) "#####". 3. ..... are the one who store retrieve, update and delete data. A) GIS. B) End user. C) Programmer. D) Database designer. Show Answer Correct Answer: B) End user. 4. What is a Data Lake? A) A centralized repository for storing large amounts of structured and unstructured data. B) A type of database optimized for online transaction processing. C) A tool for data visualization and reporting. D) A programming language used for data analysis. Show Answer Correct Answer: A) A centralized repository for storing large amounts of structured and unstructured data. 5. How is an "Attribute" best defined in a relational database? A) Used to represent a property, quality, or characteristic of an entity. B) The type of data that the database will store. C) Able to store, sort, and search data. D) A field that bisects, including system row and column. Show Answer Correct Answer: A) Used to represent a property, quality, or characteristic of an entity. 6. What does a DBMS help with? A) Data redundancy. B) Data security. C) Efficient data management. D) All of the above. Show Answer Correct Answer: D) All of the above. 7. Which database model stores data in objects with attributes and methods, similar to object-oriented programming? A) Hierarchical Database Model. B) Object-Oriented Database Model. C) Network Database Model. D) Relational Database Model. Show Answer Correct Answer: B) Object-Oriented Database Model. 8. INSERT A) An SQL command used to add new data. B) An SQL command used to delete data. C) An SQL command used to update existing data. D) An SQL command used to retrieve data. Show Answer Correct Answer: A) An SQL command used to add new data. 9. What is an "entity" in a relational database? A) A query that retrieves data. B) A real-world object or concept represented by a table. C) A rule used to normalize data. D) A foreign key in a database table. Show Answer Correct Answer: B) A real-world object or concept represented by a table. 10. What is the function of a 'memo' data type in a database? A) Store numbers for calculations. B) Store a large amount of text. C) Automatically assign numbers to records. D) Create hyperlinks. Show Answer Correct Answer: B) Store a large amount of text. 11. Which view is best for creating calculated fields? A) Datasheet View. B) Print Preview. C) Design View. D) Form View. Show Answer Correct Answer: C) Design View. 12. What does DBMS stand for? A) Data Base Management System. B) Data Base Maintenance System. C) Database Management Software. D) Data Backup Management System. Show Answer Correct Answer: A) Data Base Management System. 13. What is a database management system? A) A database management system (DBMS) is a software that allows users to create, manipulate, and manage databases. B) A database management system is a programming language used to query databases. C) A database management system is a hardware device used to store and retrieve data. D) A database management system is a network protocol used to transfer data between databases. Show Answer Correct Answer: A) A database management system (DBMS) is a software that allows users to create, manipulate, and manage databases. 14. Which of the following is a legal expression in SQL? A) SELECT NULL FROM EMPLOYEE;. B) SELECT NAME FROM EMPLOYEE;. C) SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;. D) None of the above. Show Answer Correct Answer: B) SELECT NAME FROM EMPLOYEE;. 15. Which of the following is NOT a tool that is available with a complete database management system A) Presentation. B) Report writer. C) Graphics. D) Ad-hoc query. Show Answer Correct Answer: A) Presentation. 16. The main goal of normalization is to: A) Increase data redundancy. B) Minimize data redundancy. C) Delete all records. D) Combine all tables into one. Show Answer Correct Answer: B) Minimize data redundancy. 17. What type of database is Microsoft SQL Server classified as? A) NoSQL Database. B) Object-Oriented Database. C) Relational Database. D) Hierarchical Database. Show Answer Correct Answer: C) Relational Database. 18. In a classroom database, which field uniquely identifies each student record? A) Primary key. B) Foreign key. C) Duplicate key. D) Search key. Show Answer Correct Answer: A) Primary key. 19. What is a secondary key in a database? A) A column that uniquely identifies a subset of rows. B) A column that references another table. C) A column that is not required to be unique. D) A column that can be used as a primary key. Show Answer Correct Answer: A) A column that uniquely identifies a subset of rows. 20. What is the main purpose of an Entity-Relationship Diagram (ERD)? A) To create a database schema. B) To manage data retrieval. C) To store data in a database. D) To visualize database structure and relationships. Show Answer Correct Answer: D) To visualize database structure and relationships. 21. In a one-to-many relationship, where is the primary key used? A) In the table on the 'many' side of the relationship. B) In the table on the 'one' side of the relationship. C) In both tables involved in the relationship. D) Primary keys are not used in one-to-many relationships. Show Answer Correct Answer: B) In the table on the 'one' side of the relationship. 22. What are the main components of database architecture? A) The main components are the user interface, the server, and the network. B) The main components consist of the programming language, the compiler, and the web browser. C) The main components include the operating system, the hardware, and the cloud storage. D) The main components of database architecture are the database management system (DBMS), the database, and the application. Show Answer Correct Answer: D) The main components of database architecture are the database management system (DBMS), the database, and the application. 23. Hapuslah pada field MONITOR pada kolom nama ..... barang pada tabel barang! A) SQL>delete on table barang where NAMA BARANG='MONITOR';. B) SQL> delete from table barang where NAMA BARANG='MONITOR';. C) SQL>delete on barang where NAMA BARANG='MONITOR';. D) SQL> delete from barang where NAMA BARANG='MONITOR';. E) SQL>drop table barang;. Show Answer Correct Answer: D) SQL> delete from barang where NAMA BARANG='MONITOR';. 24. Which of the following is an advantage of using a surrogate key? A) It has meaningful real-world data. B) It is derived from a combination of columns. C) It reduces the size and complexity of joins. D) It is easy to interpret by end users. Show Answer Correct Answer: C) It reduces the size and complexity of joins. 25. Which of the following is NOT a database language? A) DDL. B) DML. C) HTML. D) DCL. Show Answer Correct Answer: C) HTML. ← 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