Characteristics of DBMS ?<\/h2>\n<\/div>\n<\/div>\n

\n

\n

\n
• \n
  A) non-redundant<\/ul>\n<\/li>\n<\/ul>\n
  \n
  • \n
    B) data independence<\/ul>\n<\/li>\n<\/ul>\n
    \n
    • \n
      C) increased security<\/ul>\n<\/li>\n<\/ul>\n
      D) all the above<\/ul>\n<\/div>\n<\/div>\n

      Answer : D) all the above<\/strong><\/p>\n

      \n

      \n

      What is DBMS ?<\/h2>\n<\/div>\n<\/div>\n

      \n

      \n

      \n
      • A database management system (DBMS) is a software package designed to define manipulate, retrieve and manage data in a database.<\/li>\n
      • A DBMS mostly manipulates the data itself, the data format, field names, record structure and file structure. It also defines rules to validate and manipulate this data.<\/li>\n
      • A DBMS relieves users of framing programs for data maintenance. Fourth-generation query languages, such as SQL, are used along with the DBMS package to interact with a database.<\/li>\n
      • Some other DBMS examples include:\n
        \n
        • MySQL<\/li>\n
        • SQL Server<\/li>\n
        • Oracle<\/li>\n
        • dBASE<\/li>\n
        • FoxPro<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
          Characterstics of DBMS<\/span><\/div>\n

          \n

          \n

          \n
          • Data abstraction and independence.<\/li>\n
          • Data security.<\/li>\n
          • A locking mechanism for concurrent access.<\/li>\n
          • An efficient handler to balance the needs of multiple applications using the same data.<\/li>\n
          • The ability to swiftly recover from crashes and errors, including restartability and recoverability.<\/li>\n
          • Robust data integrity capabilities.<\/li>\n
          • Logging and auditing of activity.<\/li>\n
          • Simple access using a standard application programming interface (API).<\/li>\n
          • Uniform administration procedures for data.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
            \n

            <\/div>\n<\/div>\n

            Characteristics of DBMS<\/p>\n

            \n

            \n

            Advandages of DBMS<\/h2>\n<\/div>\n<\/div>\n

            \n

            \n

            \n
            • One of the most advantages of using a DBMS is that it lets end users and application programmers access and use the same data while managing data integrity.<\/li>\n
            • Data is better protected and maintained when it can be shared using a DBMS instead of creating new iterations of the same data stored in new files for every new application.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

              Answer : D) all the above…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[7157],"tags":[7217,195,7213,7214,7160,7212,7215,360,203,199,214,7227,7209,198,363,209,7224,7228,7220,7210,7218,7225,7163,7158,7165,7161,7219,7230,7198,7205,7223,7169,205,7222,7216,7231,222,196,212,213,7221,286,710,207,366,204,282,208,367,7197,7229,7164,3715,206,7207,200,7226,7171,7162,197,280,364,7208,7211,7183,285,15915],"class_list":["post-1036","post","type-post","status-publish","format-standard","hentry","category-dbms","tag-5-example-of-database","tag-accenture-interview-questions-and-answers","tag-advantages-and-disadvantages-of-dbms","tag-advantages-of-database-approach","tag-advantages-of-database-management-system","tag-advantages-of-dbms","tag-advantages-of-dbms-over-file-system","tag-atos-interview-questions-and-answers","tag-capgemini-interview-questions-and-answers","tag-casting-networks-india-pvt-limited-interview-questions-and-answers","tag-cgi-group-inc-interview-questions-and-answers","tag-characteristics-of-database","tag-characteristics-of-dbms","tag-chetu-interview-questions-and-answers","tag-ciena-corporation-interview-questions-and-answers","tag-collabera-technologies-interview-questions-and-answers","tag-concept-of-database-management-system","tag-database-and-database-management-system","tag-database-application","tag-database-examples","tag-database-management","tag-database-management-software","tag-database-management-system","tag-database-management-system-examples","tag-database-management-system-notes","tag-database-management-system-tutorial","tag-database-system","tag-database-system-applications","tag-dbms","tag-dbms-examples","tag-dbms-programs","tag-dbms-software","tag-dell-international-services-india-pvt-ltd-interview-questions-and-answers","tag-example-of-database-system","tag-example-of-dbms-and-rdbms","tag-explain-database-management-system","tag-flipkart-interview-questions-and-answers","tag-ibm-interview-questions-and-answers","tag-indecomm-global-services-interview-questions-and-answers","tag-infosys-technologies-interview-questions-and-answers","tag-introduction-to-database-management-system","tag-lt-infotech-interview-questions-and-answers","tag-mavenir-interview-questions-and-answers","tag-mphasis-interview-questions-and-answers","tag-netapp-interview-questions-and-answers","tag-oracle-corporation-interview-questions-and-answers","tag-persistent-systems-interview-questions-and-answers","tag-prokarma-softech-pvt-ltd-interview-questions-and-answers","tag-rbs-india-development-centre-pvt-ltd-interview-questions-and-answers","tag-rdbms","tag-rdbms-database","tag-relational-database-management-system","tag-ruboid-technovision-pvt-ltd-interview-questions-and-answers","tag-sap-labs-india-pvt-ltd-interview-questions-and-answers","tag-shell-infotech-interview-questions-and-answers","tag-tech-mahindra-interview-questions-and-answers","tag-transaction-in-dbms","tag-types-of-database","tag-types-of-database-management-system","tag-unitedhealth-group-interview-questions-and-answers","tag-virtusa-consulting-services-pvt-ltd-interview-questions-and-answers","tag-wells-fargo-interview-questions-and-answers","tag-what-is-database-management-system","tag-what-is-database-system","tag-what-is-dbms","tag-xoriant-solutions-pvt-ltd-interview-questions-and-answers","tag-xp-interview-questions-and-answers"],"yoast_head":"\n