Saiesh Technologies Interview Questions and Answers

Update query syntax in SQL and its purpose

• Syntax: UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition

• Used to modify existing records in a table

• Helps to keep data up-to-date and accurate

• Can be used to update a single column or multiple columns at once

• Example: UPDATE employees SET salary = 50000 WHERE department = 'IT'

No, internet is not required to access standalone applications.

• Standalone applications are designed to work independently without internet connectivity.

• They are installed on the local machine and can be accessed without any internet connection.

• Examples of standalone applications are Microsoft Word, Adobe Photoshop, etc.

Standalone apps run on a single device, web apps run on a server accessed through a browser, and cloud apps run on remote servers.

• Standalone apps are installed on a device and do not require an internet connection.

• Web apps are accessed through a browser and require an internet connection.

• Cloud apps are hosted on remote servers and accessed through the internet.

• Web apps and cloud apps can be accessed from multiple devices.

• Examples of standalone apps include Microsoft Word and ...read more

The process to purchase something from the market involves several steps.

• Identify the item to be purchased

• Check the availability of the item in the market

• Compare prices and quality of the item from different shops

• Select the shop to purchase the item from

• Check the payment options available

• Make the payment

• Collect the item and check for any damages

• Take the receipt and keep it for future reference

Boundary value analysis is a testing technique that involves testing values at the edges or boundaries of input domains.

• It helps identify errors that occur at the boundaries of input values

• It involves testing values at the upper and lower limits of input domains

• It is used to ensure that the software behaves correctly when it encounters boundary values

• For example, if a program accepts values between 1 and 100, boundary value analysis would test values like 1, 100, and 101

Manual testing is a process of verifying software manually to find defects and ensure it meets requirements.

• Manual testing involves executing test cases manually without the use of automation tools

• It requires a tester to have a deep understanding of the software being tested and the ability to identify defects

• Manual testing can be time-consuming and repetitive, but it is essential for ensuring software quality

• Examples of manual testing include functional testing, regression t...read more