Ps Staffing Solutions Interview Questions and Answers

Page life cycle refers to the series of events that occur from the time a page is requested to the time the page is fully rendered and sent to the client.

• Page life cycle includes events like page initialization, loading, postback processing, rendering, and unloading.

• Developers can hook into different events in the page life cycle to execute custom code.

• Understanding page life cycle is important for developing efficient

DML stands for Data Manipulation Language and is used for managing data in a database. DDL stands for Data Definition Language and is used for defining database structure.

• DML is used for operations like insert, update, delete data in a database.

• DDL is used for operations like creating, altering, dropping database objects like tables, indexes, etc.

• Examples: INSERT, UPDATE, DELETE are DML commands. CREATE, ALTER, DROP ar

Truncate is a DDL command that removes all rows from a table, while delete is a DML command that removes specific rows.

• Truncate is faster than delete as it does not log individual row deletions.

• Truncate resets identity columns, while delete does not.

• Truncate cannot be rolled back, while delete can be rolled back using a transaction.

• Truncate does not fire triggers, while delete does.

• Truncate does not require a where cla