This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 26 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 26 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What does the term "data redundancy" refer to? A) Storing data in multiple formats. B) Processing data to create information. C) Duplicating data unnecessarily within a database. D) The inability to retrieve data when needed. Show Answer Correct Answer: C) Duplicating data unnecessarily within a database. 2. Why is a database important in organizing information? A) It keeps information structured and easy to find. B) It removes all duplicate data automatically. C) It only stores numerical data. D) It is only useful for large organizations. Show Answer Correct Answer: A) It keeps information structured and easy to find. 3. Which term refers to a unique identifier for each record in a table that is composed of more than one field? A) Composite key. B) Foreign key. C) Primary key. D) Secondary key. Show Answer Correct Answer: A) Composite key. 4. What is a composite key in a database? A) A key made up of multiple attributes. B) A key used for encryption. C) A key that uniquely identifies each record. D) None of the above. Show Answer Correct Answer: A) A key made up of multiple attributes. 5. Neha wishes to rename a table in her database. What should she do? A) Press F5. B) Right-click table name and select Rename. C) Use Save As. D) Edit field name in Datasheet. Show Answer Correct Answer: B) Right-click table name and select Rename. 6. Which of the following is an example of domain integrity being enforced? A) A student's ID is unique. B) A grade must be between 1 and 7. C) A teacher record is deleted when a course is removed. D) A database is restored from backup. Show Answer Correct Answer: B) A grade must be between 1 and 7. 7. What does a conceptual data model NOT include? A) Primary keys. B) Business ideas and rules. C) Entities and their attributes. D) Relationships between entities. Show Answer Correct Answer: A) Primary keys. 8. What is the purpose of Advanced Filter Sort? A) To create new databases. B) To modify form layouts. C) To perform complex filtering and sorting operations. D) To print reports only. Show Answer Correct Answer: C) To perform complex filtering and sorting operations. 9. Provide an example of a dependency in a database. A) DepartmentID $\rightarrow$ ProjectName. B) EmployeeID $\rightarrow$ EmployeeName. C) EmployeeName $\rightarrow$ EmployeeID. D) ProjectID $\rightarrow$ EmployeeRole. Show Answer Correct Answer: B) EmployeeID $\rightarrow$ EmployeeName. 10. What are relationships in the context of a relational database? A) Links between users and databases. B) The joins between tables in a relational database. C) The connections between different databases. D) The formatting styles in database tables. Show Answer Correct Answer: B) The joins between tables in a relational database. 11. What is the purpose of the TRY-CATCH statement in T-SQL? A) To declare variables. B) To handle exceptions. C) To define functions. D) To create loops. Show Answer Correct Answer: B) To handle exceptions. 12. A situation in which one table in a database has a foreign key that refers to a primary key in another table. A) Linkage. B) Association. C) Connection. D) Relationship. Show Answer Correct Answer: D) Relationship. 13. In MS Access, what is a record? A) A single column in a table. B) The navigation pane. C) The table design blueprint. D) A complete set of related data about one item. Show Answer Correct Answer: D) A complete set of related data about one item. 14. Peter Chen developed and defined a model of important relationships called the er model A) 1976. B) 1975. C) 1970. D) 1974. E) 1977. Show Answer Correct Answer: A) 1976. 15. Which of the following is an example of a row in a database? A) A single name. B) A single record. C) A single folder. D) A single image. Show Answer Correct Answer: B) A single record. 16. Which of the following is an example of a relationship? A) Rainbow. B) Friendship. C) Cooking. D) Marriage. Show Answer Correct Answer: D) Marriage. 17. What are the potential drawbacks of using stored procedures? A) Stored procedures are easier to maintain than application code. B) Stored procedures eliminate the need for database security. C) Potential drawbacks of using stored procedures include increased complexity, performance issues, reduced flexibility, and potential for vendor lock-in. D) Stored procedures always improve performance. Show Answer Correct Answer: C) Potential drawbacks of using stored procedures include increased complexity, performance issues, reduced flexibility, and potential for vendor lock-in. 18. Which key uniquely identifies a record in a table? A) Secondary key. B) Primary key. C) Index key. D) Foreign key. Show Answer Correct Answer: B) Primary key. 19. In a relational database, the three basic operations used to develop useful sets of data are ..... A) Select, project, and where. B) Select, join, and where. C) Select, project, and join. D) Where, from, and join. Show Answer Correct Answer: C) Select, project, and join. 20. This key uniquely identifies each record in an entity. A) Secondary Key. B) Primary Key or Key Identifier. C) Composite Key. D) Foreign Key. Show Answer Correct Answer: B) Primary Key or Key Identifier. 21. What can queries help you calculate in a database? A) Sums, averages, and counts. B) Movie durations. C) Song lengths. D) Art dimensions. Show Answer Correct Answer: A) Sums, averages, and counts. 22. Which SQL clause filters groups? A) ORDER BY. B) DISTINCT. C) HAVING. D) WHERE. Show Answer Correct Answer: C) HAVING. 23. Which SQL command would you use to change a student's course from "ICT Level 5" to "Software Engineering" ? A) INSERT. B) DELETE. C) SELECT. D) UPDATE. Show Answer Correct Answer: D) UPDATE. 24. In an ERD, what symbol represents an entity? A) Oval. B) Diamond. C) Square. D) Circle. Show Answer Correct Answer: C) Square. 25. What does the ORDER BY clause do? A) Filters results based on a condition. B) Sorts returned data by a chosen field. C) Deletes unwanted records. D) Inserts new records alphabetically. Show Answer Correct Answer: B) Sorts returned data by a chosen field. 26. What happens if a primary key is duplicated? A) The duplicate entry is stored without any issues. B) The database automatically corrects the duplicate entry. C) The database merges the duplicate entries into one. D) The database will reject the duplicate entry, resulting in an error. Show Answer Correct Answer: D) The database will reject the duplicate entry, resulting in an error. 27. Microsoft Access cannot create a 'many-to-many' relationship directly because it is a theoretical type. How must a developer implement this practically? A) By merging all data into one giant flat-file table. B) By using a primary key that contains blank records. C) By using a link table combined with two one-to-many relationships. D) By changing all related data types to Boolean logic. Show Answer Correct Answer: C) By using a link table combined with two one-to-many relationships. 28. A ..... helps speed up the retrieval of data by creating a quick lookup reference. A) View. B) Trigger. C) Table. D) Index. Show Answer Correct Answer: D) Index. 29. Why is it important for each record to have a unique primary key? A) To make it colorful. B) To ensure data integrity. C) To increase speed. D) To reduce file size. Show Answer Correct Answer: B) To ensure data integrity. 30. Which of the following is a characteristic of a relational database? A) Data is stored in a flat file. B) Data cannot be queried. C) Data is stored in a hierarchical structure. D) Data is organized in tables. Show Answer Correct Answer: D) Data is organized in tables. 31. What does the term 'cardinality' refer to in database relationships? A) The speed of data retrieval. B) The size of the database. C) The type of data stored in a table. D) The number of instances of one entity that can be associated with another. Show Answer Correct Answer: D) The number of instances of one entity that can be associated with another. 32. What is the maximum number of tables that can be related in MS Access? A) 10 tables. B) 5 tables. C) There is no practical limit. D) 20 tables. Show Answer Correct Answer: C) There is no practical limit. 33. In a 'one-to-many' relationship between a 'Customers' table and an 'Orders' table, where would you expect to find the linking field? A) A Boolean field in the 'Customers' table indicating if they have orders. B) An attachment field for customer photos in the 'Orders' table. C) A primary key unique only to the 'Orders' table. D) A foreign key in the 'Orders' table that matches the 'Customer ID'. Show Answer Correct Answer: D) A foreign key in the 'Orders' table that matches the 'Customer ID'. 34. What is a dependency diagram used for? A) To manage user permissions in a system. B) To visualize relationships and dependencies between components in a system. C) To create a timeline of project milestones. D) To track the performance of individual components. Show Answer Correct Answer: B) To visualize relationships and dependencies between components in a system. 35. What is one role of a Security DBA? A) Scheduling software updates. B) Managing indexing and query logs. C) Implementing access control. D) None of the above. Show Answer Correct Answer: C) Implementing access control. 36. What does NoSQL stand for? A) Non-SQL Databases. B) Non-Structured Query Language. C) Not Optimized SQL. D) Not Only SQL. Show Answer Correct Answer: D) Not Only SQL. 37. Which SQL command is used to modify existing records in a table? A) INSERT. B) UPDATE. C) DELETE. D) SELECT. Show Answer Correct Answer: B) UPDATE. 38. What is one function of metadata? A) Helps identify where data came from. B) Helps store archived logs. C) Helps execute database queries. D) None of the above. Show Answer Correct Answer: A) Helps identify where data came from. 39. Describe the process of normalizing a database and why it is important in database design. A) It is important in order to minimize data redundancy, improve data integrity, and optimize database performance. B) It is only important for small databases, not large ones. C) It is not important, as it does not affect data integrity. D) It is important for increasing data redundancy and decreasing data integrity. Show Answer Correct Answer: A) It is important in order to minimize data redundancy, improve data integrity, and optimize database performance. 40. Anything that can have data stored about it, for example, a person, place, event, or thing. A) Attribute. B) Record. C) Entity. D) Object. Show Answer Correct Answer: C) Entity. 41. To ..... a database means to change existing information, such as updating an address. A) Retrieve. B) Update. C) Delete. D) Create. Show Answer Correct Answer: B) Update. 42. What are the types of NOSQL databases? A) Document databases. B) Key-value stores. C) Graph & Column-oriented databases. D) All of the above. Show Answer Correct Answer: D) All of the above. 43. What is the role of application programs in relation to a DBMS? A) They store data directly in the database. B) They manage the DBMS. C) They create the database structure. D) They request data from the DBMS. Show Answer Correct Answer: D) They request data from the DBMS. 44. Which of the folowing starts off with open, undo, and can be customized to contain the commands you use most frequently? A) The help window. B) The quick access toolbar. C) A worksheet. D) The ribbon. Show Answer Correct Answer: B) The quick access toolbar. 45. What is a key characteristic of a "One to One" relationship? A) One item in one table, multiple in another. B) No items in either table. C) One item in each table. D) Multiple items in each table. Show Answer Correct Answer: C) One item in each table. 46. How does a Data Mart differ from a Data Warehouse? A) A Data Mart is a subset of a Data Warehouse, focused on a specific business area. B) A Data Warehouse is a subset of a Data Mart, focused on a specific business area. C) A Data Mart and a Data Warehouse are the same. D) A Data Mart is used for transactional processing, while a Data Warehouse is used for analytical processing. Show Answer Correct Answer: A) A Data Mart is a subset of a Data Warehouse, focused on a specific business area. 47. What is the main goal of data verification? A) To check the format of data. B) To ensure data is logically consistent. C) To ensure data matches the original source. D) To prevent concurrent access. Show Answer Correct Answer: C) To ensure data matches the original source. 48. Electronic is an example of Digital database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 49. Which property guarantees isolation of transactions? A) Isolation. B) Consistency. C) Atomicity. D) Durability. Show Answer Correct Answer: A) Isolation. 50. In database normalisation, what is the second normal form (2NF)? A) A table that is in 1NF and has no partial dependencies. B) A table that is in 1NF and has no transitive dependencies. C) A table that is in 1NF and has a single primary key. D) A table that is in 1NF and has all foreign keys removed. Show Answer Correct Answer: A) A table that is in 1NF and has no partial dependencies. 51. ..... is a person, place, object, event or concept in the user environment about which company wishes to maintain the data A) Attribute. B) Entity. C) Relationship. D) None of these. Show Answer Correct Answer: B) Entity. 52. A column in a table in a database. A) Field. B) Row. C) Table. D) Record. Show Answer Correct Answer: A) Field. 53. Perintah ini digunakan untuk menampilkan basis data yang telah dibuat adalah ..... A) Databases;. B) Show databases;. C) Show databases:. D) Select databases;. E) Show database;. Show Answer Correct Answer: B) Show databases;. 54. In a school database, which of the following would be the MOST suitable primary key? A) First Name. B) Student ID Number. C) Date of Birth. D) Grade. Show Answer Correct Answer: B) Student ID Number. 55. Which of the following types of queries retrieves specific data from a database? A) Delete Query. B) Select Query. C) Make Table Query. D) Append Query. Show Answer Correct Answer: B) Select Query. 56. What is the function of an "index" in a relational database? A) To create a relationship between two tables. B) To perform full-text searches. C) To improve the speed of data retrieval. D) To delete data from multiple tables. Show Answer Correct Answer: C) To improve the speed of data retrieval. 57. In the context of relational databases, what is a composite key? A) A single attribute that uniquely identifies a record. B) A foreign key that refers to a primary key in another table. C) An attribute that can accept null values. D) A combination of two or more attributes that uniquely identify a record. Show Answer Correct Answer: D) A combination of two or more attributes that uniquely identify a record. 58. What is the full form of ACID in databases? A) Access, Control, Integrity, Data. B) Application, Configuration, Isolation, Database. C) Atomicity, Confidentiality, Integrity, Durability. D) Atomicity, Consistency, Isolation, Durability. Show Answer Correct Answer: D) Atomicity, Consistency, Isolation, Durability. 59. Perintah ini digunakan untuk menampilkan seluruh isi table adalah ..... A) Show tables;. B) Select isi tables;. C) Select * from table name;. D) Select tables;. E) Desc table;. Show Answer Correct Answer: C) Select * from table name;. 60. Which join returns all rows when there is a match in either table? A) FULL OUTER JOIN. B) INNER JOIN. C) LEFT JOIN. D) CROSS JOIN. Show Answer Correct Answer: A) FULL OUTER JOIN. ← 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