ORYX GTL Interview Questions and Answers

Q1. Basic java questions
Add your answer
Q2. Sql related questions
Add your answer

Q1. Work experience
Ans. 
I have over five years of experience in management, focusing on team leadership, project coordination, and operational efficiency.
• Led a team of 10 in a retail environment, improving sales by 20% through effective training and motivation.

• Managed multiple projects simultaneously, ensuring timely delivery and adherence to budget constraints.

• Implemented a new inventory management system that reduced stock discrepancies by ...read more
Answered by AI
Add your answer
Q2. How many experiance
Add your answer

Q1. Current ctc discussion
Add your answer

Basic to medium questions on array string SQL

Q1. Project related questions
Add your answer

Q1. What are your salary expectations?
Ans. 
I am looking for a competitive salary that reflects my skills and experience, ideally in the range of $70,000 to $90,000.
• Research industry standards: For example, Glassdoor indicates that Business Analysts in my area earn between $70,000 and $90,000.

• Consider my experience: With 5 years in the field, I bring valuable insights and skills that can drive business success.

• Discuss benefits: I value a comprehensive benefits p...read more
Answered by AI
Add your answer
Q2. What is your family background?
Add your answer
Q3. What do you know about company? what type of products company develops?
Ans. Brief: 4 types of products, I recommend to visit the website of the company for updated details.
Answered Anonymously
Add your answer

Q1. Tell me about yourself?
Ans. Start by telling your name, your hometown, your qualifications, your previous jobs, your job profile in previous companies, why you want to join at a current job profile.
Answered Anonymously
Add your answer
Q2. Questions about projects, your academics.
Add your answer

Basic aptitude followed with english and reasoning

Q1. Core java technical questions , spring , spring boot
Add your answer
Q2. What is JIT in java
Add your answer
Q3. Explain lifecyxle of thread in java
Ans. 
The lifecycle of a thread in Java includes several stages from creation to termination.
• A thread is created using the Thread class or implementing the Runnable interface.

• The thread goes through the new, runnable, and blocked states before running.

• Once running, the thread can be paused, resumed, or stopped.

• Finally, the thread reaches the terminated state and cannot be restarted.
Answered by AI
Add your answer

Q1. Explain the acid properties
Ans. 
ACID properties ensure reliable transactions in databases: Atomicity, Consistency, Isolation, Durability.
• Atomicity: Transactions are all-or-nothing. Example: If a bank transfer fails, no money is deducted.

• Consistency: Transactions must leave the database in a valid state. Example: A transaction should not violate any integrity constraints.

• Isolation: Transactions occur independently. Example: Concurrent transactions do ...read more
Answered by AI
Add your answer
Q2. Explain the indexing
Ans. 
Indexing is a data structure technique that improves the speed of data retrieval operations on a database or data set.
• Indexing creates a data structure (like a B-tree) that allows for faster searches.

• For example, a book index helps locate topics quickly without scanning every page.

• In databases, an index on a column allows for quicker query results, e.g., searching for a user by email.

• Indexes can be unique (no duplicate...read more
Answered by AI
Add your answer

Q1. Sql queries asking in
Ans. 
SQL queries for Business Analysts focus on data retrieval, manipulation, and reporting from databases.
• Understand basic SQL commands: SELECT, INSERT, UPDATE, DELETE.

• Use JOINs to combine data from multiple tables. Example: SELECT * FROM Orders JOIN Customers ON Orders.CustomerID = Customers.CustomerID.

• Utilize WHERE clause for filtering data. Example: SELECT * FROM Products WHERE Price > 100.

• Aggregate functions like CO...read more
Answered by AI
Add your answer
Q2. Python questions asked in
Add your answer

Q1. What is your minimum salary expectation?
Add your answer
Q2. Are you planning to stay long-term in this position?
Ans. 
I am committed to long-term growth and contribution in this position, aligning my goals with the company's vision.
• I believe in building strong relationships with my team and the organization, which takes time and dedication.

• For example, I aim to take on increasing responsibilities and contribute to long-term projects.

• I am eager to develop my skills and grow within the company, ensuring I can add value over time.

• I see t...read more
Answered by AI
Add your answer