Nucsoft Junior Software Engineer Interview Questions and Answers

Normal interview experience

Q1. Primary key foreign key delete truncate
Add your answer
Q2. Tell me about yourself project details
Add your answer

Q1. What is primary key
Ans. 
Primary key is a unique identifier for each record in a database table.
• Primary key ensures each record in a table is unique

• It can be a single column or a combination of columns

• Primary key values cannot be null

• Example: 'id' column in a 'users' table
Answered by AI
Add your answer
Q2. Difference between delete and truncate
Ans. 
Delete removes rows one by one, while truncate removes all rows at once.
• Delete is a DML command, while truncate is a DDL command.

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

• Delete fires triggers, while truncate does not fire triggers.
Answered by AI
Add your answer