Mysql Multiple Choice Questions

  1. 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
Answer :
D
Explanation:
Added By : Rajat

  1. 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
Answer :
A
Explanation:
Added By : Rajat


  1. 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
Answer :
B
Explanation:
Added By : Rajat

  1. What is maximum length of Database, Table, Column, trigger and view's name in MySQL?
    1. 128
    2. 256
    3. 64
    4. Unlimited
Answer :
C
Explanation:
Added By : Rajat

  1. 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
Answer :
D
Explanation:
Added By : Rajat

  1. 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
Answer :
A
Explanation:
Added By : Rajat


  1. Which statement is used to change database?
    1. USE db_name;
    2. WANT db_name;
    3. CHANGE db_name;
    4. None of the above
Answer :
A
Explanation:
Added By : Sumit

  1. Which statement is used to find out what databases currently exist on the server?
    1. SHOW DATABASE
    2. SHOW DATABASES
    3. SHOW ALL DATABASES
    4. All the above
Answer :
B
Explanation:
Added By : Sumit

Social Sharing
Search