AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Cogniscient Business Solutions
Compare
Filter interviews by
Cogniscient Business Solutions SAP Technical Consultant Interview Questions and Answers
Cogniscient Business Solutions SAP Technical Consultant Interview Experiences
1 interview found
aditya sharma
BASIC SQL RELATED QUESTIONS
(2 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.
- 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.
Top trending discussions
Interview questions from similar companies
Anonymous
Selected
I applied via Naukri.com and was interviewed before Nov 2021. There were 2 interview rounds.
(2 Questions)
- Q1. Oops concepts, core java
- Q2. Java 8 stream api and lambda
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.
(2 Questions)
- Q1. Basics of python, project related questions
- Q2. Basic SQL, few simple problem solving questions
(2 Questions)
- Q1. Interests, hobbies ,general HR questions
- Q2. Expected hike, salary, work timings preferred
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. SQL window functions
- Q2. Basic SQL queries
- Q3. Basic Power BI
Interview Preparation Tips
Selected
I applied via Walk-in and was interviewed before Aug 2022. There were 4 interview rounds.
Test of SQL, Tableau and other skills based on your resume on Skillate
(1 Question)
- Q1. SQL and other skills technical questions
(1 Question)
- Q1. Manager round / 2nd technical round
I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Drill Down,Drill through
- Q2. Dax functions like date add,date diff,time Intelligence
- Q3. Import direct query
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Aug 2024. There were 2 interview rounds.
(3 Questions)
- Q1. Question related to oops
- Q2. Question related to coding
- Q3. I was rejected after 2nd round
(2 Questions)
- Q1. Question related to advanced topic in oops
- Q2. Question related to coding
Interview Questionnaire
2 Questions
- Q1. Fsmo roles
- Q2. Office 365
I applied via Approached by Company
(2 Questions)
- Q1. Sql is the most important , Focus on Joins ,Sub query and Sql basics
- Q2. Joining tables with different joins
- Ans.
Joining tables with different joins in SQL
Use INNER JOIN to return rows when there is at least one match in both tables
Use LEFT JOIN to return all rows from the left table and the matched rows from the right table
Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table
Use FULL JOIN to return rows when there is a match in one of the tables
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Jul 2021. There were 3 interview rounds.
Interview Questionnaire
5 Questions
- Q1. Given an input string "neeraj chopra" Write Python code to get output string as "jareen arpohc".
- Ans.
The Python code to get the output string as 'jareen arpohc' from the input string 'neeraj chopra' is provided.
Split the input string into individual words
Reverse each word
Join the reversed words with a space in between
- Q2. Given a list of 10 numbers. Write a code to list only even numbers out of the original list.
- Ans.
Code to list even numbers from a given list of 10 numbers.
Loop through the list of numbers
Check if each number is even using the modulo operator
If the number is even, add it to a new list of even numbers
Return the new list of even numbers
- Q3. SQL queries using Window Functions Rank() , Dense Rank() etc
- Q4. Reversal of string in python code
- Ans.
Reversing a string in Python code
Use slicing to reverse the string
Use the built-in function 'reversed()'
Convert the string to a list, reverse it, and then join it back to a string
- Q5. SQL queries in general.
Interview Preparation Tips
Basic Python , SQL knowledge is enough to crack the interviews.
Skills evaluated in this interview
Cogniscient Business Solutions Interview FAQs
Tell us how to improve this page.
Cogniscient Business Solutions Interviews By Designations
- Cogniscient Business Solutions Software Engineer Trainee Interview Questions
- Cogniscient Business Solutions ERP Functional Consultant Interview Questions
- Cogniscient Business Solutions Business Development Manager Interview Questions
- Cogniscient Business Solutions SAP Technical Consultant Interview Questions
- Cogniscient Business Solutions SAP B1 Functional Consultant Interview Questions
- Cogniscient Business Solutions Programmer Analyst Interview Questions
- Cogniscient Business Solutions Associate Software Engineer Interview Questions
Interview Questions for Popular Designations
- SAP Abap Technical Consultant Interview Questions
- Technical Lead Interview Questions
- Oracle Technical Consultant Interview Questions
- SAP Abap Consultant Interview Questions
- SAP Fico Consultant Interview Questions
- SAP MM Consultant Interview Questions
- SAP Consultant Interview Questions
- SAP SD Consultant Interview Questions
- Show more
Cogniscient Business Solutions SAP Technical Consultant Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Cogniscient Business Solutions SAP Technical Consultant Reviews and Ratings
based on 1 review
Rating in categories
|
Assistant Software Engineer
31
salaries
|  ₹1.5 L/yr - ₹4.1 L/yr |
|
SQL Developer
29
salaries
| ₹1.9 L/yr - ₹7 L/yr |
|
Software Engineer
16
salaries
| ₹2 L/yr - ₹6.6 L/yr |
|
Software Developer
16
salaries
| ₹1.8 L/yr - ₹5.5 L/yr |
|
Technical Consultant
13
salaries
| ₹1.8 L/yr - ₹5.4 L/yr |
Maxgen Technologies
Value Point Systems
JoulestoWatts Business Solutions
F1 Info Solutions and Services
- Home >
- Interviews >
- Cogniscient Business Solutions Interview Questions >
- Cogniscient Business Solutions SAP Technical Consultant Interview Questions
