AmbitionBox Interview Questions, Process, and Tips

Q1. Difference between delete and truncate
Ans. 
Delete removes specific rows from a table, while truncate removes all rows from a table.
• Delete is a DML command, while truncate is a DDL command.

• Delete is slower as it logs individual row deletions, while truncate is faster as it deallocates the data pages.

• Delete can be rolled back, while truncate cannot be rolled back.

• Delete can have a WHERE clause to specify conditions, while truncate removes all rows without any con...read more
Answered by AI
View 1 more answer

Q1. What is identify property
Ans. 
Identity property is used in SQL to automatically generate unique values for a column.
• Identity property is used to create an auto-incrementing column in a table.

• It is commonly used as a primary key in a table.

• The identity property can be applied to numeric data types such as INT, BIGINT, etc.

• The identity value starts from a seed value and increments by a specified increment value.

• Example: CREATE TABLE Employees (ID INT
Answered by AI
View 1 more answer
Q2. What is synonyms what is use of it?
Ans. 
Synonyms are database objects that allow users to create aliases for other database objects.
• Synonyms can be used to simplify complex queries by providing a shorter name for a table or view.

• They can also be used to provide a layer of abstraction between the user and the underlying database objects.

• Synonyms can be created for tables, views, stored procedures, and other database objects.

• They can be used to reference objec...read more
Answered by AI
Add your answer

Q1. What is index what is use off it
Ans. 
An index is a database object that improves the speed of data retrieval operations on a table.
• Indexes are used to quickly locate data without having to search every row in a table.

• They are created on one or more columns of a table.

• Indexes can be clustered or non-clustered.

• Clustered indexes determine the physical order of data in a table.

• Non-clustered indexes are separate structures that contain a copy of the indexed co...read more
Answered by AI
Add your answer

Q1. What is difference between tempory table and table variable
Ans. 
Temporary tables are stored in tempdb while table variables are stored in memory.
• Temporary tables are created using CREATE TABLE statement while table variables are declared using DECLARE statement.

• Temporary tables can be accessed across sessions while table variables are limited to the scope of the batch, stored procedure or function.

• Temporary tables can have indexes and constraints while table variables cannot.

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

Q1. What is synonyms what is use off it
Ans. 
Synonyms are alternate names for database objects. They are used to simplify queries and provide security.
• Synonyms are used to provide an alternate name for a database object such as a table, view, stored procedure, or function.

• They can simplify queries by providing a shorter or more meaningful name for an object.

• Synonyms can also be used to provide security by allowing users to access an object without knowing its act...read more
Answered by AI
Add your answer

Q1. Total subject about sql and power bi
Add your answer

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

I am to good for any type of work doing

Q1. How do you perform keyword research?
Add your answer
Q2. What are ITSM and its processes?
Add your answer

Q1. Have you ever worked on a project with tight deadlines? How did you manage?
Add your answer
Q2. Describe a time when you faced a challenging situation. How did you handle it?
Add your answer

Question: Write a function to sort an array of integers in ascending order without using the built-in sort() function.

javascript
Copy code
function customSort(arr) {
// Your code here
}
console.log(customSort([5, 3, 8, 1])); // Output: [1, 3, 5, 8]

Operational Efficiency: Automating workflows in ServiceNow should reduce processing time for customer queries and loan applications by 50%.
Increased Visibility: SEO and SEM strategies should increase the bank’s website traffic by 30% within 3 months.
Improved Customer Experience: A modern portal with faster support options will increase customer satisfaction ratings.

A report/document explaining the solutions for the above tasks.
A code file for the HTML/CSS/JavaScript task.
Screenshots or diagrams (if applicable) for ServiceNow workflows.

Data Interpretation
Study the following data and answer the question:

Year Revenue (₹) Profit (₹)
2020 10,000 2,000
2021 12,000 3,000
2022 15,000 4,000Question:
What is the average profit percentage over the three years?

Options:
A) 20%
B) 25%
C) 22%
D) 27%

Q1. What is the meaning of a technical issue?
Add your answer
Q2. What is the meaning of a technical issue?
Ans. 
A technical issue refers to a problem arising from technology or systems that disrupts normal operations.
• Technical issues can include software bugs, such as a program crashing unexpectedly.

• Hardware failures, like a computer not booting up due to a faulty power supply.

• Network connectivity problems, such as being unable to access the internet.

• Configuration errors, for example, incorrect settings in a router causing conne
Answered by AI
Add your answer

Q1. What was your experience during the one-on-one round of the interview?
Ans. 
The one-on-one interview was insightful, allowing for a deep dive into my skills and experiences in copywriting.
• The interviewer was friendly and made me feel comfortable, which helped me express my thoughts clearly.

• I was asked about my previous projects, such as a successful campaign I wrote for a local business that increased their sales by 30%.

• We discussed my writing process, where I explained how I research and tail...read more
Answered by AI
Add your answer
Q2. What happened during the one-on-one round?
Add your answer

Q1. What is the implementation of Merge Sort in Java?
Ans. 
Merge Sort is a divide and conquer algorithm that divides the input array into two halves, recursively sorts them, and then merges the sorted halves.
• Divide the input array into two halves

• Recursively sort the two halves

• Merge the sorted halves back together
Answered by AI
Add your answer
Q2. What is the implementation of the Quick Sort algorithm in Java?
Ans. 
Quick Sort is a popular sorting algorithm that uses a divide-and-conquer approach to sort elements in an array.
• Choose a pivot element from the array.

• Partition the array into two sub-arrays: elements less than the pivot and elements greater than the pivot.

• Recursively apply the same process to the sub-arrays.

• Combine the sorted sub-arrays to get the final sorted array.
Answered by AI
Add your answer