This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 6 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 6 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What does the symbol represent in a flowchart when a decision has to be made? A) Rectangle. B) Parallelogram. C) Diamond. D) Arrow. Show Answer Correct Answer: C) Diamond. 2. Which function returns the maximum value in a column? A) COUNT(). B) MAX(). C) SUM(). D) AVG(). Show Answer Correct Answer: B) MAX(). 3. Which of the following best describes the difference between a field and a record? A) A field stores all information about one item, while a record stores one type of information. B) A field is a column of one type of data, while a record is a row about one item. C) A record is a collection of tables, while a field is a table name. D) A record and a field mean the same thing. Show Answer Correct Answer: B) A field is a column of one type of data, while a record is a row about one item. 4. What does DDL stand for in databases? A) Data Display Language. B) Database Design Language. C) Data Description Language. D) Data Definition Language. Show Answer Correct Answer: D) Data Definition Language. 5. Why is it important for a database to be associated with a general topic? A) It helps organize related data efficiently. B) It makes the database slower. C) It increases the risk of data loss. D) It limits the use of the database. Show Answer Correct Answer: A) It helps organize related data efficiently. 6. What does 3NF stand for in database normalization? A) Third Normal Form. B) Three Normal Functions. C) Three Normal Forms. D) Third Normal Function. Show Answer Correct Answer: A) Third Normal Form. 7. Jenis diagram UML yang menggambarkan interaksi antara system dan actor adalah ..... A) Use case diagram. B) Activity diagram. C) Sequence diagram. D) Class diagram. E) Object diagram. Show Answer Correct Answer: A) Use case diagram. 8. What is a Data Warehouse? A) A system used for reporting and data analysis. B) A type of database optimized for transaction processing. C) A software development methodology. D) A network security protocol. Show Answer Correct Answer: A) A system used for reporting and data analysis. 9. Which of the following describes a "schema" ? A) A collection of queries stored in the database. B) The structure of a database, defining how tables, fields, and relationships are organized. C) A type of SQL query used to retrieve data. D) A system for managing database connections. Show Answer Correct Answer: B) The structure of a database, defining how tables, fields, and relationships are organized. 10. What is the purpose of the DROP command in DDL? A) To retrieve records from a table. B) To modify table data. C) To remove an entire table or database object. D) To add new records to a table. Show Answer Correct Answer: C) To remove an entire table or database object. 11. When data of one file cannot be mapped to other relation file, it is called data ..... A) Inconsistency. B) Dependence. C) Redundancy. D) Isolation. Show Answer Correct Answer: A) Inconsistency. 12. Which of the following is a type of database management system? A) SQL Server. B) Microsoft Word. C) Microsoft Excel. D) Adobe Photoshop. Show Answer Correct Answer: A) SQL Server. 13. The separation of the data definition from the program is known as: A) Data dictionary. B) Data independence. C) Data integrity. D) Referential integrity. Show Answer Correct Answer: B) Data independence. 14. The purpose of DBLC is to: A) Build mobile apps. B) Create a database system systematically. C) Write queries. D) Encrypt network data. Show Answer Correct Answer: B) Create a database system systematically. 15. RDBMS A) Relational Database Basic Management System. B) Relational Database Management System. C) Required Database Management Setup. D) None of these. Show Answer Correct Answer: B) Relational Database Management System. 16. What should you do instead of repeating 'country' in every record? A) Use a text box. B) Enter manually. C) Create a dropdown list. D) Create a new table. Show Answer Correct Answer: C) Create a dropdown list. 17. Write a SELECT query to list the employees whose salary is greater than 1000. A) SELECT ename, sal FROM emp WHERE sal GREATER THAN 1000. B) SELECT ename, sal FROM emp WHERE sal > 1000. C) SELECT ename, sal FROM emp WHERE sal >= 1000. D) SELECT ename, sal FROM emp WHERE sal MORE THAN 1000. Show Answer Correct Answer: B) SELECT ename, sal FROM emp WHERE sal > 1000. 18. Why is it important to accurately map entities, columns, and data types in a database? A) It simplifies the process of creating primary keys for each table. B) It ensures that data can be retrieved and stored correctly in the database. C) It eliminates the need for creating relationships between tables. D) It guarantees that the database can handle a large number of concurrent users. Show Answer Correct Answer: B) It ensures that data can be retrieved and stored correctly in the database. 19. Which data type can store up to 8 bytes of data? A) Text. B) Number. C) Date/Time. D) Large Number. Show Answer Correct Answer: B) Number. 20. What does a conceptual ERD provide? A) A high-level overview of the database. B) Detailed implementation steps. C) A list of all records. D) Only the data types. Show Answer Correct Answer: A) A high-level overview of the database. 21. Flat-file database A) A database that contains only one table. B) A database that contains multiple tables. C) A database that is used for large-scale data processing. D) A database that is designed for complex queries. Show Answer Correct Answer: A) A database that contains only one table. 22. A Query in Microsoft Access is used to: A) Store data for future use. B) Select records from the underlying table that meet some search criteria. C) Create a form to facilitate data entry. D) None. Show Answer Correct Answer: B) Select records from the underlying table that meet some search criteria. 23. Why is Data organised in a table? A) For collection of Data. B) For records. C) For slave table. D) For quick retreival of Information. Show Answer Correct Answer: D) For quick retreival of Information. 24. Which of the following is a type of database software? A) Microsoft Word. B) Microsoft Excel. C) Microsoft Access. D) Adobe Photoshop. Show Answer Correct Answer: C) Microsoft Access. 25. What is the significance of a database management system (DBMS)? A) It is not necessary for small databases. B) It simplifies data management and access. C) It is only used for large databases. D) It complicates data access. Show Answer Correct Answer: B) It simplifies data management and access. ← 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 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 10Class 11 Computer Science Chapter 7 Database Concepts Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books