{"id":2159,"date":"2024-04-10T05:59:04","date_gmt":"2024-04-10T04:59:04","guid":{"rendered":"https:\/\/mcqsadda.com\/?p=2159"},"modified":"2024-07-17T10:51:17","modified_gmt":"2024-07-17T09:51:17","slug":"database-concept-set-3","status":"publish","type":"post","link":"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-3\/","title":{"rendered":"Database Concept Set &#8211; 3"},"content":{"rendered":"\n<h1 class=\"wp-block-heading has-text-align-right has-vivid-purple-color has-text-color has-link-color has-larger-font-size wp-elements-cb7687725d8889ee94db971a4764370f\"><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-2\/\" title=\"\">Prev<\/a>       <strong><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/08\/database-concept-set-1\/\" title=\"\">1<\/a>        <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-2\/\" title=\"\">2<\/a>        <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-3\/\" title=\"\">3<\/a>        <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-4\/\" title=\"\">4<\/a><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/03\/06\/introduction-to-computer-set-4\/\" title=\"\"> <\/a>       <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-5\/\" title=\"\">5<\/a><\/strong>       <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-4\/\" title=\"\">Next<\/a><\/h1>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-vivid-green-cyan-background-color has-background has-text-align-left wp-element-button\" href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-quiz-3\/\">mock test<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>21. The database stores information in _______.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Rows and columns<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Blocks<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Tracks and sectors<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. All of these<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION :  A database stores information in rows and columns. A database is a structured repository of information that is organized in a grid system of rows and columns to make it easier to access, manage, and update. \n  \n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>22. To locate a data item for storage is<\/strong> _______.<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Field<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong><strong><strong><strong>Feed<\/strong><\/strong><\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Database<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Fetch<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:D<BR>\nSOLUTION:Fetch is the term used to locate a data item for storage in computer technology. \n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>23. The smallest unit of information about a record in a database is called a<\/strong> ________.<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Cell<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Field<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Record<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Query<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION:The smallest unit of information about a record in a database is called a field. \n\n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>24. An entity set that does not have sufficient attributes to form a primary key, is a _______.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Strong entity set<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Weak entity set<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Simple entity set<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Primary entity set<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION:An entity set that does not have sufficient attributes to form a primary key is a weak entity set. \n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>25. DBMS is comprised of tables that made up of rows called ___ and columns called__<\/strong>____.<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A.Fields, records<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Records, fields<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Address, fields<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Ranges, sheet<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION:A database management system (DBMS) is made up of tables that contain rows called records and columns called fields. <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>26. What is a stored question about information in a database?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Query<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Sort<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Report<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Record<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION :A query is a stored question about information in a database. It&#8217;s a request for data or information from a database table or tables, and can be used to perform an action on the data, or both. \n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>27. A program that generally has more user-friendly interface than a DBMS is called a<\/strong> <strong>________.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Front end<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong><strong><strong><strong>Repository<\/strong><\/strong><\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Back end<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Form<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER: A<BR>\nSOLUTION:A program that generally has a more user-friendly interface than a DBMS is called a front end. \n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>28. What is the overall term for creating, editing, formatting, storing, retrieving a text document?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Word processing<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Spreadsheet design<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Web design<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Database management<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION:The overall term for creating, editing, formatting, storing, retrieving, and printing a text document is word processing. \n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>29. DBMS helps to achieve_______.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Data independence<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Centralized control of data<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Selection of data<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Both \u20181\u2019 and \u20182\u2019<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION:A database management system (DBMS) helps to achieve data independence.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>30. Periodically adding, changing and deleting file records is called __ file.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Updating<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Upgrading<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Restructuring<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Renewing<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION:Periodically adding, changing, and deleting file records is called file updating. \n<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-vivid-green-cyan-background-color has-background has-text-align-left wp-element-button\" href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-quiz-3\/\">mock test<\/a><\/div>\n<\/div>\n\n\n\n<h1 class=\"wp-block-heading has-text-align-right has-vivid-purple-color has-text-color has-link-color has-larger-font-size wp-elements-cb7687725d8889ee94db971a4764370f\"><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-2\/\" title=\"\">Prev<\/a>       <strong><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/08\/database-concept-set-1\/\" title=\"\">1<\/a>        <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-2\/\" title=\"\">2<\/a>        <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-3\/\" title=\"\">3<\/a>        <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-4\/\" title=\"\">4<\/a><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/03\/06\/introduction-to-computer-set-4\/\" title=\"\"> <\/a>       <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-5\/\" title=\"\">5<\/a><\/strong>       <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-4\/\" title=\"\">Next<\/a><\/h1>\n","protected":false},"excerpt":{"rendered":"<p>Prev 1 2 3 4 5 Next 21. The database stores information in _______. A. Rows and columns B. Blocks C. Tracks and sectors D. All of these ANSWER &#038; SOLUTION ANSWER:A SOLUTION : A database stores information in rows and columns. A database is a structured repository of information that is organized in a<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[1402,1399,1404,1400,5623,1405,1395,1398,1397,1401,1403],"class_list":{"0":"post-2159","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-computer","7":"tag-a-program-that-generally-has-more-user-friendly-interface-than-a-dbms-is-called-a-________","8":"tag-an-entity-set-that-does-not-have-sufficient-attributes-to-form-a-primary-key-is-a-_______","9":"tag-dbms-helps-to-achieve_______","10":"tag-dbms-is-comprised-of-tables-that-made-up-of-rows-called-___-and-columns-called______","11":"tag-mcqs-for-sda-fda-pdo-vao-banking-kas-ias-ssc-gd-ssc-chsl-ssc-cgl-for-all-compitative-exams","12":"tag-periodically-adding-changing-and-deleting-file-records-is-called-__-file","13":"tag-the-database-stores-information-in-_______","14":"tag-the-smallest-unit-of-information-about-a-record-in-a-database-is-called-a-________","15":"tag-to-locate-a-data-item-for-storage-is-_______","16":"tag-what-is-a-stored-question-about-information-in-a-database","17":"tag-what-is-the-overall-term-for-creating-editingformatting-storing-retrieving-a-text-document"},"_links":{"self":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2159","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/comments?post=2159"}],"version-history":[{"count":3,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2159\/revisions"}],"predecessor-version":[{"id":3533,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2159\/revisions\/3533"}],"wp:attachment":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/media?parent=2159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/categories?post=2159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/tags?post=2159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}