This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 21 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 21 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The key word used for displaying unique values from the column A) Unique. B) Distinct. C) All. D) From. Show Answer Correct Answer: B) Distinct. 2. The word ..... indicates that the facts have not yet been processed to reveal their meaning. A) Raw. B) Information. C) Data. D) Dictionary. Show Answer Correct Answer: A) Raw. 3. Which of the following statements about DBMS security is TRUE? A) DBMS cannot restrict user access to data. B) DBMS allows for user authentication and access control. C) DBMS automatically encrypts all data by default. D) DBMS does not support data backup. Show Answer Correct Answer: B) DBMS allows for user authentication and access control. 4. Identify the Foreign Key from table "Sales" Table Client:ClientID (primary Key) clientname clientphone Table:Sales SalesID (Primary Key) ClientID Profit A) SalesID. B) Profit. C) Clientphone. D) ClientID. Show Answer Correct Answer: D) ClientID. 5. What are stored procedures and how do they work? A) Stored procedures are user-defined functions that return values. B) Stored procedures are temporary tables used for data storage. C) Stored procedures are scripts that run on the client side for data retrieval. D) Stored procedures are precompiled SQL code stored in a database that can be executed with parameters. Show Answer Correct Answer: D) Stored procedures are precompiled SQL code stored in a database that can be executed with parameters. 6. What is the main advantage of a DBMS over a file system? A) Easy data entry. B) More security features. C) No need for backup. D) Faster access to data. Show Answer Correct Answer: D) Faster access to data. 7. Which of the following is a characteristic of a database? A) Data redundancy. B) Data inconsistency. C) Data integrity. D) Data isolation. Show Answer Correct Answer: C) Data integrity. 8. What is SQL and how is it used in databases? A) SQL is a programming language used to manage and manipulate relational databases. B) SQL is a type of database software. C) SQL is used for creating web applications. D) SQL is a markup language for designing web pages. Show Answer Correct Answer: A) SQL is a programming language used to manage and manipulate relational databases. 9. How does a DBMS ensure data integrity? A) By using constraints and rules to enforce data accuracy and consistency. B) By regularly deleting old data. C) By randomly changing the data values. D) By allowing unrestricted access to all users. Show Answer Correct Answer: A) By using constraints and rules to enforce data accuracy and consistency. 10. Which department is responsible for maintaining the accuracy of patient records in a hospital? A) Health Information Management. B) Human Resources. C) Technical Support. D) Finance. Show Answer Correct Answer: A) Health Information Management. 11. What type of database uses tables to store data? A) Hierarchical. B) Network. C) Relational. D) Object-Oriented. Show Answer Correct Answer: C) Relational. 12. Which of the following is NOT an example of a database? A) Telephone book. B) Real estate listing. C) Online library catalog. D) DVD. Show Answer Correct Answer: D) DVD. 13. In a relational database, what is a 'table'? A) A collection of data organised in rows and columns. B) A single piece of data. C) A graphical representation of data. D) A software application. Show Answer Correct Answer: A) A collection of data organised in rows and columns. 14. Write a basic SQL query to select all records from a table named 'Students'. A) SELECT ALL FROM Students;. B) GET * FROM Students;. C) SELECT Students;. D) SELECT * FROM Students;. Show Answer Correct Answer: D) SELECT * FROM Students;. 15. What is the purpose of the CREATE TABLE statement? A) To delete an existing table from a database. B) To define a new table in a database. C) To update records in a table. D) To retrieve data from a table. Show Answer Correct Answer: B) To define a new table in a database. 16. What is a primary function of the data dictionary in a DBMS? A) Creating user interfaces. B) Storing user passwords. C) Managing hardware resources. D) Storing definitions of data elements. Show Answer Correct Answer: D) Storing definitions of data elements. 17. Which one of the following is unshielded twisted pair cable connector? A) BNC connector. B) Subscriber channel connector. C) RJ-45 connector. D) Straight-tip connector. Show Answer Correct Answer: C) RJ-45 connector. 18. Differentiate between instances and schemas in a database. A) Schemas are the actual data, while instances define the structure. B) Schemas define the structure of the database, while instances are the actual data stored within that structure. C) Instances represent the database design, while schemas hold the data. D) Schemas are temporary data sets, while instances are permanent structures. Show Answer Correct Answer: B) Schemas define the structure of the database, while instances are the actual data stored within that structure. 19. What is the first normal form in database normalization? A) A table is in first normal form (1NF) if it has no primary key. B) A table is in first normal form (1NF) if it allows duplicate records. C) A table is in first normal form (1NF) if it contains nested values. D) A table is in first normal form (1NF) if it contains only atomic values and each record is unique. Show Answer Correct Answer: D) A table is in first normal form (1NF) if it contains only atomic values and each record is unique. 20. Which one of the following refers to "data about data" ? A) Directory. B) Subdata. C) Warehouse. D) Metadata. Show Answer Correct Answer: D) Metadata. 21. ..... :Law protecting personal data of EU citizens. A) GDPR. B) HIPAA. C) FERPA. D) CCPA. Show Answer Correct Answer: A) GDPR. 22. What is data inconsistency? A) When data is stored in separate linked tables. B) When data is stored multiple times in different files. C) When data is not accurate or complete. D) When data is stored in a single file. Show Answer Correct Answer: C) When data is not accurate or complete. 23. What does the term 'inheritance' mean in an ER model? A) Attributes of one entity are passed to another. B) One entity is related to another. C) An entity type shares attributes with another entity type. D) Entities share relationships with other entities. Show Answer Correct Answer: A) Attributes of one entity are passed to another. 24. Which is the best normalized design for a restaurant ordering system? A) One table with Orders, Customers, and Products. B) Separate tables for Customers, Orders, and Products with relationships. C) Merge Customers and Orders into one table. D) Store Product data inside Orders. Show Answer Correct Answer: B) Separate tables for Customers, Orders, and Products with relationships. 25. What does query optimization involve? A) Using only local data for all queries. B) Limiting the number of nodes involved in a query. C) Decomposing the query into structured steps. D) Creating a single query for all nodes. Show Answer Correct Answer: C) Decomposing the query into structured steps. ← 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