FRSPL Test Analyst Interview Questions and Answers for Experienced

Database stores data for applications, data warehouse stores data for analysis.

• Database is used for transactional processing, data warehouse is used for analytical processing.

• Database stores current data, data warehouse stores historical data.

• Database is optimized for read and write operations, data warehouse is optimized for read operations.

• Examples of databases include MySQL, Oracle, and SQL Server. Examples of data ...read more

Views tables difference

• Views are virtual tables that display data from one or more tables

• Views do not store data, whereas tables do

• Views can be used to restrict access to certain columns or rows

• Tables can be modified directly, whereas views cannot

Cast function is used to change the datatype of a value or expression in SQL.

• Syntax: CAST(expression AS datatype)

• Example: CAST('123' AS INT) will convert the string '123' to integer datatype

• Supported datatypes: INT, FLOAT, DECIMAL, CHAR, VARCHAR, DATE, TIME, etc.

Datatype consistency in minus query

• Datatype of selected columns should remain same for minus query

• Mismatch can cause errors or unexpected results

Both have their own advantages and disadvantages depending on the use case.

• Star schema is simpler and easier to understand, but may not be suitable for complex data relationships.

• Snowflake schema is more normalized and can handle complex data relationships, but can be more difficult to understand and maintain.

• The choice between the two depends on the specific requirements of the project and the data being analyzed.

• For ...read more

Regression testing is the process of retesting modified software to ensure that previously working functionalities are still intact.

• Regression testing is performed after making changes to software to ensure that the existing functionalities are not affected.

• It helps in identifying any new defects or issues introduced due to the changes made.

• It involves re-executing test cases that cover the affected areas of the softwa...read more