Manohar Lal Jewellers Interview Questions and Answers

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

Q1. Must power sell, how to bid placed on iex exchange.
Ans. 
Power selling on IEX involves strategic bidding to optimize energy sales and maximize profits.
• Understand the market dynamics: Analyze demand and supply trends on IEX.

• Set competitive bid prices: Ensure your bid is attractive compared to others.

• Utilize advanced bidding strategies: Consider using block bids for larger quantities.

• Monitor real-time data: Keep an eye on market fluctuations to adjust bids accordingly.

• Review p...read more
Answered by AI
Add your answer
Q2. How to discover rate in iex exchange?
Ans. 
Discovering rates in the IEX exchange involves analyzing market data and using specific tools and APIs.
• Utilize the IEX Cloud API to access real-time and historical market data.

• Check the IEX website for the latest stock prices and trading volumes.

• Use financial analysis tools like TradingView or Bloomberg to visualize rate trends.

• Monitor news and reports that may affect stock rates on the IEX exchange.
Answered by AI
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