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

Mysql Multiple Choice Questions

17. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
    1. DML(Data Manipulation Langauge)
    2. DDL(Data Definition Langauge)
    3. Query
    4. Relational Schema

---

---

18. Create table employee (name varchar ,id integer) What type of statement is this ?
    1. DML
    2. View
    3. DDL
    4. Integrity constraint

---

19. To remove a relation from an SQL database, we use the ______ command.
    1. Delete
    2. Purge
    3. Remove
    4. Drop table

---

---

20. Insert into instructor values (10211, 'Smith', 'Biology', 66000); What type of statement is this?
    1. Query
    2. DML
    3. Relational
    4. DDL

---

21. The term attribute refers to a ___________ of a table.
    1. Record
    2. Column
    3. Tuple
    4. Key

---

22. The number of attributes in relation is called as its
    1. Cardinality
    2. Entity
    3. Tuples
    4. Degree

---

---

23. Which of the following is used to delete an entire MYSQL database?
    1. drop entiredb dbname
    2. drop database dbname
    3. drop db dbname
    4. drop dbase dbname

---

24. Drop Table cannot be used to drop a table referenced by a ______________ constraint.
    1. Primary Key
    2. Sub Key
    3. Super Key
    4. Foreign Key

---