Loading, please wait ...
Open its course - Database Systems

Short Questions for Database Management System (DBMS)

  • ×

    Hidden Questions!

    Some short questions are not visible. Usually teachers hides their visibility if they are few in number. Subject Expert recommends them to have more than 70+ questions against the topic and make them public.

  • 1 What are the disadvantages of DBMS?

    Answer
    Following are the disadvantage of DBMS:

    • Complexity
    • Size
    • Cost of DBMS
    • Additional hardware costs
    • Cost of conversion
    • Performance
    • Higher impact of a failure


  • 2 Mention at least eight advantages of the database management systems?

    Answer
    Following are the advantages of DBMS:

    1. Control of data redundancy.
    2. Data consistency
    3. More information from the same amount of data.
    4. Sharing of data.
    5. Improved data integrity.
    6. Improved security.
    7. Enforcement of standards.
    8. Economy of scale.
    9. Balanced conflicting requirements
    10. Improved data accessibility and responsiveness
    11. Increased productivity
    12. Improved maintenance through data independence
    13. Increased concurrency
    14. mproved backup and recovery services


  • 3 Visualize the DBMS components and their interaction using a diagram.

    Answer
    Coming soon


  • 4 Describe at least five purposes of database management systems (DBMS)?

    Answer

    Note: The answer is at least five option from the following.
    1. Access: Provide one application to access many databases
    2. Layers: Hide physical storage considerations from the user
    3. Views: To provide only the data a user needs
    4. Security: Restrict access to the data
    5. Integrity: Preserve data integrity while supporting change
    6. Recovery: Return the database to a consistent state after a failure of any kind
    7. Concurrency: Offer simultaneous access to many users
    8. Backup


  • 5 What functions are allowed by DBMS to its users?

    Answer
    Allows users to:

    • Store data
    • Manage change (updates)
    • Organize data
    • Retrieve data
    • Retain privacy (security)


  • 6 Describe Database Management Systems (DBMS).

    Answer
    A database management system is a software system that enables users to define, create, and maintain the database and which provides controlled access to this database.

    • Provides systematic method of creating, updating, storing, and retrieving data in a database
    • It enables end users and application programmers to share data among multiple applications
    • A DBMS also provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and restoring a database


Contact Us

support@subexpert.com
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn, Evaluate and Optimize

Follow Us
Facebook Switch Display Mode Enable Translation
© 2024 - Subject Expert