Shapoorji Pallonji Group SQL Developer Interview Questions and Answers

Amazing aptitute test with knowledge of all aspects of the industry

Great assessment of all the interview natures of the assignment for risk, protocol, and valuation.

Q1. Javascript basic questions
Add your answer
Q2. Javascript basic questions
Add your answer

Logical and Maths ,Sql,Java

Q1. Coding skills related to web and database
Add your answer

Q1. General aptitude and behavioral questions
Add your answer

To upper management related to software practices

Q1. The first round was technical and it was a hard round as your concept of sap should be clear
Add your answer
Q2. Why do u maintain Reconcilation a/c?
Ans. 
Reconciliation accounts are maintained to ensure accuracy and consistency in financial records.
• Helps in identifying discrepancies between different accounts

• Ensures accuracy and consistency in financial statements

• Facilitates easy tracking of transactions and balances

• Aids in detecting errors or fraud in accounting records
Answered by AI
Add your answer
Q3. FI MM Integration, FI SD Integration?
Add your answer
Q4. What we maintain on company code lvl and client level and why?
Ans. 
Company code level is maintained for global settings applicable to all clients, while client level is maintained for specific settings unique to each client.
• Company code level settings include currency, chart of accounts, and fiscal year variants.

• Client level settings include customer master data, vendor master data, and sales organization data.
Answered by AI
Add your answer
Q5. Phases of blueprint, tables
Ans. 
Blueprint phases include planning, designing, and implementation. Tables are used to organize data in a structured format.
• Blueprint phases: planning, designing, implementation

• Tables: organize data in structured format

• Examples: creating a blueprint for a new building, using tables in a database to store information
Answered by AI
Add your answer

Q1. Manager round some kind of behavioural check and some technical question asked as they give u scenerio about the work and some accounting questions
Add your answer
Q2. General Entries, P2P, OTC, RTR
Add your answer
Q3. What bank Reconcilation and validations
Ans. 
Bank reconciliation involves comparing the bank statement with the company's records to ensure they match, while validations involve verifying the accuracy and completeness of financial transactions.
• Bank reconciliation ensures that the company's records match the bank statement by comparing deposits, withdrawals, and other transactions.

• Validations involve verifying the accuracy and completeness of financial transaction...read more
Answered by AI
Add your answer

Q1. The last round was hr
Add your answer
Q2. Some kind of behavioural check, salary discussions, terms and conditions but one thing here the hr round is not a formality round as u have to give full impression over there dont take it simple
Add your answer

Q1. Based on your CV
Add your answer

Q1. Based on the project and skill they are in need
Add your answer

Q1. General HR and code of conduct explained
Add your answer
Q2. General discussions
Add your answer

Q1. Data types in SQL. Write prime number logical code in SQL
Ans. 
SQL data types and prime number logic code
• SQL data types include integer, float, varchar, etc.

• To write prime number logic in SQL, use a loop to check if a number is divisible by any number less than itself

• Example: DECLARE @num INT = 7; SELECT CASE WHEN COUNT(*) = 2 THEN 'Prime' ELSE 'Not Prime' END FROM (SELECT 1 AS num UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6) AS n
Answered by AI
Add your answer

Q1. Why do you want to join us?
Add your answer

IT WAS BASIC AND EASY TO SOLVE

Q1. OOPS CONCEPT OF JAVA
Ans. 
OOPS concepts in Java refer to the principles of Object-Oriented Programming such as inheritance, encapsulation, polymorphism, and abstraction.
• Inheritance: Allows a class to inherit properties and behavior from another class. Example: class B extends class A.

• Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: private variables with public getter and setter methods.

• Polymorphism...read more
Answered by AI
Add your answer
Q2. JAVA SPRING BOOT
Add your answer

Q1. Achievements, Experience, Projects Handled
Add your answer
Q2. Project work executed in last few years
Ans. 
I have executed multiple projects in the last few years.
• Developed a new website for a client using HTML, CSS, and JavaScript.

• Created a mobile application for a startup using React Native.

• Managed a team of developers to build a custom CRM system for a large corporation.

• Implemented a data analytics solution for a healthcare organization using Python and SQL.

• Designed and executed a social media marketing campaign for a no
Answered by AI
Add your answer