Business Analyst

1. DELETE : 
Basically, it is a Data Manipulation Language Command (DML). It is used to delete one or more tuples of a table. With the help of the “DELETE” command, we can either delete all the rows in one go or can delete rows one by one. i.e., we can use it as per the requirement or the condition using the Where clause. It is comparatively slower than the TRUNCATE command. The TRUNCATE command does not remove the structure of the table.
SYNTAX – 
If we want to delete all the rows of the table:
DELETE from;
SYNTAX – 
If we want to delete the row of the table as per the condition then we use the WHERE clause,
DELETE from WHERE ;
Note – Here we can use the “ROLLBACK” command to restore the tuple because it does not auto-commit.

2. DROP : 
It is a Data Definition Language Command (DDL). It is used to drop the whole table. With the help of the “DROP” command we can drop (delete) the whole structure in one go i.e. it removes the named elements of the schema. By using this command the existence of the whole table is finished or say lost. 
SYNTAX – 
If we want to drop the table:
DROP table ;
Note – Here we can’t restore the table by using the “ROLLBACK” command because it auto commits.

3. TRUNCATE : 
It is also a Data Definition Language Command (DDL). It is used to delete all the rows of a relation (table) in one go. With the help of the “TRUNCATE” command, we can’t delete the single row as here WHERE clause is not used. By using this command the existence of all the rows of the table is lost. It is comparatively faster than the delete command as it deletes all the rows fastly. 

SYNTAX – 
If we want to use truncate :
TRUNCATE;
Note – Here we can’t restore the tuples of the table by using the “ROLLBACK” command.

A measure is a field that can be aggregated in some way, such as a sum or an average. Think of it as something that can be collected, counted, or combined in some way to return a single value.
A dimension is a field that can be used to split up another field or measure into distinct groups. It can be used to define the level of detail to perform an aggregation on

The parameters in Tableau are the workbook variables like a number, date, or calculated field that allows users to replace a constant value in a calculation, filter, or reference line.
For example, the user can create a new calculated field that returns True if the aggregate of total marks is greater than 90% and returns False if it is less than 90%. Users can replace the constant value of "90%" in the formula with the parameters in Tableau as per the requirements. With the parameter control, users can dynamically vary the threshold values in their calculation.

A subquery is a query in a query. It is also called an inner query or a nested query. A subquery can be used anywhere an expression is allowed. It is a query expression enclosed in parentheses. Subqueries can be used with SELECT, INSERT, UPDATE, or DELETE statements.

Tip 1 : Be sure to do your homework on the organization and its culture before the interview.
Tip 2 : Employers want to understand how you use your time and energy to stay productive and efficient. Be sure to emphasize that you adhere to deadlines and take them seriously.
Tip 3 : Talk about a relevant incident that made you keen on the profession you are pursuing and follow up by discussing your education.