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

Mysql Multiple Choice Questions

9. The primary key is selected from the:
   1. composite keys.
   2. determinants
   3. foreign keys
   4. candidate keys

---

---

10. If there is more than one key for relation schema in DBMS then each key in relation schema is classified as
    1. Prime key
    2. Super key
    3. Candidate key
    4. Primary key

---

11. Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
    1. Left outer join
    2. Full outer join
    3. Right outer join
    4. Half outer join

---

---

12. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
    1. Candidate key
    2. Sub key
    3. Super key
    4. Foreign key

---

13. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
    1. Rows
    2. Key
    3. Attribute
    4. Fields

---

14. A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
    1. Candidate
    2. Primary
    3. Super
    4. Sub

---

---

15. Which of the following statements creates a new table temp instructor that has the same schema as instructor.
    1. create table temp_instructor;
    2. Create table temp_instructor like instructor;
    3. Create Table as temp_instructor;
    4. Create table like temp_instructor;

---

16. A relational database consists of a collection of
    1. Table
    2. Fields
    3. Records
    4. Keys

---