PPN Solutions EPM Consultant Interview Questions and Answers

Q1. Mysql query for 3rd highest salary
Ans. 
Use a subquery to find the third highest salary from the employees table in MySQL.
• Use a subquery to select distinct salaries from the employees table.

• Order the salaries in descending order and use LIMIT to get the third highest salary.

• Example: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 2, 1;
Answered by AI
Add your answer
Q2. What are the steps to connect to a database?
Ans. 
Steps to connect to a database involve specifying the database type, providing credentials, and establishing a connection.
• Specify the type of database you want to connect to (e.g. MySQL, PostgreSQL, MongoDB).

• Provide the necessary credentials such as username and password.

• Establish a connection using a programming language or tool like JDBC, ODBC, or ORM frameworks.
Answered by AI
Add your answer

Q1. Tell us about the change management
Add your answer
Q2. What is HEAD type of method in REST API Integration
Ans. 
HEAD method in REST API Integration is used to retrieve the headers of a resource without fetching the body.
• HEAD requests are similar to GET requests but only return the headers of the resource, not the body.

• This can be useful for checking the status of a resource or determining its size without downloading the entire content.

• For example, a HEAD request to a website URL will return the headers like content type, conten
Answered by AI
Add your answer

Q1. What is your proudest solution provided to the clients
Add your answer
Q2. Breif about your day to day activities
Add your answer

Q1. TEll us about yourself
Add your answer
Q2. Why should we hire you
Add your answer

Q1. Azure ad connect components
Add your answer
Q2. Authentication protocol
Add your answer
Q3. Metaverse explaination
Add your answer
Q4. Application integration
Add your answer
Q5. Scim provisioning
Add your answer
Q6. Conditional access
Add your answer
Q7. Privileged identity management
Add your answer

Q1. About different joins in SQL
Add your answer
Q2. 1)About previous projects done in detail 2) Regarding any certification like dp-203 or spark certification 3) spark architecture 4) about delta table
Add your answer
Q3. Some questions about adf pipelines scenario based
Add your answer
Q4. Spark actions and transformation
Add your answer

Q1. Exolain jvm Architecture
Add your answer
Q2. Write pallindrome code
Ans. 
A palindrome code is a program that checks if a given string reads the same forwards and backwards.
• Create a function that takes a string as input

• Reverse the string and compare it to the original string

• Return true if they are the same, false otherwise
Answered by AI
Add your answer

Q1. What is cursor and it's use
Ans. 
A cursor is a database object used to retrieve and manipulate data in a database management system.
• A cursor allows for sequential processing of query results one row at a time.

• It can be used to update or delete specific rows in a result set.

• Cursors are commonly used in stored procedures and triggers.

• Example: DECLARE cursor_name CURSOR FOR SELECT column1, column2 FROM table_name;
Answered by AI
Add your answer
Q2. Query using listagg
Ans. 
Query using listagg function to concatenate values into a single string
• Use the listagg function followed by the column name and delimiter in parentheses

• Specify the order by clause if needed

• Can be used in SQL queries to display aggregated data
Answered by AI
Add your answer

Q1. Salary discussion
Add your answer
Q2. Confidence analysis
Add your answer

You could crack easily if you done coding in past.

Javascript & UI creation

Q1. Tell me the sap journey
Ans. 
The SAP journey involves implementing, customizing, and optimizing SAP software to meet business needs.
• Start with understanding the business requirements and goals

• Implement SAP software modules based on the requirements

• Customize the software to fit the specific needs of the organization

• Optimize the system for efficiency and effectiveness

• Provide training and support to users for successful adoption
Answered by AI
Add your answer
Q2. Subcontracting process
Add your answer
Q3. Consignment process
Add your answer

Q1. Salary expectations
Add your answer