Upload Button Icon Add office photos

Filter interviews by

Techmicra Interview Questions, Process, and Tips

Updated 28 May 2024

Top Techmicra Interview Questions and Answers

Techmicra Interview Experiences

Popular Designations

2 interviews found

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 14 Apr 2024

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Internshala and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - One-on-one 

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

  • Answered by AI
  • 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

  • Answered by AI
  • 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;

  • Answered by AI
  • 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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare

Skills evaluated in this interview

SQL Developer Interview Questions asked at other Companies

Q1. How is a change request in application serviced by development team (business analysis, code analysis, discussion with BA, requirment freeze, etc.)
View answer (4)

Intern Interview Questions & Answers

user image Anonymous

posted on 28 May 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(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;

  • Answered by AI

Skills evaluated in this interview

Intern Interview Questions asked at other Companies

Q1. Case. There is a housing society “The wasteful society”, you collect all the household garbage and sell it to 5 different businesses. Determine what price you will pay to the society members in Rs/kg, given you want to make a profit of 20% ... read more
View answer (8)

Jobs at Techmicra

View all

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Oops Concepts and Data Structure Questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Oops And Data Structure, Collection.

I applied via Recruitment Consultant and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic communication skills were tested. Sone techical questn too. Versant test is mandatory

Interview Preparation Tips

Interview preparation tips for other job seekers - Please never go for these third party vendors. They misguide you regarding profile . I went for this third party vendor named savantis solution and it really misguided me

Interview Questionnaire 

1 Question

  • Q1. Where do you see yourself after 5 years from now

I applied via Campus Placement and was interviewed before Feb 2020. There were 6 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Was interviewed as fresher?
  • Q2. Written test conducted? with verbal ability test ? GD
  • Q3. How would u deal with a problematic situation when you are working in a team?
  • Q4. What are your plans about higher studies?

Interview Preparation Tips

Interview preparation tips for other job seekers - it was basic with apptiude test and attitiude test.

Interview Questionnaire 

1 Question

  • Q1. Questions related to COBOL,JCL,VSAM,DB2,CICS,Vision plus

I applied via Referral and was interviewed before Jan 2021. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Previous work related queries

Interview Preparation Tips

Interview preparation tips for other job seekers - Please prepares office and sap

Interview Questionnaire 

2 Questions

  • Q1. They asked me on java and I have joined as a fresher they not much questions as I got selected as fresher on oops concepts and collections
  • Q2. Please be confident while facing interview and they will check your communication skills

Interview Questionnaire 

1 Question

  • Q1. Who is the most important person have to transform you in your life?

Interview Preparation Tips

Interview preparation tips for other job seekers - Just speak your mind you will be selected.

Techmicra Interview FAQs

How many rounds are there in Techmicra interview?
Techmicra interview process usually has 1 rounds. The most common rounds in the Techmicra interview process are One-on-one Round and Technical.
How to prepare for Techmicra interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Techmicra. The most common topics and skills that interviewers at Techmicra expect are Application Development, Web Development, Debugging, PHP and Web Technologies.
What are the top questions asked in Techmicra interview?

Some of the top questions asked at the Techmicra interview -

  1. Create table, put values in ...read more
  2. Rank using window sliding in my...read more
  3. Input values in it in My...read more

Tell us how to improve this page.

Techmicra Interview Process

based on 2 interviews

Interview experience

3.5
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.8
 • 8.1k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Amazon Interview Questions
4.1
 • 5k Interviews
Capgemini Interview Questions
3.7
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
View all

Techmicra Reviews and Ratings

based on 3 reviews

4.0/5

Rating in categories

4.0

Skill development

4.0

Work-life balance

4.0

Salary

4.0

Job security

4.0

Company culture

4.0

Promotions

4.0

Work satisfaction

Explore 3 Reviews and Ratings
Android Developer

Ahmedabad

8-13 Yrs

Not Disclosed

ASP . NET Developer

Ahmedabad

2-5 Yrs

Not Disclosed

Web / Graphics Designer

Ahmedabad

1-4 Yrs

Not Disclosed

Explore more jobs
Compare Techmicra with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview