{"id":2193,"date":"2024-04-10T07:37:15","date_gmt":"2024-04-10T06:37:15","guid":{"rendered":"https:\/\/mcqsadda.com\/?p=2193"},"modified":"2024-07-17T10:49:28","modified_gmt":"2024-07-17T09:49:28","slug":"database-concept-set-5","status":"publish","type":"post","link":"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-5\/","title":{"rendered":"Database Concept Set &#8211; 5"},"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-18a2425ba2d5ae6c57bae3b6a8784050\">Prev       <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>       Next<\/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-5\/\">mock test<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1. In an E-R diagram, attributes 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. Circle<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:C<BR>\nSOLUTION : In an Entity Relationship (ER) diagram, attributes are represented by ellipses. \n  \n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2. Relationship can be divided in to<\/strong> __________.<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. One to one<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong><strong><strong><strong>Many to <\/strong><\/strong><\/strong><\/strong>many<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. One to many<\/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:In general, tables can be related in one of three different ways: one-to-one, one-to-many or many-to-many. The relationship is used to cross reference information between tables.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>3. Press _____ to quit MS Access.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Tab +F4<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Esc+ W<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Ctrl +F4<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Alt+F4<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:D<BR>\nSOLUTION:To quit MS Access, you can press Alt + F4. Alt + F4 is a keyboard shortcut that closes the current active window.\n\n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>4. A _____ is an area reserved for a specific piece of data.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Report<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Key<\/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. Field<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:D<BR>\nSOLUTION:A field is an area in a table that is reserved for a specific piece of data. A field is also known as an attribute, and is a component of a record that contains a single piece of data for the record&#8217;s subject. \n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>5. Which of the following is not a type of MS Access database object?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Table<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Form<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Worksheets<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Modules<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:C<BR>\nSOLUTION: Worksheets are not a type of Microsoft Access database object. Worksheets are a feature of Microsoft Excel, which is a separate application in the Microsoft Office suite.  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>6. The size of yes\/no field is always ________.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. 1 bit<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. 1 Byte<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. 1 Character<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. 1KB<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION :The size of yes\/no field is always 1 bit .\n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>7. How can we create a query in Microsoft Access?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Drag and drop fields<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong><strong><strong><strong>Type the SQL<\/strong><\/strong><\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Use query wizard<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. All of above<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER: D<BR>\nSOLUTION:In Microsoft Access, you can create queries by dragging and dropping fields, typing the SQL, or using the query wizard.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>8. A single set of related data values is referred to as ________.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Data value<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Record<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Field<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Table<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION:A single set of related data values is referred to as a record. In a database, a record represents a complete set of information about a specific entity or item. \n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>9. What is used to uniquely identify each record in a table?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Foreign key<\/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. Datatype<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Primary key<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:D<BR>\nSOLUTION:A primary key is used to uniquely identify each record in a table. It is a field or a combination of fields that uniquely identifies a record in a database table. \n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>10. ___________ data type stores date and time values between the years 100 through 9999.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Date<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Time<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Date\/Time<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Memo<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:C<BR>\nSOLUTION:The correct answer is Date\/Time. This data type is used to store both date and time values. \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-5\/\">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-18a2425ba2d5ae6c57bae3b6a8784050\">Prev       <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>       Next<\/h1>\n","protected":false},"excerpt":{"rendered":"<p>Prev 1 2 3 4 5 Next 1. In an E-R diagram, attributes are represented by ________. A. Rectangle B. Square C. Ellipse D. Circle ANSWER &#038; SOLUTION ANSWER:C SOLUTION : In an Entity Relationship (ER) diagram, attributes are represented by ellipses. 2. Relationship can be divided in to __________. A. One to one B.<\/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":[1428,1421,1426,1425,1418,5623,1420,1419,1424,1427,1423],"class_list":{"0":"post-2193","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-computer","7":"tag-___________-data-type-stores-date-and-time-values-between-the-years-100-through-9999","8":"tag-a-_____-is-an-area-reserved-for-a-specific-piece-of-data","9":"tag-a-single-set-of-related-data-values-is-referred-to-as-________","10":"tag-how-can-we-create-a-query-in-microsoft-access","11":"tag-in-an-e-r-diagram-attributes-are-represented-by-________","12":"tag-mcqs-for-sda-fda-pdo-vao-banking-kas-ias-ssc-gd-ssc-chsl-ssc-cgl-for-all-compitative-exams","13":"tag-press-_____-to-quit-ms-access","14":"tag-relationship-can-be-divided-in-to-__________","15":"tag-the-size-of-yes-no-field-is-always-________","16":"tag-what-is-used-to-uniquely-identify-each-record-in-a-table","17":"tag-which-of-the-following-is-not-a-type-of-ms-access-database-object"},"_links":{"self":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2193","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=2193"}],"version-history":[{"count":2,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2193\/revisions"}],"predecessor-version":[{"id":3537,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2193\/revisions\/3537"}],"wp:attachment":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/media?parent=2193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/categories?post=2193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/tags?post=2193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}