{"id":10590,"date":"2021-11-04T18:45:27","date_gmt":"2021-11-04T13:15:27","guid":{"rendered":"https:\/\/scholarsclasses.com\/blog\/?p=10590"},"modified":"2025-10-09T16:29:04","modified_gmt":"2025-10-09T10:59:04","slug":"12th-commerce-it-chapter-5-exercise","status":"publish","type":"post","link":"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/","title":{"rendered":"12th Commerce IT Chapter 5 Exercise &#8211; Database Concepts using Libre Office Base | 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-69d9d6cfdf4bf\" 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-69d9d6cfdf4bf\"  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\/12th-commerce-it-chapter-5-exercise\/#12th_Commerce_IT_Chapter_5_Exercise\" >12th Commerce IT Chapter 5 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\/12th-commerce-it-chapter-5-exercise\/#Chapter_5_%E2%80%93_Database_Concepts_using_Libre_Office_Base\" >Chapter 5 &#8211; Database Concepts using Libre Office Base<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/#Q_1_Fill_in_the_blanks\" >Q 1. Fill in the blanks<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/#Q_2_State_TrueFalse\" >Q 2. State True\/False.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/#Q_3_Multiple_Choice_Question_1_correct_answer\" >Q 3. Multiple Choice Question. (1 correct answer)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/#Q_4_Answer_in_brief\" >Q 4. Answer in brief.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/#1_Define_database\" >1) Define database.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/#2_What_is_a_query\" >2) What is a query?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/#3_Define_report\" >3) Define report.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/#4_Explain_working_area_of_Base\" >4) Explain working area of Base.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/#Q_5_Match_the_following\" >Q 5. Match the following.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/#Extra_Questions\" >Extra Questions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/#Choose_a_single_correct_answer_from_the_given_options\" >Choose a single correct answer from the given options.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/#12th_Commerce_IT_Textbook_Solutions\" >12th 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=\"12th_Commerce_IT_Chapter_5_Exercise\"><\/span><strong>12th Commerce IT Chapter 5 Exercise<\/strong><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=\"Chapter_5_%E2%80%93_Database_Concepts_using_Libre_Office_Base\"><\/span>Chapter 5 &#8211; Database Concepts using Libre Office Base<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Q_1_Fill_in_the_blanks\"><\/span>Q 1. Fill in the blanks<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>1) <strong><span style=\"text-decoration: underline;\">Database<\/span><\/strong> is a collection of related data.<\/p>\n\n\n\n<p>2) Queries are used to <strong><span style=\"text-decoration: underline;\">retrieve<\/span><\/strong> information from database.<\/p>\n\n\n\n<p>3) The representation of data in printed form is called as <strong><span style=\"text-decoration: underline;\">report<\/span><\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Q_2_State_TrueFalse\"><\/span>Q 2. State True\/False.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>1Form is used to collect the data from the user.<br><strong>Answer: True<\/strong><\/p>\n\n\n\n<p>2) Menu bar is present below Title bar.<br><strong>Answer: True<\/strong><\/p>\n\n\n\n<p>3) Columns are called as records.<br><strong>Answer: False<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"576\" data-src=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2021\/11\/12th-Commerce-IT-Chapter-5-Exercise-1024x576.jpg\" alt=\"12th Commerce IT Chapter 5 Exercise\" class=\"wp-image-10592 lazyload\" title=\"\" data-srcset=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2021\/11\/12th-Commerce-IT-Chapter-5-Exercise-1024x576.jpg 1024w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2021\/11\/12th-Commerce-IT-Chapter-5-Exercise-300x169.jpg 300w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2021\/11\/12th-Commerce-IT-Chapter-5-Exercise-768x432.jpg 768w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2021\/11\/12th-Commerce-IT-Chapter-5-Exercise-1536x864.jpg 1536w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2021\/11\/12th-Commerce-IT-Chapter-5-Exercise-640x360.jpg 640w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2021\/11\/12th-Commerce-IT-Chapter-5-Exercise.jpg 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\">12th Commerce IT Chapter 5 Exercise<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Q_3_Multiple_Choice_Question_1_correct_answer\"><\/span>Q 3. Multiple Choice Question.<br>(1 correct answer)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>1) Rows in Base are called as<\/strong> <strong>\u2026\u2026\u2026\u2026\u2026\u2026\u2026..<br><span class=\"has-inline-color has-vivid-purple-color\">a) records <br><\/span><\/strong>b) fields<br>c) table <br>d) database<\/p>\n\n\n\n<p><strong>2) File extension of Base is \u2026\u2026\u2026\u2026\u2026.<br><\/strong>a) .odt <br>b) .ods<br><strong><span class=\"has-inline-color has-vivid-purple-color\">c) .odb <br><\/span><\/strong>d) .odp<\/p>\n\n\n\n<p><strong>Free online lecture on above topic &#8211; <a href=\"https:\/\/youtube.com\/playlist?list=PLGiOLU46prNe6tQIJakepd3uGvatQyBUe\" target=\"_blank\" rel=\"noreferrer noopener\">Click Here<\/a><\/strong><\/p>\n\n\n\n<p class=\"has-text-align-center\"><strong><a href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-notes\/\" target=\"_blank\" rel=\"noreferrer noopener\">Solution of other subjects<\/a><br>Solution of Chapters of IT<\/strong><br><strong><a href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-1-exercise\/\" target=\"_blank\" rel=\"noreferrer noopener\">1<\/a> &#8211; <a href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-2-exercise\/\" target=\"_blank\" rel=\"noreferrer noopener\">2<\/a> &#8211; <a href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-3-exercise\/\" target=\"_blank\" rel=\"noreferrer noopener\">3<\/a> &#8211; <a href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-4-exercise\/\" target=\"_blank\" rel=\"noreferrer noopener\">4<\/a> &#8211; <a href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/\" target=\"_blank\" rel=\"noreferrer noopener\">5<\/a> &#8211; <a href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-6-exercise\/\" target=\"_blank\" rel=\"noreferrer noopener\">6<\/a><\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Q_4_Answer_in_brief\"><\/span>Q 4. Answer in brief.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Define_database\"><\/span><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">1) Define database.<\/mark><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>Answer:<\/strong> <\/p>\n\n\n\n<p>A database is a collection of related data items stored in an organized manner. A Database consists of different objects like table, query, form, and report. The table is a collection of related data. The query is used to retrieve information from database. The form is used to collect the information from user. Report is used to represent the data in printed form.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_What_is_a_query\"><\/span><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">2) What is a query?<\/mark><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>Answer:<\/strong> <\/p>\n\n\n\n<p>a) A Query is a question asked within the database environment. For example how many students are in XII standard.<br>b) Query displays a subset of data contained in various tables of database. <br>c) Query is used to retrieve records from the table.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Define_report\"><\/span><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">3) Define report.<\/mark><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>Answer:<\/strong> <\/p>\n\n\n\n<p>a) The presentation of information in an organised and readable format as per the user&#8217;s requirement is known as report.<br>b) Various complex reports can be generated that can help in taking decisions by the management.<br>c) Report is the representation of data in printed form.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_Explain_working_area_of_Base\"><\/span><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">4) Explain working area of Base.<\/mark><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>Answer:<\/strong> <\/p>\n\n\n\n<p>a) Rest of the part below standard tool bar is called as working area.<br>b) It is divided into two panes-Left pane and right pane.<br>c) Left pane displays name of database objects like tables, queries, forms and reports.<br>d) Right pane displays activities related to that particular object.<\/p>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Q_5_Match_the_following\"><\/span>Q 5. Match the following.<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>A<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>B<\/strong><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">1) Query<\/td><td class=\"has-text-align-center\" data-align=\"center\">a) Collect information from user.<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">2) Report<\/td><td class=\"has-text-align-center\" data-align=\"center\">b) Collection of related data.<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">3) Form<\/td><td class=\"has-text-align-center\" data-align=\"center\">c) Retrieve data from database.<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">4) Table<\/td><td class=\"has-text-align-center\" data-align=\"center\">d) printed form of data.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>1) &#8211; c) Retrieve data from database.<br>2) &#8211; d) printed form of data.<br>3) &#8211; a) Collect information from user.<br>4) &#8211; b) Collection of related data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Extra_Questions\"><\/span>Extra Questions<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center has-vivid-green-cyan-background-color has-background\"><span class=\"ez-toc-section\" id=\"Choose_a_single_correct_answer_from_the_given_options\"><\/span>Choose a single correct answer from the given options.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>1. _____ is an open source database.<\/strong><br>a) LibreOffice writter<br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">b) LibreOffice Base<br><\/mark><\/strong>c) Microsoft Access<br>d) LibreOffice Calc<\/p>\n\n\n\n<p><strong>2. ______means all kinds of fat, figures, place, things, or events.<\/strong><br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">a) Data <br><\/mark><\/strong>b) Information <br>c) Query <br>d) Report<\/p>\n\n\n\n<p><strong>3. _____ may be in oral, written, computerized form.<\/strong><br>a) Information <br>b) Query <br>c) Report <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">d) Data<\/mark><\/strong><\/p>\n\n\n\n<p><strong>4. ______must be processed in a proper way to generate useful and meaningful information.<br><\/strong>a) Information <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">b) Data <br><\/mark><\/strong>c) Table <br>d) Report<\/p>\n\n\n\n<p><strong>5. _____is the required result obtained from the processing of the data.<br><\/strong>a) Table <br>b) Data <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">c) Information <br><\/mark><\/strong>d) Report<\/p>\n\n\n\n<p><strong>6. _____ is output generated through processing of raw data.<\/strong><br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">a) Information <br><\/mark><\/strong>b) Database <br>c) Data <br>d) Query<\/p>\n\n\n\n<p><strong>7. _____is a collection of related data items stored in an organised manner.<br><\/strong>a) Information <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">b) Database <br><\/mark><\/strong>c) Raw Data <br>d) Operations<\/p>\n\n\n\n<p><strong>8. _____consists of object like table, query, form and report.<\/strong><br>a) Information <br>b) Raw data<br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">c) Database <br><\/mark><\/strong>d) Operation<\/p>\n\n\n\n<p><strong>9. _____is a collection of related data.<\/strong><br>a) Data <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">b) Table <br><\/mark><\/strong>c) Query <br>d) Report<\/p>\n\n\n\n<p><strong>10. ____ is used retrieve information from database.<\/strong><br>a) Table <br>b) Report <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">c) Query <br><\/mark><\/strong>d) Data<\/p>\n\n\n\n<p><strong>11. ____ is used to collect the information from user.<\/strong><br>a) Table <br>b) Query <br>c) Report <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">d) Form<\/mark><\/strong><\/p>\n\n\n\n<p><strong>12. _____ is used to represent the data in printed form.<\/strong><br>a) Query <br>b) Form <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">c) Report <br><\/mark><\/strong>d) Table<\/p>\n\n\n\n<p><strong>13. ____is a software design to define manipulate, retrieve and manage data in a database.<\/strong><br>a) Table <br>b) Query <br>c) Report <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">d) DBMS<\/mark><\/strong><\/p>\n\n\n\n<p><strong>14. ____ defines rules to validate and manipulate the data.<\/strong><br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">a) DBMS <br><\/mark><\/strong>b) Report <br>c) Methods <br>d) Functions<\/p>\n\n\n\n<p><strong>15) DBMS stands for_____.<\/strong><br>a) Digital Management System<br>b) Design Management System<br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">c) Database Management System<br><\/mark><\/strong>d) Draft Management System<\/p>\n\n\n\n<p><strong>16. _____ is a Relational Database Management System.<\/strong><br>a) Excel <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">b) Base <br><\/mark><\/strong>c) Word <br>d) Tally<\/p>\n\n\n\n<p><strong>17. RDBMS stands for______.<\/strong><br>a) Ratio Database Management System<br>b) Right Database Management System<br>c) Regional Database Management System<br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">d) Relational Database Management System<\/mark><\/strong><\/p>\n\n\n\n<p><strong>18. A DBMS that is based on Relational data model is called as ______.<\/strong><br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">a) RDBMS <br><\/mark><\/strong>b) Table <br>c) Report <br>d) Query<\/p>\n\n\n\n<p><strong>19. A_____model is the internal structure of a database that describes a way of storing and retrieving of data.<br><\/strong>a) Table <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">b) Data <br><\/mark><\/strong>c) Query <br>d) Report<\/p>\n\n\n\n<p><strong>20. _____ is a collection of related data objects known as Tables, Forms, Queries, and Reports.<br><\/strong>a) Word <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">b) Excel <br><\/mark><\/strong>c) Tally <br>d) Base<\/p>\n\n\n\n<p><strong>21. Extensions off base file is______.<\/strong><br>a) .odx <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">b) .odb <br><\/mark><\/strong>c) .odm <br>d) .doc<\/p>\n\n\n\n<p><strong>22. On the screen of the base _____ bar is present below Title bar.<\/strong><br>a) Tool <br>b) Standard <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">c) Menu <br><\/mark><\/strong>d) Working Area<\/p>\n\n\n\n<p><strong>23. ______ is a basic unit of storing data in database.<br><\/strong>a) Query <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">b) Table <br><\/mark><\/strong>c) Form <br>d) Report<\/p>\n\n\n\n<p><strong>24. ______ is a real-world object about which data is to be stored.<\/strong><br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">a) Entity <br><\/mark><\/strong>b) Report <br>c) Data <br>d) Database<\/p>\n\n\n\n<p><strong>25. Each entity has a collection of_____associated with it.<\/strong><br>a) Record <br>b) Row <br><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-accent-2-color\">c) Attributes <br><\/mark><\/strong>d) Column<\/p>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\"><span class=\"ez-toc-section\" id=\"12th_Commerce_IT_Textbook_Solutions\"><\/span>12th 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\/12th-commerce-it-chapter-1-exercise\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-1-exercise\/\">1) Advanced Web Designing<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-2-exercise\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-2-exercise\/\">2) Digital Marketing<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-3-exercise\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-3-exercise\/\">3) Computerised Accounting with GST<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-4-exercise\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-4-exercise\/\">4) E-Commerce and E-Governance<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-5-exercise\/\">5) Database Concepts using LibreOffice Base<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-6-exercise\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-it-chapter-6-exercise\/\">6) Enterprise Resource Planning (ERP)<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><strong>Check out our other posts related to the 12th Commerce<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/www.youtube.com\/@Scholarszilla\" data-type=\"link\" data-id=\"https:\/\/www.youtube.com\/@Scholarszilla\" target=\"_blank\" rel=\"noopener\">12th Commerce Video Lectures<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-notes\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-notes\/\">Textbook Solutions of 12th Commerce (All Subjects)<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/ebalbharti-12th-books-pdf\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/ebalbharti-12th-books-pdf\/\"> Free PDF of 12th Commerce Textbooks <\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/hsc-it-online-exam\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/hsc-it-online-exam\/\">12th Commerce IT MCQ Preparation (Online Test)<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/new-paper-pattern-of-12th-commerce\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/new-paper-pattern-of-12th-commerce\/\"> Free PDF of 12th Commerce Textbooks <\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/sample-question-paper-for-12th-commerce\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/sample-question-paper-for-12th-commerce\/\">Sample Paper of 12th Commerce for Practice PDF<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-navneet-practice-papers-pdf\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/12th-commerce-navneet-practice-papers-pdf\/\">PDF of Solved Sample papers of 12th Commerce to improve Paper Presentation<\/a><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><a href=\"https:\/\/scholarsclasses.com\/blog\/hsc-previous-year-question-paper\/\" data-type=\"link\" data-id=\"https:\/\/scholarsclasses.com\/blog\/hsc-previous-year-question-paper\/\">Old Question Papers of 12th Commerce with solution (All Subjects)<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><br><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":10592,"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":[3590],"class_list":["post-10590","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hsc-maharashtra-board","tag-12th-commerce-it-chapter-5-exercise"],"_links":{"self":[{"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/posts\/10590","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=10590"}],"version-history":[{"count":7,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/posts\/10590\/revisions"}],"predecessor-version":[{"id":39716,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/posts\/10590\/revisions\/39716"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/media\/10592"}],"wp:attachment":[{"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/media?parent=10590"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/categories?post=10590"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/tags?post=10590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}