AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
JK
Tech
Compare
Filter interviews by
JK Tech Interview Questions and Answers
15 Interview questions
SQL queries using joins and window functions
Use INNER JOIN to combine rows from two or more tables based on a related column
Use WINDOW functions like ROW_NUMBER() to assign a unique sequential integer to each row within a partition
Example: SELECT column1, column2, ROW_NUMBER() OVER(PARTITION BY column1 ORDER BY column2) AS row_num FROM table_name
This SQL query retrieves records from a table where a specified column starts with the letter 'S'.
Use the SQL 'LIKE' operator to filter records.
Example: SELECT * FROM table_name WHERE column_name LIKE 'S%';
The '%' wildcard represents any sequence of characters following 'S'.
Ensure the column is case-sensitive if needed, depending on the database settings.
I am a detail-oriented Business Analyst with a passion for data-driven decision-making and a strong background in project management.
Over 5 years of experience in business analysis across various industries, including finance and healthcare.
Skilled in gathering and documenting requirements through stakeholder interviews and workshops.
Proficient in data analysis tools like Excel and SQL, which I used to identify tr...
This company is a leading provider of innovative solutions in the tech industry, focusing on enhancing user experience and efficiency.
Founded in 2005, the company has grown rapidly, expanding its services globally.
They specialize in software development, offering products that streamline business processes.
The company has received multiple awards for its commitment to sustainability and corporate social responsibi...
Yes, I am familiar with queries in databases.
Queries are used to retrieve specific data from a database.
They can be written in SQL (Structured Query Language).
Examples of queries include SELECT, INSERT, UPDATE, and DELETE.
Implementing a targeted marketing campaign, improving customer service, and expanding product offerings.
Develop a targeted marketing campaign to reach potential customers
Improve customer service to retain existing customers and attract new ones
Expand product offerings to appeal to a wider range of customers
To plan repeat business, focus on building strong relationships, providing excellent service, offering incentives, and staying in touch.
Build strong relationships with clients to encourage loyalty
Provide excellent service to exceed customer expectations
Offer incentives such as discounts or rewards for repeat business
Stay in touch with clients through regular communication and follow-ups
Base course is a layer of material laid on the subgrade to provide a stable foundation for pavement construction.
Base course is typically made of crushed stone, gravel, or recycled concrete.
It is placed on top of the subgrade and compacted to provide a solid base for the pavement.
The thickness and type of base course used depend on the specific project requirements.
Base course helps to distribute the load of the p...
Truncate is a DDL command that removes all rows from a table, while delete is a DML command that removes specific rows.
Truncate is faster than delete as it does not log individual row deletions.
Truncate resets identity columns, while delete does not.
Truncate cannot be rolled back, while delete can be rolled back using a transaction.
Truncate does not fire triggers, while delete does.
Truncate is used to quickly remo...
Yes, I am comfortable with the location.
I am familiar with the area and have no issues commuting to work.
I have researched the neighborhood and feel safe and comfortable there.
I have visited the office location and found it convenient for me.
JK Tech Interview Experiences
36 interviews found
Ponkarthick kumar
(1 Question)
- Q1. Write SQL query fetch record start letter s
- Ans.
This SQL query retrieves records from a table where a specified column starts with the letter 'S'.
Use the SQL 'LIKE' operator to filter records.
Example: SELECT * FROM table_name WHERE column_name LIKE 'S%';
The '%' wildcard represents any sequence of characters following 'S'.
Ensure the column is case-sensitive if needed, depending on the database settings.
Skills evaluated in this interview
(2 Questions)
- Q1. What do you know about this company?
- Ans.
This company is a leading provider of innovative solutions in the tech industry, focusing on enhancing user experience and efficiency.
Founded in 2005, the company has grown rapidly, expanding its services globally.
They specialize in software development, offering products that streamline business processes.
The company has received multiple awards for its commitment to sustainability and corporate social responsibility.
...
- Q2. Tell about yourself
- Ans.
I am a detail-oriented Business Analyst with a passion for data-driven decision-making and a strong background in project management.
Over 5 years of experience in business analysis across various industries, including finance and healthcare.
Skilled in gathering and documenting requirements through stakeholder interviews and workshops.
Proficient in data analysis tools like Excel and SQL, which I used to identify trends ...
(2 Questions)
- Q1. How much experience you have in progress
- Ans.
I have over 10 years of experience in making progress in various consulting projects.
Over 10 years of experience in consulting projects
Successfully led multiple projects to completion
Implemented strategies that resulted in significant progress
Collaborated with teams to achieve project milestones
- Q2. Do you know queries
- Ans.
Yes, I am familiar with queries in databases.
Queries are used to retrieve specific data from a database.
They can be written in SQL (Structured Query Language).
Examples of queries include SELECT, INSERT, UPDATE, and DELETE.
Skills evaluated in this interview
59_SONAM GUPTA
(2 Questions)
- Q1. Basic opps concept of .net
- Q2. SQL and angular questions
Selected
I applied via Referral and was interviewed in Jan 2024. There was 1 interview round.
(5 Questions)
- Q1. Technical question
- Q2. For data filling
- Q3. Data type based
- Q4. For data filling duifficulties
- Q5. Data filling form
Business Development Manager and Team Lead Interview Questions & Answers
Anonymous
posted on 8 Aug 2024
Selected
I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.
(2 Questions)
- Q1. Strategy to increase bussiness
- Ans.
Implementing a targeted marketing campaign, improving customer service, and expanding product offerings.
Develop a targeted marketing campaign to reach potential customers
Improve customer service to retain existing customers and attract new ones
Expand product offerings to appeal to a wider range of customers
- Q2. How to plan repeat businees
- Ans.
To plan repeat business, focus on building strong relationships, providing excellent service, offering incentives, and staying in touch.
Build strong relationships with clients to encourage loyalty
Provide excellent service to exceed customer expectations
Offer incentives such as discounts or rewards for repeat business
Stay in touch with clients through regular communication and follow-ups
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
Coding skil is speed important
Mathematics skils and seed pf calculation
Interview Preparation Tips
Good coding test of 2 hour medium questions
(2 Questions)
- Q1. About your self
- Q2. About project and typical hr Questions
(2 Questions)
- Q1. System monitoring related question User management related question like to change password of user, create a user , if user not able to login what is the troubleshoot . Lvm activity like create vg To cre...
- Q2. If the size of fs doesn't increase by command chfs what will do we have storage space , but after also we are not able to increase the size of file system What is nfs ,how will configure nfs
- Ans.
If the size of fs doesn't increase by chfs command, check for available storage space and ensure proper permissions. If issue persists, consider unmounting the filesystem before resizing.
Check available storage space using commands like df or du
Ensure proper permissions to modify the filesystem
If still unable to increase size, consider unmounting the filesystem before resizing
Example: df -h to check available storage s...
(1 Question)
- Q1. Vios cluster related question were added in 2 nd with first round question.
(2 Questions)
- Q1. Discussion about location and salary
- Q2. Comfortable with this location
- Ans.
Yes, I am comfortable with the location.
I am familiar with the area and have no issues commuting to work.
I have researched the neighborhood and feel safe and comfortable there.
I have visited the office location and found it convenient for me.
Interview Preparation Tips
It's the game of backup and file. Do focus on that .
Skills evaluated in this interview
(1 Question)
- Q1. General knowledge
(5 Questions)
- Q1. One on one round
- Q2. My interview around me
- Q3. My name my qualifications
- Q4. My passion my hobby
- Q5. Education and other qualifications
Top trending discussions
JK Tech Interview FAQs
The duration of JK Tech interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
JK Tech Interviews By Designations
- JK Tech Software Engineer Interview Questions
- JK Tech Associate Consultant Interview Questions
- JK Tech Consultant Interview Questions
- JK Tech Trainee Interview Questions
- JK Tech Technical Lead Interview Questions
- JK Tech Senior Consultant Interview Questions
- JK Tech Senior Business Analyst Interview Questions
- JK Tech Business Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 31 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
JK Tech Reviews and Ratings
based on 489 reviews
Rating in categories
|
Software Engineer
278
salaries
|  ₹2.6 L/yr - ₹10.3 L/yr |
|
Senior Consultant
224
salaries
| ₹12 L/yr - ₹21.7 L/yr |
|
Senior Software Engineer
211
salaries
| ₹6 L/yr - ₹23 L/yr |
|
Technical Lead
151
salaries
| ₹18.3 L/yr - ₹32.5 L/yr |
|
Consultant
131
salaries
| ₹3.8 L/yr - ₹10 L/yr |
Softenger
Capital Numbers Infotech
DesignTech Systems
SISL Infotech
- Home >
- Interviews >
- JK Tech Interview Questions
