MySQL Online Aptitude Test 1

15 Questions | Total Attempts: 1399

SettingsSettingsSettings
MySQL Online Aptitude Test 1 - Quiz

The test contains 15 questions and there is no time limit. The test is not official, it's just a nice way to see how much you know, or don't know, about SQL. Count Your ScoreYou will get 1 point for each correct answer. At the end of the Quiz, your total score will be displayed. Maximum score is 15 points. Good luck


Questions and Answers
  • 1. 
    What does SQL stands for?
    • A. 

      Structure query language

    • B. 

      Strong question language

    • C. 

      Structured question language

    • D. 

      Separate query language

  • 2. 
    What is the use of SQL?
    • A. 

      Storing data in database

    • B. 

      Manipulating data in database

    • C. 

      Retrieving data in database

    • D. 

      All of the above

  • 3. 
    Which SQL statement is used to extract data from the database?
    • A. 

      SELECT

    • B. 

      ACCESS

    • C. 

      OPEN

    • D. 

      GET

  • 4. 
    Which SQL statement is used to return only different values?
    • A. 

      DUPLICATE

    • B. 

      DISTINCT

    • C. 

      DIFFERENT

    • D. 

      SELECT

  • 5. 
    Which of the right syntax for DISTINCT SQL statement?
    • A. 

      SELECT DIFFERENT column1, column2, ... FROM table_name;

    • B. 

      SELECT DISTINCT column1, column2, ... WHERE table_name;

    • C. 

      SELECT DISTINCT column1, column2, ... FROM table_name;

  • 6. 
    You can add a row using SQL in a database with which of the following?
    • A. 

      ADD

    • B. 

      CREATE

    • C. 

      INSERT

    • D. 

      MAKE

  • 7. 
    The command to remove rows from a table 'CUSTOMER' is:
    • A. 

      REMOVE FROM CUSTOMER

    • B. 

      DROP FROM CUSTOMER

    • C. 

      DELETE FROM CUSTOMER WHERE

    • D. 

      UPDATE FROM CUSTOMER

  • 8. 
    Which command is used to specify the number of records to return?
    • A. 

      SELECT

    • B. 

      SELECT TOP

    • C. 

      EXTRACT

    • D. 

      SELECT SPECIFIC

  • 9. 
    The SQL WHERE clause?
    • A. 

      Limits the column data that are returned

    • B. 

      Limits the row data are returned

    • C. 

      Both A and B are correct

    • D. 

      Neither A nor B are correct

  • 10. 
    The wildcard in a WHERE clause is useful when?
    • A. 

      An exact match is necessary in a SELECT statement.

    • B. 

      An exact match is not possible in a SELECT statement.

    • C. 

      An exact match is necessary in a CREATE statement.

    • D. 

      An exact match is not possible in a CREATE statement.

  • 11. 
    Which command is used to insert a new records in the table?
    • A. 

      ADD

    • B. 

      INSERT INTO

    • C. 

      INSERT

    • D. 

      NEW

  • 12. 
    Which command is used to modify column name or table structure?
    • A. 

      MODIFY

    • B. 

      ADD

    • C. 

      CHANGE

    • D. 

      ALTER

  • 13. 
    Which command is used to change or update data in a table?
    • A. 

      CHANGE

    • B. 

      ALTER

    • C. 

      UPDATE

    • D. 

      MODIFY

  • 14. 
    Which keyword is used with UPDATE command to change the value?
    • A. 

      CHANGE

    • B. 

      MODIFY

    • C. 

      ADD

    • D. 

      SET

  • 15. 
    Which keyword is used with ALTER command to delete a column?
    • A. 

      DROP

    • B. 

      DELETE

    • C. 

      REMOVE

    • D. 

      CHANGE