AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Techmicra Interview Questions and Answers
Techmicra Interview Experiences
2 interviews found
Anonymous
I applied via Internshala and was interviewed in Mar 2024. There was 1 interview round.
(5 Questions)
- Q1. Create table, put values in it.
- Ans.
Creating a table and inserting values in SQL.
Use CREATE TABLE statement to create a table.
Use INSERT INTO statement to insert values into the table.
Specify column names and data types when creating the table.
Provide values for each column when inserting data into the table.
- Q2. Input values in it in Mysql
- Ans.
To input values in MySQL, use the INSERT INTO statement with the table name and column names.
Use INSERT INTO statement followed by the table name
Specify the column names in parentheses after the table name
Provide the values to be inserted in the corresponding order
- Q3. Find today date
- Ans.
Use the GETDATE() function in SQL to find today's date.
Use the GETDATE() function in SQL to get the current date and time
To get only the date part, use the CONVERT function with the appropriate style code
Example: SELECT CONVERT(date, GETDATE()) AS TodayDate;
- Q4. Second Maximum Salary, Name
- Q5. Rank using window sliding in mysql
- Ans.
Rank using window sliding in MySQL
Use the RANK() function with window sliding to assign ranks to rows based on specified criteria
Specify the window frame using ORDER BY and PARTITION BY clauses
Example: SELECT id, name, RANK() OVER (PARTITION BY department ORDER BY salary DESC) AS rank FROM employees
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- Q1. What is a left join?
- Ans.
A left join is a type of SQL join that returns all rows from the left table and the matched rows from the right table.
Left join is used to combine rows from two or more tables based on a related column between them.
If there is no match found in the right table, NULL values are returned for the columns of the right table.
Example: SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id;
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
himanshu kohli
I applied via Walk-in and was interviewed before May 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Introducing your self
Interview Preparation Tips
I applied via Naukri.com
Interview Questionnaire
2 Questions
- Q1. Why Amazon?
- Ans.
Amazon's innovation, customer focus, and diverse opportunities align with my career goals and values.
Customer Obsession: Amazon prioritizes customer satisfaction, evident in initiatives like Prime and personalized recommendations.
Innovation: The company is a leader in technology and logistics, constantly pushing boundaries with services like AWS and drone delivery.
Diversity of Roles: Amazon offers a wide range of caree...
- Q2. What do you expect from Amazon?
- Ans.
I expect Amazon to foster innovation, provide growth opportunities, and maintain a customer-centric culture.
Opportunities for professional development, such as training programs and mentorship.
A collaborative work environment that encourages teamwork and idea sharing.
Access to cutting-edge technology and resources to drive innovation.
A strong focus on customer satisfaction, ensuring that every decision prioritizes the ...
Interview Preparation Tips
Interview Questionnaire
2 Questions
- Q1. Technical
- Q2. Be yourself
I appeared for an interview before Jul 2020.
Interview Questionnaire
1 Question
- Q1. Is Infosys listed?
- Ans.
Yes, Infosys is listed on the Indian stock exchanges as well as on the NYSE.
Infosys is listed on the Bombay Stock Exchange (BSE) and National Stock Exchange of India (NSE)
It is also listed on the New York Stock Exchange (NYSE)
Infosys has a market capitalization of over $80 billion as of 2021
Interview Preparation Tips
I applied via Job Fair and was interviewed before Feb 2021. There were 2 interview rounds.
(1 Question)
- Q1. Basic accounting methods and journals
Interview Preparation Tips
Sayan Dey
I applied via Naukri.com and was interviewed in Nov 2019. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Why are you looking for the job change?
- Ans.
I'm seeking new challenges and opportunities for growth that align with my career goals and aspirations.
Desire for professional growth: I'm looking to expand my skill set and take on more leadership responsibilities.
Seeking a better cultural fit: My current company has a different work culture than what I thrive in; I value collaboration and innovation.
Interest in new technologies: I'm excited about working with cuttin...
- Q2. Relevant technical questions, as per my current technology
Interview Preparation Tips
I applied via Approached by Company and was interviewed before May 2018. There were 6 interview rounds.
Interview Questionnaire
5 Questions
- Q1. This is face to face interview... They are observing our behaviour... Attitude... Etc
- Q2. Introduce u r self....
- Ans.
I am a dedicated and hardworking individual with a passion for learning and growth.
I have a Bachelor's degree in Business Administration from XYZ University.
I have 3 years of experience working in marketing and sales roles.
I am proficient in Microsoft Office Suite and have strong communication skills.
I am a team player and enjoy collaborating with others to achieve common goals.
- Q3. U r carrier objections
- Ans.
My career objectives focus on continuous growth, contributing to team success, and making a positive impact in my field.
Aim to develop expertise in my field, such as becoming a certified project manager.
Seek leadership opportunities to guide and mentor junior team members.
Aspire to work on innovative projects that challenge my skills and creativity.
Desire to contribute to a company's mission, like improving customer sa...
- Q4. About TCS
- Q5. Why should u select TCS
- Ans.
TCS is a global leader in IT services with a strong reputation for innovation and client satisfaction.
TCS has a proven track record of delivering high-quality services to clients worldwide.
TCS offers a wide range of opportunities for career growth and development.
TCS values diversity and inclusion, creating a supportive work environment for employees.
TCS invests in cutting-edge technologies and training programs to kee...
Interview Preparation Tips
Experience: Any kind of topic u cn select... Sales, accounts, service
Round: Test
Experience: Aptitude test... Mathematic and problem solving... General knowledge is very important
Round: Telephonic
Experience: This is final round... BH directly interact with us...
General Tips: Be confident... Be clam.... Keep smiling face... That is the way to win
Skills: Communication, Body Language, Leadership, Presentation Skills, Time Management
Duration: <1 week
I applied via Company Website and was interviewed before Feb 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. They asked about dbms questions in the form of table formate
- Q2. They asked code for some python program
Interview Preparation Tips
Techmicra Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 2 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Techmicra Interview Questions
