Trilogic Digital Media Interview Questions and Answers

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. 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

Q1. Two Pointer Technique question to get the highest sum from two sorted list by jumping from one list to another list on common element.
Add your answer
Q2. Combine two sorted array such as first element would be the lowest element and second would be the largest element as so on.
Ans. 
Merge two sorted arrays with alternating lowest and highest elements.
• Create a new array to store the result

• Use two pointers to iterate through the two input arrays

• Alternate between adding the lowest and highest elements to the result array
Answered by AI
Add your answer

Q1. Design SplitWise
Ans. 
SplitWise is a platform for splitting expenses among friends or groups.
• Allow users to create groups and add expenses

• Calculate each user's share of the expenses

• Send notifications to users for pending payments

• Support multiple currencies for international groups
Answered by AI
Add your answer

Q1. Design API Rate Limiter
Ans. 
Design API Rate Limiter to control the number of requests a user can make within a specific time frame.
• Implement a token bucket algorithm to track and limit the number of requests per user.

• Use a sliding window to track the time frame for request limits.

• Consider using a distributed cache like Redis to store and manage request limits.

• Provide appropriate error responses when the rate limit is exceeded.

• Allow for customizat...read more
Answered by AI
Add your answer

Q1. Tell me about yourself?
Ans. 
Experienced professional with a background in management and a proven track record of leading teams to success.
• Over 5 years of experience in management roles

• Strong leadership skills demonstrated through successful team projects

• Excellent communication and problem-solving abilities

• Bachelor's degree in Business Administration from XYZ University

• Previous experience as a Team Leader at ABC Company
Answered by AI
Add your answer
Q2. Information about previous EXP?
Ans. 
I have 5 years of experience in retail management, including 2 years as an Assistant Manager.
• 5 years of experience in retail management

• 2 years as an Assistant Manager

• Strong leadership and team management skills

• Experience in inventory management and sales forecasting
Answered by AI
Add your answer

Q1. Salary discussion
Add your answer
Q2. Tell about notice period
Ans. 
Notice period refers to the amount of time an employee must give before leaving a job.
• Notice period is typically stated in the employment contract.

• It can range from a few weeks to several months depending on the company and position.

• During the notice period, the employee is expected to work as usual and hand over responsibilities.

• Some companies may allow employees to buy out their notice period by paying a fee.

• Failure ...read more
Answered by AI
Add your answer

Q1. They will basic check for your communication and excel skills
Add your answer
Q2. They will ask you to explain about your work history and just be presentable during the interview
Add your answer

Q1. Take me through your profile? What do you know about Gracenote
Add your answer

Q1. The HR is as opportunist as they can get. They will ask why you want to join gracenote to gauge your interest and they will ask you for your family background, etc. If you come from a good background plea...read more
Add your answer

Q1. What is Ct and pt
Ans. 
CT and PT are electrical devices used for current and voltage measurement in power systems.
• CT stands for Current Transformer, used to step down high currents to a measurable level for protection and metering purposes.

• PT stands for Potential Transformer, used to step down high voltages to a measurable level for protection and metering purposes.

• CTs and PTs are commonly used in power systems to provide accurate measuremen...read more
Answered by AI
Add your answer

Q1. What are the different components of computer hardware and how can errors related to them be resolved?
Ans. 
Computer hardware components include CPU, RAM, motherboard, hard drive, graphics card, and power supply. Errors can be resolved by troubleshooting, replacing faulty components, or updating drivers.
• CPU (Central Processing Unit) - Check for overheating, reseat if necessary.

• RAM (Random Access Memory) - Test for errors using diagnostic tools, replace if faulty.

• Motherboard - Check for loose connections, update BIOS if neede...read more
Answered by AI
Add your answer
Q2. Networking related questions, router, switch, firewall
Add your answer

Q1. Final technical round
Add your answer
Q2. Computer hardware and networking knowledge Check
Add your answer

Hr and United manager and it head discussion to final

Q1. Document properly conducted hr and job process
Add your answer
Q2. What is your highest level of education?
Ans. 
Bachelor's degree in Computer Science
• Bachelor's degree in Computer Science

• Graduated from XYZ University in 2018

• Relevant coursework in programming, networking, and database management
Answered by AI
Add your answer

Q1. Finally joining
Add your answer

Q1. Introduction, current company and project, roles and responsibilities.
Add your answer
Q2. Basic fresher types questions
Add your answer

Q1. About the Types of Functional Testing
Add your answer

Q1. Explain your daily work in current role
Add your answer

Q1. Salary Discussion
Add your answer