SQL Computech SQL Developer Interview Questions and Answers

Q1. Types of Indexes
Ans. 
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
• Clustered indexes physically reorder the data in the table based on the index key.

• Non-clustered indexes create a separate structure for the index, pointing back to the original table data.

• Unique indexes ensure that no two rows have the same values in the indexed columns.

• Composite indexes are created on multiple columns to improve...read more
Answered by AI
Add your answer
Q2. Sceanrio based question
Add your answer

Q1. Salary discussion
Add your answer
Q2. Joining date and last working date
Add your answer

Profit and loss,percentage

Q1. Why do you this job ?
Add your answer
Q2. How can i believe you are the best to our company?
Add your answer

Learn basics of aptitude

Q1. Learn oops conceps and knowledge of coding in any language
Add your answer

Q1. What are your strengths and weaknesses?
Add your answer
Q2. Tell me about yourself.
Add your answer

Q1. Discussion about my previous project
Add your answer
Q2. Question on html, css, javascript & react
Add your answer
Q3. Explain about promises
Ans. 
Promises are objects representing the eventual completion or failure of an asynchronous operation.
• Promises are used to handle asynchronous operations in JavaScript.

• They can be in one of three states: pending, fulfilled, or rejected.

• Promises can be chained using .then() to handle success and .catch() to handle errors.

• Example: const myPromise = new Promise((resolve, reject) => { ... });
Answered by AI
Add your answer
Q4. Use state, context api
Add your answer
Q5. Box modelling in css, css pre processors
Ans. 
Box model in CSS refers to the way elements are rendered in a web page. CSS preprocessors like SASS or LESS help streamline CSS development.
• Box model in CSS includes content, padding, border, and margin.

• CSS preprocessors like SASS or LESS allow for variables, nesting, and mixins to be used in CSS.

• Example: box-sizing: border-box; in CSS changes the box model to include padding and border in the element's total width and
Answered by AI
Add your answer

Q1. Reverse an array using Java 8
Ans. 
Using Java 8, reverse an array of strings
• Use Arrays.stream() to convert the array to a stream

• Use Collections.reverse() to reverse the stream

• Use Collectors.toList() to convert the stream back to a list
Answered by AI
Add your answer

Q1. Code a controller class , service class, entity and repository
Ans. 
Code a controller, service, entity, and repository classes for a software application.
• Create a controller class to handle incoming requests and interact with the service layer.

• Develop a service class to implement business logic and interact with the repository.

• Define an entity class to represent data in the application.

• Implement a repository class to handle database operations for the entity.
Answered by AI
Add your answer
Q2. Basic questions about steams
Add your answer

Q1. How do you optimize Stored procedure
Ans. 
Optimizing stored procedures involves using proper indexing, reducing unnecessary loops, and minimizing database calls.
• Use proper indexing on columns used in WHERE clauses to improve query performance

• Avoid using cursors and loops whenever possible, as they can be inefficient

• Minimize the number of database calls by combining multiple queries into a single query or using temporary tables

• Consider using bulk processing tec...read more
Answered by AI
Add your answer
Q2. How do you optimize SQL query
Ans. 
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
• Use indexes on columns frequently used in WHERE clauses

• Minimize data retrieval by selecting only necessary columns

• Avoid unnecessary joins by using EXISTS or IN clauses instead

• Optimize query structure by using appropriate join types and conditions
Answered by AI
Add your answer
Q3. What is use of returning clause
Ans. 
Returning clause is used to return a value from a function or procedure in PL/SQL.
• Used to return a single value from a function or procedure

• Can be used to return multiple values using OUT parameters

• Helps in passing values back to the calling program
Answered by AI
View 1 more answer
Q4. Disadvantages of triggers
Ans. 
Triggers can lead to performance issues, complexity, and potential for unintended consequences.
• Triggers can make code harder to debug and maintain

• They can lead to cascading effects if not carefully implemented

• Performance can be impacted if triggers are not optimized

• Triggers can introduce dependencies between different parts of the codebase
Answered by AI
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. Angular life cycle, angular loading and some scenarios about authentication
Add your answer
Q2. Javascript out put based questions based on it's execution
Add your answer