This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 20 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 20 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. ..... :Taking responsibility for data misuse. A) Integrity. B) Anonymity. C) Accountability. D) Confidentiality. Show Answer Correct Answer: C) Accountability. 2. Which of the following is NOT typically associated with a data warehouse? A) Having a structure quite different from operational databases. B) Requiring data massaging for decisions. C) Supporting day-to-day operations. D) Storing historical data. Show Answer Correct Answer: C) Supporting day-to-day operations. 3. What is SQL and its role in DBMS? A) SQL is a markup language for designing user interfaces. B) SQL is used for creating web applications. C) SQL is a programming language used to manage and manipulate relational databases in a DBMS. D) SQL is a type of database management system. Show Answer Correct Answer: C) SQL is a programming language used to manage and manipulate relational databases in a DBMS. 4. An operating system function that memorizes track of information regarding the creation, deletion, transfer, copy, and storage of files in an organized manner is related to ..... A) Security Management. B) File Management. C) Memory Management. D) Device Management. Show Answer Correct Answer: B) File Management. 5. What is the primary purpose of transaction transparency in DDBMS? A) To increase processing speed. B) To reduce network traffic. C) To maintain data consistency and integrity. D) To simplify database design. Show Answer Correct Answer: C) To maintain data consistency and integrity. 6. Which of the following aggregate function is used to specify number of tuples in the given table A) Max(*). B) Count(Attribute). C) Count(*). D) Sum(attribute). Show Answer Correct Answer: C) Count(*). 7. Which SQL command is used to insert new rows into a table? A) APPEND. B) INSERT INTO. C) CREATE. D) ADD. Show Answer Correct Answer: B) INSERT INTO. 8. What is a common use case for graph databases? A) Analyzing relationships between data points. B) Managing transactions. C) Storing large volumes of unstructured data. D) Performing complex calculations. Show Answer Correct Answer: A) Analyzing relationships between data points. 9. Serial Schedule:Transactions execute one after another with ..... A) No overlap. B) Partial overlap. C) Full overlap. D) Random overlap. Show Answer Correct Answer: A) No overlap. 10. A column or combination of columns that contain values that uniquely identify each row in the table A) Primary key. B) Foreign key. C) Composite key. D) None of the above. Show Answer Correct Answer: A) Primary key. 11. ..... :Protecting data from loss and failure. A) Backup and Recovery Security. B) Network Security. C) Physical Security. D) Application Security. Show Answer Correct Answer: A) Backup and Recovery Security. 12. Which view allows to modify table's structure in Access? A) Pivot chart view. B) Pivot table view. C) Design view. D) Datasheet view. Show Answer Correct Answer: C) Design view. 13. Which of the following is NOT a transparency feature of a distributed DBMS? A) Replication transparency. B) Data redundancy transparency. C) Concurrency transparency. D) Failure transparency. Show Answer Correct Answer: B) Data redundancy transparency. 14. What is the significance of a primary key in a relational database? A) It defines the data type of attributes. B) It allows duplicate values in a table. C) It uniquely identifies each record in a table. D) It is used to create foreign key relationships. Show Answer Correct Answer: C) It uniquely identifies each record in a table. 15. A company wants to enforce strict access control on its database. Which feature should it implement? A) Authorization and Role-Based Access Control (RBAC). B) Query Optimization. C) Data Replication. D) Normalization. Show Answer Correct Answer: A) Authorization and Role-Based Access Control (RBAC). 16. Transaction: ..... is a set of read and write operations that form a single logical unit of work. A) A set of read and write operations that form a single logical unit of work. B) A set of arithmetic operations performed in sequence. C) A group of unrelated database queries. D) A collection of backup files. Show Answer Correct Answer: A) A set of read and write operations that form a single logical unit of work. 17. What are the key components of a data model? A) Entities, attributes, relationships, and constraints. B) Fields, records, structures, and functions. C) Tables, views, indexes, and queries. D) Schemas, models, formats, and types. Show Answer Correct Answer: A) Entities, attributes, relationships, and constraints. 18. What is a key difference between paper-based and digital database systems? A) Paper-based systems are faster and more secure. B) Digital systems are costlier but slower. C) Paper-based systems are manual and prone to data loss, while digital systems are faster and more secure. D) Both systems are equally efficient. Show Answer Correct Answer: C) Paper-based systems are manual and prone to data loss, while digital systems are faster and more secure. 19. Chloe is creating a database for several customers. What is the data type for the field total sales? A) Data. B) Currency. C) Number. D) Yes/No. Show Answer Correct Answer: B) Currency. 20. The number of tuples in a relation is called its ..... , while the number of attributes in a relation is called its ..... A) Cardinality, Degree. B) Participation constraint, cardinality. C) Degree, Participation constraint. D) Degree, Cardinality. Show Answer Correct Answer: A) Cardinality, Degree. 21. Which of the following is NOT a database management system? A) MySQL. B) Oracle. C) PostgreSQL. D) Excel. Show Answer Correct Answer: D) Excel. 22. What is a logical schema? A) A hardware device used to store data. B) A physical representation of a database. C) A programming language used to query databases. D) A data model for a specific database that is independent of the DBMS used. Show Answer Correct Answer: D) A data model for a specific database that is independent of the DBMS used. 23. What is DBMS and its role in managing databases? A) DBMS is a software used to manage and organize databases. B) DBMS is a programming language. C) DBMS is a type of computer monitor. D) DBMS is a hardware component used in networking. Show Answer Correct Answer: A) DBMS is a software used to manage and organize databases. 24. Which of the following is the disadvantages of DBMS? A) Database systems are fast to be designed. B) Cost of setup of DBMS is relatively cheap. C) Database will not be corrupted. D) Database systems are complex. Show Answer Correct Answer: D) Database systems are complex. 25. If a user requests information about a specific product from a database, which DBMS function translates this logical request into a command to physically locate and retrieve the data? A) Data transformation and presentation. B) Data dictionary management. C) Data storage management. D) Data backup management. Show Answer Correct Answer: A) Data transformation and presentation. 26. What is the purpose of concurrency control in databases? A) To increase speed. B) To prevent transaction interference and maintain consistency. C) To reduce memory usage. D) To allow multiple users to access the database. Show Answer Correct Answer: B) To prevent transaction interference and maintain consistency. 27. How the Every weak entity set can be changed into a strong entity set through? A) Using generalization. B) Using aggregation. C) Adding appropriate attributes. D) None of the above. Show Answer Correct Answer: C) Adding appropriate attributes. 28. Which of the following is a characteristic of client-side programming? A) Generates dynamic content. B) Manages database connections. C) Processes requests on the web server. D) Runs on the client's browser. Show Answer Correct Answer: D) Runs on the client's browser. 29. What type of attributes does a strong entity set with only simple attributes have? A) Composite attributes. B) Multi-valued attributes. C) Weak attributes. D) Simple attributes. Show Answer Correct Answer: D) Simple attributes. 30. What is a common query language used in DBMS? A) SQL. B) HTML. C) Python. D) Java. Show Answer Correct Answer: A) SQL. 31. Which best describes the difference between logical and physical schema? A) Logical = physical storage media; Physical = queries. B) Logical = indexes; Physical = keys. C) Logical = data storage; Physical = user views. D) Logical = data organization; Physical = actual storage. Show Answer Correct Answer: D) Logical = data organization; Physical = actual storage. 32. Which of the following describes a one-to-one relationship in an ERD? A) An entity is related to only one instance of another entity. B) Multiple entities are related to multiple instances of another entity. C) Many entities are related to a single instance of another entity. D) An entity is related to many instances of another entity. Show Answer Correct Answer: A) An entity is related to only one instance of another entity. 33. What is the output of a query in tuple relational calculus? A) A set of tuples. B) A single value. C) No output. D) A single tuple. Show Answer Correct Answer: A) A set of tuples. 34. What are the key differences between OLAP and OLTP systems? A) OLAP is designed for operational tasks, while OLTP focuses on data warehousing. B) OLAP handles real-time data, whereas OLTP is for historical data. C) OLAP is for transaction processing, while OLTP is for data analysis. D) OLAP is for data analysis and reporting, while OLTP is for transaction processing. Show Answer Correct Answer: D) OLAP is for data analysis and reporting, while OLTP is for transaction processing. 35. Duplication of data is called ..... A) Consistency. B) Inconsistency. C) Foreign Key. D) Redundancy. Show Answer Correct Answer: D) Redundancy. 36. What is the role of end users in a database system? A) Using application programs to access data. B) Managing the DBMS. C) Creating backup procedures. D) Designing the database. Show Answer Correct Answer: A) Using application programs to access data. 37. What is the expected outcome of the lesson on DDBMS? A) Understanding the benefits and drawbacks of DDBMS. B) Learning only about local databases. C) Ignoring the characteristics of DDBMS. D) Focusing solely on data replication. Show Answer Correct Answer: A) Understanding the benefits and drawbacks of DDBMS. 38. Which of the following is used to ensure that a relationship between two tables remains consistent? A) Primary Key Constraint. B) Unique Constraint. C) Referential Integrity Constraint. D) Check Constraint. Show Answer Correct Answer: C) Referential Integrity Constraint. 39. What is a risk of vendor lock-in? A) Without open exports. B) With multiple file formats. C) With data redundancy. D) With user access issues. Show Answer Correct Answer: A) Without open exports. 40. A standardized programming language that is used to manage relational databases A) Query. B) Table. C) SQL. D) MySQL. Show Answer Correct Answer: C) SQL. 41. Which component is NOT typically part of an information system? A) Processes. B) Mathematical equations. C) People. D) Hardware. Show Answer Correct Answer: B) Mathematical equations. 42. Which function in MS Access can be used to calculate the total fertilizer used for all farms? A) AVG(). B) MAX(). C) SUM(). D) COUNT(). Show Answer Correct Answer: C) SUM(). 43. All of the following are advantages of packaged data models EXCEPT: A) Packaged data models can be built using proven components evolved from cumulative experiences. B) Projects take less time and cost less. C) The data model is easier to evolve. D) More one-to-one relationships give the data model more flexibility. Show Answer Correct Answer: D) More one-to-one relationships give the data model more flexibility. 44. What is a key difference between a spreadsheet and a database management system? A) A spreadsheet is a multi-file system, while a DBMS is a single file. B) A spreadsheet is less complex than a DBMS. C) A spreadsheet has controlled data redundancy, while a DBMS has uncontrolled redundancy. D) DBMS provides controlled access and integrity, while a spreadsheet often suffers from data redundancy and inconsistency. Show Answer Correct Answer: D) DBMS provides controlled access and integrity, while a spreadsheet often suffers from data redundancy and inconsistency. 45. The basic data type char(n) is a ..... length character string and varchar(n) is ..... length character. A) Fixed, equal. B) Equal, variable. C) Fixed, variable. D) Variable, equal. Show Answer Correct Answer: C) Fixed, variable. 46. Which of the following uses Oracle Database for managing inventory and transactional data? A) Stack Overflow. B) Walmart. C) Reddit. D) Pinterest. Show Answer Correct Answer: B) Walmart. 47. What is the main characteristic of a distributed database? A) Data is distributed across several sites. B) Data is located at a single site. C) Data is only accessible offline. D) Data is stored in tables only. Show Answer Correct Answer: A) Data is distributed across several sites. 48. How does a DBMS improve data integrity? A) By compressing the data. B) By storing data in separate linked tables. C) By validating the data entry. D) By encrypting the data. Show Answer Correct Answer: C) By validating the data entry. 49. What SQL clause is used to restrict the rows returned by a query depending on validity of two conditions simultaneously? A) AND. B) WHERE. C) HAVING. D) FROM. Show Answer Correct Answer: A) AND. 50. What are the advantages of using a cloud-based DBMS? A) Limited storage capacity. B) High maintenance costs. C) Advantages of using a cloud-based DBMS include scalability, cost-effectiveness, accessibility, automatic updates, and enhanced security. D) Inaccessible from remote locations. Show Answer Correct Answer: C) Advantages of using a cloud-based DBMS include scalability, cost-effectiveness, accessibility, automatic updates, and enhanced security. 51. In-memory databases are less secure than disk-based databases. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 52. What is a limitation of manual file handling? A) Low labor requirement. B) High efficiency. C) Data redundancy. D) Easy access. Show Answer Correct Answer: C) Data redundancy. 53. What includes a number of external schemas or user views? A) Internal or Physical level. B) Conceptual or Logical level. C) External or View level. D) None of the above. Show Answer Correct Answer: C) External or View level. 54. What is a logical schema in a DBMS? A) The structure that defines how data is organized and related. B) The actual data stored in the database. C) A programming interface for the database. D) A query used to retrieve data. Show Answer Correct Answer: A) The structure that defines how data is organized and related. 55. Which of the following best describes the structure of a database? A) A list of web pages. B) A collection of images and videos. C) Tables with rows and columns storing data. D) A book with chapters and sections. Show Answer Correct Answer: C) Tables with rows and columns storing data. 56. What does the HAVING clause do in SQL? A) It retrieves unique values from a column in a table. B) It joins two or more tables together. C) It sorts the result set in descending order. D) It filters records after aggregation has been performed. Show Answer Correct Answer: D) It filters records after aggregation has been performed. 57. Which validation rule allows exactly digits for number fields in Access? A) Is Null or Between 100000 and 99999. B) Is Null or Like "????". C) Is Null or >= 0 AND< = 99999. D) Is Null or < = 99999. Show Answer Correct Answer: C) Is Null or >= 0 AND< = 99999. 58. What is the primary function of the 'SQL' tab in phpMyAdmin as described in the image? A) To import data from SQL files. B) To modify the phpMyAdmin user interface. C) To export data to CSV files. D) To manipulate records in database tables using SQL queries. Show Answer Correct Answer: D) To manipulate records in database tables using SQL queries. 59. Select from the following the multi-valued attribute. A) Date of birth. B) Name. C) Phone number. D) All of the mentioned. Show Answer Correct Answer: C) Phone number. 60. Which of the following objects is considered the basic building block of a relational database? A) Report. B) Query. C) Table. D) Form. Show Answer Correct Answer: C) Table. ← 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