TaxCon Interview Questions and Answers

Enough testing is done when all the requirements are met and the risk of defects is acceptable.

• Ensure all requirements are tested

• Use risk analysis to determine acceptable defect rate

• Consider time and budget constraints

• Review test coverage and results

• Get feedback from stakeholders

Delete removes specific rows from a table, Drop deletes the entire table, and Truncate deletes all rows from a table.

• Delete is a DML operation while Drop and Truncate are DDL operations.

• Delete can be rolled back, while Drop and Truncate cannot be rolled back.

• Delete operation is slower compared to Drop and Truncate.

• Delete operation maintains the transaction log, while Drop and Truncate do not.

• Delete operation triggers delete triggers, while Drop and Truncate do not trigger any...read more

Differed state in JIRA is a state where an issue is waiting for an action or decision before it can be moved to the next state.

• Issues in differed state are not actively being worked on.

• They are waiting for a decision or action from someone else.

• Examples of differed state include 'Waiting for Customer' or 'Blocked'.

Smoke testing is a quick and shallow test to check if the critical functionalities of the application are working. Sanity testing is a more comprehensive test to check if the new changes or fixes have not affected the existing functionalities.

• Smoke testing is done to ensure that the application is stable enough for further testing.

• Sanity testing is done to ensure that the new changes or fixes have not introduced any new issues.

• Smoke testing is a subset of sanity testing.

• Smoke...read more

To join two tables, use the JOIN keyword in SQL and specify the columns to join on.

• Use the JOIN keyword in SQL

• Specify the columns to join on using ON keyword

• Types of JOINs: INNER, LEFT, RIGHT, FULL OUTER

• Example: SELECT * FROM table1 JOIN table2 ON table1.column = table2.column

There are process and technical difficulties in the current organization.

• Lack of documentation for processes and systems

• Inadequate training for new team members

• Outdated technology and infrastructure

• Poor communication between teams

• Inefficient incident management process