Database Management System Questions Asked in Companies

DELETE command: DELETE command is used to delete rows from a table based on the condition that we provide in a WHERE clause. DELETE command delete only those rows which are specified with the WHERE clause. DELETE command can be rolled back. DELETE command maintain a log, that’s why it is slow. DELETE use row … Read more

A stored procedure is a group of SQL statements that have been created and stored in the database. The stored procedure increases the reusability as here the code or the procedure is stored into the system and used again and again that makes the work easy, takes less time in processing and decreases the complexity … Read more

ACID properties are some basic rules, which has to be satisfied by every transaction to preserve the integrity. These properties and rules are: ATOMICITY: Atomicity is more generally known as ?all or nothing rule.’ Which implies all are considered as one unit, and they either run to completion or not executed at all. CONSISTENCY: This … Read more

BCNF stands for Boyce-Codd Normal Form. It is an advanced version of 3NF, so it is also referred to as 3.5NF. BCNF is stricter than 3NF. A table complies with BCNF if it satisfies the following conditions: It is in 3NF. For every functional dependency X->Y, X should be the super key of the table. … Read more

3NF stands for Third Normal Form. A database is called in 3NF if it satisfies the following conditions: It is in second normal form. There is no transitive functional dependency. For example: X->Z Where: X->Y Y does not -> X Y->Z so, X->Z 3NF stands for Third Normal Form, which is a normalization technique used … Read more