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

Online Test for Mysql

1. What is maximum length of Database, Table, Column, trigger and view's name in MySQL?
   128
   256
   64
   Unlimited

---

2. The student marks should not be greater than 100. This is
   Integrity constraint
   Referential constraint
   Over-defined constraint
   Feasible constraint

---

---

3. Which is the right statement to fetch all tables start with "a"?
   SHOW TABLES LIKE 'a%';
   SHOW TABLES LIKE 'a';
   SHOW ALL TABLES LIKE 'a%';
   All the above

---

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

---

5. In order to add a new column to an existing table in SQL, we can use the command
   MODIFY TABLE
   EDIT TABLE
   ALTER TABLE
   ALTER COLUMNS

---

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

---

---

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

---

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

---

9. Commit command is used for
   To restore the old values
   To save the current table
   To save the current transaction
   To recover the old table

---