AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Posidex Technologies
Compare
Filter interviews by
Posidex Technologies SQL Developer Interview Questions and Answers
Posidex Technologies SQL Developer Interview Experiences
1 interview found
Anonymous
I applied via Walk-in and was interviewed in May 2022. There was 1 interview round.
(2 Questions)
- Q1. What is join and it's syntax?
- 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.
Syntax: SELECT column_name(s) FROM table1 JOIN table2 ON table1.column_name = table2.column_name;
Types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN.
Example: SELECT customers.name, orders.order_date FROM customers JOIN orders ON customers.customer_id =
- Q2. What is constrain?, Whatis DDL?
- Ans.
Constrain is a rule that restricts the values in a database column. DDL is a set of SQL commands used to create, modify, and delete database objects.
Constrains ensure data integrity and prevent invalid data from being inserted into a database.
DDL includes commands like CREATE, ALTER, and DROP to manage database objects like tables, indexes, and views.
Constrains are defined using DDL commands like CHECK, UNIQUE, and FOR...
Interview Preparation Tips
- Joins
- Substring
- Instring
- Constraint
- DDL
- Dml
- DCL
- TCL
- SCALAR FUNTION
- MULTI ROW FUNCTIONS
- SINGLE ROW FUNCTION
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
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
Interview Questionnaire
1 Question
- Q1. It is a telephonic round. First question:Tell me about yourself , second question :method overriding .then he asked about my salary current CTC and expected CTC ,I have answered the same and said that we...
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
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
(1 Question)
- Q1. Tell me about yourself
(1 Question)
- Q1. What is capital market
- Ans.
Capital market is a financial market where individuals and institutions trade financial securities.
Capital market is where long-term securities like stocks and bonds are bought and sold.
It helps companies raise capital by issuing stocks or bonds to investors.
Investors can buy and sell securities through stock exchanges like NYSE or NASDAQ.
Capital market plays a crucial role in the economy by facilitating investment and
(1 Question)
- Q1. What is your goal in life
I applied via Referral and was interviewed in Sep 2021. There were 3 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Tell me about recent Project Details and what is your Role in this Project.
- Ans. I explained my project and the modules which I had developed. Informed about Team members and their responsibilities who were working on the same Project. Then my role in the team as well as my responsibilities in the Project.
- Q2. Git and Azure DevOps related Questions
- Ans. I Explained how we work on AzureDevOps. Explained workflow with Git Repos through DevOps Repositories. Explained Build and Release Pipelines also Explained NuGet Packages using Artifacts
- Q3. Explain Solid Principles and Where to use this with Example
- Ans.
Solid Principles are a set of design principles for writing maintainable and scalable software.
Solid Principles consist of five principles: Single Responsibility Principle, Open/Closed Principle, Liskov Substitution Principle, Interface Segregation Principle, and Dependency Inversion Principle.
Single Responsibility Principle states that a class should have only one reason to change.
Open/Closed Principle states that sof...
- Q4. Abstraction and Interface Differance
- Ans.
Abstraction focuses on hiding implementation details, while interface defines a contract for classes to follow.
Abstraction allows us to focus on the essential features of an object, while hiding unnecessary details.
Interface defines a set of methods that a class must implement, providing a contract for how the class should behave.
Abstraction is achieved through abstract classes and interfaces in object-oriented program...
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in Apr 2023. There were 3 interview rounds.
(1 Question)
- Q1. All about the background
(1 Question)
- Q1. They didn't really asked much
(1 Question)
- Q1. Asked about my experience as an integration developer
Posidex Technologies Interview FAQs
Tell us how to improve this page.
Posidex Technologies Interviews By Designations
- Posidex Technologies Accountant Interview Questions
- Posidex Technologies Software Engineer Interview Questions
- Posidex Technologies Software Developer Interview Questions
- Posidex Technologies Associate Java Developer Interview Questions
- Posidex Technologies Java Developer Interview Questions
- Posidex Technologies Accounts & Administration Executive Interview Questions
- Posidex Technologies SQL Developer Interview Questions
- Posidex Technologies HR Specialist Interview Questions
- Show more
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
Interview Questions from Similar Companies
Fast track your campus placements
|
Software Engineer
72
salaries
|  ₹3.3 L/yr - ₹10.8 L/yr |
|
Associate Software Engineer
42
salaries
| ₹2 L/yr - ₹6 L/yr |
|
QA Engineer
23
salaries
| ₹3 L/yr - ₹10 L/yr |
|
Senior Software Engineer
13
salaries
| ₹4.2 L/yr - ₹14.5 L/yr |
|
Software Developer
12
salaries
| ₹3.2 L/yr - ₹8.5 L/yr |
Karvy Financial Services
Reliance Money
Sonata Finance
Bss Microfinance
- Home >
- Interviews >
- Posidex Technologies Interview Questions >
- Posidex Technologies SQL Developer Interview Questions
