This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 33 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 33 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. ..... is used to store a logically related data. A) File. B) DBMS. C) Data model. D) Database. Show Answer Correct Answer: D) Database. 2. Number of rows in a relation is called its ..... A) Degree. B) Cardinality. C) Attribute. D) None of these. Show Answer Correct Answer: B) Cardinality. 3. The language used in application programs to request data from the DBMS is referred to as the A) DML. B) DDL. C) DCL. D) None of the above. Show Answer Correct Answer: A) DML. 4. Which of the following is an example of an aggregate function in SQL? A) COUNT. B) INSERT. C) JOIN. D) SELECT. Show Answer Correct Answer: A) COUNT. 5. .... is never directly stored in the database. A) Information. B) Software. C) Table. D) Data. Show Answer Correct Answer: D) Data. 6. Indicate whether the statement is true or false:Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 7. What is a characteristic of a distributed database? A) It consists of multiple databases connected across locations. B) It is stored in a single location. C) It cannot be accessed remotely. D) It is only used by small organizations. Show Answer Correct Answer: A) It consists of multiple databases connected across locations. 8. Help Priya to display sname and sales of east and west areas A) Select sname, sales from Salesman where area="East" and area="West";. B) Select sname, sales from Salesman where area="East" or area="West";. C) Select sname, sales from Salesman where area in "East" and "West";. D) Select sname, sales from Salesman where area="East" , "West";. Show Answer Correct Answer: B) Select sname, sales from Salesman where area="East" or area="West";. 9. What is a foreign key and how is it used? A) A foreign key is a field that contains only numeric values. B) A foreign key is a type of index that speeds up queries. C) A foreign key is a unique identifier for a table. D) A foreign key is a field in one table that links to the primary key of another table, establishing a relationship between the two. Show Answer Correct Answer: D) A foreign key is a field in one table that links to the primary key of another table, establishing a relationship between the two. 10. Which model is typically associated with the conceptual level of a database? A) Physical Data Model. B) Relational Data Model. C) View Data Model. D) Schema Model. Show Answer Correct Answer: B) Relational Data Model. 11. Which of the following would most likely occur at the conceptual level of database design? A) Writing SQL queries to display data. B) Defining user permissions for individual columns. C) Optimization of disk I/O access patterns. D) Describing logical structure of the entire database independent of physical considerations. Show Answer Correct Answer: D) Describing logical structure of the entire database independent of physical considerations. 12. Which database object is used to create a user-friendly interface for entering and viewing data? A) Table. B) Query. C) Report. D) Form. Show Answer Correct Answer: D) Form. 13. If a database administrator needs to delete a specific student's record, why is a relational database more reliable than a flat-file database? A) Relational databases prevent any data from being deleted by mistake. B) Data is stored in one place, so it is less likely to be overlooked or require multiple deletions. C) Relational databases automatically back up data before every deletion. D) Flat-file databases do not support the deletion of individual rows. Show Answer Correct Answer: B) Data is stored in one place, so it is less likely to be overlooked or require multiple deletions. 14. The column which has unique values in all the rows but is not a primary key is called ..... key. A) Candidate. B) Alternate. C) Composite. D) Foreign. Show Answer Correct Answer: B) Alternate. 15. How is the result set sorted in ascending order using a SELECT statement? A) DESC. B) SORT ASCENDING. C) ORDER BY. D) ASC. Show Answer Correct Answer: C) ORDER BY. 16. Which database system is ideal for graph-based applications? A) Document-based DBMS. B) Hierarchical DBMS. C) Relational DBMS. D) Graph DBMS. Show Answer Correct Answer: D) Graph DBMS. 17. In an ER diagram, what does a diamond shape represent? A) Entity. B) Relationship. C) Key. D) Attribute. Show Answer Correct Answer: B) Relationship. 18. Which of the following programming languages can be used to write application programs that interact with a DBMS? A) CSS. B) HTML. C) JavaScript. D) Python. Show Answer Correct Answer: D) Python. 19. In a table there can be many alternate keys. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 20. What is the best practice for editing records in MS Access? A) Always work in Design View. B) Edit directly in Datasheet View. C) Only edit through queries. D) Save after each field modification. Show Answer Correct Answer: B) Edit directly in Datasheet View. 21. Which join returns rows from one table even if there's no match in another? A) CROSS JOIN. B) OUTER JOIN. C) INNER JOIN. D) NATURAL JOIN. Show Answer Correct Answer: B) OUTER JOIN. 22. What does DDL stand for in SQL? A) Data Description Language. B) Data Development Language. C) Data Distribution Language. D) Data Definition Language. Show Answer Correct Answer: D) Data Definition Language. 23. What is a key characteristic of relational databases? A) Data cannot be related. B) Data is split into several tables. C) All data is stored in one table. D) Data is unstructured. Show Answer Correct Answer: B) Data is split into several tables. 24. What is a subquery and when would you use one? A) A subquery is a method for optimizing database performance. B) A subquery is a type of database index. C) A subquery is used to create new tables in a database. D) A subquery is a nested query used to retrieve data based on another query's results. Show Answer Correct Answer: D) A subquery is a nested query used to retrieve data based on another query's results. 25. What are the two types of data independence? A) Physical data independence and Logical data independence. B) User independence and System independence. C) Internal independence and External independence. D) Static independence and Dynamic independence. Show Answer Correct Answer: A) Physical data independence and Logical data independence. 26. Which is the BEST example of alphabetic data? A) @#$ %. B) 2025. C) A1B2C3. D) Hanoi. Show Answer Correct Answer: D) Hanoi. 27. Which of these is a valid example of a calculated field that should be avoided in database design? A) Age. B) Name. C) Date of Birth. D) ID number. Show Answer Correct Answer: A) Age. 28. What is the primary difference between a file-based system and a database management system (DBMS)? A) A file-based system is faster. B) A DBMS allows for better data organization and retrieval. C) File-based systems are more secure. D) A DBMS can only handle small amounts of data. Show Answer Correct Answer: B) A DBMS allows for better data organization and retrieval. 29. Indicate whether the statement is true or false:A data quality analyst should be proficient in SQL and JavaScript. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 30. The data stored in database at a particular moment of time is called ..... of database. A) Instance. B) Schema. C) E-R Diagram. D) Relation. Show Answer Correct Answer: A) Instance. 31. An attribute in a relation is a foreign key if the ..... key from one relation is used as an attribute in that relation A) Candidate. B) Primary. C) Super. D) Sub. Show Answer Correct Answer: B) Primary. 32. Which of the following is true about BCNF and 3NF? A) BCNF and 3NF are identical in terms of their requirements. B) Every 3NF relation is also in BCNF, but not every BCNF relation is in 3NF. C) Every BCNF relation is also in 3NF, but not every 3NF relation is in BCNF. D) BCNF focuses on functional dependencies, while 3NF focuses on foreign key relationships. Show Answer Correct Answer: C) Every BCNF relation is also in 3NF, but not every 3NF relation is in BCNF. 33. What is durability of a database? A) During a power failure, all committed transactions are cancelled. B) During a power failure, few committed transactions are lost. C) During a power failure, all committed transactions survive. D) None of the above. Show Answer Correct Answer: C) During a power failure, all committed transactions survive. 34. Basis terdiri dari dua kata, yaitu basis dan data. Basis dapat diartikan sebagai ..... A) Perekaman. B) Tabel. C) Rekaman. D) File. E) Gudang. Show Answer Correct Answer: E) Gudang. 35. Section B:Multiple Choice (5 marks)-Circle or write the correct letter (A, B, C, or D). A record in a table represents: A) A single column of data. B) A collection of related fields. C) One field in a table. D) The entire database. Show Answer Correct Answer: B) A collection of related fields. 36. What does Normalisation allow a database designer to do? A) Design their database efficiently, removing the chance of redundancy and inaccuracies. B) Remove additional records from the tables. C) Add as much data as they like. D) Draw an ERD. Show Answer Correct Answer: A) Design their database efficiently, removing the chance of redundancy and inaccuracies. 37. In database terminology, an entity is best defined as: A) A collection of attributes. B) A unique identifier for a record. C) A set of relationships. D) A real-world object or concept represented in the database. Show Answer Correct Answer: D) A real-world object or concept represented in the database. 38. Why do we need a DATABASE SYSTEM? A) To efficiently store and manage small volumes of data. B) To efficiently store, retrieve and manage small volumes of files. C) To efficiently store, retrieve, and manage large volumes of data. D) To efficiently store, retrieve, and manage large volumes of papers. Show Answer Correct Answer: C) To efficiently store, retrieve, and manage large volumes of data. 39. Which key is used to maintain relationship between tables? A) Candidate key. B) Foreign key. C) Primary key. D) Alternate key. Show Answer Correct Answer: B) Foreign key. 40. What is the main goal of data analysis according to Mario Faria? A) To visualize data. B) To store data efficiently. C) To transform data into conclusions. D) To collect data. Show Answer Correct Answer: C) To transform data into conclusions. 41. Which operator checks whether a subquery returns any row? A) ANY. B) ALL. C) EXISTS. D) IN. Show Answer Correct Answer: C) EXISTS. 42. Which of the following is a type of data that can be stored in a database? A) Text. B) Numbers. C) Dates. D) All of the above. Show Answer Correct Answer: D) All of the above. 43. How does a DBMS benefit end users? A) By requiring users to learn programming languages. B) By hiding the details of database operations. C) By providing a complex view of data. D) By eliminating the need for data management. Show Answer Correct Answer: B) By hiding the details of database operations. 44. How might a school database improve efficiency? A) By grading exams. B) By hiring teachers. C) By organizing student information. D) By teaching classes. Show Answer Correct Answer: C) By organizing student information. 45. What are the common data types used in databases? A) Integer, float, string, boolean, date, and time. B) Integer, float, string, boolean, datetime, and timestamp. C) Int, double, char, bool, date, and datetime. D) Number, decimal, text, boolean, date, and timestamp. Show Answer Correct Answer: A) Integer, float, string, boolean, date, and time. 46. In a relational database table for customers, the information about a single customer resides in a single ..... A) Row. B) Field. C) Table. D) Column. Show Answer Correct Answer: A) Row. 47. Which normal form eliminates partial dependencies? A) 1NF. B) 3NF. C) 2NF. D) BCNF. Show Answer Correct Answer: C) 2NF. 48. ..... tools can be used to rapidly analyze large unstructured data sets, such as email, memos, and survey responses, to discover patterns and relationships. A) Clustering. B) Text mining. C) OLAP. D) In-memory. Show Answer Correct Answer: B) Text mining. 49. Which of these is an example of an entire record in a "Students" table? A) Name, Age, Class, Grade. B) FirstName. C) Date of Birth. D) StudentID. Show Answer Correct Answer: A) Name, Age, Class, Grade. 50. Which database structure allows data to be accessed through navigational paths? A) Object. B) Tabular. C) Network. D) Relational. Show Answer Correct Answer: C) Network. 51. How do you retrieve data from a database? A) Retrieve data using Python scripts without a database connection. B) Use HTML to retrieve data from a database. C) Access data through a web browser interface. D) Use SQL SELECT statements to retrieve data from a database. Show Answer Correct Answer: D) Use SQL SELECT statements to retrieve data from a database. 52. What is the main advantage of using a Database Management System (DBMS)? A) It requires no maintenance. B) It eliminates the need for data. C) It is always free to use. D) It provides a way to manage data efficiently. Show Answer Correct Answer: D) It provides a way to manage data efficiently. 53. Which of the following is a feature of a centralized database? A) It is spread across multiple locations. B) It is maintained in a single unit. C) It requires multiple servers. D) It is only used for small data sets. Show Answer Correct Answer: B) It is maintained in a single unit. 54. Which clause combines the result of two SELECT statements, removing duplicates? A) UNION. B) UNION ALL. C) INTERSECT. D) EXCEPT. Show Answer Correct Answer: A) UNION. 55. Which type of database supports the storage and management of spatial data? A) NoSQL Database. B) Geographical Information System (GIS). C) Relational Database. D) Object-Oriented Database. Show Answer Correct Answer: B) Geographical Information System (GIS). 56. What is the primary key constraint used for? A) Index. B) Redundancy. C) Foreign key. D) Uniqueness. Show Answer Correct Answer: D) Uniqueness. 57. In an ERD, what does a rectangle shape represent? A) An entity. B) A relationship. C) A primary key. D) An attribute. Show Answer Correct Answer: A) An entity. 58. Degree and Cardinality of cartesian product of faculty and courses is? A) Degree 9 Cardinality 30. B) Degree 10 Cardinality 36. C) Degree 36 Cardinality 10. D) Degree 30 Cardinality 9. Show Answer Correct Answer: A) Degree 9 Cardinality 30. 59. Which of the following best defines a table in MS Access? A) A file that stores text and images. B) A collection of records organized in rows and columns. C) A layout used to print data. D) A tool to sort and filter information. Show Answer Correct Answer: B) A collection of records organized in rows and columns. 60. A distributed database ..... A) Uses SQL. B) Is a database that is distributed across many business firms. C) Uses predictive analysis. D) Is a database that is stored in multiple physical locations. Show Answer Correct Answer: D) Is a database that is stored in multiple physical locations. ← 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