Filter interviews by
I appeared for an interview before Jul 2016.
Primary keys uniquely identify records in a table, while foreign keys establish relationships between tables.
Primary keys ensure data integrity by enforcing uniqueness and preventing duplicate records.
Foreign keys create relationships between tables, allowing data to be linked and referenced across multiple tables.
Primary keys are typically used as foreign keys in related tables to establish relationships.
Foreign keys ...
Inner joins are used to combine rows from two or more tables based on a related column between them.
Inner joins return only the matching rows from both tables.
The join condition is specified using the ON keyword followed by the column(s) to join on.
Inner joins can be used to retrieve data from multiple tables based on a common column.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
The SELECT command is used to retrieve data from a database table.
SELECT is a fundamental SQL command used in database management systems.
It allows you to specify the columns and rows you want to retrieve from a table.
You can use various clauses like WHERE, ORDER BY, GROUP BY, etc. to filter and sort the data.
The result of a SELECT query is a result set or a cursor containing the selected data.
Example: SELECT * FROM em...
To create a table, use the CREATE TABLE statement in SQL.
Specify the table name after the CREATE TABLE keyword.
List the column names and their data types within parentheses.
Add any constraints or indexes as needed.
Example: CREATE TABLE employees (id INT, name VARCHAR(50), age INT);
I worked as a Systems Analyst at XYZ Company, where I was responsible for troubleshooting and resolving application issues.
Troubleshooting and resolving application issues
Collaborating with developers to implement fixes
Providing technical support to end users
Top trending discussions
I applied via Naukri.com and was interviewed before Nov 2020. There was 1 interview round.
I applied via Naukri.com and was interviewed before Mar 2020. There were 5 interview rounds.
posted on 1 Apr 2022
I applied via Naukri.com and was interviewed in Mar 2022. There were 2 interview rounds.
posted on 28 Nov 2024
I applied via Approached by Company and was interviewed in May 2024. There were 2 interview rounds.
Count duplicates in a string using java
Tell me about your framework
I applied via Naukri.com and was interviewed in Sep 2023. There were 2 interview rounds.
Questions on SQL queries
I applied via Naukri.com and was interviewed in Sep 2021. There were 2 interview rounds.
I applied via Naukri.com and was interviewed before May 2023. There was 1 interview round.
SSO can be implemented using protocols like SAML, OAuth, or OpenID Connect.
Choose a suitable SSO protocol like SAML, OAuth, or OpenID Connect.
Integrate the chosen protocol with your application's authentication system.
Set up identity providers (IdP) and service providers (SP) for SSO.
Implement single sign-on functionality to allow users to access multiple applications with one set of credentials.
based on 2 reviews
Rating in categories
Senior Recruitment Associate
255
salaries
| ₹3 L/yr - ₹8.5 L/yr |
Recruitment Associate
177
salaries
| ₹2.5 L/yr - ₹5.2 L/yr |
Recruitment Specialist
126
salaries
| ₹3.6 L/yr - ₹10.6 L/yr |
Payroll Specialist
94
salaries
| ₹2 L/yr - ₹7 L/yr |
Principal Consultant
76
salaries
| ₹3.5 L/yr - ₹11 L/yr |
Randstad
Team Lease
Innovsource Services
IMPACT Infotech