This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 24 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 24 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. When must a developer use the ROLLBACK TRANSACTION command? A) At the beginning of every stored procedure to clear old data. B) After a COMMIT to save a backup copy of the changes. C) After a BEGIN TRANSACTION when a business rule is violated or an error occurs. D) Instead of a BEGIN CATCH block for faster error handling. Show Answer Correct Answer: C) After a BEGIN TRANSACTION when a business rule is violated or an error occurs. 2. What does an entity relationship diagram (ERD) illustrate? A) The structure of a database table. B) The relationships between two entities in a relational database. C) The primary and foreign keys in a table. D) The format control for data entry. Show Answer Correct Answer: B) The relationships between two entities in a relational database. 3. Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity? A) Instance entity. B) Subtype entity. C) Archetype entity. D) Supertype entity. Show Answer Correct Answer: B) Subtype entity. 4. What does the DISTINCT keyword do? A) Removes duplicate rows. B) Filters null values. C) Counts rows. D) Sorts the data. Show Answer Correct Answer: A) Removes duplicate rows. 5. What is the primary function of a database management system? A) To create and manage spreadsheets. B) To create, organize, and maintain databases. C) To design websites. D) To manage email communications. Show Answer Correct Answer: B) To create, organize, and maintain databases. 6. The database design that consists of multiple tables that are linked together through matching data stored in each table is called a: A) Network database. B) Object oriented database. C) Hierarchical database. D) Relational database. Show Answer Correct Answer: D) Relational database. 7. In an input mask, what does the character 'A' represent? A) User can enter a letter or a digit. B) User must enter a letter or a digit. C) User can enter a digit, space, plus or minus sign. D) User must enter a letter. Show Answer Correct Answer: B) User must enter a letter or a digit. 8. ..... resembles Create view. A) With data. B) Create table as. C) Create view as. D) Create table like. Show Answer Correct Answer: B) Create table as. 9. You ran an SQL command requesting the DBMS to display data in a table named USER ..... TABLES. The result includes columns labeled "TableName, " "NumberOfColumns, " and "PrimaryKey." You are looking at: A) An index. B) Metadata. C) A report. D) User data. Show Answer Correct Answer: B) Metadata. 10. MongoDB stores data in which format internally? A) JSON. B) CSV. C) BSON. D) XML. Show Answer Correct Answer: C) BSON. 11. Which of the following is NOT a common data validation method? A) Format check. B) Type check. C) Range check. D) Encryption check. Show Answer Correct Answer: D) Encryption check. 12. Which of the following refers to something that can be identified in the user's work environment, something that the users want to track? A) Attribute. B) Identifier. C) Entity. D) Relationship. Show Answer Correct Answer: C) Entity. 13. The fact that a traditional file system cannot respond to unanticipated information requirements in a timely fashion is an example of which of the following issues with traditional file systems? A) Program-data dependence. B) Lack of data sharing. C) Poor security. D) Lack of flexibility. Show Answer Correct Answer: D) Lack of flexibility. 14. In which of the following is a single-entity instance of one type related to many entity instances of another type? A) One-to-One Relationship. B) Many-to-Many Relationship. C) Composite Relationship. D) One-to-Many Relationship. Show Answer Correct Answer: D) One-to-Many Relationship. 15. Apa itu konsep entity-relationship (ER) dalam desain database? A) ER concept focuses on storing data in a database without relationships. B) Entity-Relationship (ER) concept is used for data visualization only. C) ER concept is not relevant for database design. D) Entity-Relationship (ER) concept in database design is a way to visually represent the relationships between entities in a database. Show Answer Correct Answer: D) Entity-Relationship (ER) concept in database design is a way to visually represent the relationships between entities in a database. 16. Which SQL clause is used to specify the order in which the result set is returned? A) GROUP BY. B) SORT. C) FILTER. D) ORDER BY. Show Answer Correct Answer: D) ORDER BY. 17. In the analogy comparing a database to a file cabinet, what do tables represent? A) Drawers. B) File folders. C) Sheets of paper. D) File cabinet. Show Answer Correct Answer: A) Drawers. 18. What is the purpose of normalization in database design? A) To increase data duplication for faster access. B) To enhance the visual representation of data in reports. C) The purpose of normalization is to reduce data redundancy and improve data integrity. D) To simplify the database structure by merging tables. Show Answer Correct Answer: C) The purpose of normalization is to reduce data redundancy and improve data integrity. 19. What is a composite primary key? A) An attribute that is a primary key in another table. B) A primary key made up from two or more attributes. C) A primary key that can be duplicated in the same table. D) A foreign key that is a primary key in more than one other table. Show Answer Correct Answer: B) A primary key made up from two or more attributes. 20. The $ and operator in MongoDB is used to: A) Combine two queries where both must be true. B) Combine two queries where one must be true. C) Sort data in ascending order. D) Perform aggregation. Show Answer Correct Answer: A) Combine two queries where both must be true. 21. A ..... is a type of command that retrieves data from a database on a server. A) Data dictionary. B) Query. C) Constraint. D) All of these. Show Answer Correct Answer: B) Query. 22. What is a database also known as? A) Data lake. B) Data warehouse. C) Data pond. D) Data bank. Show Answer Correct Answer: D) Data bank. 23. This is an organized collection of information. A) Information. B) Data. C) Database. D) DBMS. Show Answer Correct Answer: C) Database. 24. What are the main types of database security measures? A) Access Control, Encryption, Auditing, Backup and Recovery. B) User Interface Design. C) Network Security. D) Data Mining. Show Answer Correct Answer: A) Access Control, Encryption, Auditing, Backup and Recovery. 25. Which is NOT a disadvantage of a flat file system? A) Difficult data retrieval. B) Data redundancy. C) High security. D) Lack of concurrency. Show Answer Correct Answer: C) High security. 26. In a relational data model, entities are represented as: A) Data models. B) Databases. C) Attributes. D) Relations. Show Answer Correct Answer: D) Relations. 27. How can you manipulate data in Access? A) Access does not support any programming languages. B) Use queries, forms, reports, macros, and VBA. C) Use only tables to store data. D) Data cannot be manipulated in Access. Show Answer Correct Answer: B) Use queries, forms, reports, macros, and VBA. 28. How are "Fields" defined in a relational database? A) The ability to keep data consistent with relevant raw facts. B) The ability to store, sort, and search data. C) The single cell bisecting row and column. D) Categories of data being stored within the table. Show Answer Correct Answer: D) Categories of data being stored within the table. 29. Which of the following are not the examples of a database? A) MS Access 2019. B) MS PowerPoint 2019. C) FoxPro. D) MySQL. Show Answer Correct Answer: B) MS PowerPoint 2019. 30. Which data type is used to store $ 984746.93? A) Number. B) Large Number. C) Currency. D) Date/Time. Show Answer Correct Answer: C) Currency. 31. Which feature helps restrict the kind of data that can be entered in a field? A) AutoNumber. B) Field Size and Data Type settings. C) Save As option. D) Design View. Show Answer Correct Answer: B) Field Size and Data Type settings. 32. In SQL, which command is used to SELECT only one copy of each set of duplicable rows A) SELECT DISTINCT. B) SELECT UNIQUE. C) SELECT DIFFERENT. D) All of the above. Show Answer Correct Answer: A) SELECT DISTINCT. 33. What would be the main effect of a change at the conceptual level of the database? A) It would require hardware upgrades. B) It could affect all external views but not the physical storage. C) It would directly change indexing structures. D) It would force a change in file system layout. Show Answer Correct Answer: B) It could affect all external views but not the physical storage. 34. What gives meaning to these numbers and figures is ..... A) Knowledge. B) Information. C) Wisdom. D) Data. Show Answer Correct Answer: B) Information. 35. A quick way to find data in a database is to use ..... A) Queries. B) Quandries. C) Questions. D) File folders. Show Answer Correct Answer: A) Queries. 36. How does a database administrator ensure data integrity? A) By ignoring software updates and patches. B) By implementing constraints, performing backups, validating input data, and enforcing security measures. C) By sharing the database password with unauthorized users. D) By deleting random data entries. Show Answer Correct Answer: B) By implementing constraints, performing backups, validating input data, and enforcing security measures. 37. Which of the following is a key advantage of using a DBMS over a file-based system? A) Simplified data structure. B) Reduced data redundancy. C) Lower initial setup cost. D) Faster data retrieval for small datasets. Show Answer Correct Answer: B) Reduced data redundancy. 38. What is the function of a primary key? A) It is a heading for data organization. B) It represents a table in a database. C) It reduces data-entry errors. D) It provides a unique identifier for a record/entity. Show Answer Correct Answer: D) It provides a unique identifier for a record/entity. 39. How do you link tables using primary keys? A) Link tables by matching the names of the columns directly. B) Use the primary key of one table as a primary key in another table. C) Use the primary key of one table as a foreign key in another table to create a relationship. D) Create a relationship by copying the entire table into another. Show Answer Correct Answer: C) Use the primary key of one table as a foreign key in another table to create a relationship. 40. Why is data integrity important in a database? A) To allow for faster data retrieval. B) To maintain accurate and consistent data. C) To enable data encryption. D) To ensure data is stored securely. Show Answer Correct Answer: B) To maintain accurate and consistent data. 41. What is a "foreign key" in a relational database? A) A key that is used for encryption. B) A key that references the primary key in another table. C) A key that uniquely identifies each record in a table. D) A key that is used for indexing purposes. Show Answer Correct Answer: B) A key that references the primary key in another table. 42. What is a key characteristic of the relational model? A) Uses hierarchical indexes. B) Contains only unstructured data. C) Organizes data into rows and columns. D) Uses object inheritance. Show Answer Correct Answer: C) Organizes data into rows and columns. 43. What does a double-lined box represent in an ER diagram? A) Relationship. B) Attribute. C) Entity. D) Key. Show Answer Correct Answer: C) Entity. 44. Which IS component includes switches and firewalls? A) Hardware/Network infrastructure. B) Applications/Services. C) Software/Development tools. D) None of the above. Show Answer Correct Answer: A) Hardware/Network infrastructure. 45. Which data model uses a tree-like structure? A) Hierarchical model. B) Network model. C) Relational model. D) Object-oriented model. Show Answer Correct Answer: A) Hierarchical model. 46. ..... states that only valid data will be written to the database. A) Consistency. B) Atomicity. C) Isolation. D) Durability. Show Answer Correct Answer: A) Consistency. 47. Which of the following is an example of end user data? A) Patient ID. B) Database structure. C) Database management system. D) Data characteristics. Show Answer Correct Answer: A) Patient ID. 48. Which of the following is NOT a type of database application? A) Textual Databases. B) Multimedia Databases. C) Spreadsheet Applications. D) Geographic Information Systems (GIS). Show Answer Correct Answer: C) Spreadsheet Applications. 49. What is the purpose of a field in a database? A) The purpose of a field in a database is to store a specific piece of information for each record in a table. B) The purpose of a field in a database is to organize records in a table. C) The purpose of a field in a database is to display data in a table. D) The purpose of a field in a database is to calculate values for each record in a table. Show Answer Correct Answer: A) The purpose of a field in a database is to store a specific piece of information for each record in a table. 50. Jazari is designing a student database for his school project. What is a primary key in this database? A) A field that stores only text values. B) A duplicate field in a table. C) A field used for calculations. D) A field that uniquely identifies a record. Show Answer Correct Answer: D) A field that uniquely identifies a record. 51. One shopper buys many items. How is this expressed as a relationship on an ER diagram? A) 1:M. B) 1:1. C) M:N. D) M:1. Show Answer Correct Answer: A) 1:M. 52. Which of the below SELECT statement is used to select all columns of EMP table? A) SELECT ALL FROM emp. B) SELECT # FROM emp. C) SELECT * FROM emp. D) SELECT empno, ename, deptno, sal, job, mgr, hiredate FROM emp. Show Answer Correct Answer: C) SELECT * FROM emp. 53. Explain the difference between SQL and NoSQL databases. A) SQL databases are designed for unstructured data. B) SQL databases are non-relational with a fixed schema. C) SQL databases are relational with a fixed schema; NoSQL databases are non-relational with flexible schemas. D) NoSQL databases require a predefined schema. Show Answer Correct Answer: C) SQL databases are relational with a fixed schema; NoSQL databases are non-relational with flexible schemas. 54. Pooja is entering data directly into a spreadsheet-like interface in Access. She is working in: A) Design View. B) Form View. C) Query View. D) Datasheet View. Show Answer Correct Answer: D) Datasheet View. 55. What is a query in a database? A) A row in a table. B) A type of report. C) A request for data. D) A column in a table. Show Answer Correct Answer: C) A request for data. 56. Kemar is organizing a library database and needs to ensure each book can be uniquely identified. Which field should he use to uniquely identify a record in the table? A) Duplicate key. B) Primary key. C) Foreign key. D) Search key. Show Answer Correct Answer: B) Primary key. 57. Which of the following is a guideline for naming tables? A) Use only numbers. B) Use spaces. C) Use letters, numbers, and underscores. D) Use lowercase letters only. Show Answer Correct Answer: C) Use letters, numbers, and underscores. 58. Which type of database designer focuses on conceptual and logical design? A) Physical Database Designer. B) Application Designer. C) Logical Database Designer. D) System Designer. Show Answer Correct Answer: C) Logical Database Designer. 59. What is the first step in using a database? A) Running queries. B) Importing data. C) Creating its structure. D) Generating reports. Show Answer Correct Answer: C) Creating its structure. 60. Which architecture uses a single database on a single server? A) Client/Server DBMS. B) Centralized DBMS. C) Cloud DBMS. D) Distributed DBMS. Show Answer Correct Answer: B) Centralized 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 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