Q9. Explain the primary key with the help of an example.
Ans. Primary key refers to a key that helps us to uniquely identify a record in a table. The primary key is used to avoid duplicate data. In other words, a column which a primary key will not contain duplicates information in any of its records. For example, the Employee_Details table, we can set the primary key in the Emp_Code column, which contains the employee code. In this case, duplicate values are not possible in the column.
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.
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.