Naviga Interview Questions and Answers

Q1. Why do you want to work here tell me something about your selff
Add your answer
Q2. What do you decide to apply to this postion
Add your answer

Entry level basic reasong test needs to be cleared to pass for round 2

Q1. Based on the field or department some questions woukd be asked jn a 30 to 60 min interview session.
Add your answer

Q1. Joins - scenario based question
Ans. 
Joins in SQL combine rows from two or more tables based on related columns.
• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.a_id;

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.a_id;

• RIGHT JOIN: Returns all records from the right table and matched records from th...read more
Answered by AI
Add your answer
Q2. Difference between clustered and non-clustered indexes?
Ans. 
Clustered indexes physically order the data rows in the table while non-clustered indexes do not.
• Clustered indexes determine the physical order of data rows in a table.

• Non-clustered indexes store a separate structure that contains the index key values and pointers to the actual data rows.

• Tables can only have one clustered index but multiple non-clustered indexes.

• Clustered indexes are faster for retrieval of data but sl...read more
Answered by AI
Add your answer