{"id":2172,"date":"2024-04-10T06:51:40","date_gmt":"2024-04-10T05:51:40","guid":{"rendered":"https:\/\/mcqsadda.com\/?p=2172"},"modified":"2024-07-17T10:51:02","modified_gmt":"2024-07-17T09:51:02","slug":"database-concept-set-4","status":"publish","type":"post","link":"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-4\/","title":{"rendered":"Database Concept Set &#8211; 4"},"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-a8a575a147605fec4cd9f0416bc98743\"><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-3\/\" 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-5\/\" 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-4\/\">mock test<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>31. ___ is one reason for problems of data integrity.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Data availability constraints<\/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. <strong>Security constraints<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Unauthorized access of data<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION : Data availability constraints are one reason for problems of data integrity.\n  \n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>32. ___ means that the data contained in a database is accurate and reliable.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Data redundancy<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong><strong><strong><strong>Data integrity<\/strong><\/strong><\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Data reliability<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Data consistency<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION:Data integrity means that the data contained in a database is accurate and reliable.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>33. Which of the following is the drawback of DBMS?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Improvement in Data<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Backup and recovery<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Complexity<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Maintenance of data integrity<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:C<BR>\nSOLUTION:Some of the main disadvantages of DBMS are: Cost, Complexity, Scalability, Dependence on Technology, Performance issue, Data Integration, Security, and Data loss.\n\n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>34. In which of the following database are used?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Banking<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Finance<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Sales<\/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:D<BR>\nSOLUTION:Banking: Used to store and process financial transactions, such as balances, deposits, loans, and credit cards\nFinance: Used to store information about sales and holdings, and purchasing financial stocks and bonds\nSales: Used to streamline and manage sales accounts and contacts more efficiently \n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>35. Oracle is a____.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Hardware<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. High level language<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Operating system<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. RDBMS<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:D<BR>\nSOLUTION: Oracle is an RDBMS (Relational Database Management System).  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>36. The purpose of the primary key in a database is to<\/strong> _______.<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Unlock the database<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Provide a map of the data<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Uniquely identify a record<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Establish constraints on database operations<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:C<BR>\nSOLUTION :A primary key is used to ensure data in the specific column is unique.\n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>37. Which of the following types of table constraints will prevent the entry of duplicate rows?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Primary key<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong><strong><strong><strong>Unique<\/strong><\/strong><\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Null<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Foreign key<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER: A<BR>\nSOLUTION:A primary key is a type of table constraint that prevents duplicate rows\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>38. Which database language is used to access data in existing database?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. DDL<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. DML<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. DCL<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. None of these<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION:Data Manipulation Language (DML) is used to access data in an existing database. \n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>39. An E-R diagram is a graphic method of presenting Primary keys and their relationships_______.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Primary keys and their relationships to&nbsp; instances<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Entity classes and their relationships<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Entity classes and their <strong>relationsh<\/strong>ips to  primary keys<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. None of the above<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:C<BR>\nSOLUTION:An Entity-Relationship (ER) diagram is a graphic method of presenting primary keys and their relationships to entity classes. \n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>40. In an E-R diagram, an entity set is are represented by<\/strong> _________.<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Rectangle<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Square<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Ellipse<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Triangle<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION:Rectangles divided into two parts represent entity sets in an ER diagram. The upper rectangle contains the name of the entity sets.\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-4\/\">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-a8a575a147605fec4cd9f0416bc98743\"><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-3\/\" 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-5\/\" title=\"\">Next<\/a><\/h1>\n","protected":false},"excerpt":{"rendered":"<p>Prev 1 2 3 4 5 Next 31. ___ is one reason for problems of data integrity. A. Data availability constraints B. Blocks C. Security constraints D. Unauthorized access of data ANSWER &#038; SOLUTION ANSWER:A SOLUTION : Data availability constraints are one reason for problems of data integrity. 32. ___ means that the data contained<\/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":[1407,1408,1415,1416,1410,5623,1411,1412,1414,1409,1413],"class_list":{"0":"post-2172","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-computer","7":"tag-___-is-one-reason-for-problems-of-data-integrity","8":"tag-___-means-that-the-data-contained-in-a-database-is-accurate-and-reliable","9":"tag-an-e-r-diagram-is-a-graphic-method-of-presenting-primary-keys-and-their-relationships_______","10":"tag-in-an-e-r-diagram-an-entity-set-is-are-represented-by-_________","11":"tag-in-which-of-the-following-database-are-used","12":"tag-mcqs-for-sda-fda-pdo-vao-banking-kas-ias-ssc-gd-ssc-chsl-ssc-cgl-for-all-compitative-exams","13":"tag-oracle-is-a____","14":"tag-the-purpose-of-the-primary-key-in-a-database-is-to-_______","15":"tag-which-database-language-is-used-to-access-data-in-existing-database","16":"tag-which-of-the-following-is-the-drawback-of-dbms","17":"tag-which-of-the-following-types-of-table-constraints-will-prevent-the-entry-of-duplicate-rows"},"_links":{"self":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2172","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=2172"}],"version-history":[{"count":3,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2172\/revisions"}],"predecessor-version":[{"id":3535,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2172\/revisions\/3535"}],"wp:attachment":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/media?parent=2172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/categories?post=2172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/tags?post=2172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}