This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 59 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 59 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a ..... A) Transitive dependency. B) Referential integrity constraint. C) Partial dependency. D) Primary key. Show Answer Correct Answer: B) Referential integrity constraint. 2. What are some security measures provided by a DBMS? A) Usernames and passwords. B) Access rights. C) Encryption of data. D) All of the above. Show Answer Correct Answer: D) All of the above. 3. Which of the following is not true about the ALTER TABLE statement? A) It can add a new row. B) It can add a new column. C) It can modify existing columns. D) It can define a default value for the new column. Show Answer Correct Answer: A) It can add a new row. 4. Which DBMS allows Pinterest to store and analyze user engagement data? A) PostgreSQL. B) Snowflake. C) Cassandra. D) HBase. Show Answer Correct Answer: D) HBase. 5. Outline the steps involved in the database design process. A) Data Entry, Data Processing, Data Analysis. B) The steps involved in the database design process are:Requirements Gathering, Conceptual Design, Logical Design, Physical Design, Implementation, Testing, and Maintenance. C) Backup, Recovery, Data Migration. D) User Interface Design, System Testing, Deployment. Show Answer Correct Answer: B) The steps involved in the database design process are:Requirements Gathering, Conceptual Design, Logical Design, Physical Design, Implementation, Testing, and Maintenance. 6. Which of the following is a characteristic of the relational model? A) Uses tables to represent data. B) Uses hierarchical structures. C) Uses object-oriented programming. D) Uses flat files. Show Answer Correct Answer: A) Uses tables to represent data. 7. In the context of a database, what is a "view" ? A) A graphical representation of data. B) A virtual table based on the result of a SELECT query. C) A data input form. D) A backup copy of the database. Show Answer Correct Answer: B) A virtual table based on the result of a SELECT query. 8. Which one of the following refers to the "data about data" ? A) Directory. B) Sub Data. C) Warehouse. D) Meta Data. Show Answer Correct Answer: D) Meta Data. 9. Which one of the following is NOT an advantage of DBMS A) Increased data consistency. B) Reduced data redundancy. C) Improved data security. D) Increase data isolation. Show Answer Correct Answer: D) Increase data isolation. 10. Which of the following is not the advantage of database? A) Sharing of Data. B) Reduce Data Redundancy. C) Increase Data Inconsistency. D) Data Security. Show Answer Correct Answer: C) Increase Data Inconsistency. 11. What is the purpose of data redundancy in a database? A) To improve data integrity. B) To reduce data storage space. C) To ensure data consistency. D) To enhance data retrieval speed. Show Answer Correct Answer: A) To improve data integrity. 12. Which of the following is an advantage of a distributed database? A) Slower response to data requests. B) Limited user control over data. C) Reduced communications costs. D) Increased complexity in data management. Show Answer Correct Answer: C) Reduced communications costs. 13. What is normalisation in the context of databases? A) The process of backing up data. B) The process of organising data to reduce redundancy. C) The process of encrypting data. D) The process of indexing data for faster retrieval. Show Answer Correct Answer: B) The process of organising data to reduce redundancy. 14. Which feature of a DBMS allows users to request and manipulate data? A) Query processor. B) Logical schema. C) Data integrity. D) File storage system. Show Answer Correct Answer: A) Query processor. 15. Which of the following is an example of a NoSQL DBMS? A) MongoDB. B) Oracle. C) SQL Server. D) MySQL. Show Answer Correct Answer: A) MongoDB. 16. Time-series databases are optimized for handling non-time-stamped data. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 17. All lock information is managed by a ..... which is responsible for assigning and policing the locks used by the transactions. A) Scheduler. B) DBMS. C) Lock manager. D) Locking agent. Show Answer Correct Answer: C) Lock manager. 18. Hirarki Data terdiri dari (urutan yang terkecil ke yang besar): A) Bit-byte-field-record-File-Database. B) Byte-Bit-field-record-file-database. C) Field-bit-byte-record-file-Database. D) Record-File-Database-Bit-Byte-Field. E) File-database-Bit-Byte-Field-Record. Show Answer Correct Answer: A) Bit-byte-field-record-File-Database. 19. What feature of a database management system allows users to protect sensitive patient information? A) Encryption. B) Sorting. C) Filtering. D) Formatting. Show Answer Correct Answer: A) Encryption. 20. What is a crucial step to ensure data security in a hospital's database management system? A) Sharing passwords between departments. B) Storing data in plain text. C) Implementing encryption and access controls. D) Allowing all staff to access all data. Show Answer Correct Answer: C) Implementing encryption and access controls. 21. What should companies do regarding naming conventions according to the image? A) Ignore naming conventions as they are outdated. B) Choose naming conventions randomly. C) Identify and follow a naming convention. D) Create a new naming convention for each project. Show Answer Correct Answer: C) Identify and follow a naming convention. 22. Why is it important for computer graduates to learn DBMS? A) It is important for computer graduates to learn DBMS to effectively manage data, ensure data integrity, and optimize database performance. B) DBMS knowledge is not applicable in data science. C) Learning DBMS is unnecessary for software development. D) DBMS is only relevant for database administrators. Show Answer Correct Answer: A) It is important for computer graduates to learn DBMS to effectively manage data, ensure data integrity, and optimize database performance. 23. What are the three levels of the ANSI-SPARC architecture? A) Physical Level, Logical Level, Data Level. B) External Level, Conceptual Level, Internal Level. C) Presentation Level, Application Level, Database Level. D) User Level, System Level, Storage Level. Show Answer Correct Answer: B) External Level, Conceptual Level, Internal Level. 24. What is the purpose of the WHERE clause in SQL? A) To create new records in the database. B) To join multiple tables together. C) To filter records based on specified conditions. D) To sort records in ascending order. Show Answer Correct Answer: C) To filter records based on specified conditions. 25. How can user authentication enhance database security? A) User authentication enhances database security by restricting access to authorized users only. B) It eliminates the need for data encryption. C) User authentication slows down database performance. D) It allows anyone to access the database freely. Show Answer Correct Answer: A) User authentication enhances database security by restricting access to authorized users only. ← PreviousNext →Related 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 8Class 12 Computer Science Chapter 3 Database Management Systems Quiz 9Class 12 Computer Science Chapter 3 Database Management Systems Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books