This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 75 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 75 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is NOT supported by MySQL? A) Temporary (Hash) Tables. B) Table Joining. C) Stored Procedures. D) Regular Expression Matching. Show Answer Correct Answer: C) Stored Procedures. 2. What is DQL and how is it used? A) Data Query Language, used to query data from databases. B) Data Query Language, used to define database schemas. C) Data Query Language, used to manipulate data in databases. D) Data Query Language, used to control access to data. Show Answer Correct Answer: A) Data Query Language, used to query data from databases. 3. Which tab in MS Access allows users to create forms? A) File. B) Create. C) Design. D) View. Show Answer Correct Answer: B) Create. 4. Why are many-to-many relationships considered problematic in database design? A) They simplify data management. B) They help in faster data retrieval. C) They can cause issues with data integrity. D) They reduce the need for additional tables. Show Answer Correct Answer: C) They can cause issues with data integrity. 5. Relational Algebra was first created by ..... A) E F Codd. B) Chen. C) Chris Date. D) Hugh Darwen. Show Answer Correct Answer: A) E F Codd. 6. How can you pass parameters to a stored procedure? A) Parameters can only be passed as JSON objects. B) You can only pass parameters as global variables. C) Stored procedures do not accept any parameters. D) You can pass parameters by defining them in the procedure and providing values during the call. Show Answer Correct Answer: D) You can pass parameters by defining them in the procedure and providing values during the call. 7. Match the following:1. Navigational model-Tables2. Relational model-Records3. DBMS-SQL Server4. RDBMS-Dbase A) 1-2-3-4. B) 2-1-3-4. C) 2-1-4-3. D) 1-2-4-3. Show Answer Correct Answer: C) 2-1-4-3. 8. What is an example of a many-to-many relationship in a database? A) A student can enroll in multiple courses, and a course can have multiple students. B) A teacher can teach multiple subjects, but each subject is taught by only one teacher. C) A customer can place multiple orders, but each order is placed by only one customer. D) A book can have only one author. Show Answer Correct Answer: A) A student can enroll in multiple courses, and a course can have multiple students. 9. The property / properties of a database system is / are: A) It is an integrated collection of logically related records. B) It consolidates separate files into a common pool of data records. C) Data stored in a database is independent of the application programs using it. D) All of the above. Show Answer Correct Answer: D) All of the above. 10. Which of the following factors is NOT considered when choosing a database? A) Data structure. B) Query complexity. C) The programming language of the developer. D) Scalability needs. Show Answer Correct Answer: C) The programming language of the developer. 11. Which of the following is software that handles all application operations between browser-based computers and a company's back-end business applications or databases? A) Database server software. B) Application server software. C) Web browser software. D) Data mining software. Show Answer Correct Answer: B) Application server software. 12. Who manages the Database? A) Database Administrator. B) Relational Database Management System (RDBMS). C) Both A & B. D) None of them. Show Answer Correct Answer: A) Database Administrator. 13. A relational database consists of a collection of ..... A) Tables. B) Fields. C) Records. D) Keys. Show Answer Correct Answer: A) Tables. 14. ..... also provides protection and security to the database. A) Program. B) Software. C) Hardware. D) DBMS. Show Answer Correct Answer: D) DBMS. 15. What is the role of indexing in database performance? A) Indexing in databases has no impact on performance. B) Indexing in databases slows down performance by increasing the time it takes to retrieve data. C) Indexing in databases causes data corruption. D) Indexing in databases improves performance by allowing the system to quickly locate and retrieve specific rows of data without scanning the entire table. Show Answer Correct Answer: D) Indexing in databases improves performance by allowing the system to quickly locate and retrieve specific rows of data without scanning the entire table. 16. To take effective decision in the organization requires A) Data. B) Information. C) Image. D) Current trends. Show Answer Correct Answer: B) Information. 17. Which command permanently saves all the work done since the BEGIN TRANSACTION command? A) SAVE TRANSACTION. B) COMMIT TRANSACTION. C) END TRANSACTION. D) FLUSH TRANSACTION. Show Answer Correct Answer: B) COMMIT TRANSACTION. 18. Indicate whether the statement is true or false:In-memory computing relies primarily on a computer's disk drives for data storage. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 19. Which command structure inserts a new row into a table? A) INSERT INTO () VALUES ();. B) ADD NEW () INTO ;. C) INSERT VALUES ();. D) INSERT RECORD () ;. Show Answer Correct Answer: A) INSERT INTO () VALUES ();. 20. What is normalization in the context of databases? A) The process of converting physical data into digital form. B) The method of organizing data to reduce redundancy. C) The act of deleting unnecessary data. D) The technique of backing up data. Show Answer Correct Answer: B) The method of organizing data to reduce redundancy. 21. MS Access is an example of a database. A) TRUE. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 22. The functions of a DBMS, except for: A) Creating and processing forms. B) Creating databases. C) Processing data. D) Managing databases. Show Answer Correct Answer: A) Creating and processing forms. 23. What type of data can be stored in a social media database? A) Audio files. B) Structured data. C) Images and videos. D) Unstructured data. Show Answer Correct Answer: B) Structured data. 24. What is the purpose of action queries in a database? A) To retrieve data. B) To change data like adding, updating, and deleting. C) To create reports. D) To automate tasks. Show Answer Correct Answer: B) To change data like adding, updating, and deleting. 25. What is an input mask? A) A heading for organizing data. B) A control added to a field to control the format of data being added. C) A unique identifier for a record. D) A primary key linking tables. Show Answer Correct Answer: B) A control added to a field to control the format of data being added. ← 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