Cogniscient Business Solutions Interview Questions and Answers

BASIC SQL RELATED QUESTIONS

Q1. WHAT ARE VIEWS?
Ans. 
Views are virtual tables that display data from one or more tables in a database.
• Views do not store data themselves, but instead display data from underlying tables.

• Views can be used to simplify complex queries by pre-defining joins, filters, and calculations.

• Views can also restrict access to certain columns or rows of data for security purposes.
Answered by AI
Add your answer
Q2. What are functions and procedures
Ans. 
Functions and procedures are blocks of code that can be called to perform specific tasks in a program.
• Functions are reusable blocks of code that can return a value.

• Procedures are similar to functions but do not return a value.

• Functions and procedures help in organizing code and making it more modular.

• Examples: Function to calculate the square of a number, Procedure to print a message.
Answered by AI
Add your answer

Q1. Experience of Selling SAO costing and technical questions
Add your answer
Q2. Existing deals closein previous company
Add your answer

Q1. It was a HR round and they checked the experience and communication.
Add your answer
Q2. According to my qualification and experience. They didn't ask many things. Just normal intro round.
Add your answer

They were two guys and were asked about manufacturing process and import purchase process and all the financials hit.

Good assignment and logical question

SQL query optimisation and procedures