Software Qa Automation Engineer Interview Questions and Answers

To solve the issue of mistakenly assigned gender values in SQL, you can update the incorrect values using SQL queries.

• Identify the incorrect gender values in the SQL table

• Use UPDATE statement with appropriate conditions to correct the values

• For example, if 'F' is mistakenly assigned for male, update it to 'M' using UPDATE statement

Count the occurrences of a particular word from a file.

• Read the file and store its contents in a string variable.

• Split the string into an array of words using a delimiter.

• Loop through the array and count the occurrences of the particular word.

• Return the count.