This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 51 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 51 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which component is NOT typically part of an information system? A) People. B) Processes. C) Hardware. D) Mathematical equations. Show Answer Correct Answer: D) Mathematical equations. 2. Which function in MS Access can be used to calculate the total fertilizer used for all farms? A) COUNT(). B) AVG(). C) SUM(). D) MAX(). Show Answer Correct Answer: C) SUM(). 3. All of the following are advantages of packaged data models EXCEPT: A) Packaged data models can be built using proven components evolved from cumulative experiences. B) Projects take less time and cost less. C) The data model is easier to evolve. D) More one-to-one relationships give the data model more flexibility. Show Answer Correct Answer: D) More one-to-one relationships give the data model more flexibility. 4. What is a key difference between a spreadsheet and a database management system? A) A spreadsheet is a multi-file system, while a DBMS is a single file. B) A spreadsheet is less complex than a DBMS. C) A spreadsheet has controlled data redundancy, while a DBMS has uncontrolled redundancy. D) DBMS provides controlled access and integrity, while a spreadsheet often suffers from data redundancy and inconsistency. Show Answer Correct Answer: D) DBMS provides controlled access and integrity, while a spreadsheet often suffers from data redundancy and inconsistency. 5. The basic data type char(n) is a ..... length character string and varchar(n) is ..... length character. A) Fixed, equal. B) Equal, variable. C) Fixed, variable. D) Variable, equal. Show Answer Correct Answer: C) Fixed, variable. 6. Which of the following uses Oracle Database for managing inventory and transactional data? A) Reddit. B) Walmart. C) Pinterest. D) Stack Overflow. Show Answer Correct Answer: B) Walmart. 7. What is the main characteristic of a distributed database? A) Data is located at a single site. B) Data is distributed across several sites. C) Data is stored in tables only. D) Data is only accessible offline. Show Answer Correct Answer: B) Data is distributed across several sites. 8. How does a DBMS improve data integrity? A) By storing data in separate linked tables. B) By validating the data entry. C) By compressing the data. D) By encrypting the data. Show Answer Correct Answer: B) By validating the data entry. 9. What SQL clause is used to restrict the rows returned by a query depending on validity of two conditions simultaneously? A) AND. B) WHERE. C) HAVING. D) FROM. Show Answer Correct Answer: A) AND. 10. What are the advantages of using a cloud-based DBMS? A) Limited storage capacity. B) High maintenance costs. C) Advantages of using a cloud-based DBMS include scalability, cost-effectiveness, accessibility, automatic updates, and enhanced security. D) Inaccessible from remote locations. Show Answer Correct Answer: C) Advantages of using a cloud-based DBMS include scalability, cost-effectiveness, accessibility, automatic updates, and enhanced security. 11. In-memory databases are less secure than disk-based databases. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 12. What is a limitation of manual file handling? A) High efficiency. B) Data redundancy. C) Low labor requirement. D) Easy access. Show Answer Correct Answer: B) Data redundancy. 13. What includes a number of external schemas or user views? A) Internal or Physical level. B) Conceptual or Logical level. C) External or View level. D) None of the above. Show Answer Correct Answer: C) External or View level. 14. What is a logical schema in a DBMS? A) The structure that defines how data is organized and related. B) The actual data stored in the database. C) A programming interface for the database. D) A query used to retrieve data. Show Answer Correct Answer: A) The structure that defines how data is organized and related. 15. Which of the following best describes the structure of a database? A) A list of web pages. B) A collection of images and videos. C) Tables with rows and columns storing data. D) A book with chapters and sections. Show Answer Correct Answer: C) Tables with rows and columns storing data. 16. What does the HAVING clause do in SQL? A) It sorts the result set in descending order. B) It retrieves unique values from a column in a table. C) It filters records after aggregation has been performed. D) It joins two or more tables together. Show Answer Correct Answer: C) It filters records after aggregation has been performed. 17. Which validation rule allows exactly digits for number fields in Access? A) Is Null or Between 100000 and 99999. B) Is Null or Like "????". C) Is Null or >= 0 AND< = 99999. D) Is Null or < = 99999. Show Answer Correct Answer: C) Is Null or >= 0 AND< = 99999. 18. What is the primary function of the 'SQL' tab in phpMyAdmin as described in the image? A) To import data from SQL files. B) To manipulate records in database tables using SQL queries. C) To modify the phpMyAdmin user interface. D) To export data to CSV files. Show Answer Correct Answer: B) To manipulate records in database tables using SQL queries. 19. Select from the following the multi-valued attribute. A) Date of birth. B) Name. C) Phone number. D) All of the mentioned. Show Answer Correct Answer: C) Phone number. 20. Which of the following objects is considered the basic building block of a relational database? A) Form. B) Query. C) Table. D) Report. Show Answer Correct Answer: C) Table. 21. What is the Super key? A) A superkey is a group of single or multiple keys which identifies rows in a table. B) A super key may have additional attributes that are not needed for unique identification. C) Both A and B. D) None of the above. Show Answer Correct Answer: C) Both A and B. 22. What is the function of the DROP command in SQL? A) To delete a table or database. B) To add new data. C) To update existing data. D) To select specific data. Show Answer Correct Answer: A) To delete a table or database. 23. Database management systems, operating systems, applications and utilities are all examples of ..... A) Software. B) Hardware. C) Computer infrastructure. D) Input and output. Show Answer Correct Answer: A) Software. 24. Which one of the following programing models is the most recent concept that used to write dynamic program? A) Object oriented programming. B) Imperative programing. C) Functional programing. D) Logic programming. Show Answer Correct Answer: A) Object oriented programming. 25. In a 1:N relationship, how is it represented in a relational schema? A) By placing the primary key of the parent in the child table. B) By creating a separate table for each entity. C) By using a composite key. D) By merging both tables into one. Show Answer Correct Answer: A) By placing the primary key of the parent in the child table. ← PreviousNext →Related QuizzesClass 12 Computer Science Chapter 3 Database Management Systems Quiz 1Class 12 Computer Science Chapter 3 Database Management Systems Quiz 2Class 12 Computer Science Chapter 3 Database Management Systems Quiz 3Class 12 Computer Science Chapter 3 Database Management Systems Quiz 4Class 12 Computer Science Chapter 3 Database Management Systems Quiz 5Class 12 Computer Science Chapter 3 Database Management Systems Quiz 6Class 12 Computer Science Chapter 3 Database Management Systems Quiz 7Class 12 Computer Science Chapter 3 Database Management Systems Quiz 8Class 12 Computer Science Chapter 3 Database Management Systems Quiz 9Class 12 Computer Science Chapter 3 Database Management Systems Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books