This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 5 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 5 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is a filter in a database? A) A tool to delete data. B) A tool to format data. C) A tool to create new tables. D) A tool to display only specific records based on criteria. Show Answer Correct Answer: D) A tool to display only specific records based on criteria. 2. What is the purpose of a "primary key" ? A) To create a relationship between two databases. B) To link two tables together. C) To provide backup for a table's data. D) To uniquely identify each record in a table. Show Answer Correct Answer: D) To uniquely identify each record in a table. 3. A company's employee table lists "Department = HR, IT, Sales." If one record shows "Department = XY, " this violates: A) Domain Rule. B) Redundancy Rule. C) Data Integrity. D) Normalization. Show Answer Correct Answer: C) Data Integrity. 4. What is the main function of the internal level? A) Provides business rules. B) Shows user interface. C) Represents reports. D) Defines physical storage. Show Answer Correct Answer: D) Defines physical storage. 5. An individual data item stored for an entity, for example, name, address, or date of birth. A) Entity. B) Field. C) Record. D) Attribute (database). Show Answer Correct Answer: D) Attribute (database). 6. What is the purpose of a relational database? A) To store data in tables with rows and columns. B) To create visual presentations. C) To manage email communications. D) To design web pages. Show Answer Correct Answer: A) To store data in tables with rows and columns. 7. What is the main purpose of a database catalog? A) To store user data. B) To manage user access. C) To describe the database structure and constraints. D) To create backups of the database. Show Answer Correct Answer: C) To describe the database structure and constraints. 8. Which of the following is used for entering, modifying, and viewing records in a database? A) Report. B) Query. C) Table. D) Form. Show Answer Correct Answer: D) Form. 9. What are the components of an E-R model? A) Entity. B) Attributes. C) Relationship. D) All the above. Show Answer Correct Answer: D) All the above. 10. The data values for all the fields related to a person or object is called a record. A) False. B) True. C) All the above. D) None of the above. Show Answer Correct Answer: B) True. 11. If a shop keeps a table for all products, this table is called a: A) Schema. B) Relation. C) Domain. D) Entity. Show Answer Correct Answer: B) Relation. 12. What is the main advantage of using a database over a simple list? A) Databases are more difficult to use. B) Databases organize and retrieve data efficiently. C) Databases do not allow relationships between data. D) Databases only work on large computers. Show Answer Correct Answer: B) Databases organize and retrieve data efficiently. 13. What is the primary key for the continents table? A) Population. B) Continent. C) Name. D) Area. Show Answer Correct Answer: B) Continent. 14. Indicate whether the statement is true or false:Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 15. What does ACID stand for in the context of database transactions? A) Atomicity, Consistency, Isolation, Durability. B) Aggregate, Commit, Isolate, Distribute. C) Association, Constraint, Index, Data. D) All Columns In Database. Show Answer Correct Answer: A) Atomicity, Consistency, Isolation, Durability. 16. The purposes of normalization are: A) To ensure that the anomalies doesn't occur. B) To reduce data or storage redundancy. C) To ensure easy for record searching/finding. D) All the above. Show Answer Correct Answer: D) All the above. 17. A ..... is an organized collection of structured data. A) DBMS. B) Information. C) Database. D) File. Show Answer Correct Answer: C) Database. 18. The DBMS can be divided into ..... major components. A) 6. B) 5. C) 7. D) 4. Show Answer Correct Answer: B) 5. 19. A data ..... is a set of rules that define valid data. A) Constraint. B) Data dictionary. C) Query. D) All of these. Show Answer Correct Answer: A) Constraint. 20. When should a composite unique identifier be used in a database design? A) When a foreign key is used to link two entities together. B) When there is a one-to-one (1:1) relationship between two entities. C) When an entity has a many-to-many (N:N) relationship with another entity. D) When there are multiple attributes that together uniquely identify an entity. Show Answer Correct Answer: D) When there are multiple attributes that together uniquely identify an entity. 21. Which of the following is a problem commonly associated with the old file-based approach? A) Centralized control of data. B) High data independence. C) Program-data dependence. D) Standardized query language. Show Answer Correct Answer: C) Program-data dependence. 22. How do records relate to rows in a database? A) Rows are a type of record that only contains metadata. B) Records are unrelated to rows in a database. C) Records are represented as rows in a database table. D) Records are stored in columns of a database table. Show Answer Correct Answer: C) Records are represented as rows in a database table. 23. What is the primary purpose of a database? A) To create beautiful presentations. B) To organize and manage large amounts of information. C) To play video games. D) To send emails. Show Answer Correct Answer: B) To organize and manage large amounts of information. 24. Perintah SQL yang digunakan untuk menghapus tabel bernama 'nama ..... siswa' adalah ..... A) ERASE TABLE nama siswa;. B) DROP TABLE nama siswa;. C) REMOVE TABLE nama siswa;. D) DELETE TABLE nama siswa;. Show Answer Correct Answer: B) DROP TABLE nama siswa;. 25. What is Data Definition Language (DDL)? A) Data Definition Language (DDL) is a language used to define and manage database structures. B) Data Definition Language (DDL) is a protocol for securing data access. C) Data Definition Language (DDL) is a tool for visualizing database queries. D) Data Definition Language (DDL) is a method for analyzing data trends. Show Answer Correct Answer: A) Data Definition Language (DDL) is a language used to define and manage database structures. 26. Which of the following is an example of a DBMS A) Microsoft Office. B) Oracle. C) SQL. D) PHP. Show Answer Correct Answer: B) Oracle. 27. Which of the following is NOT a type of database? A) Relational Database. B) NoSQL Database. C) Object-Oriented Database. D) Static Database. Show Answer Correct Answer: D) Static Database. 28. Which of the following is a characteristic of metadata? A) It is raw data. B) It is only used for storage. C) It is not related to end user data. D) It describes data characteristics. Show Answer Correct Answer: D) It describes data characteristics. 29. What is data about data called? A) Metadata. B) Data inconsistency. C) Data redundancy. D) Data Description. Show Answer Correct Answer: A) Metadata. 30. Which of the following is a benefit of using indexes in a database? A) They prevent data duplication. B) They increase storage requirements. C) They slow down data retrieval. D) They speed up data retrieval. Show Answer Correct Answer: D) They speed up data retrieval. 31. Which of the following is a Data Definition Language (DDL) command? A) Merge. B) Delete. C) Insert. D) Drop. Show Answer Correct Answer: D) Drop. 32. What is the first step in creating a database file in MS Access? A) Enter data. B) Open the software. C) Change the file name. D) Click "Create". Show Answer Correct Answer: B) Open the software. 33. True or False:When multiple people want to access "the data" at the same time, does this pose a challenge for databases? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 34. Define a view in SQL and its purpose. A) A view in SQL is a command used to delete records from a table. B) A view in SQL is a physical table that stores data permanently. C) A view in SQL is a type of index that speeds up queries. D) A view in SQL is a virtual table that represents the result of a stored query. Show Answer Correct Answer: D) A view in SQL is a virtual table that represents the result of a stored query. 35. What does DML stand for and what does it include? A) Data Management Language; it includes CREATE, ALTER, DROP. B) Data Modeling Language; it includes SELECT, INSERT, UPDATE, DELETE. C) Data Mining Language; it includes SELECT, INSERT, UPDATE, DELETE. D) Data Manipulation Language; it includes SELECT, INSERT, UPDATE, DELETE. Show Answer Correct Answer: D) Data Manipulation Language; it includes SELECT, INSERT, UPDATE, DELETE. 36. Indicate whether the statement is true or false:An unnormalized relation contains repeating groups. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 37. Sebuah kumpulan data yang saling terkait yang disimpan dalam perangkat keras komputer dan digunakan oleh perangkat lunak untuk memanipulasinya adalah definisi dari ..... A) Databese. B) Databes. C) Basis Data. D) Databeses. E) Database. Show Answer Correct Answer: E) Database. 38. An ER diagram shows relationships between: A) Records with foreign keys. B) Two items about which there is data kept. C) Tables in a relational database. D) Rows in a relational database. Show Answer Correct Answer: C) Tables in a relational database. 39. Which property is important in order to reduce and improve data integrity? A) Database distribution. B) Database normalization. C) Data storage. D) Data access. Show Answer Correct Answer: D) Data access. 40. What is the purpose of data integrity? A) To ensure data is always deleted. B) To maintain the accuracy and consistency of data. C) To create new data entries. D) To ignore outdated data. Show Answer Correct Answer: B) To maintain the accuracy and consistency of data. 41. Which of the following is one of the basic types of joins in DB? A) Outer join. B) Self-join. C) Equi-join. D) All of the above. Show Answer Correct Answer: D) All of the above. 42. Which level of data abstraction describes what data is stored and the relationships among data? A) Physical level. B) Internal level. C) Conceptual level. D) External level. Show Answer Correct Answer: C) Conceptual level. 43. An entity that is related with it is known as ..... A) Binary relationship. B) Recursive relationship. C) Ternary relationship. D) None of the above. Show Answer Correct Answer: A) Binary relationship. 44. What is a stored procedure? A) A stored procedure is a temporary table used for data storage. B) A stored procedure is a precompiled collection of SQL statements stored in a database. C) A stored procedure is a single SQL statement executed on demand. D) A stored procedure is a type of database index. Show Answer Correct Answer: B) A stored procedure is a precompiled collection of SQL statements stored in a database. 45. Which function returns the minimum value in a column? A) COUNT(). B) AVG(). C) SUM(). D) MIN(). Show Answer Correct Answer: D) MIN(). 46. In what scenario would sorting data in ascending order be particularly useful? A) When the data does not have a natural ordering. B) When you need to find the most recent entry quickly. C) When you want to display records from oldest to newest. D) When you are looking for the highest value onlyTagsDOK Level 3:Strategic Thinking. Show Answer Correct Answer: C) When you want to display records from oldest to newest. 47. What is a row in a database? A) A single folder. B) A single unit of data. C) A single image. D) A single file. Show Answer Correct Answer: B) A single unit of data. 48. Can a database have multiple primary keys? A) A primary key can be composed of multiple columns in a database. B) No, a database cannot have multiple primary keys. C) A database can have one primary key per table. D) Yes, a database can have multiple primary keys. Show Answer Correct Answer: B) No, a database cannot have multiple primary keys. 49. Which of the following database structures uses a tree-like format to store data? A) Graph database. B) Network database. C) Hierarchical database. D) Relational database. Show Answer Correct Answer: C) Hierarchical database. 50. Which of the following statements about big data is not true? A) Big data refers solely to data in the petabyte range. B) Big data can reveal more patterns and interesting relationships than smaller data sets. C) Big data are produced in much larger quantities and much more rapidly than traditional data. D) Big data is finding many uses in the public sector. Show Answer Correct Answer: A) Big data refers solely to data in the petabyte range. 51. Which SQL command delete all the records and does not remove the structure? A) Drop. B) Insert. C) Truncate. D) None of the above. Show Answer Correct Answer: C) Truncate. 52. Thierry is designing a database for a school project. He needs to decide how many Primary keys a table can have. How many can he choose? A) Only 1. B) Depends on number of columns. C) Depends on DBA. D) Only 2. Show Answer Correct Answer: A) Only 1. 53. A report is needed to display student names, class names, and their assigned teachers. What must be done first? A) Create a query joining Students, Classes, and Teachers tables. B) Create a new table for reports. C) Enter the data manually. D) Print each table separately. Show Answer Correct Answer: A) Create a query joining Students, Classes, and Teachers tables. 54. How can graphics be added to a form in MS Access? A) Using the Insert Image control. B) Through the Form Wizard only. C) Through query design. D) By copying from Excel only. Show Answer Correct Answer: A) Using the Insert Image control. 55. What is the main function of reports in a database? A) To automate tasks. B) To present data in different views and formats. C) To change data. D) To retrieve data. Show Answer Correct Answer: B) To present data in different views and formats. 56. What is a "column" in the context of a table? A) A vertical set of data representing an attribute. B) A foreign key. C) A relationship between two tables. D) A SQL query. Show Answer Correct Answer: A) A vertical set of data representing an attribute. 57. Which of the following describes a "row" in a relational database? A) A unique identifier for a table. B) A single, complete set of related data in a table. C) A query that selects specific records. D) A command used to create a database schema. Show Answer Correct Answer: B) A single, complete set of related data in a table. 58. Data cleansing not only corrects errors but also ..... A) Establishes logical relationships between data. B) Enforces consistency among different sets of data that originated in a separate information system. C) Normalizes data. D) Structures data. Show Answer Correct Answer: B) Enforces consistency among different sets of data that originated in a separate information system. 59. When each entity in the entity set may not occur in at least one relationship in that relationship set, is called: A) Total Participation. B) Partial Participation. C) Relational Participation. D) Conditional Participation. Show Answer Correct Answer: B) Partial Participation. 60. This is a software that controls the storage, organization, and retrieval of data. A) DBMS. B) Data. C) Information. D) Database. Show Answer Correct Answer: A) DBMS. ← 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 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 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books