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

Online Test for Mysql

1. DDL 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. 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

---

---

3. Which statement is used to count number of rows in table?
   SELECT COUNT(*) FROM placement_question;
   SELECT COUNT ALL(*) FROM placement_question;
   SELECT ROWS(*) FROM placement_question;
   All the above

---

4. The primary key is selected from the:
   composite keys.
   determinants
   foreign keys
   candidate keys

---

5. DCL is used to _______?
   Manage the changes made by DML statements
   Inserting, Deleting and Updating data
   Control access to data stored in a database
   None of the above

---

6. Function which causes retrieval of any kind of data from database is considered as
   Interface or Signature
   User friendly signature
   Conceptual signature
   Logical signature

---

---

7. Query result can be displayed vertically by terminating the query____?
   With \V instead of a semicolon
   With \G instead of a semicolon
   With \M instead of a semicolon
   All the above

---

8. BCNF Stands for _________.
   Binary Coded Normal Form
   Boyce - Codd Normal Form
   Bit Code Normal Form
   Boyce Codd Natural Form

---

9. The data type BLOB stands for:
   Binary Large Object
   Big List Object
   Binary List Object
   None of the above

---

10. 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:
    Left outer join
    Full outer join
    Right outer join
    Half outer join

---