Greyb Cakephp Developer Interview Questions and Answers

Q1. Html/css based questions.
Add your answer
Q2. Write css to make a backdrop.
Ans. 
Use CSS to create a backdrop for a webpage.
• Use the 'background' property to set the color or image of the backdrop.

• Set the 'position' property to 'fixed' to ensure the backdrop covers the entire viewport.

• Adjust the 'z-index' property to ensure the backdrop is behind other elements.
Answered by AI
Add your answer

Q1. RESTful API Services
Add your answer
Q2. Questions on ES6 -> Generator, Weakset
Add your answer
Q3. Knowledge on Testing
Add your answer
Q4. Basic Angular, CSS questions
Add your answer

Q1. Find 3rd highest salary
Ans. 
Use SQL query with ORDER BY and LIMIT to find 3rd highest salary
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 2,1 to skip first two highest salaries and get the third highest salary
Answered by AI
Add your answer
Q2. Pivoting and unpivoting in SQL
Ans. 
Pivoting and unpivoting are techniques used in SQL to transform data from rows to columns and vice versa.
• Pivoting involves rotating rows into columns, typically used to summarize data.

• Unpivoting involves rotating columns into rows, typically used to normalize data.

• Pivoting can be done using the PIVOT keyword in SQL, while unpivoting can be done using the UNPIVOT keyword.
Answered by AI
Add your answer
Q3. Difference in rank and dense rank
Ans. 
Rank assigns unique rank to each row, while dense rank allows for ties in ranking.
• Rank leaves gaps in ranking sequence, while dense rank does not

• Rank(1, 2, 2, 4) = 1, 2, 3, 4

• Dense Rank(1, 2, 2, 4) = 1, 2, 2, 3
Answered by AI
Add your answer

Q1. Explain K8s Architecture
Ans. 
K8s Architecture refers to the structure and components of Kubernetes, an open-source container orchestration platform.
• Kubernetes follows a master-slave architecture with a master node and multiple worker nodes.

• Master node components include API server, scheduler, controller manager, and etcd.

• Worker nodes run pods which contain containers.

• Kubernetes uses labels and selectors to manage and organize resources.

• K8s archite...read more
Answered by AI
Add your answer
Q2. Explain Jenkins pipeline
Ans. 
Jenkins pipeline is a set of plugins that allow for the automation of building, testing, and deploying code.
• Jenkins pipeline is defined as a suite of plugins that support implementing and integrating continuous delivery pipelines.

• It allows for defining the entire build process as code, which can be version controlled and shared.

• Pipeline stages can include building, testing, deploying, and other tasks, with each stage b...read more
Answered by AI
Add your answer

Q1. What you know about Pharma industry?
Add your answer
Q2. Pharma in United States
Add your answer

Easy questions according to the role.

Q1. Interview was for 30 min
Add your answer

Q1. Basic HR Questions like Introduce yourself etc
Add your answer

Q1. Tell me soothing about yourself
Add your answer
Q2. Why do you want to join us
Add your answer

Q1. What is php session & how it works?
Ans. 
PHP session is a way to store user data on the server and maintain it across multiple pages.
• Session data is stored on the server and identified by a unique session ID.

• Session ID is usually stored in a cookie on the user's browser.

• Session data can be accessed and modified across multiple pages.

• Session can be started using the session_start() function.

• Session can be destroyed using the session_destroy() function.
Answered by AI
Add your answer

Q1. Js questions and 2 coding questions
Add your answer
Q2. Questions on angular, html and css
Add your answer