This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 24 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 24 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What does the CASE statement allow you to do? A) Create new databases. B) Define new data types. C) Delete records from a table. D) Perform multiple actions based on conditions. Show Answer Correct Answer: D) Perform multiple actions based on conditions. 2. Which file system problem makes it difficult to generate ad-hoc reports? A) Data redundancy. B) Security problems. C) Difficulty in accessing data. D) Atomicity problems. Show Answer Correct Answer: C) Difficulty in accessing data. 3. Which of the following is NOT an example of a Primary Key? A) Customer number. B) Order number. C) Member ID. D) Product Name. Show Answer Correct Answer: D) Product Name. 4. Database that supports data located at a single site. A) Centralized Database System. B) Distributed Database System. C) Centered Database System. D) Distribution Database System. Show Answer Correct Answer: A) Centralized Database System. 5. Which SQL command is used to change a column's data type? A) UPDATE. B) MODIFY. C) ALTER. D) CHANGE. Show Answer Correct Answer: C) ALTER. 6. The number of rows in a relation A) Degree. B) Tuple. C) Cardinality. D) Domain. Show Answer Correct Answer: C) Cardinality. 7. User Interface A) The part of a database system that allows users to interact with the database. B) A tool for managing database backups. C) A programming language used for database queries. D) The hardware component of a database server. Show Answer Correct Answer: A) The part of a database system that allows users to interact with the database. 8. Which of the following statements contains an error? A) SELECT * FROM emp WHERE empid = 493945;. B) SELECT empid FROM emp WHERE empid= 493945;. C) SELECT empid FROM emp;. D) SELECT empid WHERE empid = 56949 AND lastname = 'SMITH';. Show Answer Correct Answer: D) SELECT empid WHERE empid = 56949 AND lastname = 'SMITH';. 9. Section B:Multiple Choice (5 marks)-Circle or write the correct letter (A, B, C, or D). Which of the following is an advantage of a database? A) It increases data errors. B) It allows easy searching and sorting of information. C) It makes data harder to access. D) It cannot be shared among users. Show Answer Correct Answer: B) It allows easy searching and sorting of information. 10. A database system mainly helps to reduce ..... A) Performance. B) Accuracy. C) Data redundancy. D) Storage. Show Answer Correct Answer: C) Data redundancy. 11. In SQL Developer, what is the role of the "Commit" button? A) Delete changes made. B) Display all tables. C) Permanently save the changes made to the database. D) Cancel the script execution. Show Answer Correct Answer: C) Permanently save the changes made to the database. 12. In SQL, Which of the following is a Data Manipulation Language(DML) command? A) Create. B) Alter. C) Merge. D) Drop. Show Answer Correct Answer: C) Merge. 13. What is the role of queries in a database? A) To create tables. B) To ask questions about data. C) To automate tasks. D) To present data. Show Answer Correct Answer: B) To ask questions about data. 14. We need database for ..... A) Accessing data and information . B) Processing the data as needed. C) Updating existing data. D) All of the above. Show Answer Correct Answer: D) All of the above. 15. Which data type would be most appropriate for storing a person's age? A) String. B) Integer. C) Boolean. D) FloatTagsDOK Level 2:Skill/Concept. Show Answer Correct Answer: B) Integer. 16. Which model organizes data using parent-child relationships? A) Hierarchical model. B) Network model. C) Relational model. D) Object model. Show Answer Correct Answer: A) Hierarchical model. 17. A subscription table needs to uniquely identify each record using two attributes together:subID is missing, but startDate and endDate exist. What type of key would use startDate and endDate together to ensure uniqueness? A) Composite primary key. B) Secondary lookup key. C) Foreign reference key. D) Surrogate alternate key. Show Answer Correct Answer: A) Composite primary key. 18. An attribute or the smallest set of attributes in a table where no tuple has the same value. A) Primary key. B) Foreign key. C) Candidate key. D) Composite key. Show Answer Correct Answer: C) Candidate key. 19. Which of the following statements about flowcharting is TRUE? A) A flowchart is a program. B) A flowchart is the only step in programming. C) Flowcharts are helpful in detecting errors. D) Flowcharts are limited to certain programming languages. Show Answer Correct Answer: C) Flowcharts are helpful in detecting errors. 20. What is the relationship where a single row in one table relates to many entries in the other? A) One-to-many. B) None of the above. C) One-to-one. D) Many-to-many. Show Answer Correct Answer: A) One-to-many. 21. What is a key difference between anonymous blocks and stored procedures? A) Anonymous blocks accept parameters. B) Stored procedures cannot use variables. C) Stored procedures are named and stored in the database. D) Anonymous blocks can be reused outside of Oracle. Show Answer Correct Answer: C) Stored procedures are named and stored in the database. 22. What are the common data types used in MySQL? A) BOOLEAN, ENUM, SET, JSON, SMALLINT. B) Common data types in MySQL include INT, VARCHAR, TEXT, DATE, and DATETIME. C) FLOAT, CHAR, BLOB, TIME, TIMESTAMP. D) DOUBLE, MEDIUMINT, TINYTEXT, YEAR, CLOB. Show Answer Correct Answer: B) Common data types in MySQL include INT, VARCHAR, TEXT, DATE, and DATETIME. 23. What is the main goal of a database system? A) To limit user access to data. B) To ensure data is always redundant. C) To create complex data structures. D) To provide a way to store and retrieve database information conveniently and efficiently. Show Answer Correct Answer: D) To provide a way to store and retrieve database information conveniently and efficiently. 24. Which is an example of DBMS (Database Management System)? A) Oracle. B) MS PowerPoint. C) MS Word. D) MS Excel. Show Answer Correct Answer: A) Oracle. 25. What is a Foreign Key in a database? A) A reference to a primary key in another table. B) A key that is used for accessing the database remotely. C) A key that is used for database backups. D) A key that is used for database optimization. Show Answer Correct Answer: A) A reference to a primary key in another table. ← 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