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

Online Test for Mysql

1. Which level of Abstraction describes what data are stored in the Database?
   Physical Level
   View Level
   Abstraction Level
   Logical Level

---

2. Which of the following is used to delete an entire MYSQL database?
   drop entiredb dbname
   drop database dbname
   drop db dbname
   drop dbase dbname

---

---

3. DROP TRIGGER Command is not used to drop the trigger.
   True
   False

---

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

---

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

---

6. Which statement is used to load data form file to table?
   LOAD LOCAL INFILE '/path/student.txt' INTO TABLE student;
   LOAD DATA LOCAL INFILE '/path/student.txt' INTO TABLE student;
   LOAD DATA LOCAL '/path/student.txt' INTO TABLE student;
   All the above

---

---

7. Which statement is used to displays information about the columns in a table.
   SHOW COLUMNS FROM tbl_job;
   EXPLAIN tbl_job;
   DESCRIBE tbl_job;
   All the above

---

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

---

9. Query to check value of MYSQL system variable
   SHOW VARIABLES
   SHOW VARIABLES GLOBAL
   SHOW GLOBAL VARIABLES
   A & C Both

---

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

---