DigiHelic Sfdc Developer Interview Questions and Answers

Q1. What is the closure in JS?
Ans. 
Closure in JS is a function that retains access to variables from its parent scope even after the parent function has finished executing.
• Closure allows functions to have access to variables from an outer function even after the outer function has finished executing.

• It is created whenever a function is defined within another function, and the inner function has access to the outer function's variables.

• Closures are commo...read more
Answered by AI
Add your answer
Q2. Explain about web worker ?
Ans. 
Web workers allow running JavaScript code in the background without blocking the main thread.
• Web workers are separate JavaScript files that run in the background.

• They allow for multi-threading in web applications.

• Web workers can perform tasks like heavy calculations or network requests without affecting the main UI thread.

• Communication between web workers and the main thread is done through message passing.
Answered by AI
Add your answer
Q3. How to pass props in React
Ans. 
Props in React are passed from parent components to child components to share data and functionality.
• Props are passed as attributes in JSX when rendering a component

• Props can be accessed in the child component using 'this.props'

• Props are read-only and should not be modified directly
Answered by AI
Add your answer

Q1. PLSQL basic to advanced.
Add your answer
Q2. Explain collections in details?
Ans. 
Collections in PL/SQL are data structures used to store multiple elements of the same data type.
• Collections can be nested tables, varrays, or associative arrays.

• Nested tables are like one-dimensional arrays with no upper bounds.

• Varrays are like arrays with a maximum size that is specified at declaration.

• Associative arrays are like lookup tables where each element is accessed using a unique key.

• Collections can be used t...read more
Answered by AI
Add your answer
Q3. Bulk collect concept
Ans. 
Bulk collect is a feature in PL/SQL that allows for fetching multiple rows of data at once.
• Improves performance by reducing context switches between the PL/SQL engine and SQL engine

• Reduces network traffic by fetching multiple rows in a single round trip

• Can be used with SELECT INTO or FETCH INTO statements
Answered by AI
Add your answer
Q4. Decode and case
Add your answer
Q5. Tuning of sql and some sql code
Add your answer

Bank product related questions and carrer expericnce .

Q1. How to insert multiple values in one go
Ans. 
Use the INSERT INTO statement with multiple value sets separated by commas
• Use the INSERT INTO statement followed by the table name

• List the column names in parentheses after the table name

• Use the VALUES keyword followed by multiple value sets in parentheses, separated by commas

• Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4)
Answered by AI
Add your answer
Q2. Update query using joins
Ans. 
Update query using joins in SQL
• Use UPDATE statement with JOIN clause to update data in multiple tables

• Specify the tables to be updated and joined using ON clause

• Set the columns to be updated in SET clause
Answered by AI
Add your answer

Q1. Technical discussion
Add your answer

Q1. Manager round and technical discussion
Add your answer

Q1. Selection processs
Add your answer

Moderate to difficult

Q1. DSA questions based on Dynamic programming
Add your answer

HTML CSS javascript jQuery

Q1. Explain about about you and background and your experiences and expertise areas. Difficulties or challenges that we faced in our last project What is performance tuning in Teradata and how to do one? Whet...read more
Add your answer

Q1. What are your salary expectations?
Add your answer

Q1. Explain about your experience and expertise? Tell about yourself?
Add your answer

Q1. Tell about yourself? Explain your last project and the challenges that you faced and if any appreciation you got from clients?
Add your answer

Q1. Self introduction and
Add your answer

Q1. U ask some questions on technical questions
Add your answer