1. Placement Question
2. Mysql Interview Questions
3. Mysql Multiple Choice Questions

Mysql Multiple Choice Questions

41. TCL is used for _______?
    1. Manage the changes made by DML statements
    2. Defining database schema
    3. Control access to data stored in a database
    4. None of the above

---

---

42. DCL is used to _______?
    1. Manage the changes made by DML statements
    2. Inserting, Deleting and Updating data
    3. Control access to data stored in a database
    4. None of the above

---

43. DDL is used for _______?
    1. Manage the changes made by DML statements
    2. Defining database schema
    3. Control access to data stored in a database
    4. None of the above

---

---

44. DML is used for _______?
    1. Control access to data stored in a database
    2. Defining database schema
    3. Inserting, Deleting and Updating data
    4. None of the above

---

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

---

46. Query result can be displayed vertically by terminating the query____?
    1. With \V instead of a semicolon
    2. With \G instead of a semicolon
    3. With \M instead of a semicolon
    4. All the above

---

---

47. Which command is used to import data form text file in MySQL on MySQL editor?
    1. mysql> source text_file_path;
    2. mysql> \. text_file_path
    3. None of the above
    4. A and B Both

---

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

---