This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > 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 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the purpose of normalization in databases? A) The goal of normalization is to enhance data retrieval speed and reduce storage. B) Normalization is used to simplify database design and eliminate all relationships. C) Normalization aims to increase data duplication and decrease integrity. D) The purpose of normalization is to reduce data redundancy and improve data integrity. Show Answer Correct Answer: D) The purpose of normalization is to reduce data redundancy and improve data integrity. 2. What is metadata? A) Data that is processed. B) Data about data. C) Raw data collected. D) Data stored in a database. Show Answer Correct Answer: B) Data about data. 3. What is a data dictionary? A) A control for formatting data input. B) A table that represents the structure of a database table at the design stage. C) A primary key in another table. D) An automatic check to reduce errors. Show Answer Correct Answer: B) A table that represents the structure of a database table at the design stage. 4. What data type is used to store 09/11/2023 values? A) Number. B) Date/Time. C) Date/Time Extended. D) Currency. Show Answer Correct Answer: B) Date/Time. 5. Which key is selected from a set of candidate keys to uniquely identify a record? A) Composite key. B) Foreign key. C) Secondary key. D) Primary key. Show Answer Correct Answer: D) Primary key. 6. What is the purpose of data modeling? A) To help programmers and others understand the complex flow of data within an organization. B) To create new programming languages. C) To manage network security. D) To design hardware components. Show Answer Correct Answer: A) To help programmers and others understand the complex flow of data within an organization. 7. How would you sort the results of a query in descending order by the column "score" ? A) GROUP BY score DESC. B) SORT score DESCENDING. C) ORDER BY score ASC. D) ORDER BY score DESC. Show Answer Correct Answer: D) ORDER BY score DESC. 8. A ..... database is designed for handling large-scale and unstructured data. A) NoSQL. B) Network. C) Relational. D) Hierarchical. Show Answer Correct Answer: A) NoSQL. 9. Berikut ini perintah yang ada pada Data Control Language adalah ..... A) Grant. B) Revoke. C) Truncate. D) Grant and Revoke. E) Revoke and Truncate. Show Answer Correct Answer: D) Grant and Revoke. 10. What does the LIKE operator do in a query? A) Searches for a specific pattern in a field. B) Deletes records. C) Sorts data in descending order. D) Adds new records automatically. Show Answer Correct Answer: A) Searches for a specific pattern in a field. 11. What does normalization aim to achieve? A) Combine all data into one table. B) Increase data complexity. C) Maximize data storage. D) Minimize redundancy and dependency. Show Answer Correct Answer: D) Minimize redundancy and dependency. 12. 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. 13. Which of the following data is NOT alphanumeric? A) "MathsExam2024". B) "Fadi2025". C) "ABC123". D) "#####". Show Answer Correct Answer: D) "#####". 14. ..... are the one who store retrieve, update and delete data. A) End user. B) Programmer. C) GIS. D) Database designer. Show Answer Correct Answer: A) End user. 15. 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. 16. 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. 17. 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. 18. Which database model stores data in objects with attributes and methods, similar to object-oriented programming? A) Network Database Model. B) Hierarchical Database Model. C) Object-Oriented Database Model. D) Relational Database Model. Show Answer Correct Answer: C) Object-Oriented Database Model. 19. What is an "entity" in a relational database? A) A rule used to normalize data. B) A query that retrieves data. C) A foreign key in a database table. D) A real-world object or concept represented by a table. Show Answer Correct Answer: D) A real-world object or concept represented by a table. 20. 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. 21. Which view is best for creating calculated fields? A) Print Preview. B) Form View. C) Datasheet View. D) Design View. Show Answer Correct Answer: D) Design View. 22. What does DBMS stand for? A) Data Backup Management System. B) Data Base Management System. C) Data Base Maintenance System. D) Database Management Software. Show Answer Correct Answer: B) Data Base Management System. 23. 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. 24. 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;. 25. Which of the following is NOT a tool that is available with a complete database management system A) Ad-hoc query. B) Graphics. C) Report writer. D) Presentation. Show Answer Correct Answer: D) Presentation. 26. 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. 27. What type of database is Microsoft SQL Server classified as? A) Hierarchical Database. B) NoSQL Database. C) Object-Oriented Database. D) Relational Database. Show Answer Correct Answer: D) Relational Database. 28. In a classroom database, which field uniquely identifies each student record? A) Primary key. B) Foreign key. C) Search key. D) Duplicate key. Show Answer Correct Answer: A) Primary key. 29. What is a secondary key in a database? A) A column that uniquely identifies a subset of rows. B) A column that can be used as a primary key. C) A column that is not required to be unique. D) A column that references another table. Show Answer Correct Answer: A) A column that uniquely identifies a subset of rows. 30. 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. 31. 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. 32. 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. 33. 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. 34. Which of the following is NOT a database language? A) DML. B) HTML. C) DDL. D) DCL. Show Answer Correct Answer: B) HTML. 35. Segala pengguna software aplikasi (user) adalah ..... A) Relationship. B) Actor. C) Note. D) Use case. E) Use case subject. Show Answer Correct Answer: B) Actor. 36. Which of the following is the default view when a new table is created in Access? A) Layout View. B) Datasheet View. C) Design View. D) Form View. Show Answer Correct Answer: B) Datasheet View. 37. Perintah yang digunakan untuk menampilkan tabel yang telah di buat adalah ..... A) Show databases;. B) Desc table;. C) Show table;. D) Select nama table;. E) Show tables;. Show Answer Correct Answer: E) Show tables;. 38. Malachi is designing a database for a car rental company. Why is a license plate number suitable as a primary key? A) It is easy to remember. B) It is a number field. C) It is always unique. D) It can be duplicated in different states. Show Answer Correct Answer: C) It is always unique. 39. The virtual table that its created by data from the result of an SQL 'Select' statement is called ..... A) Transaction. B) Synonym. C) Sequence. D) View. Show Answer Correct Answer: D) View. 40. Define the term 'field' in a database context. A) A field is a type of database that contains multiple tables. B) A field is a column in a database table that stores individual data attributes for records. C) A field is a graphical interface for database management. D) A field is a database command used to retrieve data. Show Answer Correct Answer: B) A field is a column in a database table that stores individual data attributes for records. 41. Which of the following is the BEST example of symbolic data? A) A12345. B) 24567. C) January. D) @#$ %. Show Answer Correct Answer: D) @#$ %. 42. The cardinality ratio of a relationship describes: A) The physical storage size of data. B) The number of attributes in a table. C) The speed of data retrieval. D) The number of instances of one entity that can or must be associated with instances of another entity. Show Answer Correct Answer: D) The number of instances of one entity that can or must be associated with instances of another entity. 43. Who is primarily responsible for producing the high-level data model that describes entities, relationships and constraints for the entire organization? A) Physical database designer. B) Database administrator. C) Conceptual database designer. D) Data entry clerk. Show Answer Correct Answer: C) Conceptual database designer. 44. Which of the following views is used to set field properties such as field size and caption? A) Form View. B) Datasheet View. C) Report View. D) Design View. Show Answer Correct Answer: D) Design View. 45. What is the role of SQL Server in database management? A) To create spreadsheets. B) To design user interfaces. C) To administer databases. D) To manage email servers. Show Answer Correct Answer: C) To administer databases. 46. In a "One to Many" relationship, which table is considered the parent? A) The table with fewer records. B) The table on the left. C) The table on the right. D) The table with more records. Show Answer Correct Answer: B) The table on the left. 47. Which of the following best describes a database system? A) A programming language for databases. B) An organization of components that manage data. C) A single table of data. D) A collection of unrelated data. Show Answer Correct Answer: B) An organization of components that manage data. 48. What does data architecture describe? A) The access methods of the data assets. B) The flow and structure of data assets. C) The network layout used to transfer data. D) None of the above. Show Answer Correct Answer: B) The flow and structure of data assets. 49. Which of the following is NOT a valid secondary key in a database? A) A product's name. B) A student's last name. C) An order's date. D) A customer's name. Show Answer Correct Answer: A) A product's name. 50. The join operation ..... A) Creates a subset consisting of columns in a table. B) Combines relational tables to provide the user with more information than is otherwise available. C) Identifies the table from which the columns will be selected. D) Organizes elements into segments. Show Answer Correct Answer: B) Combines relational tables to provide the user with more information than is otherwise available. 51. What does the self-describing nature of databases provide? A) Complete description of database structure stored in system catalog. B) User authentication. C) Data encryption. D) Automatic data entry. Show Answer Correct Answer: A) Complete description of database structure stored in system catalog. 52. Which view allows you to see the structure of a table and set field names, data types, and sizes? A) Form View. B) Design View. C) Query View. D) Datasheet View. Show Answer Correct Answer: B) Design View. 53. A relationship between two tables is established using which key? A) Primary Key. B) Candidate Key. C) Foreign Key. D) Unique Key. Show Answer Correct Answer: C) Foreign Key. 54. In a database, how is a many-to-many (N:N) relationship between two entities typically resolved? A) By creating a composite entity (junction table) with foreign keys to both entities. B) By combining the attributes of both entities into a single entity. C) By denormalizing the database structure for better performance. D) By using a one-to-many (1:N) relationship between the entities. Show Answer Correct Answer: A) By creating a composite entity (junction table) with foreign keys to both entities. 55. What is a composite key? A) Multiple fields combined to identify a record. B) A type of data. C) A single field that identifies a record. D) A method of data storage. Show Answer Correct Answer: A) Multiple fields combined to identify a record. 56. Describe the process of de-normalization. A) De-normalization is the process of removing redundancy from a database schema. B) De-normalization is the process of introducing redundancy into a database schema to improve read performance. C) De-normalization is used to ensure data integrity in a database. D) De-normalization is the process of optimizing a database for write performance. Show Answer Correct Answer: B) De-normalization is the process of introducing redundancy into a database schema to improve read performance. 57. What is a database index and why is it used? A) A database index is a data structure that improves the speed of data retrieval operations. B) A database index is a method for encrypting data. C) A database index is used to store data permanently. D) A database index is a type of database backup. Show Answer Correct Answer: A) A database index is a data structure that improves the speed of data retrieval operations. 58. In a one-to-one relationship: A) Tables do not need relationships. B) It is not commonly used in databases. C) One record in table A has at most one matching record in table B. D) A record in table A can have multiple matches in table B. Show Answer Correct Answer: C) One record in table A has at most one matching record in table B. 59. How does information differ from data? A) Information is raw, while data is processed. B) Data is meaningful, while information is not. C) Information is data that has been processed and given context. D) There is no difference between data and information. Show Answer Correct Answer: C) Information is data that has been processed and given context. 60. Which feature in reports allows grouping and summarizing data? A) Sorting. B) Formatting. C) Filtering. D) Grouping. Show Answer Correct Answer: D) Grouping. ← PreviousNext →Related QuizzesScience QuizzesClass 11 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 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books