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
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
Anonymous
I applied via Campus Placement and was interviewed before Aug 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Regarding my previous experience.
- Q2. Regarding my background
Interview Preparation Tips
I applied via Indeed and was interviewed before Jun 2020. There were 5 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Basic php and array functions
- Q2. Mysql basic, views, triggers
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Feb 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. How meny days working, and working hours
- Ans.
The number of working days and working hours for a Software Developer.
Software Developers typically work 5 days a week.
The standard working hours for Software Developers are 8 hours per day.
However, the actual number of working days and hours may vary depending on the company and project requirements.
Interview Preparation Tips
Basic aptitude and coding problems were asked
System design and advanced algorithms were asked
I applied via Company Website and was interviewed before Jun 2020. There were 5 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Php basic and array functions
- Q2. Mysql basic,views,triggers
Interview Preparation Tips
(1 Question)
- Q1. 3 dsa problem asked
Covers basics aps around 15 question
DSA based questions from leetcode easy and medium
Inroduction of capital market
(1 Question)
- Q1. What is primary & secondary market, types of corporate actions with example
- Ans.
Primary market is where new securities are issued, while secondary market is where existing securities are traded.
Primary market involves the issuance of new securities by companies to raise capital, while secondary market involves the trading of existing securities among investors.
Types of corporate actions include stock splits, dividends, mergers and acquisitions, and spin-offs.
Stock split is when a company increases...
shahila salmani
Selected
I applied via Company Website and was interviewed before Oct 2022. There were 2 interview rounds.
(4 Questions)
- Q1. What is share market
- Ans.
Share market is a platform where buying and selling of company stocks and securities takes place.
Share market allows companies to raise capital by selling shares to investors
Investors can buy and sell shares to make profits
Prices of shares fluctuate based on supply and demand, company performance, and economic factors
- Q2. Dividend is declared by whom?
- Ans.
Dividends are declared by the board of directors of a company.
Dividends are typically declared by the board of directors of a company.
The board of directors considers various factors such as company performance, financial health, and future growth prospects before declaring dividends.
Shareholders receive dividends as a distribution of profits.
Dividends can be in the form of cash, stock, or property.
Companies may choose...
- Q3. What is equity management?
- Ans.
Equity management involves the strategic allocation and distribution of company ownership to maximize shareholder value.
Involves determining the optimal mix of debt and equity financing for a company
Includes managing the issuance of new shares, buybacks, and dividends
Strategic decisions to ensure fair treatment of shareholders and maximize returns
Examples: IPOs, stock repurchases, dividend policies
- Q4. What are shares?
- Ans.
Shares represent ownership in a company and entitle the holder to a portion of the company's assets and profits.
Shares are units of ownership in a company that are bought and sold on the stock market.
Shareholders have voting rights and may receive dividends based on the company's performance.
Shares can be classified as common stock or preferred stock, each with different rights and benefits.
Interview Preparation Tips
CredenTek Software & Consultancy Interview FAQs
Tell us how to improve this page.
CredenTek Software & Consultancy Interviews By Designations
CredenTek Software & Consultancy SQL Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Software Engineer
108
salaries
|  ₹1.8 L/yr - ₹6.7 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 |
|
Senior Software Engineer
15
salaries
| ₹4.1 L/yr - ₹10.2 L/yr |
|
Project Lead
15
salaries
| ₹7.8 L/yr - ₹17.5 L/yr |
Karvy Financial Services
Reliance Money
Sonata Finance
Bss Microfinance
- Home >
- Interviews >
- CredenTek Software & Consultancy Interview Questions >
- CredenTek Software & Consultancy SQL Developer Interview Questions
