CredenTek Software & Consultancy Interview Questions, Process, and Tips

Q1. What is a test case in software testing?
Ans. 
A test case in software testing is a set of conditions or variables under which a tester will determine whether a system under test is working correctly or not.
• A test case includes preconditions, inputs, expected outcomes, and postconditions.

• It helps in identifying defects or errors in the software.

• Examples of test cases include verifying login functionality, checking data validation, and testing performance under load...read more
Answered by AI
Add your answer

Q1. Introduction, family background and educational qualifications
Add your answer

Q1. Third highest salary in emp table?
Ans. 
To find the third highest salary in emp table, we need to use the ORDER BY and LIMIT clauses.
• Use ORDER BY to sort the salaries in descending order.

• Use LIMIT to select the third highest salary.

• Example query: SELECT salary FROM emp ORDER BY salary DESC LIMIT 2,1
Answered by AI
Add your answer
Q2. What is join and write down one example?
Ans. 
Join is used to combine rows from two or more tables based on a related column between them.
• Join is used to retrieve data from multiple tables in a single query.

• There are different types of joins like inner join, left join, right join, and full outer join.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Answered by AI
Add your answer

Q1. Technical questions on SQL Linux and windows
Add your answer
Q2. Technical questions on SQL windows and Linux commands
Add your answer

60 min, aptitude, coding mcq

Q1. Find second highest salary of an employee
Add your answer
Q2. Programming of design pattern
Ans. 
Design patterns are reusable solutions to common problems in software design.
• Design patterns help in creating maintainable and scalable code.

• Examples include Singleton, Factory, Observer, and Strategy patterns.

• Each design pattern has a specific purpose and can be applied in different scenarios.
Answered by AI
Add your answer