SQL Aptitude

SQL MCQ

SQL Practice MCQ 1

  1. SQL stands for

    A.

    B.

    C.

    D.

  2. This statement is used to retrieve data from the database table

    A.

    B.

    C.

    D.

  3. Which clause is used to sort the data in result set?

    A.

    B.

    C.

    D.

  4. To add new records in database this statement is used

    A.

    B.

    C.

    D.

  5. The ___________ operator displays a record if ALL of the conditions listed are true

    A.

    B.

    C.

    D.

  6. Which SQL statement is used to return only different values?

    A.

    B.

    C.

    D.

  7. Which operator is used to select values within a range?

    A.

    B.

    C.

    D.

  8. __________ operator is used to search for a specified pattern in a column?

    A.

    B.

    C.

    D.

  9. Which SQL statement is used to create a table in a database?

    A.

    B.

    C.

    D.

  10. This is used to give alias name to table or column while writing sql query

    A.

    B.

    C.

    D.


Facebook Linked In Google + twitter Reddit Bookmark this page