Micron Technology Interview Questions and Answers

Online assesment aptitude, 3 SQL questions, 2 easy DSA coding questions.
2d square grid traversal

Q1. SQL only Window functions, case switch statements, remove duplicate from table, aggregate functions If you are good at python plus points If you have basic idea/previous work experience with GCP you can ...read more
Add your answer

Q1. Goals, where do see your self in 4 years(say that you will work at micron for a long time, don't say shit like I want to pursue higher studies) What does success mean to you
Add your answer

Q1. Write a spark program to find the word with maximum length in a given string
Ans. 
Use Spark program to find word with maximum length in a given string
• Split the string into words using space as delimiter

• Map each word to its length

• Find the word with maximum length using reduce operation
Answered by AI
Add your answer
Q2. Write an sql query to change rows into columns and vice versa
Ans. 
Use SQL pivot function to change rows into columns and vice versa
• Use the PIVOT function in SQL to transform rows into columns

• Use the UNPIVOT function in SQL to transform columns into rows

• Example: SELECT * FROM table_name PIVOT (SUM(value) FOR column_name IN (value1, value2, value3))

• Example: SELECT * FROM table_name UNPIVOT (value FOR column_name IN (value1, value2, value3))
Answered by AI
Add your answer
Q3. Write an sql query to fetch duplicate rows in a table
Ans. 
SQL query to fetch duplicate rows in a table
• Use GROUP BY and HAVING clause to identify duplicate rows

• Select columns to check for duplicates

• Example: SELECT column1, column2, COUNT(*) FROM table_name GROUP BY column1, column2 HAVING COUNT(*) > 1;
Answered by AI
Add your answer
Q4. Diff between repartition and colaesce, clustering and partitioning in bq
Ans. 
Repartition increases or decreases the number of partitions in a DataFrame, while coalesce only decreases the number of partitions. Clustering is used for organizing data within a partition, while partitioning is dividing data into logical units.
• Repartition increases or decreases the number of partitions in a DataFrame, which can be useful for parallelism and performance optimization.

• Coalesce only decreases the number ...read more
Answered by AI
Add your answer

Q1. Design SW timer library that handles multiple clients and HW supports 1us granularity.
Ans. 
Design a software timer library for multiple clients with 1us granularity support.
• Use a priority queue to manage timers based on expiration time.

• Implement a callback mechanism for clients to receive notifications.

• Support multiple timer types: one-shot, periodic, and delayed timers.

• Ensure thread safety for concurrent access from multiple clients.

• Provide an API for clients to create, cancel, and query timers.
Answered by AI
Add your answer
Q2. Sliding window pattern questions.
Add your answer

Q1. Basic concepts about OOPs and asked to code examples of polymorphism
Add your answer
Q2. Asked to write down SQL queries based on scenario
Add your answer
Q3. Discussion on docker and frontend.
Add your answer
Q4. My interview went nice. I nearly got all answers. But my resume was more OS related and it didn't matched with their requirements
Add your answer

Q1. How to predict if a 32 bit number is divisible by 8, draw a circuit using gates
Ans. 
To predict if a 32 bit number is divisible by 8, design a circuit using gates.
• Use a circuit with AND, OR, and NOT gates to check if the last three bits of the number are all zeros.

• If the last three bits are zeros, then the number is divisible by 8.

• For example, if the 32 bit number is 11010000, the last three bits are zeros, so it is divisible by 8.
Answered by AI
Add your answer
Q2. Various verilog scripting questions
Add your answer

Q1. What is normalization
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization is used to eliminate data redundancy by breaking up tables into smaller, related tables.

• It helps in reducing data anomalies such as insertion, update, and deletion anomalies.

• Normalization is achieved through a series of stages called normal forms, with the most common being First Normal Form (1NF)...read more
Answered by AI
Add your answer
Q2. Code for armstrong alogrithm
Ans. 
Armstrong algorithm is used to find Armstrong numbers in a given range.
• Iterate through the numbers in the given range

• Calculate the sum of cubes of each digit in the number

• Check if the sum is equal to the original number
Answered by AI
Add your answer