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

Online Test for Mysql

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

---

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

---

---

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

---

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

---

5. Referential integrity is directly related to
   Relation Key
   Primary Key
   Unique Key
   Foreign Key

---

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

---

---

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

---

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

---

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

---

10. Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
    Left outer join
    Full outer join
    Right outer join
    Half outer join

---