1. Placement Question
2. Mysql Interview Questions
3. Mysql Multiple Choice Questions

Mysql Multiple Choice Questions

1. Which symbol denotes derived attributes in the ER Model?
   1. Double ellipse
   2. Dashed ellipse
   3. Squared ellipse
   4. Ellipse with attribute name underlined

---

---

2. ACID properties of a transactions are
   1. Atomicity, consistency, isolation, database
   2. Atomicity, consistency, isolation, durability
   3. Atomicity, consistency, integrity, durability
   4. Atomicity, consistency, integrity, database

---

3. Commit command is used for
   1. To restore the old values
   2. To save the current table
   3. To save the current transaction
   4. To recover the old table

---

---

4. A table that displays data redundancies yields ________ anomalies
   1. Insertion
   2. Deletion
   3. Update
   4. All of the above

---

5. The value of Primary key
   1. can be duplicated
   2. can be null
   3. cannot be null
   4. none of these

---

6. MVD is called as
   1. Many Value Dependency
   2. More Value Dependency
   3. Multi Value Dependency
   4. All of the Above

---

---

7. Drop table structure is
   1. DML Statement
   2. DDL Statement
   3. Query Statement
   4. None of the above

---

8. In SQL, __________ is an Aggregate function.
   1. SELECT
   2. CREATE
   3. AVG
   4. MODIFY

---