Q7. Define DBMS functioning.
Ans. DBMS means database management system. The application that helps in creation, maintenance and use of 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.
Read More …
Q4. Can a primary key contain null value?
Ans. No, primary key cannot contain null value.
Q4. What do you mean by a foreign key?
Ans. A foreign key is a reference of the primary key in an another table.
Q3. What Do you understand by a primary key?
Ans. The key that helps us to uniquely identify a record n a table.
Q2. Is it possible to completely remove data duplication from a database?
Ans. It is not possible to eliminate data duplication completely from a database. It can be reduced considerably by using DBMS.
Q1. What do you understand by a record?
Ans. A record is also known as row. A row of data that represents a complete set of information in a table.
Q11. What is a query?
Ans. A query is a request sent by a user to retrieve specific data from a table base in a database.
Q10. How does DBMS ensures data security?
Ans. DBMS provides security of data by ensuring that authorized users are able to access the database. Authorized users are those uses whose credentials are verified through security checks.
Q9. How does DBMS work?
Ans. In DBMS, data is stored at a centralized location. This provides a commonplace for user’s access data easily. In addition, if any changes are made in the database, then they will we made at just one place, but the changed the information would be instantly available to all the users.