One Trust Software Engineer Interview Questions and Answers

Q1. There were two interviewers. I was interviewed in python. Two coding questions on python and one SQL question and few questions on projects and previous working experience and knowledge on linux.
Add your answer
Q2. What is your work experience
Add your answer
Q3. What are the projects you worked on
Add your answer

Q1. Some question were related to APIs
Add your answer
Q2. What is rest API
Ans. 
REST API is a set of rules and conventions for building and interacting with web services using HTTP methods.
• REST stands for Representational State Transfer

• Uses standard HTTP methods like GET, POST, PUT, DELETE

• Data is transferred in JSON or XML format

• Stateless communication between client and server

• Example: GET request to retrieve data from a server
Answered by AI
Add your answer

Q1. Discuss the project you are most proud of
Ans. 
Developed a mobile app for tracking personal fitness goals
• Used React Native to create a cross-platform app

• Implemented features such as goal setting, progress tracking, and workout logging

• Integrated with wearable devices like Fitbit for automatic data syncing
Answered by AI
Add your answer
Q2. What are ways to speed up SQL queries? List them in increasing order of complexity?
Ans. 
Ways to speed up SQL queries in increasing order of complexity
• Use indexes on columns frequently used in WHERE clauses

• Optimize queries by avoiding unnecessary joins and subqueries

• Use stored procedures to reduce network traffic and improve performance

• Consider denormalizing tables for frequently accessed data

• Use query optimization techniques like query caching and query hints
Answered by AI
Add your answer
Q3. Is Redis single-threaded or multi-threaded?
Ans. 
Redis is single-threaded.
• Redis is single-threaded, meaning it can only execute one command at a time.

• This design choice allows Redis to be extremely fast and efficient for certain use cases.

• However, it also means that Redis may not be the best choice for highly concurrent workloads.
Answered by AI
Add your answer
Q4. What sort of data types can be used as keys in Python?
Ans. 
Data types that can be used as keys in Python include strings, integers, floats, tuples, and custom objects.
• Strings are commonly used as keys in Python dictionaries.

• Integers and floats can also be used as keys.

• Tuples can be used as keys if they only contain immutable elements.

• Custom objects can be used as keys if they are hashable.

• Examples: {'name': 'John'}, {1: 'apple'}, {(1, 2): 'tuple'}
Answered by AI
Add your answer
Q5. What types of indexing exist in SQL?
Ans. 
Types of indexing in SQL include clustered, non-clustered, unique, and composite indexes.
• Clustered index physically reorders the table based on the index key

• Non-clustered index creates a separate structure for the index

• Unique index ensures that all values in the index column are unique

• Composite index uses multiple columns for indexing
Answered by AI
Add your answer

1 hr time limit. Some technical mathematical question, english grammar related, genral knowledge.

After clearing apti, they will assign machine test. 1 hr time limite.

Q1. After clearing assign technical round in that project managers giving interview. Asking Oops consept, some php technical quetions like php array function, global variables, mvc, mysal queries, joins, ind...read more
Add your answer

Q1. After clear interview first round, TL giving second round.
Add your answer

Q1. For salary discussion
Add your answer

Don’t panic. All rounds are easy

Q1. Oops concepts, some logical array programs
Add your answer

Q1. Agile methodology questions, describe your project structure etc
Add your answer

Q1. Company details, role and Payment discussion
Add your answer

Q1. Oops Concepts like Abstraction, difference between Abstract class and Method
Add your answer