This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 90 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 90 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the purpose of using a TRY ..... CATCH block within a stored procedure that contains a transaction? A) To improve the performance of the COMMIT command. B) To define the OUTPUT parameters of the procedure. C) To handle unexpected system errors and ensure a ROLLBACK is issued. D) To bypass the SERIALIZABLE isolation level. Show Answer Correct Answer: C) To handle unexpected system errors and ensure a ROLLBACK is issued. 2. Which SQL keyword is used to return specific columns? A) SHOW. B) RETURN. C) SELECT. D) OUTPUT. Show Answer Correct Answer: C) SELECT. 3. What is a column in a database? A) A single image. B) A single attribute of a record. C) A single file. D) A single folder. Show Answer Correct Answer: B) A single attribute of a record. 4. Information about NoSQL databases A) There are several problems with the operation of big data, which can be effectively solved with a relational database. B) Graph-oriented databases use graph theory to store, display, and query relationships. C) OLTP is another type of database that can quickly process requests and maintain data integrity in multiple available environments. D) This type of DBMS uses parent-generation relationships to store data. E) None. Show Answer Correct Answer: A) There are several problems with the operation of big data, which can be effectively solved with a relational database. 5. Which high-level language was developed in 1995 and is widely used for web applications? A) C++. B) FORTRAN. C) Java. D) BASIC. Show Answer Correct Answer: C) Java. 6. Who are the typical users and administrators of a database system? A) System administrators, network engineers, project managers. B) Marketing specialists, graphic designers, content creators. C) Sales representatives, customer support agents, IT technicians. D) End-users, data analysts, developers, and database administrators (DBAs). Show Answer Correct Answer: D) End-users, data analysts, developers, and database administrators (DBAs). 7. Which command is used to rename a collection? A) Db.renameCollection(). B) Db.collection.rename(). C) Db.collection.renameCollection(). D) Db.collection.renameTo(). Show Answer Correct Answer: D) Db.collection.renameTo(). 8. Which of the following is an example of an input mask? A) Allowing only numbers in a phone number field. B) Sorting data in alphabetical order. C) Formatting reports for printing. D) Storing text in a lookup field. Show Answer Correct Answer: A) Allowing only numbers in a phone number field. 9. What does middleware do in an information system? A) It enables communication between users and applications. B) It enables communication between applications or data bases. C) It enables communication between users. D) None of the above. Show Answer Correct Answer: B) It enables communication between applications or data bases. 10. What is the external level in a database architecture concerned with? A) Data storage. B) End-user interaction. C) Data modeling. D) Security enforcement. Show Answer Correct Answer: B) End-user interaction. 11. How can indexing improve database performance? A) Indexing enhances data retrieval speed and efficiency in databases. B) Indexing increases the amount of data stored in the database. C) Indexing slows down data retrieval processes. D) Indexing makes data updates more complex and time-consuming. Show Answer Correct Answer: A) Indexing enhances data retrieval speed and efficiency in databases. 12. Which is the earliest data model? A) Relational. B) Network. C) Hierarchical. D) ER. Show Answer Correct Answer: C) Hierarchical. 13. What is the primary purpose of data validation? A) To encrypt sensitive data. B) To ensure entered data meets predefined rules and constraints. C) To speed up database queries. D) To create backups of the database. Show Answer Correct Answer: B) To ensure entered data meets predefined rules and constraints. 14. What is the significance of primary keys in a database? A) Primary keys are used to store large amounts of data. B) Primary keys are optional for all database tables. C) Primary keys can be duplicated across records. D) Primary keys ensure uniqueness and integrity of records in a database. Show Answer Correct Answer: D) Primary keys ensure uniqueness and integrity of records in a database. 15. Which constraint prevents NULL values in a column? A) PRIMARY KEY. B) NOT NULL. C) CHECK. D) UNIQUE. Show Answer Correct Answer: B) NOT NULL. 16. What is a record? A) A complete set of related fields. B) A table of multiple databases. C) A link between two tables. D) A column in a table. Show Answer Correct Answer: A) A complete set of related fields. 17. Which view in MS Access displays data in a spreadsheet-like format? A) Form View. B) Report View. C) Design View. D) Datasheet View. Show Answer Correct Answer: D) Datasheet View. 18. What is the purpose of data validation? A) To ensure data is accurate and complete. B) To verify data against the original source. C) To delete unnecessary data. D) To create new data entries. Show Answer Correct Answer: A) To ensure data is accurate and complete. 19. Fields are made up of records. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 20. Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator? A) Supertype entity. B) Subtype entity. C) Archetype entity. D) Instance entity. Show Answer Correct Answer: B) Subtype entity. 21. Which of the following is NOT an advantage of using a DBMS? A) Data integrity. B) Data complexity. C) Data backup and recovery. D) Data sharing. Show Answer Correct Answer: B) Data complexity. 22. Data redundancy occurs when: A) Data is stored efficiently. B) The same data is stored multiple times. C) Data is stored in one table only. D) No relationships exist between tables. Show Answer Correct Answer: B) The same data is stored multiple times. 23. What are the normal forms in database normalization? A) 1NF, 2NF, 3NF, 5NF, 9NF. B) 1NF, 2NF, 3NF, 4NF, 8NF. C) 1NF, 2NF, 3NF, 6NF, 7NF. D) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. Show Answer Correct Answer: D) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. 24. Which statement is used to assign a value to a variable in T-SQL? A) DEFINE. B) UPDATE. C) ASSIGN. D) SET. Show Answer Correct Answer: D) SET. 25. Which of the following is NOT a component of a database? A) Table. B) Field. C) Record. D) Formula. Show Answer Correct Answer: D) Formula. ← PreviousRelated 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