Some SQL Interview questions with answer
Q1. What is the difference between DELETE and TRUNCATE statements? DELETE TRUNCATE Delete command is used to delete a row in a table. Truncate is used to delete all the rows from a table. You can rollback data after using delete statement. You cannot rollback data. It is a DML command. It is a DDL command. It is slower…
BI Developer specialized in SQL Query Development/ SSIS/ SSAS/ SSRS /Power BI/ MS Office. Enjoy working in data analysis and presentation, challenging projects where I can uncover valuable business insights for an organization from previously under-utilized data sources and creating custom made reports and interactive dashboards