Senior Database Developer Interview Questions and Answers for Freshers

Cascade refers to the automatic propagation of changes made to a parent record to its related child records.

• Cascade is a feature in database management systems that ensures data consistency and integrity.

• It allows changes made to a parent record to be automatically reflected in its related child records.

• For example, if a parent record is deleted, all its child records will also be deleted automatically.

• Cascade can be set up for various types of actions, such as update, delete...read more

Delete removes specific rows while truncate removes all rows from a table.

• Delete is a DML command while truncate is a DDL command.

• Delete can be rolled back while truncate cannot be rolled back.

• Delete is slower than truncate as it logs each row deletion while truncate does not.

• Delete can have a WHERE clause to specify which rows to delete while truncate deletes all rows.

• Delete does not reset the identity of the table while truncate resets the identity of the table.

• Example: DEL...read more