Q2. Define DBMS and its functioning. Ans. DBMS is a program that controls the creation, maintenance, and use of a database. In DBMS, data is stored centrally. This allows users to easily access and share data as a common resource. DBMS helps in the integration of stored data by preventing inconsistencies and duplicate data. In addition, accessing, retrieving, and modifying the stored data is easy. DBMS also allows multiple users to access the data at the same time. Moreover, the access to the database is controlled. In other words, unauthorized users are prevented from accessing the database.
Q3. How does DBMS ensure data security. Ans. DBMS provides security for data by ensuring that only authorized users are able to access the database. Authorized users are doors users whose credentials are verified through security checks.
The data that is stored in a database may contain valuable or sensitive information. For example, the database of an organization can contain personal information about its employees or information about the financial deals made with other organizations. Such type of information is highly sensitive and may damage the organization or its goodwill if it were to fall in wrong hands. Therefore, it is important that such information should be provided adequate security. DBMS provides security for data by ensuring that only authorized users are able to access the database. Authorized users have the rights or permission to access or change the database. This not only helps keep track of the users who access and make changes in the database, but also preventsothers without right credentials to access the database.
Q1. What is a BASE? Ans. BASE also known as openoffice.org BASE or OO BASE, is a database application in the OpenOffice suite.BASE is a popular relational database management system or RDBMS. RDBMS is a type of database system that stores data in the form of related tables.