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

Online Test for Mysql

1. Which command is used to import data form text file in MySQL on MySQL editor?
   mysql> source text_file_path;
   mysql> \. text_file_path
   None of the above
   A and B Both

---

2. What will be the output of this query UPDATE tab_name SET col1 = col1 + 1, col2 = col1;
   col1 and col2 have different value
   col1 and col2 have same value
   col2 has original value of col1
   None of the above

---

---

3. The problem that occurs when one transaction updates a database item and then the transaction fails for some reason is ________.
   Dirty Read Problem
   Temporary Modify Problem
   Temporary Select Problem
   None of the above

---

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

---

5. 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

---

6. 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

---

---

7. To remove a relation from an SQL database, we use the ______ command.
   Delete
   Purge
   Remove
   Drop table

---

8. 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

---

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

---

10. A relational database consists of a collection of
    Table
    Fields
    Records
    Keys

---