Blue Yonder Plsql Developer Interview Questions and Answers

Q1. What is dirty read
Ans. 
Dirty read is when a transaction reads data that has been modified by another transaction but not yet committed.
• Occurs when a transaction reads uncommitted data from another transaction

• Can lead to inconsistent or incorrect results

• Can be prevented by using proper isolation levels in database transactions
Answered by AI
Add your answer
Q2. Count of rows in inner join, left join, right join
Ans. 
Count of rows in different types of joins in SQL
• Inner join: Counts only the rows that have matching values in both tables

• Left join: Counts all rows from the left table and the matching rows from the right table

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

Q1. Basic SQL questions
Add your answer
Q2. Advanced PLSQL questions
Add your answer

DSA based on any general language prefer C++

Q1. DBMS, BST, Sieve of Erathnus, Dynamic Programming
Add your answer
Q2. Debugging c++ code
Add your answer
Q3. OOPS based question
Add your answer

Q1. General questions and some questions on personality
Add your answer

Q1. What is your approach to building basic logic skills?
Ans. 
My approach to building basic logic skills involves practicing problem-solving exercises, breaking down complex problems into smaller parts, and seeking feedback to improve.
• Practice problem-solving exercises regularly to strengthen logical thinking abilities.

• Break down complex problems into smaller, more manageable parts to better understand the problem and find solutions.

• Seek feedback from peers or mentors to identify...read more
Answered by AI
Add your answer

Q1. Some behavioural questions?
Add your answer

Q1. Basics about angular
Add your answer
Q2. Javascript concepts
Add your answer

Technical MCQ questions on core computer science subjects were asked.

Q1. How to find whether the given linked list has loop in it?
Add your answer
Q2. Explain osi model with example of browser.
Add your answer

Q1. Javascript question
Add your answer

Python code for solving a string usecase using stack, SQL join and groupby queries