DBMS - Quick reference - 2

6. What is a checkpoint in DBMS?
Checkpoint is the mechanism where all the previous logs are removed from the system where it is created and stored permanently in a storage disk. Checkpoint declares a point before which the DBMS was in consistent state, and all the transactions were committed.

7. What are the disadvantages of file processing systems?
Data Redundancy.
Data Inconsistency.
Difficulty in Accessing Data.
Limited Data Sharing.
Integrity Problems.
Atomicity Problems.

8. What is an attribute?
In RDBMS, a table organizes data in rows and columns. The columns are known as attributes whereas the rows are known as records.

9. What is the difference between Trigger and Stored Procedure?
A trigger is a procedure that is executed automatically when some specific events occur in a table/view of a database, while a stored procedure is a method that can be used by an application accessing a relational database. Triggers are executed automatically when the event that the trigger is supposed to respond to occurs. But to execute a stored procedure a specific CALL or EXECUTE statement has to be used.

10. What is meant by trigger?
Trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database. The trigger is mostly used for maintaining the integrity of the information on the database.

1 2 3 4 5 6 7 8 9 10