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

Online Test for Mysql

1. Which is not a valid comment style in MySQL?
   # comment
   /* comment */
   -- comment
   //

---

---

2. How to see currently running queries in MySQL?
   SHOW PROCESSLIST;
   SHOW FULL PROCESSLIST;
   SHOW PROCESSLIST\G
   All the above

---

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

---

4. Insert into instructor values (10211, 'Smith', 'Biology', 66000); What type of statement is this?
   Query
   DML
   Relational
   DDL

---

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

---

---

6. Type data abstraction which allows conceptual representation of data in database management system is considered as
   Logical design model
   Data model
   Interface model
   User friendly model

---

7. Mysql is ____ ?
   Object Oriented Database
   XML Database
   Relational Database Management System (RDBMS)
   NoSQL Database

---

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

---

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

---