{"id":25605,"date":"2022-10-20T19:43:23","date_gmt":"2022-10-20T14:13:23","guid":{"rendered":"https:\/\/scholarsclasses.com\/blog\/?p=25605"},"modified":"2025-12-26T12:42:38","modified_gmt":"2025-12-26T07:12:38","slug":"11th-commerce-it-chapter-2-exercise","status":"publish","type":"post","link":"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-2-exercise\/","title":{"rendered":"11th Commerce IT Chapter 2 Exercise (Introduction to DBMS) | Maharashtra Board (Free Solution)"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69dcb25fb6e6f\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69dcb25fb6e6f\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-2-exercise\/#11th_Commerce_IT_Chapter_2_Exercise\" >11th Commerce IT Chapter 2 Exercise<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-2-exercise\/#Chapter_2_%E2%80%93_Introduction_to_DBMS\" >Chapter 2 &#8211; Introduction to DBMS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-2-exercise\/#Q_1_Complete_the_following_activity\" >Q 1. Complete the following activity<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-2-exercise\/#Q_2_Observe_the_field_names_of_a_database_given_below_in_Column_A_related_to_Bus_reservation_Write_suitable_data_types_for_each_field_in_front_of_the_respective_field_in_Column_B\" >Q 2. Observe the field names of a database given below in Column A related to Bus reservation. Write suitable data types for each field in front of the respective field in Column B<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-2-exercise\/#Q_3_Write_the_use_of_following_SQL_command\" >Q 3. Write the use of following SQL command.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-2-exercise\/#Q_4_Create_a_table_for_the_information_given_below_by_choosing_appropriate_data_types_Specify_the_proper_primary_key_for_table_1_Movie_2_Actor\" >Q 4. Create a table for the information given below by choosing appropriate data types. Specify the proper primary key for table 1) Movie 2) Actor<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-2-exercise\/#Q_5_Consider_the_following_table_Stationary_Write_SQL_commands_for_following_statements\" >Q 5. Consider the following table Stationary. Write SQL commands for following statements.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-2-exercise\/#Q6_Answer_the_following_questions\" >Q.6 Answer the following questions.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-2-exercise\/#Q7_In_a_company_the_data_is_stored_in_a_table_under_the_following_fields_Employee_number_Last_name_Date_of_birth_and_address_Which_data_type_will_you_use_for_the_above_field\" >Q.7 In a company the data is stored in a table under the following fields Employee number, Last name, Date of birth, and address. Which data type will you use for the above field?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-2-exercise\/#Q8_Multiple_Choice_Question_3_correct_answers\" >Q.8 Multiple Choice Question. (3 correct answers)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-2-exercise\/#Q9_Complete_the_following\" >Q.9 Complete the following<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-2-exercise\/#11th_Commerce_IT_Textbook_Solutions\" >11th Commerce IT Textbook Solutions<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading has-text-align-center\"><span class=\"ez-toc-section\" id=\"11th_Commerce_IT_Chapter_2_Exercise\"><\/span>11th Commerce IT Chapter 2 Exercise<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"576\" data-src=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/11th-Commerce-IT-Chapter-2-Exercise-1024x576.webp\" alt=\"11th-Commerce-IT-Chapter-2-Exercise\" class=\"wp-image-25683 lazyload\" title=\"\" data-srcset=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/11th-Commerce-IT-Chapter-2-Exercise-1024x576.webp 1024w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/11th-Commerce-IT-Chapter-2-Exercise-300x169.webp 300w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/11th-Commerce-IT-Chapter-2-Exercise-768x432.webp 768w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/11th-Commerce-IT-Chapter-2-Exercise-1536x864.webp 1536w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/11th-Commerce-IT-Chapter-2-Exercise.webp 1920w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/576;\" \/><figcaption class=\"wp-element-caption\">11th Commerce IT Chapter 2 Exercise<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center\"><span class=\"ez-toc-section\" id=\"Chapter_2_%E2%80%93_Introduction_to_DBMS\"><\/span>Chapter 2 &#8211; Introduction to DBMS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Q_1_Complete_the_following_activity\"><\/span>Q 1. Complete the following activity<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Tick whichever box is not valid.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"390\" height=\"273\" data-src=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/01.1_result-1.webp\" alt=\"\" class=\"wp-image-25672 lazyload\" title=\"\" data-srcset=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/01.1_result-1.webp 390w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/01.1_result-1-300x210.webp 300w\" data-sizes=\"(max-width: 390px) 100vw, 390px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 390px; --smush-placeholder-aspect-ratio: 390\/273;\" \/><\/figure>\n\n\n\n<p><strong>Answer:<\/strong> Graphic<\/p>\n\n\n\n<p>2. Student wants to create a field pincode in a table, which data type he will choose ?<\/p>\n\n\n\n<p><strong>Answer:<\/strong> Int<\/p>\n\n\n\n<p>3. Tick the appropriate box<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"392\" height=\"156\" data-src=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/01.3_result-1.webp\" alt=\"\" class=\"wp-image-25673 lazyload\" title=\"\" data-srcset=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/01.3_result-1.webp 392w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/01.3_result-1-300x119.webp 300w\" data-sizes=\"(max-width: 392px) 100vw, 392px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 392px; --smush-placeholder-aspect-ratio: 392\/156;\" \/><\/figure>\n\n\n\n<p><strong>Answer:<\/strong> Uniquely identifies a record<\/p>\n\n\n\n<p><strong>4)<\/strong> Tick the appropriate circle<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" width=\"404\" height=\"231\" data-src=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/01.4_result-3.webp\" alt=\"\" class=\"wp-image-25675 lazyload\" style=\"--smush-placeholder-width: 404px; --smush-placeholder-aspect-ratio: 404\/231;width:399px;height:228px\" title=\"\" data-srcset=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/01.4_result-3.webp 404w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/01.4_result-3-300x172.webp 300w\" data-sizes=\"(max-width: 404px) 100vw, 404px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" \/><\/figure>\n\n\n\n<p><strong>Answer:<\/strong> One or Many Tables<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Q_2_Observe_the_field_names_of_a_database_given_below_in_Column_A_related_to_Bus_reservation_Write_suitable_data_types_for_each_field_in_front_of_the_respective_field_in_Column_B\"><\/span>Q 2. Observe the field names of a database given below in Column A related to Bus reservation. Write suitable data types for each field in front of the respective field in Column B<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><thead><tr><th>Column A (Field Name)<\/th><th>Column B (Data Type)<\/th><\/tr><\/thead><tbody><tr><td>Passenger Name<\/td><td><\/td><\/tr><tr><td>Age<\/td><td><\/td><\/tr><tr><td>Gender<\/td><td><\/td><\/tr><tr><td>Name<\/td><td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Answer:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><thead><tr><th>Column A (Field Name)<\/th><th>Column B (Data Type)<\/th><\/tr><\/thead><tbody><tr><td>Passenger Name<\/td><td>Varchar<\/td><\/tr><tr><td>Age<\/td><td>Int<\/td><\/tr><tr><td>Gender<\/td><td>Char<\/td><\/tr><tr><td>Name<\/td><td>Int<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Q_3_Write_the_use_of_following_SQL_command\"><\/span>Q 3. Write the use of following SQL command.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"396\" height=\"260\" data-src=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/03_result.webp\" alt=\"\" class=\"wp-image-25676 lazyload\" title=\"\" data-srcset=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/03_result.webp 396w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/03_result-300x197.webp 300w\" data-sizes=\"(max-width: 396px) 100vw, 396px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 396px; --smush-placeholder-aspect-ratio: 396\/260;\" \/><\/figure>\n\n\n\n<p><strong>Answer:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>INSERT &#8211; Insert data into table<\/li>\n\n\n\n<li>UPDATE &#8211; Update data into table<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-center\"><strong><a href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-notes-maharashtra-board\/\" data-type=\"URL\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-notes-maharashtra-board\/\" target=\"_blank\" rel=\"noreferrer noopener\">Solution of other subjects<\/a><br><a href=\"https:\/\/scholarsclasses.com\/blog\/11th-it-textbook-solutions-maharashtra-board-free-solution\/\" data-type=\"URL\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-it-textbook-solutions-maharashtra-board-free-solution\/\">Solution of all the chapters of IT<br><\/a> <a href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-1-exercise\/\" data-type=\"URL\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-1-exercise\">1<\/a> &#8211; <a href=\"https:\/\/scholarsclasses.com\/blog\/11th-it-chapter-3-exercise\/\" data-type=\"URL\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-it-chapter-3-exercise\/\">3<\/a> &#8211; <a href=\"https:\/\/scholarsclasses.com\/blog\/11th-it-chapter-4-exercise\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-it-chapter-4-exercise\/\">4<\/a><\/strong><\/p>\n\n\n\n<p><strong>Free <a href=\"https:\/\/youtube.com\/playlist?list=PLGiOLU46prNe6tQIJakepd3uGvatQyBUe\" data-type=\"link\" data-id=\"https:\/\/youtube.com\/playlist?list=PLGiOLU46prNe6tQIJakepd3uGvatQyBUe\" target=\"_blank\" rel=\"noopener\">online<\/a> lecture on the above topic<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Q_4_Create_a_table_for_the_information_given_below_by_choosing_appropriate_data_types_Specify_the_proper_primary_key_for_table_1_Movie_2_Actor\"><\/span>Q 4. Create a table for the information given below by choosing appropriate data types. Specify the proper primary key for table 1) Movie 2) Actor<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>1. Movie ( Registeration_no, movie_name, Realease_Date)<\/strong><\/p>\n\n\n\n<p><strong>Answer:<\/strong><\/p>\n\n\n\n<p>CREATE TABLE Movie (Registeration_no int(20) PRIMARY KEY, movie_name VARCHAR(20), Realease_Date DATE);<\/p>\n\n\n\n<p><strong>2. Actor ( actor_id, Actor_name, birth_date )<\/strong><\/p>\n\n\n\n<p><strong>Answer:<\/strong><\/p>\n\n\n\n<p>CREATE TABLE Actor (actor_id int(20) PRIMARY KEY, Actor_name VARCHAR(20), Birth_Date DATE);<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Q_5_Consider_the_following_table_Stationary_Write_SQL_commands_for_following_statements\"><\/span>Q 5. Consider the following table Stationary. Write SQL commands for following statements.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"398\" height=\"181\" data-src=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/05_result-1.webp\" alt=\"\" class=\"wp-image-25677 lazyload\" title=\"\" data-srcset=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/05_result-1.webp 398w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/05_result-1-300x136.webp 300w\" data-sizes=\"(max-width: 398px) 100vw, 398px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 398px; --smush-placeholder-aspect-ratio: 398\/181;\" \/><\/figure>\n\n\n\n<p><strong>1) Write SQL command to create above Table<\/strong><\/p>\n\n\n\n<p><strong>Answer:<\/strong><\/p>\n\n\n\n<p>CREATE TABLE Stationary (S_ID int(20) PRIMARY KEY, S_Name VARCHAR(20), C_Name VARCHAR(20), Price int(20), Quantity int(20));<strong><\/strong><\/p>\n\n\n\n<p><strong>2) Write SQL command to insert above mentioned record in table<\/strong>.<\/p>\n\n\n\n<p><strong>Answer:<\/strong><\/p>\n\n\n\n<p>INSERT INTO Stationary Values (001, \u2018Note Book\u2019, \u2018ABC\u2019, 20,50);<br>INSERT INTO Stationary Values (002, \u2018Note Book\u2019, \u2018XYZ\u2019, 10,80);<br>INSERT INTO Stationary Values (003, \u2018Note Book\u2019, \u2018PQR\u2019, 600,02);<\/p>\n\n\n\n<p><strong>3) To delete above table.<\/strong><\/p>\n\n\n\n<p><strong>Answer:<\/strong><\/p>\n\n\n\n<p>DROP TABLE Stationery;<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Q6_Answer_the_following_questions\"><\/span>Q.6 Answer the following questions.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>1) What is a database?<\/strong><\/p>\n\n\n\n<p><strong>Answer:<\/strong><\/p>\n\n\n\n<p>A DBMS is a collection of programs (computer-based system) that enables the user to create and maintain a database it is used to define, construct and manipulate the data in the database for various applications. It provides information storage, organization, and retrieval capabilities. The DBMS also enforces necessary access restrictions and security measures in order to protect the database.<\/p>\n\n\n\n<p>Various types of control systems within the DBMS make sure that the database continues to function properly. They Include Integrity system Security system Concurrency control system Recovery control system Some DBMS enables us to define \u201cviews\u201d of the database. A view is how the database appears to the user. This enables us to show only the relevant information to different types of users and it increases security, as certain users will not be able to see data which they are not meant to see.<\/p>\n\n\n\n<p><strong>2) What are the advantages of a DBMS?<\/strong><\/p>\n\n\n\n<p><strong>Answer:<\/strong><\/p>\n\n\n\n<p>Advantages of a DBMS:<br>1. Redundancy is controlled: In File Processing System, duplicate data is created in many places because all the programs have their own files. This creates data redundancy which in turn wastes labor and space. \u2018In Database Management System, all the files are integrated into a single database. The whole data is stored only once in a single place so there is no chance of duplicate data.<\/p>\n\n\n\n<p>2. Sharing of Data: In a database, the users of the database can share the data among themselves. There are various levels of authorization to access the data. And consequently, the data can only be shared based on the correct authorization protocols being followed.<\/p>\n\n\n\n<p>3. Data Security: Data Security is a vital concept in a database. Only authorized users should be allowed to access the database and their identity should be authenticated using a username and password. Unauthorized users should not be allowed to access the database under any circumstances as it violates integrity constraints.<\/p>\n\n\n\n<p>4. Enforces integrity constraints: Constraints are used to store accurate data because there are many users who feed data in the database. Data stored in the database should always be correct and accurate. DBMS provides the capability to enforce these constraints on the database.<\/p>\n\n\n\n<p>5. Provides backup and recovery of data: Data loss is a very big problem for all organizations. In a traditional tile processing system, a user needs to back up the database after a regular interval of time that wastes lots of time and resources. If the volume of data is large then this process may take a very long time.<\/p>\n\n\n\n<p><strong>3) What do you understand by Data Model?<\/strong><\/p>\n\n\n\n<p><strong>Answer:<\/strong><\/p>\n\n\n\n<p>A Database model defines the logical design and structure of a database and defines how data will be stored, accessed, and updated in a database management system. While the Relational Model is the most widely used database model.<\/p>\n\n\n\n<p>Relational Model:<br>It is the most popular data model in DBMS. The relational model is the primary data model. Which is widely used for data processing. This model has all properties required to Process data with storage efficiency.<\/p>\n\n\n\n<p><strong>4) What is a primary key ?<\/strong><\/p>\n\n\n\n<p><strong>Answer:<\/strong><\/p>\n\n\n\n<p>Primary Key: A column in the table that uniquely identifies each row in that table is called a primary key.<\/p>\n\n\n\n<p><strong>5) What is DDL(Data Definition language)<\/strong><\/p>\n\n\n\n<p><strong>Answer:<\/strong><\/p>\n\n\n\n<p>DDL statements or commands are used to define and modify the database structure of your tables or schema. When you execute a DDL statement, it takes effect immediately.<br>Some examples of DDL commands are CREATE, ALTER, and DROP.<\/p>\n\n\n\n<p class=\"has-text-align-center\"><strong><a href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-notes-maharashtra-board\/\" data-type=\"URL\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-notes-maharashtra-board\/\" target=\"_blank\" rel=\"noreferrer noopener\">Solution of other subjects<\/a><br><a href=\"https:\/\/scholarsclasses.com\/blog\/11th-it-textbook-solutions-maharashtra-board-free-solution\/\" data-type=\"URL\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-it-textbook-solutions-maharashtra-board-free-solution\/\">Solution of all the chapters of IT<br><\/a> <a href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-1-exercise\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-1-exercise\/\">1<\/a> &#8211; <a href=\"https:\/\/scholarsclasses.com\/blog\/11th-it-chapter-3-exercise\/\" data-type=\"URL\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-it-chapter-3-exercise\/\">3<\/a> &#8211; <a href=\"https:\/\/scholarsclasses.com\/blog\/11th-it-chapter-4-exercise\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-it-chapter-4-exercise\/\">4<\/a><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Q7_In_a_company_the_data_is_stored_in_a_table_under_the_following_fields_Employee_number_Last_name_Date_of_birth_and_address_Which_data_type_will_you_use_for_the_above_field\"><\/span>Q.7 In a company the data is stored in a table under the following fields Employee number, Last name, Date of birth, and address. Which data type will you use for the above field?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"395\" height=\"391\" data-src=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/07_result-1.webp\" alt=\"\" class=\"wp-image-25678 lazyload\" title=\"\" data-srcset=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/07_result-1.webp 395w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/07_result-1-300x297.webp 300w\" data-sizes=\"(max-width: 395px) 100vw, 395px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 395px; --smush-placeholder-aspect-ratio: 395\/391;\" \/><\/figure>\n\n\n\n<p><strong>Answer:<\/strong> <\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><thead><tr><th>Field Name<\/th><th>Data Type<\/th><\/tr><\/thead><tbody><tr><td>Employee Name<\/td><td>Char<\/td><\/tr><tr><td>last name<\/td><td>Char<\/td><\/tr><tr><td>Address<\/td><td>Varchar<\/td><\/tr><tr><td>Date of birth<\/td><td>Date<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Q8_Multiple_Choice_Question_3_correct_answers\"><\/span>Q.8 Multiple Choice Question. (3 correct answers)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>1) Valid relationships in RDBMS are<\/strong><\/p>\n\n\n\n<p><strong>Answer:<\/strong><\/p>\n\n\n\n<p><strong>a) one to one<\/strong><\/p>\n\n\n\n<p>b) one to two<\/p>\n\n\n\n<p><strong>c) one to many<\/strong><\/p>\n\n\n\n<p>d) many to two<\/p>\n\n\n\n<p><strong>e) many to many<\/strong><\/p>\n\n\n\n<p>f) one to three<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Q9_Complete_the_following\"><\/span>Q.9 Complete the following<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"394\" height=\"260\" data-src=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/09_result.webp\" alt=\"\" class=\"wp-image-25679 lazyload\" title=\"\" data-srcset=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/09_result.webp 394w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/10\/09_result-300x198.webp 300w\" data-sizes=\"(max-width: 394px) 100vw, 394px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 394px; --smush-placeholder-aspect-ratio: 394\/260;\" \/><\/figure>\n\n\n\n<p><strong>Answer:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To remove access rights or previleges from the database &#8211; Revoke<\/li>\n\n\n\n<li>Extracts data from a table &#8211; Insert into Select<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\"><span class=\"ez-toc-section\" id=\"11th_Commerce_IT_Textbook_Solutions\"><\/span>11th Commerce IT Textbook Solutions<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Chapter Name <\/strong><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-1-exercise\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-it-chapter-1-exercise\/\">1) Basics of Information Technology<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/11th-it-chapter-3-exercise\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-it-chapter-3-exercise\/\">3) Impressive Web Designing<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/11th-it-chapter-4-exercise\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-it-chapter-4-exercise\/\">4) Cyber Law<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-notes-maharashtra-board\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-notes-maharashtra-board\/\">Textbook Solutions of 11th Commerce (All Subjects)<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-books-pdf\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/11th-commerce-books-pdf\/\"> Free PDF of 11th Commerce Textbooks <\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":25515,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5],"tags":[5423],"class_list":["post-25605","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hsc-maharashtra-board","tag-11th-commerce-it-chapter-2-exercise"],"_links":{"self":[{"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/posts\/25605","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/comments?post=25605"}],"version-history":[{"count":11,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/posts\/25605\/revisions"}],"predecessor-version":[{"id":41603,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/posts\/25605\/revisions\/41603"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/media\/25515"}],"wp:attachment":[{"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/media?parent=25605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/categories?post=25605"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/tags?post=25605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}