AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
CredenTek Software & Consultancy SQL Developer Interview Questions and Answers
CredenTek Software & Consultancy SQL Developer Interview Experiences
1 interview found
Dipak Pawar
Selected
I applied via Referral and was interviewed in Apr 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Third highest salary in emp table?
- Ans.
To find the third highest salary in emp table, we need to use the ORDER BY and LIMIT clauses.
Use ORDER BY to sort the salaries in descending order.
Use LIMIT to select the third highest salary.
Example query: SELECT salary FROM emp ORDER BY salary DESC LIMIT 2,1
- Q2. What is join and write down one example?
- Ans.
Join is used to combine rows from two or more tables based on a related column between them.
Join is used to retrieve data from multiple tables in a single query.
There are different types of joins like inner join, left join, right join, and full outer join.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Full Stack Software Developer Interview Questions & Answers
VassarLabs
Anonymous
posted on 13 Dec 2024
I applied via Campus Placement and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. Can you provide details about the projects listed on your resume?
- Ans.
I have worked on various projects including a social media platform, an e-commerce website, and a task management application.
Developed a social media platform using React for frontend and Node.js for backend
Designed and implemented an e-commerce website with payment gateway integration
Created a task management application using Angular and MongoDB for database
- Q2. What are the main concepts of Object-Oriented Programming (OOP)?
- Ans.
Main concepts of OOP include encapsulation, inheritance, polymorphism, and abstraction.
Encapsulation: Bundling data and methods that operate on the data into a single unit (object).
Inheritance: Creating new classes based on existing classes, allowing for code reuse.
Polymorphism: Objects of different classes can be treated as objects of a common superclass.
Abstraction: Hiding complex implementation details and showing o
Selected
I applied via Company Website and was interviewed before Jun 2023. There was 1 interview round.
(2 Questions)
- Q1. What are joins in sql
- Ans.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
- Q2. Types of arrays in PHP
- Ans.
Types of arrays in PHP include indexed arrays, associative arrays, and multidimensional arrays.
Indexed arrays: default type where each element is assigned a numeric index starting from 0.
Associative arrays: elements are assigned a specific key instead of numeric index.
Multidimensional arrays: arrays within arrays, creating a matrix-like structure.
Example: $indexedArray = [1, 2, 3]; $associativeArray = ['key1' => 'value...
Interview Preparation Tips
- PHP
- MySQL
Skills evaluated in this interview
Web Developer Interview Questions & Answers
Incrementors Web Solutions
Anonymous
posted on 28 Jun 2021
I applied via Walk-in and was interviewed in May 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. About my projects
- Q2. My previous internship experience and what i have learned there.
Interview Preparation Tips
CredenTek Software & Consultancy Interview FAQs
Tell us how to improve this page.
CredenTek Software & Consultancy Interviews By Designations
Interview Questions for Popular Designations
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Backend Developer Interview Questions
- Software Developer Intern Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- PHP Developer Interview Questions
- UI Developer Interview Questions
- Show more
CredenTek Software & Consultancy SQL Developer Interview Process
based on 1 interview
Interview experience
SQL Developer Interview Questions from Similar Companies
|
Software Engineer
103
salaries
|  ₹1.8 L/yr - ₹7.3 L/yr |
|
Software Developer
45
salaries
| ₹2.8 L/yr - ₹7 L/yr |
|
Application Support Engineer
26
salaries
| ₹3 L/yr - ₹5.7 L/yr |
|
Project Lead
15
salaries
| ₹7.8 L/yr - ₹17.5 L/yr |
|
Senior Software Engineer
13
salaries
| ₹4.1 L/yr - ₹10 L/yr |
Infosys
TCS
Wipro
HCLTech
- Home >
- Interviews >
- CredenTek Software & Consultancy Interview Questions >
- CredenTek Software & Consultancy SQL Developer Interview Questions
