Sophos Technologies Academic Counsellor Interview Questions and Answers

Q1. Few linux commands
Add your answer
Q2. Explain few, Any command for example
Ans. 
Some common commands for technical support engineers include ping, ipconfig, and tracert.
• Ping: Used to test the reachability of a host on an IP network.

• Ipconfig: Displays all current TCP/IP network configuration values.

• Tracert: Shows the route that packets take to reach a specified destination.
Answered by AI
Add your answer

Basics test, maths and logical

Q1. Server and basics Linux comands
Add your answer
Q2. Are you good with night shifts
Add your answer

Q1. Find the last 2 row in sql?
Add your answer

Q1. Questions regarding CV Backround
Add your answer

Mcq based on javascript linux sql

Q1. Tell me about yourself
Add your answer
Q2. Your tech skills
Add your answer
Q3. About sql and javascript
Add your answer

Q1. Most of the questions were scripting related
Add your answer
Q2. There were few questions regarding ServiceNow Core functionalities
Add your answer

Q1. The Questions were asked about scripting and debugging
Add your answer

Q1. Questions were asked regarding servicenow scripting and functionalities
Add your answer

Q1. It was an managerial round where they evaluate your behaviour skills and attitude
Add your answer

Q1. Salary discussion and onboarding process
Add your answer

First round include mcq related sql ,linux

Q1. It is related to my project it was easy
Add your answer
Q2. Question about join in sql
Add your answer

Q1. Service now question bussines rule etc
Add your answer

Q1. Behaviour question like why service now
Add your answer

Q1. How to solve the error in the code? what is scope? what are logical operators?
Ans. 
Scope refers to the visibility and accessibility of variables in a program. Logical operators are used to perform logical operations in code.
• Scope in programming refers to where in the code a variable can be accessed. It can be global, local, or block scope.

• To solve an error in the code, first identify the error message or behavior causing the issue. Then, debug the code by checking for syntax errors, logical errors, o...read more
Answered by AI
Add your answer
Q2. How will you get the data in the table using js? what are the other ways to print the output? what is a block in js?
Ans. 
To get data in a table using js, you can use DOM manipulation methods like getElementById or querySelector. Other ways to print output include console.log and innerHTML. A block in js is a set of statements enclosed in curly braces.
• Use getElementById or querySelector to get data in a table using js

• Other ways to print output include console.log and innerHTML

• A block in js is a set of statements enclosed in curly braces,
Answered by AI
Add your answer

Q1. About ServiceNow? About the technical role in my previous company? previous job roles and responsibilities? Why do you want to switch from previous company? How will you handle the challenges here in servi...read more
Add your answer
Q2. Why do I want to switch from my previous company?
Ans. 
Seeking new challenges and growth opportunities in a different environment.
• Looking for new challenges and opportunities for growth

• Interested in gaining experience in a different industry or technology

• Seeking a better work-life balance or company culture

• Wanting to work with a different team or leadership style
Answered by AI
Add your answer

Q1. What is shell in linux?
Ans. 
Shell in Linux is a command-line interpreter that allows users to interact with the operating system by executing commands.
• Shell is a program that takes commands from the keyboard and gives them to the operating system to perform.

• It can also be used to automate tasks by writing scripts.

• Common shells in Linux include Bash, Zsh, and Ksh.

• Shell scripting allows users to write programs that can be executed by the shell.

• Exam...read more
Answered by AI
Add your answer
Q2. What are the different types of joins
Ans. 
Different types of joins include inner join, outer join, left join, and right join.
• Inner join: Returns rows when there is a match in both tables

• Outer join: Returns all rows when there is a match in one of the tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table
Answered by AI
Add your answer

Q1. How to tune a sql query?
Ans. 
Tuning a SQL query involves optimizing its performance by adjusting various factors.
• Identify slow-performing queries using tools like SQL Profiler or Execution Plan.

• Optimize query structure by using appropriate indexes and avoiding unnecessary joins.

• Consider rewriting the query to use more efficient techniques like subqueries or CTEs.

• Update statistics and ensure database indexes are up to date.

• Limit the number of rows ...read more
Answered by AI
Add your answer
Q2. How to find errors in log files in linux
Ans. 
Errors in log files in Linux can be found by searching for keywords, timestamps, and error codes.
• Use 'grep' command to search for specific keywords or error codes in log files

• Look for timestamps to identify when errors occurred

• Check for any error messages or warnings that may indicate issues

• Use 'tail' command to view the end of log files for recent errors

• Consider using 'journalctl' command for system logs in systemd-ba
Answered by AI
Add your answer