This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 34 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 34 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. 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. 2. Cara menghapus database mahasiswa yaitu dengan mengetik? A) DROP DATABASE mahasiswa;. B) DROP DATABASE mahasiswa);. C) DROP mahasiswa DATABASE;. D) DELETE DATABASE mahasiswa;. E) REMOVE DATABASE mahasiswa;. Show Answer Correct Answer: A) DROP DATABASE mahasiswa;. 3. 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. 4. How is a row defined in a database? A) A row is a column in a database table. B) A row is a single record in a database table. C) A row is a collection of database tables. D) A row is a type of database query. Show Answer Correct Answer: B) A row is a single record in a database table. 5. Special legal empty value allowed in a database is ..... A) Empty. B) NULL. C) 0. D) Zero. Show Answer Correct Answer: B) NULL. 6. Which of the following is true about a "primary key" ? A) A primary key must be a foreign key. B) A primary key uniquely identifies each record in a table. C) A primary key can be duplicated across multiple records. D) A primary key must always be a composite key. Show Answer Correct Answer: B) A primary key uniquely identifies each record in a table. 7. This is a collection of programs that enables users to create and maintain databases and control all access to them. A) Database Administrator. B) Database. C) Database Management System. D) Data. Show Answer Correct Answer: C) Database Management System. 8. Which of the following best describes NoSQL databases? A) They are always centralized. B) They are designed for unstructured data. C) They require SQL for queries. D) They are only used for small applications. Show Answer Correct Answer: B) They are designed for unstructured data. 9. What does the 'select' clause do in an SQL query? A) Specifies the attributes to be returned. B) Creates a new table. C) Defines the tables to be used. D) Filters the results. Show Answer Correct Answer: A) Specifies the attributes to be returned. 10. What is the most essential element of a database? A) Query. B) Report. C) Form. D) Table. Show Answer Correct Answer: D) Table. 11. What do reports provide in a database? A) Art designs. B) Video tutorials. C) Music playlists. D) Printable summaries of information. Show Answer Correct Answer: D) Printable summaries of information. 12. Why are key-value databases useful for tasks that need quick data access? A) They use complex data models. B) They cannot grow quickly. C) They are difficult to understand. D) They have a flexible structure. Show Answer Correct Answer: D) They have a flexible structure. 13. What is a 'relation' in a relational data model? A) A relation is a collection of unrelated data points. B) A relation is a single row in a database table. C) A relation is a table consisting of rows and columns in a relational data model. D) A relation is a set of functions in programming. Show Answer Correct Answer: C) A relation is a table consisting of rows and columns in a relational data model. 14. In a library database, the "MemberID" field in the "Issue Table" refers to "MemberID" in the "Members Table." This is a: A) Domain Key. B) Foreign Key. C) Alternate Key. D) Primary Key. Show Answer Correct Answer: B) Foreign Key. 15. Explain the difference between an entity and an attribute in the context of the entity-relationship model. A) An attribute is a type of entity. B) An entity is a type of attribute. C) An entity and an attribute are the same thing. D) An entity represents a real-world object or concept, while an attribute represents a property or characteristic of that entity. Show Answer Correct Answer: D) An entity represents a real-world object or concept, while an attribute represents a property or characteristic of that entity. 16. Microsoft releases MS access, a custom DBMS that replaces all other custom DBMS products A) 1993. B) 1994. C) 1990. D) 1991. E) 1992. Show Answer Correct Answer: D) 1991. 17. What does the SQL UPDATE command do? A) Renames a table. B) Deletes existing data. C) Creates a new database. D) Modifies existing data. Show Answer Correct Answer: D) Modifies existing data. 18. Relational Algebra is used to query the database tables using A. B. C. D. A) Relational model. B) Dbase. C) ER Model. D) SQL. Show Answer Correct Answer: D) SQL. 19. What data type is used to store 248999, such as whole numbers and decimal numbers? A) Number. B) Date/Time. C) Text. D) Large Number. Show Answer Correct Answer: A) Number. 20. Which database model uses a tree-like structure with parent-child relationships? A) Relational Model. B) Network Model. C) Object-Oriented Model. D) Hierarchical Model. Show Answer Correct Answer: D) Hierarchical Model. 21. What is a unique identifier for a record in a table? A) Primary key. B) Secondary key. C) Foreign key. D) Index key. Show Answer Correct Answer: A) Primary key. 22. What is the cardinality of a relationship that is one-to-many? A) 0:1. B) M:1. C) 1:m. D) M:m. Show Answer Correct Answer: C) 1:m. 23. Which of the following can database software allow you to create? A) Tables, forms, and reports. B) Only spreadsheets. C) Only images. D) Only emails. Show Answer Correct Answer: A) Tables, forms, and reports. 24. What is an indexed field in a database? A) A field used to speed up searches. B) A field that is automatically updated. C) A field that allows duplicate values. D) A field that stores only numbers. Show Answer Correct Answer: A) A field used to speed up searches. 25. To resize a column in Access, one should: A) Use the View button. B) Click and drag the column border. C) Use Field Templates. D) Press Shift + Enter. Show Answer Correct Answer: B) Click and drag the column border. 26. In a "Students" table, the field "Admission Number" uniquely identifies every student. It is a: A) Foreign Key. B) Primary Key. C) Alternate Key. D) Candidate Key. Show Answer Correct Answer: B) Primary Key. 27. Which of the following is NOT a type of database constraint? A) Data type constraint. B) Primary key constraint. C) Unique key constraint. D) Foreign key constraint. Show Answer Correct Answer: A) Data type constraint. 28. A relational database is defined as a database that ..... A) Stores data in separate but related tables. B) Stores all information in one large table. C) Uses only one primary key per database. D) Cannot be modified once created. Show Answer Correct Answer: A) Stores data in separate but related tables. 29. What is the repetition of data indicative of? A) Inconsistency. B) Dependance. C) Redundancy. D) Isolation. Show Answer Correct Answer: C) Redundancy. 30. A data lake is composed of ..... A) Historical data from legacy systems. B) Raw unstructured and structured data that has not been analyzed. C) Internal and external data sources. D) Historic and current internal data. Show Answer Correct Answer: B) Raw unstructured and structured data that has not been analyzed. 31. What is a view in a database? A) A type of database. B) A subset of the database. C) A method to store data. D) A way to delete data. Show Answer Correct Answer: B) A subset of the database. 32. Data models are used to ..... A) Design databases. B) Control networks. C) Write programs. D) Store hardware details. Show Answer Correct Answer: A) Design databases. 33. Which condition is necessary for a distributed database? A) It must be located in one city. B) It must be connected to the internet. C) It must be stored on a single server. D) It must be managed by one person. Show Answer Correct Answer: B) It must be connected to the internet. 34. Which diagram is used to visually represent database relationships? A) Entity-Relationship (E-R) Diagram. B) Gantt Chart. C) Bar Graph. D) Flowchart. Show Answer Correct Answer: A) Entity-Relationship (E-R) Diagram. 35. A foreign key in a database is used to: A) Serve as a primary key in the same table. B) Increase data storage capacity. C) Improve data retrieval speed. D) Enforce referential integrity between two tables. Show Answer Correct Answer: D) Enforce referential integrity between two tables. 36. What is the difference between TRUNCATE and DELETE in SQL? A) TRUNCATE removes rows one by one and logs each removal, while DELETE removes all rows at once without logging. B) DELETE can remove specific rows based on a condition, while TRUNCATE removes all rows without conditions and is faster. C) TRUNCATE can remove rows based on conditions, but DELETE cannot. D) TRUNCATE cannot be rolled back, but DELETE can. Show Answer Correct Answer: B) DELETE can remove specific rows based on a condition, while TRUNCATE removes all rows without conditions and is faster. 37. Which transaction command to undo changes? A) DELETE. B) COMMIT. C) ROLLBACK. D) SAVEPOINT. Show Answer Correct Answer: C) ROLLBACK. 38. What are some popular big data technologies? A) Microsoft Excel, Google Sheets, Tableau. B) Apache Hadoop, Apache Spark, Apache Kafka, NoSQL databases (e.g., MongoDB, Cassandra), Apache Flink, and Apache Storm. C) Apache Tomcat, Apache Ant, Apache Maven. D) MySQL databases (e.g., PostgreSQL, SQLite). Show Answer Correct Answer: B) Apache Hadoop, Apache Spark, Apache Kafka, NoSQL databases (e.g., MongoDB, Cassandra), Apache Flink, and Apache Storm. 39. A set of one (1) or more computer programs that serves as an intermediary between the user and the DBMS. A) Database Application. B) Database Software. C) Database System. D) Database Integration. Show Answer Correct Answer: A) Database Application. 40. Dalam struktur database 'Kasir' yang ditunjukkan, tabel 'nota ..... penjualan' memiliki kolom 'id ..... pelanggan'. Kolom ini kemungkinan besar berfungsi sebagai apa? A) Foreign Key. B) Primary Key. C) Unique Key. D) Index. Show Answer Correct Answer: A) Foreign Key. 41. A key that consists of more than one attribute (e.g. (studentId, courseCode)) is called a: A) Candidate key. B) Composite key. C) Superkey. D) Secondary key. Show Answer Correct Answer: B) Composite key. 42. Which is NOT a problem of file systems? A) Poor security. B) Data redundancy. C) Data inconsistency. D) Data sharing. Show Answer Correct Answer: D) Data sharing. 43. Which of the following is an example of information? A) 45, 60, 75. B) Numbers only. C) Raw data. D) Average = 60, Result = Pass. Show Answer Correct Answer: D) Average = 60, Result = Pass. 44. Explain the concept of 'JOIN' in SQL and provide an example. A) The 'JOIN' clause in SQL is used to update rows in a table based on a condition. B) The 'JOIN' clause in SQL is used to sort the data in descending order. C) The 'JOIN' clause in SQL is used to delete rows from a table based on a condition. D) The 'JOIN' clause in SQL is used to combine rows from two or more tables based on a related column between them. Show Answer Correct Answer: D) The 'JOIN' clause in SQL is used to combine rows from two or more tables based on a related column between them. 45. Why are databases at risk in networked environments? A) Vulnerable components in the system may be exploited for attacks. B) They lack online indexing capabilities. C) They are isolated from monitoring tools in a networked environment. D) None of the above. Show Answer Correct Answer: A) Vulnerable components in the system may be exploited for attacks. 46. What do you mean by one to many relationships? A) Many classes may have many teachers. B) One class may have many teaches. C) One teacher can have many classes. D) Many teachers may have many classes. Show Answer Correct Answer: C) One teacher can have many classes. 47. Which of the following is a benefit of the three-level database architecture? A) Data independence. B) Simplified data entry. C) Improved transaction speed. D) Automated indexing. Show Answer Correct Answer: A) Data independence. 48. What is the advantage of using a DBMS? A) Data sharing. B) Data performance. C) Data complexity. D) Data security. Show Answer Correct Answer: A) Data sharing. 49. What is the purpose of database management? A) To create new data. B) To organize and store information efficiently. C) To delete old records. D) To print documents. Show Answer Correct Answer: B) To organize and store information efficiently. 50. Information is processed data, it has meaning or context. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 51. What is the relationship between fields and records? A) Records are stored inside fields. B) Fields are created from records. C) Fields are the rows of a record. D) Records are made up of multiple fields. Show Answer Correct Answer: D) Records are made up of multiple fields. 52. What is the role of database transactions in ensuring data integrity? A) Database transactions have no impact on data integrity. B) Database transactions ensure data consistency, isolation, durability, and atomicity, thereby maintaining data integrity. C) Database transactions are only used for data deletion in a database. D) Database transactions are not relevant in ensuring data integrity. Show Answer Correct Answer: B) Database transactions ensure data consistency, isolation, durability, and atomicity, thereby maintaining data integrity. 53. Which of the following statements about foreign keys is true? A) A foreign key must reference a primary key in the same table. B) A foreign key is used to enforce unique constraints on the referenced column. C) A foreign key can only reference a composite key. D) A foreign key establishes a relationship between two tables. Show Answer Correct Answer: D) A foreign key establishes a relationship between two tables. 54. How do you change the name of a table in SQL? A) RENAME employees AS staff;. B) UPDATE TABLE employees SET name = staff;. C) RENAME TABLE employees TO staff;. D) ALTER TABLE employees TO staff;. Show Answer Correct Answer: C) RENAME TABLE employees TO staff;. 55. Which of the following is not one of the benefits of a blockchain database? A) It enables the ability to use relational databases. B) It prevents data from being altered retroactively. C) It allows administrators to manage data more effectively. D) It enables firms to create and verify transactions on a network very rapidly. Show Answer Correct Answer: A) It enables the ability to use relational databases. 56. What does the ASCII character set do? A) It processes binary numbers into text. B) It helps format Excel tables. C) It assigns a binary code to each letter, number, or symbol. D) It organizes large amounts of data into databases. Show Answer Correct Answer: C) It assigns a binary code to each letter, number, or symbol. 57. True or False:In the Courses table, the column CourseName is an attribute, and values like 'Data Structures', 'Algorithms' are part of its domain. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 58. Which system stores data in separate application files? A) Database system. B) File system. C) Data model. D) DBMS. Show Answer Correct Answer: B) File system. 59. In the context of a university database, what does the 'Exams Table' contain? A) Student ID, Name, Age. B) Lecturer ID, Name, Department. C) Course ID, Course Name, Lecturer. D) Student ID, Course ID, Score, Grade. Show Answer Correct Answer: D) Student ID, Course ID, Score, Grade. 60. A form is used to view and enter data into a database table. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. ← 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 6Class 11 Computer Science Chapter 7 Database Concepts Quiz 7Class 11 Computer Science Chapter 7 Database Concepts Quiz 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books