This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 21 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 21 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. True or False:An entity does not represent an object in the real world? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 2. You are designing entity descriptions for Customer(custID, title, firstname, surname, email) and Product(productID, title, subject, level, price). Which choice follows a correct procedure when no natural unique attribute exists? A) Introduce a new unique identifier as the primary key. B) Use the title attribute because it is descriptive. C) Rely on email even if duplicates might exist. D) Skip the key and enforce uniqueness later. Show Answer Correct Answer: A) Introduce a new unique identifier as the primary key. 3. Kumpulan objek dengan karakteristik yang sama disebut ..... A) Data type. B) Method. C) Attribute. D) Behaviour. E) Class. Show Answer Correct Answer: E) Class. 4. What is the purpose of reports in Access? A) To create new tables. B) To delete data. C) To present information in a readable format. D) To encrypt data. Show Answer Correct Answer: C) To present information in a readable format. 5. In MongoDB, data is stored in: A) Tables. B) Collections. C) Rows. D) Views. Show Answer Correct Answer: B) Collections. 6. What do databases provide? A) A structured and centralized approach to store and retrieve data efficiently. B) An unstructured and decentralized approach to data management. C) A chaotic and disorganized way to store information. D) A manual and labor-intensive method of data processing. Show Answer Correct Answer: A) A structured and centralized approach to store and retrieve data efficiently. 7. List the different normal forms in database design. A) 1NF, 2NF, 3NF, 4NF, 5NF, 8NF. B) 1NF, 2NF, 3NF, 6NF. C) 1NF, 2NF, 3NF, 4NF, 5NF, 7NF. D) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. Show Answer Correct Answer: D) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. 8. What is the purpose of an E-R diagram in database design? A) To provide a visual representation of how entities are related. B) To store data in a file-based approach. C) To write SQL scripts for database manipulation. D) To create database tables. Show Answer Correct Answer: A) To provide a visual representation of how entities are related. 9. What does a foreign key do? A) Encrypts the table. B) Sorts the data. C) Links one table to another. D) Deletes related records. Show Answer Correct Answer: C) Links one table to another. 10. In which of the following formates data is stored in the database management system? A) Table. B) Graph. C) Image. D) Text. Show Answer Correct Answer: A) Table. 11. How can reports be generated from database queries? A) Reports can be generated by executing SQL queries and formatting the results using reporting tools or programming languages. B) Database queries cannot be used for report generation. C) Reports can only be generated using Excel spreadsheets. D) Reports are generated automatically without any queries. Show Answer Correct Answer: A) Reports can be generated by executing SQL queries and formatting the results using reporting tools or programming languages. 12. Every table in a database must have at least one foreign key. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 13. The primary key in a database: A) Uniquely identifies each row. B) Is optional. C) Can be duplicated. D) Must always contain numbers. Show Answer Correct Answer: A) Uniquely identifies each row. 14. What is a collection of related fields that represents a complete set of information? A) Record. B) Database. C) Field. D) Information. Show Answer Correct Answer: A) Record. 15. What is one key function of a data model? A) Defining how data is organized with entities and relationships. B) Defining automated deployment processes. C) Defining UI models. D) None of the above. Show Answer Correct Answer: A) Defining how data is organized with entities and relationships. 16. Dornel is managing a student database and tries to assign duplicate student ID numbers to a primary key. What happens? A) The duplicate values will be ignored. B) The duplicates will overwrite the existing values. C) The database will generate an error message. D) The database system will accept the duplicates. Show Answer Correct Answer: C) The database will generate an error message. 17. A transaction is a: A) Random query. B) Logical unit of work. C) Single statement only. D) Deadlock prevention. Show Answer Correct Answer: B) Logical unit of work. 18. What operator tests column for the absence of data? A) EXISTS operator. B) NOT operator. C) IS NULL operator. D) None of these. Show Answer Correct Answer: C) IS NULL operator. 19. Which protocol gives each transaction a unique ID based on time? A) Locking protocol. B) Wait-die protocol. C) Timestamp protocol. D) Validation protocol. Show Answer Correct Answer: C) Timestamp protocol. 20. Which of the following is an example of a database used in a school? A) A list of students with their names and grades. B) A storybook. C) A calculator. D) A video game. Show Answer Correct Answer: A) A list of students with their names and grades. 21. The Boyce-Codd Normal Form is another name for? A) First Normal Form (1NF). B) Second Normal Form (2NF). C) Third Normal Form (3NF). D) None of these. Show Answer Correct Answer: C) Third Normal Form (3NF). 22. Which of the following is a characteristic of a self-describing database? A) It requires no user input. B) It is only accessible by administrators. C) It stores metadata about the database. D) It cannot be modified. Show Answer Correct Answer: C) It stores metadata about the database. 23. A function that has no partial functional dependencies is in ..... form A) 3NF. B) 2NF. C) 4NF. D) BCNF. Show Answer Correct Answer: B) 2NF. 24. Which of the following BEST describes a table in a database? A) A single row containing all details of one student. B) A collection of related fields and records. C) A collection of ASCII codes. D) A formatted Excel sheet. Show Answer Correct Answer: B) A collection of related fields and records. 25. Hierarchical model has ..... relationship. A) One to one. B) One to many. C) Many to many. D) Many to one. Show Answer Correct Answer: B) One to many. 26. Which of the following functions is used to count the number of records in a field? A) AVG. B) SUM. C) MIN. D) COUNT. Show Answer Correct Answer: D) COUNT. 27. Which of the following data types is the most suitable for a primary key? A) Date/Time. B) Text. C) AutoNumber. D) Short text. Show Answer Correct Answer: C) AutoNumber. 28. When might a flat file database be considered sufficient? A) When the database needs to handle complex queries and multiple users. B) When the database stores data that changes frequently. C) When there is only a small amount of data. D) When the data needs to be highly secure. Show Answer Correct Answer: C) When there is only a small amount of data. 29. Which type of data model provides a technical map of rules and data structures? A) Conceptual Data Model. B) Hierarchical Data Model. C) Logical Data Model. D) Physical Data Model. Show Answer Correct Answer: C) Logical Data Model. 30. Which SQL clause is used to filter records? A) WHERE. B) ORDER BY. C) SELECT. D) GROUP BY. Show Answer Correct Answer: A) WHERE. 31. Which type of data model includes technical details and performance needs for hardware? A) Abstract Data Model. B) Physical Data Model. C) Logical Data Model. D) Conceptual Data Model. Show Answer Correct Answer: B) Physical Data Model. 32. DCL provides commands to perform actions like A) Change the structure of Tables. B) Insert, Update or Delete Records and Values. C) Authorizing Access and other control over Database. D) None of Above. Show Answer Correct Answer: C) Authorizing Access and other control over Database. 33. A transaction runs a query SELECT COUNT(*) and gets a higher count when running the same query again 5 seconds later. What concurrency phenomenon has occurred? A) Phantom Read. B) Dirty Read. C) Consistency Failure. D) Non-Repeatable Read. Show Answer Correct Answer: A) Phantom Read. 34. What data type is used to store a unique sequential number for each record in a table? A) Yes/No. B) Date/Time. C) AutoNumber. D) Number. Show Answer Correct Answer: C) AutoNumber. 35. In Datasheet View, how can you arrange records alphabetically? A) Using Advanced Filter Sort. B) Using the Sort button (A to Z or Z to A). C) Using Design View. D) None of the above. Show Answer Correct Answer: B) Using the Sort button (A to Z or Z to A). 36. Andre is setting up a new business and needs to keep track of his sales and expenses. Which data type is suitable for storing monetary values? A) Text. B) Currency. C) Memo. D) Date/Time. Show Answer Correct Answer: B) Currency. 37. What happens when you modify a field's data type in Design View? A) All existing data is automatically converted. B) The database might lose data if incompatible. C) Nothing changes until you enter new data. D) The field is automatically deleted. Show Answer Correct Answer: B) The database might lose data if incompatible. 38. What is a table in a database? A) A collection of unrelated records. B) A basic unit containing data on a specific topic. C) A method of data retrieval. D) A type of software. Show Answer Correct Answer: B) A basic unit containing data on a specific topic. 39. What is the purpose of restoring data from a backup? A) To write stories. B) To edit photos. C) To create new designs. D) To recover lost information. Show Answer Correct Answer: D) To recover lost information. 40. Which programming language is widely used for business applications? A) PASCAL. B) FORTRAN. C) Java. D) COBOL. Show Answer Correct Answer: D) COBOL. 41. A Database Management system isa type of ..... software. A) Itis a type of system software. B) It is a kind of application software. C) It is a kind of general software. D) Both A and C. Show Answer Correct Answer: A) Itis a type of system software. 42. In an ERD, what does a diamond shape represent? A) An attribute. B) A primary key. C) A relationship. D) An entity. Show Answer Correct Answer: C) A relationship. 43. Berikut adalah contoh perangkat lunak yang digunakan untuk mengelola basis data, kecuali ..... A) Microsoft Access. B) Oracle. C) Microsoft SQL. D) Microsoft Word. E) Sybase. Show Answer Correct Answer: D) Microsoft Word. 44. The following key is used to denote uniqueness in the collection? A) Id. B) Id . C) Id-. D) Id. Show Answer Correct Answer: A) Id. 45. Which of the following is the BEST example of numerical data? A) 3.14159. B) Student Name. C) %%%%$ $ $. D) A12345. Show Answer Correct Answer: A) 3.14159. 46. What does the term 'mini-world' refer to in database terminology? A) A type of database model. B) A small database. C) A database management tool. D) A part of the real world about which data is stored. Show Answer Correct Answer: D) A part of the real world about which data is stored. 47. Which of the following is NOT a popular database management system? A) Google Sheets. B) MySQL. C) Oracle Database. D) Microsoft SQL Server. Show Answer Correct Answer: A) Google Sheets. 48. Which of the following is a feature of a well-normalised database? A) Minimal data redundancy. B) High data redundancy. C) Complex queries. D) Large number of tables. Show Answer Correct Answer: A) Minimal data redundancy. 49. In the relational model, a base table (base relation) is: A) A table whose rows are always computed on demand. B) A temporary table used for sorting. C) A permanently stored table that corresponds to an entity or relationship. D) A system catalog table. Show Answer Correct Answer: C) A permanently stored table that corresponds to an entity or relationship. 50. While inserting new rows in a table you must list values in the default order of the columns. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 51. Which of the following is a type of end-user? A) Database Administrators. B) Database Management Systems. C) Casual Users. D) Database Designers. Show Answer Correct Answer: C) Casual Users. 52. A deadlock occurs in a database system when: A) A transaction is forced to rollback due to a timeout. B) A transaction is waiting indefinitely for a lock to be released. C) All the transactions are waiting for a signal from the CPU scheduler. D) Two or more transactions are waiting for each other to release resources. Show Answer Correct Answer: D) Two or more transactions are waiting for each other to release resources. 53. An entity is a real world object about which information is to be stored in a database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 54. MySQL is best classified as which type of system? A) A file management system. B) A NoSQL database. C) A relational database management system (RDBMS). D) A programming language. Show Answer Correct Answer: C) A relational database management system (RDBMS). 55. Which of the following best describes a tuple in a relational database? A) A row in a table. B) A column in a table. C) A type of query. D) A database schema. Show Answer Correct Answer: A) A row in a table. 56. What is a key limitation of flat file databases? A) Support for large volumes of data. B) No support for relationships. C) High cost of implementation. D) High complexity. Show Answer Correct Answer: B) No support for relationships. 57. Which of the following is an example of a column in a database? A) A single record. B) A single image. C) A single attribute of a record. D) A single folder. Show Answer Correct Answer: C) A single attribute of a record. 58. Which of the following is NOT one of the classical record-based logical data models? A) Relational data model. B) Network data model. C) Object-oriented physical model. D) Hierarchical data model. Show Answer Correct Answer: C) Object-oriented physical model. 59. What does the term 'atomicity' refer to in database transactions? A) All operations must be completed successfully or none at all. B) Transactions can be executed in isolation. C) Data must be consistent before and after execution. D) Changes are permanent once a transaction is completed. Show Answer Correct Answer: A) All operations must be completed successfully or none at all. 60. What are joined relations in SQL? A) Joined relations are a type of database index. B) Joined relations refer to the physical storage of tables in SQL. C) Joined relations are only possible with three or more tables. D) Joined relations in SQL are the result of combining rows from multiple tables based on a related column. Show Answer Correct Answer: D) Joined relations in SQL are the result of combining rows from multiple tables based on a related column. ← 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