{"id":2121,"date":"2024-04-08T08:24:15","date_gmt":"2024-04-08T07:24:15","guid":{"rendered":"https:\/\/mcqsadda.com\/?p=2121"},"modified":"2024-04-28T11:49:53","modified_gmt":"2024-04-28T10:49:53","slug":"database-concept-set-1","status":"publish","type":"post","link":"https:\/\/mcqsadda.com\/index.php\/2024\/04\/08\/database-concept-set-1\/","title":{"rendered":"Database Concept Set &#8211; 1"},"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-29d158f0da4fc9f77c9e7d94a0484803\">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>       <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-2\/\" 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\/08\/database-concept-quiz-1\/\">mock test<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1. What is full form DBMS?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Database Management Structure<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Database Management System<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Database Manual System<\/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 :  DBMS stands for Database Management System. It is a software system that stores, retrieves, and runs queries on data. \n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2. The ascending order of data hierarchy is ?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Bit -&gt; byte -&gt; record -&gt; field -&gt; file -&gt; database<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong><strong><strong><strong>Bit -&gt; byte -&gt;  field -&gt; record -&gt; file -&gt; database<\/strong><\/strong><\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. byte -&gt; bit -&gt; record -&gt;  field -&gt; file -&gt; database<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Bit -&gt; byte -&gt; file-&gt;field -&gt; record -&gt;database<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER: B<BR>\nSOLUTION:Bit-bytes-field-record-file-database.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>3. Duplication of data at several places is called______.<\/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. Data mining<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Data inconsistency<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Data repository<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION:Additional InformationData Redundancy:- The situation of having an identical piece of data stored in two different locations is known as data redundancy and is created by databases or other data storage technologies.\n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>4. A large store of data accumulated from a wide range of sources is called_______.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Data warehouse<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Data mining<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Data management<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. All of the above<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION:A large store of data accumulated from a wide range of sources is called a data warehouse.  \n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>5. DBA stands for ______.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Database access<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Database administrator<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Data Bank administrator<\/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: DBA stands for database administrator. DBAs are responsible for the security, performance, and integrity of databases. <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>6. Data about data is known as<\/strong> __________.<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Directory<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Sub data<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Meta data<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Data bank<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:C<BR>\nSOLUTION : Data about data is known as metadata. Metadata is structured information that describes, explains, locates, or makes it easier to retrieve, use, or manage information. \n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>7. The tool which is used to extract the data &amp; information from the data warehouse is  ________.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Data warehouse<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong><strong><strong><strong>Data redundancy<\/strong><\/strong><\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Data mining<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Data management<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER: C<BR>\nSOLUTION:Data mining is the process of extracting valuable information from large data sets.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>8.<\/strong> <strong>Rows of relation are called ____.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Entity<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Tuples<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Degree<\/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:B<BR>\nSOLUTION:Rows of a relation are called tuples. A tuple is also known as a record or row.\n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>9. DML stands for_______.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Data Management Language<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Data Multipurpose Language<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Data Manipulation Language<\/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:DML stands for Data Manipulation Language. It is a programming language that is used to make changes to a database.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>10. TCL stands for ______.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Transmission control Language<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Transactions Central Language<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Ternary Control Language<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Transaction Control Language<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:D<BR>\nSOLUTION: TCL stands for Transaction Control Language. It is a set of commands used in SQL to manage and control database transactions.<\/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\/08\/database-concept-quiz-1\/\">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-29d158f0da4fc9f77c9e7d94a0484803\">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>       <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/10\/database-concept-set-2\/\" title=\"\">Next<\/a><\/h1>\n","protected":false},"excerpt":{"rendered":"<p>Prev 1 2 3 4 5 Next 1. What is full form DBMS? A. Database Management Structure B. Database Management System C. Database Manual System D. None of these ANSWER &#038; SOLUTION ANSWER:B SOLUTION : DBMS stands for Database Management System. It is a software system that stores, retrieves, and runs queries on data. 2.<\/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":[1376,1378,1377,1381,1375,1382,1383,1374,1373],"class_list":{"0":"post-2121","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-computer","7":"tag-a-large-store-of-data-accumulated-from-a-wide-range-of-sources-is-called_______","8":"tag-data-about-data-is-known-as-__________","9":"tag-dba-stands-for-______","10":"tag-dml-stands-for_______","11":"tag-duplication-of-data-at-several-places-is-called______","12":"tag-rows-of-relation-are-called-____","13":"tag-tcl-stands-for-______","14":"tag-the-ascending-order-of-data-hierarchy-is","15":"tag-what-is-full-form-dbms"},"_links":{"self":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2121","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=2121"}],"version-history":[{"count":2,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2121\/revisions"}],"predecessor-version":[{"id":3529,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2121\/revisions\/3529"}],"wp:attachment":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/media?parent=2121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/categories?post=2121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/tags?post=2121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}