This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 9 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 9 (60 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) Data. C) Information. 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) Clientphone. C) Profit. 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 precompiled SQL code stored in a database that can be executed with parameters. C) Stored procedures are temporary tables used for data storage. D) Stored procedures are scripts that run on the client side for data retrieval. Show Answer Correct Answer: B) 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) Faster access to data. B) Easy data entry. C) No need for backup. D) More security features. Show Answer Correct Answer: A) Faster access to data. 7. Which of the following is a characteristic of a database? A) Data integrity. B) Data isolation. C) Data inconsistency. D) Data redundancy. Show Answer Correct Answer: A) 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) Network. B) Object-Oriented. C) Hierarchical. D) Relational. Show Answer Correct Answer: D) Relational. 12. 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;. 13. What is the purpose of the CREATE TABLE statement? A) To update records in a table. B) To delete an existing table from a database. C) To define a new table in a database. D) To retrieve data from a table. Show Answer Correct Answer: C) To define a new table in a database. 14. What is a primary function of the data dictionary in a DBMS? A) Creating user interfaces. B) Managing hardware resources. C) Storing definitions of data elements. D) Storing user passwords. Show Answer Correct Answer: C) Storing definitions of data elements. 15. Which one of the following is unshielded twisted pair cable connector? A) Straight-tip connector. B) RJ-45 connector. C) BNC connector. D) Subscriber channel connector. Show Answer Correct Answer: B) RJ-45 connector. 16. Differentiate between instances and schemas in a database. A) Instances represent the database design, while schemas hold the data. B) Schemas are the actual data, while instances define the structure. C) Schemas define the structure of the database, while instances are the actual data stored within that structure. D) Schemas are temporary data sets, while instances are permanent structures. Show Answer Correct Answer: C) Schemas define the structure of the database, while instances are the actual data stored within that structure. 17. 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. 18. Which one of the following refers to "data about data" ? A) Metadata. B) Directory. C) Warehouse. D) Subdata. Show Answer Correct Answer: A) Metadata. 19. ..... :Law protecting personal data of EU citizens. A) GDPR. B) CCPA. C) HIPAA. D) FERPA. Show Answer Correct Answer: A) GDPR. 20. What is data inconsistency? A) When data is stored multiple times in different files. B) When data is stored in separate linked tables. C) When data is stored in a single file. D) When data is not accurate or complete. Show Answer Correct Answer: D) When data is not accurate or complete. 21. 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) Entities share relationships with other entities. D) An entity type shares attributes with another entity type. Show Answer Correct Answer: A) Attributes of one entity are passed to another. 22. 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. 23. 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. 24. To which of the following the term "DBA" referred? A) Data Bank Administrator. B) Database Administrator. C) Data Administrator. D) None of the above. Show Answer Correct Answer: A) Data Bank Administrator. 25. What is the role of a database management system (DBMS)? A) A DBMS is used solely for data storage without any management features. B) The primary function of a DBMS is to create user interfaces for applications. C) A DBMS is designed to handle only large-scale data processing tasks. D) The role of a DBMS is to manage and organize data in databases, allowing for efficient data access, manipulation, and administration. Show Answer Correct Answer: D) The role of a DBMS is to manage and organize data in databases, allowing for efficient data access, manipulation, and administration. 26. In database management, what does a "shared lock" typically allow? A) Exclusive data modification. B) Reading data without updates. C) Permanent data storage. D) Complete data blocking. Show Answer Correct Answer: B) Reading data without updates. 27. Which one of the following is used to define the structure of the relation and relating schemas? A) DML(Data Manipulation Langauge). B) DDL(Data Definition Langauge). C) Relational Schema. D) Query. Show Answer Correct Answer: B) DDL(Data Definition Langauge). 28. Which of the following best describes the MPSD level of distribution? A) Multiple computers accessing a single data repository. B) Multiple computers each with their own local database. C) A single computer accessing multiple databases. D) Multiple processes on one computer accessing a single database. Show Answer Correct Answer: A) Multiple computers accessing a single data repository. 29. What does the SQL COUNT() function do? A) Counts all columns in a table. B) Counts the number of rows in a table or result set. C) Counts only numeric values. D) Counts characters in a string. Show Answer Correct Answer: B) Counts the number of rows in a table or result set. 30. If a company wants to provide database access to all its employees across different departments, which type of database should it implement? A) Workgroup database. B) File-based database. C) Enterprise database. D) Multiuser database for a single user. Show Answer Correct Answer: C) Enterprise database. 31. What is the main function of a primary key in a database? A) To uniquely identify a record. B) To store large amounts of data. C) To enforce data integrity. D) To link two tables. Show Answer Correct Answer: A) To uniquely identify a record. 32. What is one of the advantages of using a database management system (DBMS) according to the text? A) Increased complexity of data storage. B) Limited data accessibility. C) Control of data redundancy. D) Higher cost of data maintenance. Show Answer Correct Answer: C) Control of data redundancy. 33. Which one of the following is used to explain the objectives modern operating systems? A) To design algorithms. B) To use the computer resources efficiently. C) To make the computer environment less convenient to use. D) To provide a platform on which a user can design hardware. Show Answer Correct Answer: B) To use the computer resources efficiently. 34. Which of the following can add a row to a table? A) Update. B) Add. C) Alter. D) Insert. Show Answer Correct Answer: D) Insert. 35. Which one of the following commands is used for removing (or deleting) a relation forms the SQL database? A) Delete. B) Drop. C) Remove. D) All of the above. Show Answer Correct Answer: B) Drop. 36. Which combination of technologies is most suitable for developing a full-stack web application? A) HTML + CSS + Photoshop. B) Java + C++ + MongoDB. C) Python + Excel + Bootstrap. D) HTML + JavaScript + SQL + PHP. Show Answer Correct Answer: D) HTML + JavaScript + SQL + PHP. 37. The entity relationship set is represented in E-R diagram as A) Diamond. B) Undivided rectangles. C) Double diamonds. D) Dashed lines. Show Answer Correct Answer: A) Diamond. 38. What is the effect of the following SQL statement? DELETE FROM orders WHERE order ..... id = 1; A) Deletes all orders. B) Deletes the order with order id 1. C) Deletes orders with order id greater than 1. D) Deletes orders with order id less than 1. Show Answer Correct Answer: B) Deletes the order with order id 1. 39. What is a result of increased productivity in a DBMS? A) Decreased programmer productivity. B) Increased development time and cost. C) Reduced need for low-level file-handling routines. D) Higher cost of maintenance through data independence. Show Answer Correct Answer: C) Reduced need for low-level file-handling routines. 40. What is the function of a foreign key? A) To uniquely identify a record. B) To enforce data integrity. C) To link two tables together. D) To store metadata. Show Answer Correct Answer: C) To link two tables together. 41. What is a potential drawback of the complexity of a DBMS? A) Reduced need for database administrators. B) Improved performance for all users. C) Ease of understanding for end-users. D) Risk of bad design decisions. Show Answer Correct Answer: D) Risk of bad design decisions. 42. What is the output when the data '1678.95' is set to the number format '###0.00' in Access? A) 1670. B) 1678. C) 1670.95. D) 1678.95. Show Answer Correct Answer: D) 1678.95. 43. Netflix uses Cassandra because of its ability to handle which of the following? A) SQL queries. B) High-throughput. C) Web development. D) Low-cost storage. Show Answer Correct Answer: B) High-throughput. 44. A demonstration of an Agri-Information System typically includes: A) Database creation, data entry, and query-based analysis. B) Weather forecasting models only. C) Social media analytics. D) Satellite data visualization alone. Show Answer Correct Answer: A) Database creation, data entry, and query-based analysis. 45. Which of the following commands is used to save any transaction permanently into the database? A) Commit. B) Rollback. C) Savepoint. D) None of the above. Show Answer Correct Answer: A) Commit. 46. What is the logical structure of the database? A) Schema. B) Instance. C) Data Model. D) None of the above. Show Answer Correct Answer: A) Schema. 47. The term ..... is used to refer a row A) Field. B) Record. C) Primary key. D) Foreign key. Show Answer Correct Answer: B) Record. 48. Identify the major advantage of horizontal fragmentation in distributed databases? A) Enhanced data security. B) Increased data availability. C) Improved query performance. D) Reduced network traffic. Show Answer Correct Answer: D) Reduced network traffic. 49. What is an example of an application of DBMS? A) Online shopping B) Cooking Dishes C) Painting Art D) Gardening Tips A) G) Video streaming. B) F) Social media. C) E) Online banking. D) A) Online shopping. Show Answer Correct Answer: D) A) Online shopping. 50. What is defined by the WWW Consortium (W3C) and was originally intended as a document markup language? A) XML. B) JSON. C) HTML. D) None of the above. Show Answer Correct Answer: A) XML. 51. In any programming paradigms, the primary function that every programing must have is: A) Void(). B) User defined(). C) Main(). D) Define(). Show Answer Correct Answer: C) Main(). 52. What is the function of a database management system? A) To create and design websites. B) To perform complex mathematical calculations. C) To manage user interface elements. D) The function of a database management system is to facilitate the storage, retrieval, and management of data in databases. Show Answer Correct Answer: D) The function of a database management system is to facilitate the storage, retrieval, and management of data in databases. 53. Which of the following is a feature of a NoSQL database? A) Support for unstructured data. B) ACID transactions. C) Table-based structure. D) Fixed schema. Show Answer Correct Answer: A) Support for unstructured data. 54. What is a transaction in the context of a DBMS? A) A method of data storage. B) A collection of operations treated as a single unit. C) A type of data model. D) A user access level. Show Answer Correct Answer: B) A collection of operations treated as a single unit. 55. Identify the query that deletes all tuples in the instructor relation for those instructors associated with a department located in the Watson building which is in department relation? A) DELETE FROM instructor WHERE dept name IN 'Watson';. B) DELETE FROM department WHERE building='Watson';. C) DELETE FROM instructor WHERE dept name IN (SELECT dept name FROM department WHERE building = 'Watson');. D) None. Show Answer Correct Answer: C) DELETE FROM instructor WHERE dept name IN (SELECT dept name FROM department WHERE building = 'Watson');. 56. Which of the following correctly represents the basic syntax structure of the INSERT INTO command? A) INSERT INTO [table name] ([column1], [column2] ) VALUES ([value1], [value2] ). B) INSERT INTO [table name] VALUES ([value1], [value2] ). C) DELETE FROM [table name] WHERE [condition]. D) UPDATE [table name] SET [column1]=[value1], [column2]=[value2] . Show Answer Correct Answer: A) INSERT INTO [table name] ([column1], [column2] ) VALUES ([value1], [value2] ). 57. What is the purpose of SQL in a DBMS? A) To visualize data through graphical interfaces. B) The purpose of SQL in a DBMS is to manage and manipulate relational databases. C) To store data in a non-relational format. D) To create and design new databases. Show Answer Correct Answer: B) The purpose of SQL in a DBMS is to manage and manipulate relational databases. 58. Text, Integer, Currency, Boolean and Date/Time are all examples of ..... A) Filters. B) Validations. C) Sorts. D) Data Types. Show Answer Correct Answer: D) Data Types. 59. Atomicity:All operations in a transaction occur or ..... A) None occur. B) Some occur. C) All fail. D) Partially occur. Show Answer Correct Answer: A) None occur. 60. Define an entity in the context of the ER Model. A) An entity is a distinct object or thing in the real world that can be identified and has attributes. B) An entity is a type of relationship between two objects. C) An entity is a collection of attributes without any identifiable object. D) An entity is a process that describes how data is manipulated. Show Answer Correct Answer: A) An entity is a distinct object or thing in the real world that can be identified and has attributes. ← PreviousNext →Related QuizzesScience QuizzesClass 12 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 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books