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

Online Test for Mysql

1. Which statement is wrong to select particular columns from table?
   SELECT id, question FROM placement_question;
   SELECT id, question FROM placement_question WHERE id = '2';
   SELECT id, question FROM placement_question WHERE 1;
   All are right

---

2. The number of attributes in relation is called as its
   Cardinality
   Entity
   Tuples
   Degree

---

---

3. USE, QUIT, EXIT does not require a semicolon.
   True
   False

---

4. Which is right statement to import data from text file in MySQL on shell editor?
   shell> mysql -host host_name -u user_name -p password db_name < text_file
   shell> mysql -host host_name -u user_name -p password db_name > text_file
   shell> mysql < text_file
   All the above

---

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

---

6. Source command is used to import data in MySQL.
   True
   False

---

---

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

---

8. Which is right statement to insert multiple records?
   INSERT INTO job_question VALUES ('col1', 'col2'), ('col1', 'col2'), ...
   INSERT INTO job_question VALUES ('col1', 'col2'), VALUES ('col1', 'col2'), ...
   A and B Both
   None of the above

---

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

---

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

---