Bynry Interview Questions and Answers

Q1. They asked me about a challenging project I had worked on.
Add your answer
Q2. They also asked how I stay updated with the latest technologies.
Add your answer

Q1. Best interview has been taken here
Add your answer

Q1. Good interview has been took here
Add your answer

Q1. Introducing your self and project
Add your answer
Q2. Severity and priority
Add your answer
Q3. Smoke and sanity testing
Add your answer
Q4. Scenario base question if find bug before release
Add your answer

Q1. What is the default index type
Ans. 
B-tree index is the default index type in Oracle database.
• Default index type in Oracle is B-tree index

• B-tree index is suitable for range queries and equality searches

• Other index types in Oracle include bitmap index and function-based index
Answered by AI
Add your answer
Q2. What is the causes of query slowness
Ans. 
Causes of query slowness can include inefficient queries, lack of indexes, outdated statistics, hardware limitations, and network latency.
• Inefficient queries - poorly written queries that do not utilize indexes or join tables unnecessarily

• Lack of indexes - missing indexes on columns frequently used in queries

• Outdated statistics - outdated or inaccurate statistics can lead to poor query execution plans

• Hardware limitatio...read more
Answered by AI
Add your answer
Q3. How to resolve query slowness
Ans. 
To resolve query slowness, analyze query execution plan, optimize indexes, update statistics, consider partitioning.
• Analyze query execution plan to identify bottlenecks

• Optimize indexes to improve query performance

• Update statistics to ensure the query optimizer has accurate information

• Consider partitioning large tables to improve query performance
Answered by AI
Add your answer

Coding Test consists of 3 Problem Question (2 Logical questions and 1 SQL Query ) and Around 20 MCQS
Platform - CoderByte

30 Aptitude Question
3 Mail Writing Question

Q1. Explain 1st Problem Solved in Coding Test. Optimize it.
Ans. 
Solved a sorting problem by implementing quicksort algorithm.
• Implemented quicksort algorithm to efficiently sort the array.

• Used recursion to divide the array into smaller subarrays and sort them individually.

• Optimized the algorithm by choosing a pivot element strategically to minimize comparisons.
Answered by AI
Add your answer
Q2. Explain 2nd Problem Solved in Coding Test. I failed 1 test case in 1st round which was told to solve again.
Add your answer
Q3. Explain 3rd Question based on SQL Query.
Ans. 
The 3rd question based on SQL query likely refers to a specific query or scenario related to SQL.
• Understand the context of the query being asked about

• Analyze the structure and purpose of the SQL query

• Explain the expected output or result of the query
Answered by AI
Add your answer
Q4. Write a code to Reverse Digits.
Ans. 
Code to reverse digits of a number
• Use modulo operator to extract the last digit of the number

• Multiply the result by 10 and add the next digit until all digits are reversed

• Handle negative numbers separately by converting to positive before reversing
Answered by AI
View 1 more answer
Q5. A problem question for solving a SQL Query.
Add your answer

Q1. Communication evaluation
Add your answer

Q1. Discussion on previously handled projects
Add your answer