This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 77 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 77 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The SQL statement 'Select mod (10, 4) from dual' will display 2 as the result A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 2. What is the purpose of a school database? A) To store and manage student information. B) To create video games. C) To perform calculations. D) To write stories. Show Answer Correct Answer: A) To store and manage student information. 3. What is the significance of transaction management in databases? A) Transaction management is only important for performance optimization. B) Transaction management is significant for ensuring data integrity and consistency in databases. C) Transaction management is irrelevant in distributed databases. D) Transaction management is solely focused on user access control. Show Answer Correct Answer: B) Transaction management is significant for ensuring data integrity and consistency in databases. 4. What are the main responsibilities of a database administrator? A) Designing user interfaces. B) Managing and maintaining databases, ensuring data security, optimizing database performance, troubleshooting issues, implementing backup and recovery plans. C) Writing code for applications. D) Managing social media accounts. Show Answer Correct Answer: B) Managing and maintaining databases, ensuring data security, optimizing database performance, troubleshooting issues, implementing backup and recovery plans. 5. Data dictionary includes the actual data values of the database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 6. Which of these software helps manage a computerized database? A) MS Excel. B) DBMS. C) MS Word. D) Tally. Show Answer Correct Answer: B) DBMS. 7. Which of the following is NOT a typical data manipulation operation? A) Inserting rows into a table. B) Updating existing rows. C) Deleting rows from a table. D) Changing the physical file organization on disk. Show Answer Correct Answer: D) Changing the physical file organization on disk. 8. What does a thick line represent in referential integrity? A) A connection between unrelated tables. B) A connection between the parent and child table. C) A deletion of records. D) An update of records. Show Answer Correct Answer: B) A connection between the parent and child table. 9. What is a major disadvantage of a flat-file database? A) It requires multiple tables. B) It often contains duplicated data. C) It always needs SQL. D) It uses too many relationships. Show Answer Correct Answer: B) It often contains duplicated data. 10. Section D:Fill in the Blanks (5 marks)-Write the correct word or term in each blank space. A ..... is a collection of related information organized into tables. A) Database. B) Record. C) Field. D) Spreadsheet. Show Answer Correct Answer: A) Database. 11. What is the problem in file-based system? A) Data is easily managed. B) Data is consistent. C) Data is redundant. D) Data is organized. Show Answer Correct Answer: C) Data is redundant. 12. Which data type is appropriate for storing dates and times in a database? A) Character. B) Real. C) Date/time. D) IntegerTagsLO2. Show Answer Correct Answer: C) Date/time. 13. Name three common data types used for storing text in databases. A) INT, FLOAT, BOOLEAN. B) DATE, TIME, TIMESTAMP. C) BLOB, CLOB, XML. D) VARCHAR, TEXT, CHAR. Show Answer Correct Answer: D) VARCHAR, TEXT, CHAR. 14. What data type would you use in SQL to store a date and time value together? A) DATETIME. B) DATE. C) TIME. D) TIMESTAMP. Show Answer Correct Answer: A) DATETIME. 15. Which one of the following should be taken as a primary key? A) Name. B) DepartmentID. C) Department. D) Street. Show Answer Correct Answer: B) DepartmentID. 16. A table can be created without a primary key. A) TRUE. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 17. What do we call the number of records in a relation? A) Degree. B) Tuple. C) Cardinality. D) Domain. Show Answer Correct Answer: C) Cardinality. 18. What do you mean by consistent data in a database? A) All users view the same data. B) Providing different access levels to users. C) Information sharing between users. D) Customising data according to user's requirements. Show Answer Correct Answer: A) All users view the same data. 19. Which operator checks if a value matches one of a set of values? A) ANY. B) EXISTS. C) IN. D) ALL. Show Answer Correct Answer: C) IN. 20. What does a row in a database table represent? A) A collection of related fields. B) The header or title of a table. C) A command in SQL. D) The collection of data for a specific entry in the table. Show Answer Correct Answer: D) The collection of data for a specific entry in the table. 21. An atomic transaction is a set of SQL statements where A) All succeed. B) All fail. C) All succeed or fail. D) None succeed of fail. Show Answer Correct Answer: C) All succeed or fail. 22. The entity integrity rule requires that ..... A) All primary key entries are unique. B) A part of the key may be null. C) Foreign key values do not reference primary key values. D) Duplicate object values are allowed. Show Answer Correct Answer: A) All primary key entries are unique. 23. Microsoft SQL Server is a(n) ..... A) DBMS for both desktops and mobile devices. B) Internet DBMS. C) Desktop relational DBMS. D) DBMS for midrange computers. Show Answer Correct Answer: D) DBMS for midrange computers. 24. Which SQL query shows the names of employees who have not been assigned to any department? A) SELECT name FROM employees WHERE department id IS NULL;. B) SELECT name FROM employees WHERE department id = 0;. C) SELECT name FROM employees WHERE department id = ' ';. D) SELECT name FROM employees WHERE department id = NULL;. Show Answer Correct Answer: A) SELECT name FROM employees WHERE department id IS NULL;. 25. In an E-R diagram the uses Crows Foot Notation an entity set is represent by a A) Rectangle. B) Ellipse. C) Diamond box. D) Circle. Show Answer Correct Answer: A) Rectangle. ← PreviousNext →Related 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 8Class 11 Computer Science Chapter 7 Database Concepts Quiz 9Class 11 Computer Science Chapter 7 Database Concepts Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books