Filter interviews by
Primary key uniquely identifies a record in a table, while unique key ensures all values in a column are different.
Primary key enforces uniqueness and not null constraint
Unique key enforces uniqueness but allows null values
A table can have only one primary key but multiple unique keys
Primary key is automatically indexed for faster retrieval
Functions are defined by specifying the function name, parameters, return type, and body of the function.
Functions are defined using the 'function' keyword followed by the function name.
Parameters are listed inside parentheses after the function name.
The return type of the function is specified before the function name.
The body of the function is enclosed in curly braces {} and contains the code to be executed.
Exa...
Yes, stored procedures can return result sets or scalar values.
Stored procedures can return result sets containing multiple rows and columns
They can also return scalar values like integers, strings, etc.
Results can be accessed by calling the stored procedure and fetching the output
There are four types of joins in SQL: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN: Returns rows when there is at least one match in both tables.
LEFT JOIN: Returns all rows from the left table, and the matched rows from the right table.
RIGHT JOIN: Returns all rows from the right table, and the matched rows from the left table.
FULL JOIN: Returns rows when there is a match in one of the tables.
SQL statements are executed in a specific order to retrieve, manipulate, or delete data from a database.
SQL statements are parsed and validated first
Next, the query optimizer creates an execution plan
The execution plan is executed by the SQL engine
Finally, the results are returned to the user
Overcome
To conquer or defeat
To successfully deal with a problem or difficulty
To prevail over obstacles
Magic table is a virtual table in SQL Server that is used to access the inserted, deleted, or updated data during triggers.
Magic table is used in SQL Server triggers to access the data affected by INSERT, UPDATE, or DELETE operations.
It is not a physical table, but a virtual table that stores the affected data temporarily.
The 'inserted' and 'deleted' tables are examples of magic tables in SQL Server triggers.
Indexes are data structures used to improve the speed of data retrieval operations in databases.
Types of indexes include clustered, non-clustered, unique, and composite indexes.
Indexes can be created on one or multiple columns in a table.
Examples of indexes are primary key indexes, foreign key indexes, and secondary indexes.
I appeared for an interview in Feb 2025, where I was asked the following questions.
I applied via Company Website and was interviewed before Jul 2023. There was 1 interview round.
SQL statements are executed in a specific order to retrieve, manipulate, or delete data from a database.
SQL statements are parsed and validated first
Next, the query optimizer creates an execution plan
The execution plan is executed by the SQL engine
Finally, the results are returned to the user
Primary key uniquely identifies a record in a table, while unique key ensures all values in a column are different.
Primary key enforces uniqueness and not null constraint
Unique key enforces uniqueness but allows null values
A table can have only one primary key but multiple unique keys
Primary key is automatically indexed for faster retrieval
There are four types of joins in SQL: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN: Returns rows when there is at least one match in both tables.
LEFT JOIN: Returns all rows from the left table, and the matched rows from the right table.
RIGHT JOIN: Returns all rows from the right table, and the matched rows from the left table.
FULL JOIN: Returns rows when there is a match in one of the tables.
Overcome
To conquer or defeat
To successfully deal with a problem or difficulty
To prevail over obstacles
Yes, stored procedures can return result sets or scalar values.
Stored procedures can return result sets containing multiple rows and columns
They can also return scalar values like integers, strings, etc.
Results can be accessed by calling the stored procedure and fetching the output
Indexes are data structures used to improve the speed of data retrieval operations in databases.
Types of indexes include clustered, non-clustered, unique, and composite indexes.
Indexes can be created on one or multiple columns in a table.
Examples of indexes are primary key indexes, foreign key indexes, and secondary indexes.
Functions are defined by specifying the function name, parameters, return type, and body of the function.
Functions are defined using the 'function' keyword followed by the function name.
Parameters are listed inside parentheses after the function name.
The return type of the function is specified before the function name.
The body of the function is enclosed in curly braces {} and contains the code to be executed.
Example:...
Magic table is a virtual table in SQL Server that is used to access the inserted, deleted, or updated data during triggers.
Magic table is used in SQL Server triggers to access the data affected by INSERT, UPDATE, or DELETE operations.
It is not a physical table, but a virtual table that stores the affected data temporarily.
The 'inserted' and 'deleted' tables are examples of magic tables in SQL Server triggers.
Top trending discussions
I appeared for an interview before Jul 2021.
I applied via Walk-in and was interviewed before May 2020. There were 3 interview rounds.
I applied via Naukri.com
Amazon's innovation, customer focus, and diverse opportunities align with my career goals and values.
Customer Obsession: Amazon prioritizes customer satisfaction, evident in initiatives like Prime and personalized recommendations.
Innovation: The company is a leader in technology and logistics, constantly pushing boundaries with services like AWS and drone delivery.
Diversity of Roles: Amazon offers a wide range of caree...
I expect Amazon to foster innovation, provide growth opportunities, and maintain a customer-centric culture.
Opportunities for professional development, such as training programs and mentorship.
A collaborative work environment that encourages teamwork and idea sharing.
Access to cutting-edge technology and resources to drive innovation.
A strong focus on customer satisfaction, ensuring that every decision prioritizes the ...
I applied via Naukri.com and was interviewed before Feb 2020. There were 3 interview rounds.
Workflow, trigger, reports, roles, profiles, permission set, and sharing rules are all important features in Salesforce.
Workflow is a series of automated steps that can be used to streamline business processes.
Triggers are used to execute code before or after a record is inserted, updated, or deleted.
Reports are used to display data in a visual format, such as a table or chart.
Roles are used to define the hierarchy of ...
I appeared for an interview before Jul 2020.
Yes, Infosys is listed on the Indian stock exchanges as well as on the NYSE.
Infosys is listed on the Bombay Stock Exchange (BSE) and National Stock Exchange of India (NSE)
It is also listed on the New York Stock Exchange (NYSE)
Infosys has a market capitalization of over $80 billion as of 2021
I applied via Job Fair and was interviewed before Feb 2021. There were 2 interview rounds.
I applied via Naukri.com and was interviewed in Nov 2019. There were 3 interview rounds.
I'm seeking new challenges and opportunities for growth that align with my career goals and aspirations.
Desire for professional growth: I'm looking to expand my skill set and take on more leadership responsibilities.
Seeking a better cultural fit: My current company has a different work culture than what I thrive in; I value collaboration and innovation.
Interest in new technologies: I'm excited about working with cuttin...
based on 1 interview experience
Difficulty level
Duration
based on 15 reviews
Rating in categories
Software Engineer
18
salaries
| ₹4.3 L/yr - ₹9.5 L/yr |
Software Developer
12
salaries
| ₹3 L/yr - ₹6 L/yr |
Softwaretest Engineer
11
salaries
| ₹2.4 L/yr - ₹7 L/yr |
Data Analyst
10
salaries
| ₹3.5 L/yr - ₹5 L/yr |
RPA Developer
8
salaries
| ₹4.5 L/yr - ₹5 L/yr |
TCS
Accenture
Wipro
Cognizant