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

Online Test for Mysql

1. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
   Rows
   Key
   Attribute
   Fields

---

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

---

---

3. Which symbol denotes derived attributes in the ER Model?
   Double ellipse
   Dashed ellipse
   Squared ellipse
   Ellipse with attribute name underlined

---

4. Which is right statement to kill process/thread in MySQL?
   KILL ALL thread_id/process_id
   KILL thread_id/process_id
   REMOVE thread_id/process_id
   None of the above

---

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

---

---

6. _____ is process of extracting previously non known valid and actionable information from large data to make crucial business and strategic decisions.
   Data Management
   Database
   Data Mining
   Meta Data

---

7. The DISTINCT keyword used along with the SELECT keyword retrieves ______ ?
   Duplicate data depending on the column list
   Unique data depending on the column list
   Sorted data depending on the column list
   None of the above

---

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

---