Question d’entretien chez Visa Inc.

Round 3 F2F: SQL and DB 1. the for INSERT query 2. ? for CREATE TABLE query 3. What is wrong with this SQL statement, SELECT * FROM student where student_id = 1234. Here student_id is of data type string. Correct statement - SELECT * FROM student where student_id LIKE '1234'; 4. What is Primary Key? 5. What is a Unique Key? 6. What is Foreign Key? 7. Difference Between Left Outer Join, Right Outer Join 8. What is Inner Join? 9. What is Self Join? 10. What is Full Outer Join? 11.A join query to fetch records for a given DB schema