This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 30 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 30 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the role of an access object in a database? A) To store all database records permanently. B) To optimize database queries for faster performance. C) The role of an access object is to manage user permissions and control access to database data. D) To create backups of the database data. Show Answer Correct Answer: C) The role of an access object is to manage user permissions and control access to database data. 2. Which of the following best describes a field in MS Access? A) A column that holds specific type of data. B) A row of data. C) A saved query. D) A complete table. Show Answer Correct Answer: A) A column that holds specific type of data. 3. SQL (Structured Query Language) A) A standard language used to communicate with relational databases. B) A programming language for web development. C) A markup language for creating web pages. D) A database management system. Show Answer Correct Answer: A) A standard language used to communicate with relational databases. 4. What is a single row in a database called? A) Entity. B) Table. C) Field. D) Record. Show Answer Correct Answer: D) Record. 5. In Microsoft Access, which object allows users to view structured data entry? A) Query. B) Form. C) Report. D) Field. Show Answer Correct Answer: B) Form. 6. Why is using a 'Long Integer' field recommended for numeric data containing three or more digits? A) It allows for the inclusion of currency symbols like $ . B) It ensures the database can store and manipulate larger values without errors. C) It is the only data type that allows for a restricted number of decimal places. D) It automatically generates unique numbers for every new record. Show Answer Correct Answer: B) It ensures the database can store and manipulate larger values without errors. 7. In Oracle, who owns the data dictionary? A) DBA. B) SYS. C) SYSTEM. D) None of the above. Show Answer Correct Answer: B) SYS. 8. What type of data can a database organize? A) Only numbers. B) Only text. C) Sounds, graphics, and text files. D) Only spreadsheets. Show Answer Correct Answer: C) Sounds, graphics, and text files. 9. What is the primary advantage of using a flat-file database over a relational database for small, simple tasks? A) Faster data retrieval for complex queries. B) More efficient handling of large volumes of data. C) Simplicity in design and ease of use. D) Better data integrity and securityTagsDOK Level 2:Skill/Concept. Show Answer Correct Answer: C) Simplicity in design and ease of use. 10. Which technique is used to control access to data in a multi-user environment? A) Data compression. B) Locking. C) Data encryption. D) Indexing. Show Answer Correct Answer: B) Locking. 11. Define DDL and name some commands. A) Data Definition Language, commands include CREATE, ALTER, DROP. B) Data Description Language, commands include SELECT, INSERT, UPDATE. C) Data Derivation Language, commands include GRANT, REVOKE, COMMIT. D) Data Distribution Language, commands include JOIN, UNION, INTERSECT. Show Answer Correct Answer: A) Data Definition Language, commands include CREATE, ALTER, DROP. 12. What is the purpose of the Isolation property in ACID? A) To make sure transactions are executed quickly. B) To ensure that the database is always available. C) To encrypt the data during transactions. D) To prevent concurrent transactions from interfering with each other. Show Answer Correct Answer: D) To prevent concurrent transactions from interfering with each other. 13. Explain the concept of a 'domain' in databases. A) A domain in databases is the set of allowable values for an attribute, defining its data type and constraints. B) A domain in databases is the process of indexing data for faster retrieval. C) A domain in databases is the overall structure of a database system. D) A domain in databases refers to the physical storage location of data. Show Answer Correct Answer: A) A domain in databases is the set of allowable values for an attribute, defining its data type and constraints. 14. Explain the concept of data redundancy in database management. A) Data redundancy has no impact on data integrity in database management. B) Data redundancy is the process of organizing data in a database to minimize redundancy and dependency. C) Data redundancy involves combining multiple tables into one to simplify the database structure. D) Data redundancy is the process of adding redundant data to a database to improve read performance for large tables. Show Answer Correct Answer: A) Data redundancy has no impact on data integrity in database management. 15. Fill in the blank: ..... command is used to remove primary key from a table in SQL. A) Remove. B) Update. C) Drop. D) Alter. Show Answer Correct Answer: C) Drop. 16. Which architecture is best suited for scalability? A) Client/Server. B) Centralized. C) Hierarchical. D) File-based. Show Answer Correct Answer: A) Client/Server. 17. Which of the following is NOT an example of a DBMS? A) Microsoft Excel. B) MySQL. C) PostgreSQL. D) Oracle Database. Show Answer Correct Answer: A) Microsoft Excel. 18. A value that is not available or not known is a A) NULL value. B) Missing value. C) Unknown value. D) Zero value. Show Answer Correct Answer: A) NULL value. 19. A ..... is a software management system designed to maintain a database. A) File. B) Database. C) DBMS. D) Information. Show Answer Correct Answer: C) DBMS. 20. Which DBMS architecture offers better fault tolerance? A) Centralized. B) Hierarchical. C) Distributed. D) File system. Show Answer Correct Answer: C) Distributed. 21. Why is backup and recovery crucial for database management? A) Backup and recovery are unnecessary for database management. B) Backup and recovery slow down database performance. C) Backup and recovery increase the risk of data corruption. D) Backup and recovery help maintain data integrity, minimize data loss, and enable restoration to a previous state. Show Answer Correct Answer: D) Backup and recovery help maintain data integrity, minimize data loss, and enable restoration to a previous state. 22. A composite key is usually: A) A sequential system-generated number. B) A single-column key. C) Made of multiple attributes that have real-world meaning. D) Automatically generated by Oracle. Show Answer Correct Answer: C) Made of multiple attributes that have real-world meaning. 23. A reason for using an SQL view to hide columns is: A) To simplify a result only. B) To prevent the display of sensitive data only. C) To accomplish both of the above. D) None of the above are reasons for using an SQL view. Show Answer Correct Answer: C) To accomplish both of the above. 24. In a student database, which of the following could be a field? A) Student ID. B) All students. C) Classroom. D) School. Show Answer Correct Answer: A) Student ID. 25. A logical schema, A) Is a model usually a diagram with data structures expressed which are independent of DBMS. B) Is a standard way of organizing information into accessible parts. C) Describes how data is actually stored on disk. D) Both (A) and (C). Show Answer Correct Answer: A) Is a model usually a diagram with data structures expressed which are independent of DBMS. 26. Why is data abstraction important in DBMS? A) It reduces server load. B) It hides complexity and ensures security. C) It increases redundancy. D) It helps design spreadsheets. Show Answer Correct Answer: B) It hides complexity and ensures security. 27. .... is the most prevalent database model. A) Network. B) Object. C) Hierarchical. D) Relational. Show Answer Correct Answer: D) Relational. 28. In a relational database, two files can be joined if they have what in common? A) The same number of records. B) A common field. C) The same type of data. D) The same index. Show Answer Correct Answer: B) A common field. 29. Perintah DML yang digunakan untuk menambahkan data baru ke tabel adalah ..... A) ALTER. B) Update. C) Select. D) Delete. E) Insert. Show Answer Correct Answer: E) Insert. 30. Which of these is an example of alphanumeric data? A) 67890. B) A12345. C) %%%%. D) HelloWorld. Show Answer Correct Answer: B) A12345. 31. What is a potential consequence of poor concurrency control in a database? A) Improved data integrity. B) Enhanced system performance. C) Faster query execution. D) Lost updates or inconsistent data. Show Answer Correct Answer: D) Lost updates or inconsistent data. 32. What is a query? A) A type of database. B) A method to store data. C) A request to retrieve data. D) A way to delete data. Show Answer Correct Answer: C) A request to retrieve data. 33. Which operation could violate referential integrity in this database? A) Updating a product price value field. B) Deleting a customer still referenced by subscriptions. C) Renaming a productName for marketing. D) Changing a customer's email address field. Show Answer Correct Answer: B) Deleting a customer still referenced by subscriptions. 34. Which of the following is NOT supported by MySQL? A) Temporary (Hash) Tables. B) Table Joining. C) Regular Expression Matching. D) Stored Procedures. Show Answer Correct Answer: D) Stored Procedures. 35. What is DQL and how is it used? A) Data Query Language, used to manipulate data in databases. B) Data Query Language, used to query data from databases. C) Data Query Language, used to control access to data. D) Data Query Language, used to define database schemas. Show Answer Correct Answer: B) Data Query Language, used to query data from databases. 36. Which tab in MS Access allows users to create forms? A) Design. B) View. C) Create. D) File. Show Answer Correct Answer: C) Create. 37. Why are many-to-many relationships considered problematic in database design? A) They can cause issues with data integrity. B) They simplify data management. C) They help in faster data retrieval. D) They reduce the need for additional tables. Show Answer Correct Answer: A) They can cause issues with data integrity. 38. Relational Algebra was first created by ..... A) Hugh Darwen. B) Chris Date. C) Chen. D) E F Codd. Show Answer Correct Answer: D) E F Codd. 39. 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. 40. Match the following:1. Navigational model-Tables2. Relational model-Records3. DBMS-SQL Server4. RDBMS-Dbase A) 2-1-4-3. B) 1-2-4-3. C) 2-1-3-4. D) 1-2-3-4. Show Answer Correct Answer: A) 2-1-4-3. 41. 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. 42. 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. 43. Which of the following factors is NOT considered when choosing a database? A) Query complexity. B) The programming language of the developer. C) Data structure. D) Scalability needs. Show Answer Correct Answer: B) The programming language of the developer. 44. 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) Web browser software. B) Database server software. C) Data mining software. D) Application server software. Show Answer Correct Answer: D) Application server software. 45. 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. 46. A relational database consists of a collection of ..... A) Tables. B) Keys. C) Records. D) Fields. Show Answer Correct Answer: A) Tables. 47. ..... also provides protection and security to the database. A) Hardware. B) Software. C) Program. D) DBMS. Show Answer Correct Answer: D) DBMS. 48. 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. 49. To take effective decision in the organization requires A) Image. B) Data. C) Information. D) Current trends. Show Answer Correct Answer: C) Information. 50. Which command permanently saves all the work done since the BEGIN TRANSACTION command? A) COMMIT TRANSACTION. B) END TRANSACTION. C) SAVE TRANSACTION. D) FLUSH TRANSACTION. Show Answer Correct Answer: A) COMMIT TRANSACTION. 51. 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. 52. Which command structure inserts a new row into a table? A) INSERT INTO () VALUES ();. B) INSERT RECORD () ;. C) ADD NEW () INTO ;. D) INSERT VALUES ();. Show Answer Correct Answer: A) INSERT INTO () VALUES ();. 53. What is normalization in the context of databases? A) The method of organizing data to reduce redundancy. B) The act of deleting unnecessary data. C) The technique of backing up data. D) The process of converting physical data into digital form. Show Answer Correct Answer: A) The method of organizing data to reduce redundancy. 54. 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. 55. 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. 56. 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. 57. 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. 58. What is an input mask? A) A unique identifier for a record. B) A primary key linking tables. C) A heading for organizing data. D) A control added to a field to control the format of data being added. Show Answer Correct Answer: D) A control added to a field to control the format of data being added. 59. In a database, a ..... represents a single category of information within a table, like "Name" or "Age." A) Field. B) Record. C) Database. D) Table. Show Answer Correct Answer: A) Field. 60. DBMS means ..... A) Database Management System. B) DataBase Maintain System. C) DataBase Management Software. D) Data Bit Management System. Show Answer Correct Answer: A) Database Management System. ← PreviousNext →Related QuizzesScience QuizzesClass 11 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 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books