Sutherland Global Services Technical Consultant Interview Questions and Answers

Basic English and General aptitude questions

Q1. SImple salesforce question
Add your answer
Q2. They will give 2 coding question
Add your answer
Q3. NAAAAAAaaaaaaaaaaaa
Add your answer

Q1. Simple introduction
Add your answer
Q2. Salary discussion
Add your answer

Q1. Delete vs Drop in sql?
Ans. 
DELETE is used to remove rows from a table while keeping the table structure intact. DROP is used to remove an entire table from the database.
• DELETE is a DML (Data Manipulation Language) command, while DROP is a DDL (Data Definition Language) command.

• DELETE can be rolled back, while DROP cannot be rolled back.

• Example: DELETE FROM table_name WHERE condition; DROP TABLE table_name;
Answered by AI
Add your answer
Q2. Autocalender, duicate vs refrence in power bi
Ans. 
Autocalender creates a date table automatically, while duplicate creates a copy of a table and reference creates a linked table in Power BI.
• Autocalender automatically generates a date table based on the data in your model.

• Duplicate creates a copy of a table with the same data and structure.

• Reference creates a linked table that shares the same data as the original table.

• Autocalender is useful for quickly creating date t...read more
Answered by AI
Add your answer

Q1. Is live data is life cycle aware. If it's aware what does ViewModel do?
Ans. 
Yes
• LiveData is lifecycle aware and can be used to observe changes in data.

• ViewModel provides a way to store and manage UI-related data across configuration changes.

• ViewModel can hold LiveData objects to provide data to the UI.

• LiveData and ViewModel work together to ensure data consistency and prevent memory leaks.
Answered by AI
Add your answer
Q2. How does viewmodel survive when activity is destroyed on configuration?
Ans. 
The ViewModel survives configuration changes by being retained by the system.
• ViewModels are designed to survive configuration changes like screen rotations or language changes.

• When an activity is destroyed and recreated, the ViewModel is not destroyed and retains its data.

• The ViewModel is associated with the activity's lifecycle and is retained until the activity is finished.

• The retained ViewModel instance can be acces...read more
Answered by AI
Add your answer
Q3. Advantage of mvp over mvc.
Ans. 
MVP offers better separation of concerns and easier unit testing compared to MVC.
• MVP separates the presentation layer from the business logic, making it easier to maintain and modify the codebase.

• MVP allows for easier unit testing as the presenter can be tested independently from the view.

• MVP provides better decoupling between components, enabling easier code reuse and scalability.

• MVP promotes a clear separation of con...read more
Answered by AI
Add your answer
Q4. How does SSL pinning works?
Ans. 
SSL pinning is a security technique that ensures a client only communicates with a server using a pre-defined public key.
• SSL pinning involves hardcoding the server's public key in the client's code or configuration.

• During the SSL handshake, the client checks if the server's public key matches the pinned key.

• If the keys match, the connection is established; otherwise, it is rejected.

• Pinning prevents man-in-the-middle at
Answered by AI
Add your answer
Q5. How do you achieve data security when saving data persistanly.
Ans. 
Data security can be achieved through encryption, access controls, backups, and regular security audits.
• Encrypt sensitive data using strong encryption algorithms.

• Implement access controls to restrict unauthorized access to the data.

• Regularly backup the data to prevent data loss.

• Conduct regular security audits to identify and fix vulnerabilities.

• Use secure protocols and communication channels for data transfer.

• Implement...read more
Answered by AI
Add your answer
Q6. Where to save encription key?
Ans. 
Encryption keys should be securely stored in a separate key management system.
• Encryption keys should not be stored alongside the encrypted data.

• Use a dedicated key management system (KMS) to store and manage encryption keys.

• Implement strong access controls and authentication mechanisms for the KMS.

• Consider using hardware security modules (HSMs) for added security.

• Regularly rotate encryption keys to minimize the impact
Answered by AI
Add your answer

Regular engineering basics and some logical questions

Q1. Some technical questions related to BE
Add your answer
Q2. Micro controller and Mocro processor working
Ans. 
Microcontrollers are integrated circuits that contain a processor core, memory, and programmable input/output peripherals, while microprocessors are just the processor core.
• Microcontrollers are used in embedded systems and have all components on a single chip.

• Microprocessors require external components like memory and peripherals to function.

• Examples of microcontrollers include Arduino, PIC, and Raspberry Pi.

• Examples o...read more
Answered by AI
Add your answer

Q1. About yourself, future plans, about the company that you want to jojn
Add your answer

Q1. Related to profiles
Add your answer
Q2. Related to job profile
Add your answer

Q1. Salary and type of job
Add your answer

Q1. Related your past experience
Add your answer

There will be ask 30 MCQ's in 30 minutes when I was attend for Aptitude test
It was conducted virtual

There will be 2 coding questions asked we have to complete one of it .If we practice well very easy to clear .

Q1. In my case Technical & HR both conducted in same time it starts with introduction and later some behavioural questions and after that some basic Technical questions.
Add your answer
Q2. 1.Tell me about yourself ?
Ans. 
I am a highly motivated individual with a passion for technology and problem-solving.
• I have a degree in Computer Science and have completed several internships in the tech industry.

• I am proficient in programming languages such as Java and Python.

• I enjoy working in a team environment and collaborating to find innovative solutions.

• In my free time, I enjoy tinkering with new technologies and building personal projects.

• I a...read more
Answered by AI
Add your answer
Q3. 2.What are your strengths & weakness?
Ans. 
My strengths include problem-solving, adaptability, and teamwork. My weakness is public speaking.
• Strengths: problem-solving (e.g. finding solutions to complex technical issues), adaptability (e.g. quickly adjusting to new technologies or work environments), teamwork (e.g. collaborating effectively with colleagues)

• Weakness: public speaking (e.g. nervousness when presenting to large groups)
Answered by AI
Add your answer
Q4. 3.What are Constructors?
Ans. 
Constructors are special methods used to initialize objects in a class.
• Constructors have the same name as the class they belong to.

• They are called automatically when an object is created.

• They can be used to set default values for object properties.

• Constructors can be overloaded to accept different parameters.

• Example: public class Car { public Car() { //default constructor } public Car(String make) { //overloaded constr
Answered by AI
Add your answer
Q5. 4 .Write a program on floating numbers in java?
Ans. 
A program on floating numbers in Java.
• Declare a variable with float or double data type.

• Perform arithmetic operations on floating point numbers.

• Use formatting options to display floating point numbers.

• Be aware of precision and rounding errors.
Answered by AI
Add your answer
Q6. 5.What are your hobbies?
Ans. 
I enjoy reading, hiking, and playing board games.
• Reading: I love getting lost in a good book, especially science fiction and fantasy.

• Hiking: I enjoy exploring new trails and challenging myself physically.

• Board games: I like playing strategy games with friends and family, such as Settlers of Catan and Ticket to Ride.
Answered by AI
Add your answer
Q7. 6.Anything else you want to ask ?
Add your answer