Synechron Plsql Developer Interview Questions and Answers

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. Difference between delete, drop and truncate
Ans. 
Delete removes rows from a table, drop removes the entire table, and truncate removes all rows from a table.
• Delete is a DML operation and can be rolled back, but it is slower than truncate.

• Drop is a DDL operation and cannot be rolled back. It removes the table and all associated objects.

• Truncate is a DDL operation and cannot be rolled back. It removes all rows from the table but keeps the table structure.

• Delete and tru...read more
Answered by AI
Add your answer
Q2. Difference between table and view
Ans. 
Table stores data in a structured format while view is a virtual table created from a query.
• Table is a physical object while view is a logical object.

• Table can be modified while view cannot be modified directly.

• Table can have indexes while view cannot have indexes.

• Table can have constraints while view cannot have constraints.

• View can be used to simplify complex queries by joining multiple tables.

• View can be used to res...read more
Answered by AI
Add your answer
Q3. What type of cursors did you use
Ans. 
I have used both implicit and explicit cursors in PL/SQL development.
• Implicit cursors are used for single-row queries while explicit cursors are used for multi-row queries.

• I have used explicit cursors with parameters to make the query more dynamic.

• I have also used cursor variables to pass cursors as parameters to procedures and functions.

• Examples of cursor types I have used include FOR LOOP, FETCH, and UPDATE cursors.
Answered by AI
Add your answer
Q4. What is primary key and unique key
Ans. 
Primary key uniquely identifies a record in a table, while unique key ensures uniqueness of a column or set of columns.
• Primary key is a column or set of columns that uniquely identifies each record in a table

• Unique key ensures that a column or set of columns have unique values

• Primary key cannot have null values, while unique key can have null values

• A table can have only one primary key, but multiple unique keys
Answered by AI
Add your answer

Q1. Sql questions basic
Add your answer

Q1. Sql intermediate questions and jira and other daily tools
Add your answer

Q1. Salary and other basic
Add your answer

Easy exam sample available on youtube

Q1. What are step functions.
Ans. 
Step functions are a type of serverless function that allow you to create workflows by chaining multiple functions together.
• Step functions are used to coordinate multiple AWS services into serverless workflows.

• They allow you to define a series of steps in a workflow, with each step being a separate function.

• You can use step functions to handle complex business logic, long-running processes, and error handling.

• Step func...read more
Answered by AI
Add your answer
Q2. How to scale lambdas
Ans. 
Scaling lambdas involves optimizing memory usage, increasing concurrency, and managing dependencies.
• Optimize memory usage by reducing unnecessary variables and objects

• Increase concurrency by using asynchronous programming and parallel processing

• Manage dependencies by breaking down functions into smaller, more modular components

• Consider using AWS Lambda Provisioned Concurrency for consistent performance
Answered by AI
Add your answer

Q1. How did you handled a difficult collegelue
Ans. 
I addressed the issue directly and professionally, seeking to understand their perspective and find common ground.
• Approached the colleague privately to discuss the issue

• Listened actively to their concerns and perspective

• Sought to find common ground and reach a resolution

• Maintained professionalism and respect throughout the conversation
Answered by AI
Add your answer

Q1. Array qs reverse
Add your answer
Q2. Question about angular and react
Add your answer

Asked simple tricky questions

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

2 question 1 easy 2 medium dsa

2 codes of dsa and mcq.

Q1. Code paring round
Add your answer
Q2. Dsa question of graph
Add your answer

Q1. Difference between Var,let and const
Ans. 
Var is function scoped, let and const are block scoped. Var can be redeclared and reassigned, let can be reassigned but not redeclared, const cannot be reassigned or redeclared.
• Var is function scoped

• Let and const are block scoped

• Var can be redeclared and reassigned

• Let can be reassigned but not redeclared

• Const cannot be reassigned or redeclared
Answered by AI
Add your answer
Q2. New features in Angular 10
Ans. 
Angular 10 introduces new features like stricter types, optional strict mode, and performance improvements.
• Stricter types with TypeScript 3.9

• Optional strict mode for better type checking

• Improved build times and smaller bundle sizes

• Updated dependencies like TypeScript 3.9 and TSLib 2.0
Answered by AI
Add your answer