Tiêu đề MySQL VIVA QUESTIONS.pdf ✅

www.YouTube.com/@pradnyasclass IMPORTANT MySQL VIVA QUESTIONS 1. Full Form of SQL. Structured Query Language. 2. What is difference between SQL and MySQL? SQL is a database language where MySQL is a software which facilitates to write commands to work with the tables. 3. Define degree and cardinality. ✓ Degree - Number of columns ✓ Cardinality - Number of rows 4. What is primary key? A field which uniquely identifies a record in the table is called a primary key. 5. What do you mean by candidate key? The fields which can be a primary key is called as candidate key. 6. Define foreign key. A foreign key is a field or group of fields which is a primary key of another table. 7. Expand DML and DDL. DML stands for Data Manipulation Language. DDL stands for Data Definition Language. 8. Give two examples of DDL commands. Create, alter, drop (CAD) 9. Give two examples of DML commands. Update, Insert, delete (UID) 10. What is the difference between INSERT and UPDATE command? INSERT command is used to add a record to the table whereas UPDATE command is used to modify already inserted record.