This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 69 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 69 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the default port number for PostgreSQL? A) 1433. B) 3306. C) 5432. D) 1521. Show Answer Correct Answer: C) 5432. 2. What is the purpose of a business database? A) To store and manage customer and product information. B) To create video games. C) To perform calculations. D) To write stories. Show Answer Correct Answer: A) To store and manage customer and product information. 3. List the four main types of SQL commands. A) DQL, DDL, DML, DCL. B) DQL, DDL, RML, DCL. C) SQL, DQL, DML, DCL. D) DML, DCL, DDL, RCL. Show Answer Correct Answer: A) DQL, DDL, DML, DCL. 4. With reduced redundancy ..... automatically increases. A) Duplication. B) Consistency. C) Characters. D) AutoNumber. Show Answer Correct Answer: B) Consistency. 5. Which of the following is NOT a type of database model? A) Relational Model. B) Hierarchical Model. C) Network Model. D) Graphical Model. Show Answer Correct Answer: D) Graphical Model. 6. All candidate keys are primary keys. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 7. To check for a value outside of a range, you can use A) NOT RANGE operator. B) NOT LIKE operator. C) NOT BETWEEN operator. D) None of these. Show Answer Correct Answer: C) NOT BETWEEN operator. 8. Which of the following is a grouping of characters into a word, a group of words, or a complete number? A) File. B) Table. C) Entity. D) Field. Show Answer Correct Answer: D) Field. 9. What is data integrity in the context of databases? A) Data integrity refers to the speed of data retrieval. B) Data integrity is the amount of data stored in a database. C) Data integrity is the accuracy and consistency of data in a database. D) Data integrity is the process of backing up data regularly. Show Answer Correct Answer: C) Data integrity is the accuracy and consistency of data in a database. 10. Which entity has a unique identifier? A) Weak Entity. B) Strong Entity. C) Both. D) None. Show Answer Correct Answer: B) Strong Entity. 11. Which of the following is a valid example of a relation? A) A table named Employees with columns ID, Name, and Salary. B) A single row from a table. C) The allowed range of values for the Salary column. D) The ID field in a form. Show Answer Correct Answer: A) A table named Employees with columns ID, Name, and Salary. 12. Which of the following is NOT a purpose of a DBMS? A) To store information about classes. B) To store information about social media users. C) To store information about teachers. D) To store information about students. Show Answer Correct Answer: B) To store information about social media users. 13. What is the main purpose of creating an index in a database? A) To store data. B) To link two database files. C) To help find specific records and sort them faster. D) To convert text to machine code. Show Answer Correct Answer: C) To help find specific records and sort them faster. 14. In Datasheet View, to insert a new field, what action should be taken? A) Use Insert Row in Form View. B) Type in any cell directly. C) Double-click on "Add New Field". D) Press Ctrl + N. Show Answer Correct Answer: C) Double-click on "Add New Field". 15. What is the purpose of a primary key in a relational database? A) To establish relationships between tables. B) To ensure data uniqueness within a table. C) To index data for faster retrieval. D) To enforce data integrity constraints. Show Answer Correct Answer: B) To ensure data uniqueness within a table. 16. Which model is used in MySQL? A) Network Model. B) Hierarchical Model. C) Relational Model. D) None of the above. Show Answer Correct Answer: C) Relational Model. 17. Which DBMS is best for structured data with relations? A) Relational DBMS. B) NoSQL DBMS. C) Object-oriented DBMS. D) Graph DBMS. Show Answer Correct Answer: A) Relational DBMS. 18. The external level of data abstraction provides: A) Details on file structures. B) A simplified user view of the data. C) System architecture information. D) Programming code. Show Answer Correct Answer: B) A simplified user view of the data. 19. Which data model is most commonly used in current database systems? A) Network. B) Object-oriented. C) Hierarchical. D) Relational. Show Answer Correct Answer: D) Relational. 20. What can a query instantly generate if a database has people stored on one table and phone numbers on another? A) A list of addresses. B) A directory of each person's phone number. C) A list of emails. D) A list of job titles. Show Answer Correct Answer: B) A directory of each person's phone number. 21. What is the purpose of validation in a computerised system? A) To ensure the data entered is accurate. B) To ensure the data entered is sensible and reasonable. C) To correct any errors in the data entered. D) To check the speed of data entry. Show Answer Correct Answer: B) To ensure the data entered is sensible and reasonable. 22. Indicate whether the statement is true or false:Middleware is an application that transfers information from an organization's internal database to a web server for delivery to a user as part of a web page. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 23. Data type used for telephone numbers A) Text. B) Number. C) Date/Time. D) Yes/No. E) Currency. Show Answer Correct Answer: A) Text. 24. What is a major limitation of a file-based approach to data storage? A) Data redundancy and inconsistency. B) Faster data retrieval. C) Improved data security. D) Easier relationship management. Show Answer Correct Answer: A) Data redundancy and inconsistency. 25. A candidate key that is an alternative to the primary key. A) Primary key. B) Secondary key. C) Foreign key. D) Composite key. Show Answer Correct Answer: B) Secondary key. ← 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