Filter interviews by
I applied via Campus Placement and was interviewed in Jan 2024. There were 2 interview rounds.
Information technology
A Primary Key is a unique identifier for each record in a database table.
Uniquely identifies each record in a database table
Must have a unique value for each record
Cannot have NULL values
Can be a single column or a combination of columns
A Foreign Key is a field in a database table that is used to establish a relationship with a primary key in another table.
Used to enforce referential integrity between tables
Helps maintain data consistency by ensuring that values in the foreign key column exist in the referenced table's primary key column
Can be used to create one-to-many or many-to-many relationships between tables
A Join is used to combine rows from two or more tables based on a related column between them.
Types of Joins: Inner Join, Left Join, Right Join, Full Outer Join, Cross 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 tabl...
The SELECT statement is used in SQL to retrieve data from a database.
Used to specify which columns to retrieve from a table
Can include conditions to filter the results using WHERE clause
Can be used with functions like COUNT, SUM, AVG, etc.
Example: SELECT column1, column2 FROM table_name WHERE condition;
Top trending discussions
based on 1 interview
Interview experience
based on 2 reviews
Rating in categories
Trainee Analyst
83
salaries
| ₹2 L/yr - ₹5 L/yr |
Softwaretest Engineer
75
salaries
| ₹1 L/yr - ₹7 L/yr |
HR Coordinator
65
salaries
| ₹1.4 L/yr - ₹3.5 L/yr |
Trainee
60
salaries
| ₹1 L/yr - ₹5 L/yr |
Executive Accountant
54
salaries
| ₹1.8 L/yr - ₹3.8 L/yr |
SEED Infotech
SQUAD Infotech
STC Technologies
MindScripts Tech