This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 11 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 11 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What are the different types of data that can be stored in a database? A) Text, numbers, dates, images, audio, video, and text data. B) Text, numbers, dates, images, audio, video, and binary data. C) Text, numbers, dates, images, audio, video, and character data. D) Text, numbers, dates, images, audio, video, and boolean data. Show Answer Correct Answer: B) Text, numbers, dates, images, audio, video, and binary data. 2. In relational data model, the total number of rows can be identified as ..... A) Attribute. B) Entity. C) Cardinality. D) Degree. Show Answer Correct Answer: C) Cardinality. 3. A relation in this form has no modification anomalies: A) First normal form. B) Second normal form. C) Domain/key normal form. D) Third normal form. Show Answer Correct Answer: B) Second normal form. 4. What is the purpose of data modeling in database design? A) To create hardware for storing data. B) To help programmers understand the complex flow of data. C) To prevent data from being accessed. D) To format data automatically. Show Answer Correct Answer: B) To help programmers understand the complex flow of data. 5. What are the different types of relationships that can exist between tables in a database design? A) Red, Blue, Green. B) Cat, Dog, Bird. C) One-to-One, One-to-Many, Many-to-Many. D) Up, Down, Left. Show Answer Correct Answer: C) One-to-One, One-to-Many, Many-to-Many. 6. Meta data refers to ..... A) Data. B) Empty data. C) Data about data. D) None of these. Show Answer Correct Answer: C) Data about data. 7. In a school's database, both "Admission Number" and the combination of "Class + Section + Roll No." can identify a student. These are: A) Alternate Keys. B) Foreign Keys. C) Candidate Keys. D) Composite Keys. Show Answer Correct Answer: C) Candidate Keys. 8. How many levels are in the ANSI-SPARC model? A) 5. B) 2. C) 3. D) 4. Show Answer Correct Answer: C) 3. 9. Name three types of Database Management Systems. A) Network DBMS. B) Relational DBMS, NoSQL DBMS, Object-oriented DBMS. C) Flat-file DBMS. D) Hierarchical DBMS. Show Answer Correct Answer: B) Relational DBMS, NoSQL DBMS, Object-oriented DBMS. 10. What does an RDBMS consist of? A) Collection of records. B) Collection of Fields. C) Collection of Tables. D) Collection of Keys. Show Answer Correct Answer: C) Collection of Tables. 11. Each row in a table represents a ..... A) Record. B) Field. C) Data. D) Database. Show Answer Correct Answer: A) Record. 12. Which symbol is used in query criteria to find records that begin with a specific letter? A) &. B) #. C) *. D) Like "S*". Show Answer Correct Answer: D) Like "S*". 13. What data type should be used for the 'RoomNumber' field in the 'Classes' table? A) Logical. B) Numeric. C) Currency. D) Text. Show Answer Correct Answer: B) Numeric. 14. Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called ..... A) Data optimization. B) Data cleansing. C) Data auditing. D) Defragmentation. Show Answer Correct Answer: B) Data cleansing. 15. .... is a repository collection of related . A) Data. B) Information. C) Database. D) None of these. Show Answer Correct Answer: C) Database. 16. What is data redundancy? A) Format control for data entry. B) Unnecessary repetition of data in a database. C) Unique identifier for a record. D) Error that occurs during data entry. Show Answer Correct Answer: B) Unnecessary repetition of data in a database. 17. A relational operator that yields all rows in one table that are not found in the other table is the ..... operator. A) PRODUCT. B) INTERSECT. C) DIFFERENCE. D) UNION. Show Answer Correct Answer: C) DIFFERENCE. 18. What type of relationship exists between two tables when a foreign key references a primary key? A) One-to-many. B) Many-to-many. C) One-to-one. D) None of the above. Show Answer Correct Answer: A) One-to-many. 19. What are the advantages of using a database management system? A) A database management system (DBMS) provides several advantages, including data integrity, data security, data consistency, data sharing, data independence, and efficient data access and retrieval. B) Reduced data redundancy and inconsistency. C) Faster data processing and retrieval. D) Improved data organization and storage. Show Answer Correct Answer: A) A database management system (DBMS) provides several advantages, including data integrity, data security, data consistency, data sharing, data independence, and efficient data access and retrieval. 20. What is one reason organizations prefer databases over spreadsheets? A) Databases can generate colorful graphs. B) Databases can handle more data points efficiently. C) Spreadsheets are only for financial reports. D) Spreadsheets are harder to understand. Show Answer Correct Answer: B) Databases can handle more data points efficiently. 21. What is the primary purpose of backup and recovery features in DBMS? A) To increase database speed. B) To reduce storage costs. C) To improve user interfaces. D) To protect against data loss and restore systems after failures. Show Answer Correct Answer: D) To protect against data loss and restore systems after failures. 22. Which of the following describes the internal level of data abstraction? A) The way users see the data. B) Logical structure of the database. C) How the data is actually stored. D) Relationship among entities. Show Answer Correct Answer: C) How the data is actually stored. 23. What is a primary key and why is it important? A) A primary key is a random number for database entries, irrelevant for data management. B) A primary key is a unique identifier for records in a database, crucial for data integrity and relationships. C) A primary key is a duplicate identifier for records, essential for data redundancy. D) A primary key is a visual representation of data, important for user interface design. Show Answer Correct Answer: B) A primary key is a unique identifier for records in a database, crucial for data integrity and relationships. 24. What is an entity-relationship model and how is it used in database design? A) It is a method for organizing files in a computer system. B) It is a visual representation of the relationships between entities in a database and is used to define the structure of the database and the relationships between different data entities. C) It is a type of computer virus used to corrupt databases. D) It is a tool for creating animations in database design. Show Answer Correct Answer: B) It is a visual representation of the relationships between entities in a database and is used to define the structure of the database and the relationships between different data entities. 25. What is the functional purpose of a 'Foreign Key' within a relational database table? A) To ensure that every record within that specific table is unique. B) To act as a placeholder for media files like images and videos. C) To point to a primary key in another table to form a relationship. D) To prevent the database from being accessed by unauthorized users. Show Answer Correct Answer: C) To point to a primary key in another table to form a relationship. 26. In an ER diagram, a *mandatory* relationship means: A) The foreign key can be either NULL or NOT NULL. B) The foreign key cannot be NULL. C) The foreign key must be NULL. D) There is no foreign key involved. Show Answer Correct Answer: B) The foreign key cannot be NULL. 27. Which type of key is used to uniquely identify a record in a database table? A) Foreign Key. B) Composite Key. C) Primary Key. D) Candidate Key. Show Answer Correct Answer: C) Primary Key. 28. The process of organizing data to be stored in a database into two or more tables and establishing relationships between the tables, so that data redundancy is minimized. A) Normalization (database). B) Data Warehousing. C) Denormalization. D) Data Mining. Show Answer Correct Answer: A) Normalization (database). 29. Which of the following is NOT true of relational database management systems A) Tables are organized into columns. B) An index provides a quick way to look up data. C) Stores data in flat files. D) One or more columns uniquely identify a row within the table. Show Answer Correct Answer: C) Stores data in flat files. 30. What command would you use to delete a database in MySQL? A) DROP DATABASE database name;. B) CLEAR DATABASE database name;. C) REMOVE DATABASE database name;. D) DELETE DATABASE database name;. Show Answer Correct Answer: A) DROP DATABASE database name;. 31. Can a table have more than one foreign key? A) Yes, but only if it does not have a primary key. B) Yes, a table can have multiple foreign keys. C) No, a table cannot have any foreign keys. D) No, a table can only have one foreign key. Show Answer Correct Answer: B) Yes, a table can have multiple foreign keys. 32. Which of the following is an example of an entity? A) Person. B) Idea. C) Animal. D) Object. Show Answer Correct Answer: A) Person. 33. Business rules mainly define ..... A) Hardware requirements. B) Network protocols. C) Data relationships and constraints. D) File formats. Show Answer Correct Answer: C) Data relationships and constraints. 34. Which type of database user interacts with the external level? A) Application Developer. B) End-user. C) Database Administrator. D) Data Analyst. Show Answer Correct Answer: B) End-user. 35. Each entity is described by ..... A) Entity. B) Relationship. C) None of these. D) Attribute. Show Answer Correct Answer: D) Attribute. 36. Normalization ..... data duplication A) Maximizes. B) Eliminates. C) Increases. D) Reduces. Show Answer Correct Answer: B) Eliminates. 37. What is the purpose of relationships in a database? A) To eliminate the need for data normalization. B) To store data in a single table only. C) To create visual representations of data without structure. D) The purpose of relationships in a database is to connect and organize data across different tables, ensuring data integrity and facilitating efficient data retrieval. Show Answer Correct Answer: D) The purpose of relationships in a database is to connect and organize data across different tables, ensuring data integrity and facilitating efficient data retrieval. 38. Which data type can store unstructured data in a column? A) NUMERIC. B) VARCHAR. C) CHAR. D) RAW. Show Answer Correct Answer: D) RAW. 39. A functional dependency is a relationship between: A) Tables. B) Relations. C) Attributes. D) Rows. Show Answer Correct Answer: C) Attributes. 40. What is a foreign key used for in a database? A) To delete records. B) To create a new table. C) To enforce referential integrity. D) To store unique values. Show Answer Correct Answer: C) To enforce referential integrity. 41. What is the difference between a field and a column? A) A field is a type of database; a column is a type of table. B) A field is a horizontal set of data; a column is a vertical set of data. C) A field is a single data attribute; a column is a vertical set of fields in a table. D) A field is a collection of columns; a column is a single data attribute. Show Answer Correct Answer: C) A field is a single data attribute; a column is a vertical set of fields in a table. 42. What is the isolation property in transactions? A) All transactions must be the same. B) Transactions cannot be changed. C) Each transaction appears to execute alone. D) Transactions are executed together. Show Answer Correct Answer: C) Each transaction appears to execute alone. 43. How can a Database Administrator (DBA) ensure the security of student data using a DBMS? A) By using access rights to manage user actions. B) By storing data in unsecured locations. C) By implementing regular back-ups. D) By allowing unrestricted access to all users. Show Answer Correct Answer: A) By using access rights to manage user actions. 44. Which of the following is a characteristic of data? A) Data must be collected in real-time. B) Data is always processed. C) Data is irrelevant. D) Data is always qualitative. Show Answer Correct Answer: A) Data must be collected in real-time. 45. Which of the following is NOT a data type in a database? A) Algorithm. B) Memo. C) Auto number. D) Text. Show Answer Correct Answer: A) Algorithm. 46. Explain the role of a primary key in a database. A) The role of a primary key in a database is to uniquely identify each record and maintain data integrity. B) A primary key is optional and can be left blank in a database. C) A primary key allows duplicate records in a database. D) The primary key is used to store large amounts of data. Show Answer Correct Answer: A) The role of a primary key in a database is to uniquely identify each record and maintain data integrity. 47. Indicate whether the statement is true or false:In a database, a bit represents a single character, which can be a letter, a number, or another symbol. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 48. Which of the following is not a function of a database system? A) Managing user permissions. B) Storing data securely. C) Providing user interface design. D) Retrieving data efficiently. Show Answer Correct Answer: C) Providing user interface design. 49. What is the purpose of a report in MS Access? A) To edit table data. B) To display and print data in a structured format. C) To create new tables. D) To establish table relationships. Show Answer Correct Answer: B) To display and print data in a structured format. 50. Which of the following describes a many-to-many relationship? A) Multiple records in the first table relate to multiple records in the second table. B) Multiple records in the first table relate to one record in the second table. C) One record in the first table relates to one record in the second table. D) One record in the first table relates to multiple records in the second table. Show Answer Correct Answer: A) Multiple records in the first table relate to multiple records in the second table. 51. Why is it important to create an appropriate database structure? A) It is important to create an appropriate database structure to ensure data integrity, optimize performance, and facilitate efficient data retrieval. B) To make the database visually appealing. C) To reduce the size of the database files. D) To ensure all data is stored in a single table. Show Answer Correct Answer: A) It is important to create an appropriate database structure to ensure data integrity, optimize performance, and facilitate efficient data retrieval. 52. Describe the difference between a database and a data warehouse. A) A database is used for data backup, while a data warehouse is for data entry. B) A database is for real-time transactions, while a data warehouse is for analytical processing of historical data. C) A database stores only historical data, while a data warehouse handles real-time transactions. D) A database is a type of data warehouse that focuses on big data analysis. Show Answer Correct Answer: B) A database is for real-time transactions, while a data warehouse is for analytical processing of historical data. 53. Which of the following actions can be performed when modifying a table structure? A) Adding or deleting fields. B) Changing field definitions. C) Establishing a primary key. D) All of the above. Show Answer Correct Answer: D) All of the above. 54. What is the main function of update operations in a database? A) To retrieve data. B) To create new data. C) To modify existing data. D) To delete data. Show Answer Correct Answer: C) To modify existing data. 55. What is one advantage of using the database approach? A) Easier data sharing among multiple users. B) Higher costs for data management. C) Increased redundancy in data storage. D) Limited access to data. Show Answer Correct Answer: A) Easier data sharing among multiple users. 56. The collection of information that describes tables, attributes, constraints, indexes and other database objects is called: A) Shadow copy. B) Transaction file. C) Application log. D) Metadata (data dictionary / system catalog). Show Answer Correct Answer: D) Metadata (data dictionary / system catalog). 57. Which of the following is NOT a purpose of a DBMS in a business setting? A) To store information about social media users. B) To make better decisions. C) To improve business processes. D) To better serve customers. Show Answer Correct Answer: A) To store information about social media users. 58. Which ACID property ensures that once a transaction is committed, it will remain so even in the event of power loss or system failure? A) Isolation. B) Consistency. C) Atomicity. D) Durability. Show Answer Correct Answer: D) Durability. 59. In a database of students, which of the following could be a suitable primary key? A) Student ID number. B) Student name. C) Student's favorite subject. D) Student's birthdateTagsLO3. Show Answer Correct Answer: A) Student ID number. 60. What is the purpose of SQL in databases? A) To create databases. B) To retrieve information efficiently. C) To manage user access. D) To secure data. Show Answer Correct Answer: B) To retrieve information efficiently. ← 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