This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 83 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 83 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is a type of data that can be stored in a database? A) Text. B) Numbers. C) Dates. D) All of the above. Show Answer Correct Answer: D) All of the above. 2. How does a DBMS benefit end users? A) By eliminating the need for data management. B) By providing a complex view of data. C) By hiding the details of database operations. D) By requiring users to learn programming languages. Show Answer Correct Answer: C) By hiding the details of database operations. 3. How might a school database improve efficiency? A) By organizing student information. B) By teaching classes. C) By grading exams. D) By hiring teachers. Show Answer Correct Answer: A) By organizing student information. 4. What are the common data types used in databases? A) Integer, float, string, boolean, date, and time. B) Integer, float, string, boolean, datetime, and timestamp. C) Int, double, char, bool, date, and datetime. D) Number, decimal, text, boolean, date, and timestamp. Show Answer Correct Answer: A) Integer, float, string, boolean, date, and time. 5. In a relational database table for customers, the information about a single customer resides in a single ..... A) Field. B) Row. C) Column. D) Table. Show Answer Correct Answer: B) Row. 6. Which normal form eliminates partial dependencies? A) 1NF. B) 2NF. C) 3NF. D) BCNF. Show Answer Correct Answer: B) 2NF. 7. ..... tools can be used to rapidly analyze large unstructured data sets, such as email, memos, and survey responses, to discover patterns and relationships. A) OLAP. B) Text mining. C) In-memory. D) Clustering. Show Answer Correct Answer: B) Text mining. 8. Which of these is an example of an entire record in a "Students" table? A) Name, Age, Class, Grade. B) StudentID. C) Date of Birth. D) FirstName. Show Answer Correct Answer: A) Name, Age, Class, Grade. 9. Which database structure allows data to be accessed through navigational paths? A) Relational. B) Network. C) Object. D) Tabular. Show Answer Correct Answer: B) Network. 10. How do you retrieve data from a database? A) Use HTML to retrieve data from a database. B) Use SQL SELECT statements to retrieve data from a database. C) Retrieve data using Python scripts without a database connection. D) Access data through a web browser interface. Show Answer Correct Answer: B) Use SQL SELECT statements to retrieve data from a database. 11. What is the main advantage of using a Database Management System (DBMS)? A) It requires no maintenance. B) It is always free to use. C) It provides a way to manage data efficiently. D) It eliminates the need for data. Show Answer Correct Answer: C) It provides a way to manage data efficiently. 12. Which of the following is a feature of a centralized database? A) It is spread across multiple locations. B) It is maintained in a single unit. C) It requires multiple servers. D) It is only used for small data sets. Show Answer Correct Answer: B) It is maintained in a single unit. 13. Which clause combines the result of two SELECT statements, removing duplicates? A) UNION. B) UNION ALL. C) INTERSECT. D) EXCEPT. Show Answer Correct Answer: A) UNION. 14. Which type of database supports the storage and management of spatial data? A) Relational Database. B) NoSQL Database. C) Geographical Information System (GIS). D) Object-Oriented Database. Show Answer Correct Answer: C) Geographical Information System (GIS). 15. What is the primary key constraint used for? A) Foreign key. B) Uniqueness. C) Redundancy. D) Index. Show Answer Correct Answer: B) Uniqueness. 16. In an ERD, what does a rectangle shape represent? A) An entity. B) An attribute. C) A relationship. D) A primary key. Show Answer Correct Answer: A) An entity. 17. Degree and Cardinality of cartesian product of faculty and courses is? A) Degree 9 Cardinality 30. B) Degree 30 Cardinality 9. C) Degree 10 Cardinality 36. D) Degree 36 Cardinality 10. Show Answer Correct Answer: A) Degree 9 Cardinality 30. 18. Which of the following best defines a table in MS Access? A) A file that stores text and images. B) A collection of records organized in rows and columns. C) A layout used to print data. D) A tool to sort and filter information. Show Answer Correct Answer: B) A collection of records organized in rows and columns. 19. A distributed database ..... A) Uses predictive analysis. B) Uses SQL. C) Is a database that is stored in multiple physical locations. D) Is a database that is distributed across many business firms. Show Answer Correct Answer: C) Is a database that is stored in multiple physical locations. 20. Section D:Fill in the Blanks (5 marks)-Write the correct word or term in each blank space. One advantage of a database is that it allows easy ..... of information. A) Searching and sorting. B) Deletion. C) Duplication. D) Hiding. Show Answer Correct Answer: A) Searching and sorting. 21. Cara menghapus database mahasiswa yaitu dengan mengetik? A) DROP DATABASE mahasiswa);. B) DROP mahasiswa DATABASE;. C) DELETE DATABASE mahasiswa;. D) DROP DATABASE mahasiswa;. E) REMOVE DATABASE mahasiswa;. Show Answer Correct Answer: D) DROP DATABASE mahasiswa;. 22. What is the purpose of triggers in a database? A) The purpose of triggers in a database is to automatically execute actions in response to specific events on a table or view. B) To define the structure of a database table. C) To create backups of the database automatically. D) To store data in a more efficient way. Show Answer Correct Answer: A) The purpose of triggers in a database is to automatically execute actions in response to specific events on a table or view. 23. What are the benefits of using a NoSQL database over a traditional relational database? A) NoSQL databases provide better scalability and flexibility for unstructured data. B) NoSQL databases are always slower than relational databases. C) NoSQL databases do not support any form of data consistency. D) NoSQL databases are only suitable for small datasets. Show Answer Correct Answer: A) NoSQL databases provide better scalability and flexibility for unstructured data. 24. How is a row defined in a database? A) A row is a single record in a database table. B) A row is a column in a database table. C) A row is a type of database query. D) A row is a collection of database tables. Show Answer Correct Answer: A) A row is a single record in a database table. 25. Special legal empty value allowed in a database is ..... A) Zero. B) Empty. C) NULL. D) 0. Show Answer Correct Answer: C) NULL. ← 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