This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 19 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 19 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is a data model and why is it important? A) A data model is irrelevant for data analysis and reporting. B) A data model is a conceptual framework for organizing and defining data structures and relationships, crucial for effective data management and communication. C) A data model is only used for programming languages. D) A data model is a physical representation of data storage devices. Show Answer Correct Answer: B) A data model is a conceptual framework for organizing and defining data structures and relationships, crucial for effective data management and communication. 2. Variety is a characteristic of big data. Which type of formats does Variety comes from? A) Structured. B) Unstructured. C) Semi-structured. D) All of the above. Show Answer Correct Answer: D) All of the above. 3. What is the main advantage of using a relational database? A) Easier data visualization. B) Faster data entry. C) Improved data security. D) Reduced data redundancy. Show Answer Correct Answer: D) Reduced data redundancy. 4. What SQL clause is used to restrict the rows returned by a query? A) HAVING. B) WHEN. C) WHERE. D) FROM. Show Answer Correct Answer: C) WHERE. 5. Which of the following is a function of a DBMS that ensures the integrity and consistency of data? A) Data dictionary management. B) Network configuration. C) User interface design. D) Hardware maintenance. Show Answer Correct Answer: A) Data dictionary management. 6. In a relational database, a foreign key must be unique. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 7. Database if the collection of information or group of facts in a structured way. A) Yes. B) Not Always. C) No. D) Maybe. Show Answer Correct Answer: A) Yes. 8. What does the project operation do in relational algebra? A) Renames columns. B) Deletes columns. C) Combines rows. D) Selects specific columns. Show Answer Correct Answer: D) Selects specific columns. 9. What is SQL and what is it used for? A) SQL is used for creating web applications. B) SQL is a programming language used for managing and manipulating relational databases. C) SQL is a markup language for designing websites. D) SQL is a type of spreadsheet software. Show Answer Correct Answer: B) SQL is a programming language used for managing and manipulating relational databases. 10. A key which is referring to the primary key of another table is called ..... A) Foreign Key. B) First Primary Key. C) Alternate Key. D) Primary Key. Show Answer Correct Answer: A) Foreign Key. 11. What is the definition of a database? A) A collection of unrelated files. B) An organized collection of data that can be easily accessed, managed, and updated. C) A digital device used for computations. D) A network of interconnected systems. Show Answer Correct Answer: B) An organized collection of data that can be easily accessed, managed, and updated. 12. Which of the following is NOT a characteristic of a relational table? A) Each cell contains a single value. B) Each column has a unique name. C) The order of rows is significant. D) All rows are unique. Show Answer Correct Answer: C) The order of rows is significant. 13. Which of the following is an example of a logical data model? A) Relational model. B) Network model. C) ER model. D) File system model. Show Answer Correct Answer: C) ER model. 14. Which type of database supports a company's day-to-day operations? A) Operational database. B) Data warehouse. C) Relational database. D) Distributed database. Show Answer Correct Answer: A) Operational database. 15. Write the output when the data 'Primary Key' is set to the text < in Access? A) Primary Key. B) Primary key. C) Primary key. D) PRIMARY KEY. Show Answer Correct Answer: B) Primary key. 16. In a library system, which relationship exists between Book and Borrow? A) Many-to-Many. B) Recursive. C) One-to-One. D) One-to-Many. Show Answer Correct Answer: D) One-to-Many. 17. What is the primary purpose of a Relational Database Management System? A) To store data in a hierarchical tree structure. B) To manage data using a network model. C) To organize data into tables with rows and columns. D) To process data with a focus on unstructured data. Show Answer Correct Answer: C) To organize data into tables with rows and columns. 18. What are the advantages of using NoSQL databases over traditional SQL databases? A) Strict adherence to predefined schemas. B) Limited support for unstructured data. C) Advantages of NoSQL databases include flexibility in data models, horizontal scalability, lower latency, and support for various data types. D) Increased complexity in data management. Show Answer Correct Answer: C) Advantages of NoSQL databases include flexibility in data models, horizontal scalability, lower latency, and support for various data types. 19. In terms of databases, what is meant by isolation? A) Users cannot share data. B) Transactions must not interfere with other transactions. C) Changes must not break the database. D) None of the above. Show Answer Correct Answer: B) Transactions must not interfere with other transactions. 20. What is allowed the input mask symbol # in Access? A) Letter or digit. B) Letter A through Z. C) A digit 0-9 with +/-sign. D) A digit 0-9 without +/-sign. Show Answer Correct Answer: C) A digit 0-9 with +/-sign. 21. Accurate, relevant, and timely ..... is the key to good decision making. A) Processing. B) Information. C) Data. D) Relationships. Show Answer Correct Answer: B) Information. 22. Which of the following is NOT a characteristic of a relation in a relational database? A) All data values in an attribute must be from the same domain. B) Each attribute has a unique name. C) Tuples can be ordered. D) Each tuple must be distinct. Show Answer Correct Answer: C) Tuples can be ordered. 23. Why we need database? A) To store a particular picture. B) To store a particular audio. C) To store a particular text. D) To store a particular collection of data. Show Answer Correct Answer: D) To store a particular collection of data. 24. What role does a DBMS play in e-commerce? A) A DBMS handles customer service inquiries directly. B) A DBMS only stores images for e-commerce websites. C) A DBMS is responsible for designing the website layout. D) A DBMS manages and organizes data for e-commerce operations, ensuring data integrity and facilitating transactions. Show Answer Correct Answer: D) A DBMS manages and organizes data for e-commerce operations, ensuring data integrity and facilitating transactions. 25. Which Codd's rule guarantees access to every data element? A) Rule 2-Guaranteed Access Rule. B) Rule 1-Information Rule. C) Rule 4-View Updating Rule. D) Rule 5-Powerful Language Rule. Show Answer Correct Answer: A) Rule 2-Guaranteed Access Rule. 26. Which is NOT part of the database development process? A) Data normalization. B) Database planning. C) Software marketing. D) Database testing. Show Answer Correct Answer: C) Software marketing. 27. How does data independence improve maintenance in a DBMS? A) By increasing the complexity of the DBMS. B) By requiring substantial alterations to programs for data changes. C) By making applications dependent on data descriptions. D) By separating data descriptions from applications. Show Answer Correct Answer: D) By separating data descriptions from applications. 28. Which SQL command is used to update existing records in a table? A) MODIFY. B) ALTER. C) UPDATE. D) CHANGE. Show Answer Correct Answer: C) UPDATE. 29. Among the following computer system components, which one is responsible to manage and control the overall tasks in the computer system? A) High level languages. B) Application software. C) Central processing unit (CPU). D) Operating system. Show Answer Correct Answer: D) Operating system. 30. A company wants to merge two departments with different database structures. Which is the best approach? A) Use denormalization to combine all data in one table. B) Normalize both databases and integrate them with consistent keys. C) Store everything in spreadsheets first. D) Use only manual records. Show Answer Correct Answer: B) Normalize both databases and integrate them with consistent keys. 31. Which of the following operators is used to combine results from two queries, removing duplicates? A) MERGE. B) JOIN. C) UNION. D) INTERSECT. Show Answer Correct Answer: C) UNION. 32. A ..... addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes. A) Disjoint rule. B) Disjointness constraint. C) Partial specialization. D) Total specialization. Show Answer Correct Answer: B) Disjointness constraint. 33. ..... :Verifying a user's identity. A) Accounting. B) Encryption. C) Authentication. D) Authorization. Show Answer Correct Answer: C) Authentication. 34. Which of the following commands should be used to create a database named "student" ? A) CREATE DATABASE student. B) CREATE?I student. C) DATABASE student. D) DATABASE /student. Show Answer Correct Answer: A) CREATE DATABASE student. 35. What is the purpose of the GROUP BY clause? A) To group data. B) To sort data. C) To delete data. D) To filter data. Show Answer Correct Answer: A) To group data. 36. Abort (Rollback):The cancellation of a transaction where all changes are ..... ? A) Saved. B) Committed. C) Ignored. D) Undone. Show Answer Correct Answer: D) Undone. 37. What describes the relation name and attributes in a relational database? A) Relation Key. B) Relation Instance. C) Relation Schema. D) Attribute Domain. Show Answer Correct Answer: C) Relation Schema. 38. What is a relationship set? A) A data type. B) A collection of relationships. C) A type of entity. D) A single relationship. Show Answer Correct Answer: B) A collection of relationships. 39. What is a disadvantage of the database approach? A) Increased performance for specific applications. B) Improved backup and recovery services. C) Limited data redundancy. D) Complexity of the DBMS. Show Answer Correct Answer: D) Complexity of the DBMS. 40. In terms of databases, what is meant by security? A) Only the most important data is kept in a secure place. B) Different access rights cannot be assigned to different users. C) All data is kept in a secure place and different access rights can be assigned to different users. D) None of the above. Show Answer Correct Answer: C) All data is kept in a secure place and different access rights can be assigned to different users. 41. How can a hospital ensure that only authorized personnel access sensitive patient data? A) Implementing strong password policies and access controls. B) Allowing open access to all hospital staff. C) Sharing login credentials between departments. D) Storing data in unencrypted formats. Show Answer Correct Answer: A) Implementing strong password policies and access controls. 42. Which of the following is a top-down approach in which the entity's higher level can be divided into two lower sub-entities? A) Aggregation. B) Generalization. C) Specialization. D) All of the above. Show Answer Correct Answer: C) Specialization. 43. ..... :Allowing individuals control over their data. A) Transparency. B) Autonomy. C) Efficiency. D) Security. Show Answer Correct Answer: B) Autonomy. 44. What is the role of a database in modern computing? A) To manage data efficiently and ensure integrity. B) To provide a paper-based filing system. C) To store data in text files. D) To create redundancy in data storage. Show Answer Correct Answer: A) To manage data efficiently and ensure integrity. 45. Which of the following best describes "Data Dependence" in file systems? A) The inability to change data properties without affecting programs. B) The ability to change data properties without affecting programs. C) The ability to perform ad hoc queries easily. D) The ability to share data securely across locations. Show Answer Correct Answer: A) The inability to change data properties without affecting programs. 46. Which key establishes a link between two tables? A) Primary key. B) Foreign key. C) Candidate key. D) Composite key. Show Answer Correct Answer: B) Foreign key. 47. What is the difference between relational algebra and relational calculus? A) Relational algebra is based on set theory; relational calculus is based on logic. B) Relational algebra is used for data retrieval; relational calculus is used for data storage. C) Relational algebra uses SQL syntax; relational calculus uses XML syntax. D) Relational algebra is procedural; relational calculus is non-procedural. Show Answer Correct Answer: D) Relational algebra is procedural; relational calculus is non-procedural. 48. What is the full form of RDBMS? A) Relational Database Management System. B) Remote Data Backup Management Service. C) Random Data Backup Management System. D) Real-time Database Management Software. Show Answer Correct Answer: A) Relational Database Management System. 49. What is a characteristic of a database approach? A) Manual data entry only. B) No data sharing. C) Centralized data management. D) Decentralized data management. Show Answer Correct Answer: C) Centralized data management. 50. What is a disadvantage of using a DBMS according to the text? A) Enhanced performance for all applications. B) Increased cost of data conversion. C) Simplification of data maintenance. D) Reduced impact of system failures. Show Answer Correct Answer: B) Increased cost of data conversion. 51. What is the default name of a SQL Server database created in Visual Studio? A) DefaultDatabase.mdf. B) Database1.mdf. C) MyDatabase.mdf. D) NewDatabase.mdf. Show Answer Correct Answer: B) Database1.mdf. 52. Which of the following is a common feature of modern DBMSs? A) Inability to recover from system failures. B) Support for transaction management. C) Lack of support for concurrent users. D) No support for data backup. Show Answer Correct Answer: B) Support for transaction management. 53. What is the function of a database schema? A) To store the actual data values in the database. B) To manage the physical hardware where the database is stored. C) To provide a backup of the entire database. D) To define the logical structure of the database. Show Answer Correct Answer: D) To define the logical structure of the database. 54. The file in DBMS is called as ..... in RDBMS. A) Schema. B) Console. C) Entity. D) Table. Show Answer Correct Answer: D) Table. 55. What is the purpose of a DBMS? A) To delete data. B) To print data. C) To create files. D) To store and access data. Show Answer Correct Answer: D) To store and access data. 56. Which data model organizes data in a tree-like structure? A) Hierarchical Model. B) Network Model. C) Relational Model. D) Object-Oriented Model. Show Answer Correct Answer: A) Hierarchical Model. 57. Which normal form is achieved when a table is free of transitive dependency? A) First Normal Form (1NF). B) Boyce-Codd Normal Form (BCNF). C) Third Normal Form (3NF). D) Second Normal Form (2NF). Show Answer Correct Answer: C) Third Normal Form (3NF). 58. Which normal form is considered to eliminate transitive dependencies? A) First Normal Form (1NF). B) Second Normal Form (2NF). C) Third Normal Form (3NF). D) None of the above. Show Answer Correct Answer: C) Third Normal Form (3NF). 59. What is the primary goal of normalization in the context of a relational database? A) Maximize data redundancy. B) Minimize data security. C) Organize data to reduce data duplication and dependency. D) Increase query performance. Show Answer Correct Answer: C) Organize data to reduce data duplication and dependency. 60. What is the difference between DDL and DML? A) DDL is a programming language; DML is a markup language. B) DDL defines database structure; DML manipulates data within that structure. C) DDL and DML are the same and can be used interchangeably. D) DDL is used for querying data; DML defines database structure. Show Answer Correct Answer: B) DDL defines database structure; DML manipulates data within that structure. ← PreviousNext →Related QuizzesScience QuizzesClass 12 QuizzesClass 12 Computer Science Chapter 3 Database Management Systems Quiz 1Class 12 Computer Science Chapter 3 Database Management Systems Quiz 2Class 12 Computer Science Chapter 3 Database Management Systems Quiz 3Class 12 Computer Science Chapter 3 Database Management Systems Quiz 4Class 12 Computer Science Chapter 3 Database Management Systems Quiz 5Class 12 Computer Science Chapter 3 Database Management Systems Quiz 6Class 12 Computer Science Chapter 3 Database Management Systems Quiz 7Class 12 Computer Science Chapter 3 Database Management Systems Quiz 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books