1. PlacementQuestion
2. Mysql Interview Questions
3. Online Test for Mysql

Online Test for Mysql

1. TCL is used for _______?
   Manage the changes made by DML statements
   Defining database schema
   Control access to data stored in a database
   None of the above

---

2. What is IGNORE keyword in MySQL?
   Ignores Primary key or Unique key violations and continues processing with the next row
   Ignores Primary key or Unique key violations and leaves any remaining rows unprocessed.
   Do not ignores Primary key or Unique key violations
   None of the above

---

---

3. Which of the following is true?
   A relation in BCNF is always in 3NF.
   A relation in 3NF is always in BCNF.
   BCNF and 3NF are same.
   A relation in BCNF is not in 3NF

---

4. DML is used for _______?
   Control access to data stored in a database
   Defining database schema
   Inserting, Deleting and Updating data
   None of the above

---

5. Which statement is used to find out what databases currently exist on the server?
   SHOW DATABASE
   SHOW DATABASES
   SHOW ALL DATABASES
   All the above

---

6. Create table employee (name varchar ,id integer) What type of statement is this ?
   DML
   View
   DDL
   Integrity constraint

---

---

7. Which statement is used to connect with mysql server?
   mysql -h host_name -u user_name -p password
   mysql -u user_name -p password -h host_name
   mysql -p password -u user_name -h host_name
   All the above

---

8. Which of the following is used to delete an entire MYSQL database?
   drop entiredb dbname
   drop database dbname
   drop db dbname
   drop dbase dbname

---

9. The number of attributes in relation is called as its
   Cardinality
   Entity
   Tuples
   Degree

---

10. Storing same data in many places is called.
    Iteration
    Concurrency
    Redundancy
    Enumeration

---