IGT Solutions Technical Architect Interview Questions and Answers

DELETE is used to remove rows from a table while keeping the table structure intact. DROP is used to remove an entire table from the database.

• DELETE is a DML (Data Manipulation Language) command, while DROP is a DDL (Data Definition Language) command.

• DELETE can be rolled back, while DROP cannot be rolled back.

• Example: DELETE FROM table_name WHERE condition; DROP TABLE table_name;

Autocalender creates a date table automatically, while duplicate creates a copy of a table and reference creates a linked table in Power BI.

• Autocalender automatically generates a date table based on the data in your model.

• Duplicate creates a copy of a table with the same data and structure.

• Reference creates a linked table that shares the same data as the original table.

• Autocalender is useful for quickly creating date t...read more