Persistent Systems SQL Developer Interview Questions and Answers for Experienced

Q1. Caching Strategy
Add your answer
Q2. What is micro Frontend architecture
Ans. 
Micro Frontend architecture is an approach to building front-end applications by breaking them down into smaller, independently deployable units.
• Allows different teams to work on separate parts of the application

• Each micro frontend can be developed using different technologies

• Enables incremental upgrades and updates without affecting the entire application

• Can improve performance by loading only the necessary components

• ...read more
Answered by AI
Add your answer
Q3. Pure and impure pipes in angular
Ans. 
Pure pipes in Angular are stateless and do not change the input data, while impure pipes can have side effects and change the input data.
• Pure pipes are used for simple transformations like formatting dates or numbers.

• Impure pipes are used for more complex transformations that require state or side effects.

• Pure pipes are faster and more efficient as they only run when a pure change to the input data is detected.

• Impure p...read more
Answered by AI
Add your answer
Q4. How to make singleton services multiton
Ans. 
Singleton services can be made multiton by maintaining a map of instances with unique keys.
• Create a map to store instances with unique keys

• Use a factory method to retrieve instances based on keys

• Ensure that only one instance is created per key
Answered by AI
Add your answer
Q5. What is dependency injection
Ans. 
Dependency injection is a design pattern where components are given their dependencies rather than creating them internally.
• Allows for easier testing by injecting mock dependencies

• Promotes loose coupling between components

• Improves code reusability and maintainability

• Examples: AngularJS, Spring Framework
Answered by AI
Add your answer

Q1. Write query to get result based on hughest salary
Ans. 
Use SQL query with ORDER BY clause to get result based on highest salary
• Use SELECT statement to retrieve data from the table

• Use ORDER BY clause with DESC keyword to sort salaries in descending order

• Use LIMIT or FETCH FIRST clause to limit the result to only one row
Answered by AI
Add your answer
Q2. Writw merge query
Add your answer
Q3. Bulk collect and bulk binding difference
Ans. 
Bulk collect is used to fetch multiple rows into collections at once, while bulk binding is used to bind collections to SQL statements for improved performance.
• Bulk collect fetches multiple rows into collections in a single operation, reducing context switches and improving performance.

• Bulk binding binds collections to SQL statements, reducing the number of context switches between the PL/SQL engine and SQL engine.

• Bulk...read more
Answered by AI
Add your answer

Q1. Based on Angular
Add your answer
Q2. Based on Html, CSS, Javascript
Add your answer

Asked simple tricky questions

Q1. Class Dependency Injection
Add your answer
Q2. Questions was asked from oops concepts
Add your answer

Q1. React js Basic Question
Add your answer
Q2. Coding Question Giving API to call and show in UI
Add your answer

Q1. What is plsql and sql
Ans. 
PL/SQL is a procedural extension of SQL used for writing stored procedures, functions, triggers, and packages in Oracle databases.
• PL/SQL stands for Procedural Language/Structured Query Language

• It is used to write procedural code like stored procedures, functions, triggers, and packages in Oracle databases

• SQL (Structured Query Language) is a standard language for accessing and manipulating databases

• SQL is used to query,...read more
Answered by AI
Add your answer

Questions on plsql and sql in general

Q1. Angular related questions, Change detection strategy, View encapsulation, Rxjs Operators & Javascript basic questions
Add your answer

Q1. How you will handle a team of freshers?
Add your answer