Sony Pictures Entertainment Interview Questions and Answers

Q1. What is an LVM
Ans. 
LVM stands for Logical Volume Manager, a tool used in Linux systems to manage disk space by creating logical volumes from physical volumes.
• LVM allows for dynamic resizing of logical volumes without needing to unmount the filesystem

• It provides features like striping, mirroring, and snapshots for data management

• Common LVM commands include pvcreate, vgcreate, lvcreate, lvextend, lvreduce

• Example: Creating a new logical vol...read more
Answered by AI
Add your answer
Q2. How to check the open ports
Ans. 
To check open ports, use tools like netstat, nmap, or telnet
• Use netstat command to display all open ports on a system

• Use nmap tool to scan for open ports on a remote system

• Use telnet command to check if a specific port is open on a remote host
Answered by AI
Add your answer

Q1. What is a file storage and block storage
Ans. 
File storage stores data in files and folders, while block storage stores data in blocks or chunks.
• File storage organizes data in a hierarchical structure of files and folders, similar to a traditional file system.

• Block storage breaks data into blocks or chunks and stores them in a raw format without any file system structure.

• File storage is commonly used for storing documents, images, videos, etc., while block storage...read more
Answered by AI
Add your answer
Q2. How do you troubleshoot a server
Ans. 
To troubleshoot a server, start by checking for hardware issues, then move on to software problems and network connectivity.
• Check hardware components such as power supply, CPU, RAM, and storage devices for any issues or failures.

• Review system logs and error messages to identify any software-related issues or conflicts.

• Verify network connectivity by checking cables, switches, routers, and firewall settings.

• Use diagnosti...read more
Answered by AI
Add your answer

Q1. HTML5 CSS3 Basics and Advanced
Add your answer
Q2. Javascript Basics and Advanced
Add your answer

Q1. RO basic questions Wiring Installation Electrical consumption unit Hvac
Add your answer

45 mins coding test having javascript and react questions

Q1. Print the character and the count of character on UI whenever a keystroke happens , implement it in react
Ans. 
Implement a feature in React to display the character and count of characters on UI on each keystroke.
• Use state to store the input value and update it on each keystroke.

• Use a function to count the characters in the input value and display the result on the UI.

• Use event listeners to detect keystrokes and trigger the character count update.
Answered by AI
Add your answer
Q2. Questions about micro-frontend, web workers, best react practices
Add your answer

Q1. How do you optimize frontend code
Ans. 
Optimizing frontend code involves minimizing file sizes, reducing HTTP requests, using efficient algorithms, and implementing caching strategies.
• Minimize file sizes by removing unnecessary code, using minification tools, and optimizing images.

• Reduce HTTP requests by combining files, using sprites, and lazy loading resources.

• Use efficient algorithms and data structures to improve performance.

• Implement caching strategies...read more
Answered by AI
Add your answer
Q2. How do you collaborate in team
Ans. 
I collaborate in team by actively participating in discussions, sharing ideas, providing feedback, and working together towards common goals.
• Actively participate in team meetings and discussions

• Share ideas and insights with team members

• Provide constructive feedback on others' work

• Collaborate on projects by dividing tasks and working together towards common goals
Answered by AI
Add your answer

Q1. General strenghts and weakness questions
Add your answer
Q2. Past experience , conflict handling
Add your answer

Q1. Find 3rd transaction of user from uber cab dataset
Ans. 
To find the 3rd transaction of a user from the Uber cab dataset.
• Identify the user's transactions in the dataset

• Sort the transactions by date/time

• Select the 3rd transaction of the user
Answered by AI
Add your answer
Q2. Find last quarter ordered product from logistics dataset
Ans. 
To find the last quarter ordered product from logistics dataset.
• Identify the date range for the last quarter

• Filter the dataset for orders within that date range

• Identify the product ordered in the last quarter
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. Explain how power bi works
Add your answer

Q1. Merge 2 sorted Arrays
Ans. 
Merging two sorted arrays into a single sorted array
• Create a new array to store the merged result

• Use two pointers to iterate through both arrays and compare elements

• Add the smaller element to the new array and move the pointer for that array
Answered by AI
Add your answer
Q2. Write polyfill for getElementById
Ans. 
Polyfill for getElementById function in JavaScript
• Create a function named getElementById

• Check if the function already exists, if not, create it

• Use document.querySelector to select the element by ID

• Return the selected element
Answered by AI
Add your answer
Q3. What are the new features in React 18 ? Optimisation techinques in React ? Concurrency in React ?
Ans. 
React 18 introduces new features like automatic batching, start transition, and streaming server renderer. It also focuses on performance optimizations and concurrent rendering.
• New features in React 18 include automatic batching, start transition, and streaming server renderer.

• Optimization techniques in React 18 involve concurrent rendering, improved scheduling, and reduced re-renders.

• Concurrency in React 18 allows for...read more
Answered by AI
Add your answer

Q1. HLD round to develop Autocomplete feature End to End with API contracts and architecture.
Add your answer
Q2. Remove duplicate characters from a sentence
Ans. 
Remove duplicate characters from a sentence
• Create an empty array to store unique characters

• Iterate through each character in the sentence

• Check if the character is already in the array, if not add it
Answered by AI
Add your answer

Q1. Explain oracle Archit
Ans. 
Oracle architecture is a multi-tiered system with components like client, server, and database.
• Oracle architecture consists of client, server, and database components.

• The client communicates with the server to access the database.

• The server processes the client's requests and interacts with the database.

• The database stores and manages the data.

• Oracle architecture is designed to be scalable and secure.
Answered by AI
Add your answer
Q2. About pacting the database
Add your answer