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

Mysql Multiple Choice Questions

49. The DISTINCT keyword used along with the SELECT keyword retrieves ______ ?
    1. Duplicate data depending on the column list
    2. Unique data depending on the column list
    3. Sorted data depending on the column list
    4. None of the above

---

---

50. Which clause is used to sort the result of SELECT statement?
    1. SORT BY
    2. ORDER BY
    3. ARRENGE BY
    4. None of the above

---

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

---

---

52. Which statement is used to count number of rows in table?
    1. SELECT COUNT(*) FROM placement_question;
    2. SELECT COUNT ALL(*) FROM placement_question;
    3. SELECT ROWS(*) FROM placement_question;
    4. All the above

---

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

---

54. What is maximum length of Database, Table, Column, trigger and view's name in MySQL?
    1. 128
    2. 256
    3. 64
    4. Unlimited

---

---

55. Which statement is used to displays information about the columns in a table.
    1. SHOW COLUMNS FROM tbl_job;
    2. EXPLAIN tbl_job;
    3. DESCRIBE tbl_job;
    4. All the above

---

56. Which is the right statement to fetch all tables start with "a"?
    1. SHOW TABLES LIKE 'a%';
    2. SHOW TABLES LIKE 'a';
    3. SHOW ALL TABLES LIKE 'a%';
    4. All the above

---