Vivekananda International School Chandil Interview Questions and Answers

WHERE clause is used in SQL to filter records based on a specified condition.

• Used in SELECT, UPDATE, DELETE statements

• Filters records based on specified condition

• Can use logical operators like AND, OR

• Example: SELECT * FROM table_name WHERE column_name = 'value'

Query using JOINS in SQL

• Use JOIN keyword to combine rows from two or more tables based on a related column between them

• Types of JOINs include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

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

SDLC is the process of developing software, while STLC is the process of testing software.

• SDLC focuses on the development of software from planning to deployment.

• STLC focuses on the testing of software to ensure quality and functionality.

• SDLC includes phases like requirements gathering, design, coding, and deployment.

• STLC includes phases like test planning, test design, test execution, and test closure.

Test case design techniques are methods used to create test cases for software testing.

• Boundary Value Analysis: Testing at the boundaries of input ranges.

• Equivalence Partitioning: Dividing input data into classes and testing one from each class.

• Decision Table Testing: Creating a table of possible inputs and their corresponding outputs.

• State Transition Testing: Testing different states of the system and transitions between them.

• Use Case Testing: Testing scenarios based on user...read more

Types of Black Box testing include functional, non-functional, regression, and usability testing.

• Functional testing focuses on the behavior of the software, without looking at the internal code.

• Non-functional testing checks aspects like performance, security, and scalability.

• Regression testing ensures that new changes do not negatively impact existing functionality.

• Usability testing evaluates the user-friendliness of the software.