SQL Quiz


SQL Quiz


  1. What is the full form of SQL

    2. Structured Queries List
    Structured Query Language
    Set Query Language
    Set Queries List

  2. SQL can be used to

    3. create database structures only
    query database data only
    modify database data only
    All of the above

  3. Which of the below is NOT a valid database backup type

    4. Differential
    Simple
    Full
    None of the above

  4. Which of the following is not a recovery model of a SQL Server Database

    5. Full
    Differential
    Bulk-Logged
    Simple

  5. How many clustered indexes can we have on a table in SQL Server?

    6. 1
    249
    999
    Unlimited

  6. Which of the following is the correct order of keywords for SQL SELECT statements?

    7. SELECT, FROM, WHERE
    FROM, WHERE, SELECT
    WHERE, FROM,SELECT
    SELECT,WHERE,FROM

  7. Member of which db role can run a select query on the database object?

    8. DB_SelectData
    Dataviewer
    DB_DataReader
    Datareader

  8. Which of the below is not an ACID Property?

    9. Atomicity
    Capacity
    Isolation
    Durability

  9. ............is a virtual table in SQL through which data from one or more tables can be seen.

    10. Stored Procedure
    View
    Sub Table
    Function

  10. Which of the following in not a High Availability /Disaster Recovery Mechanism in SQL?

    11. Database Mirroring
    Log Shipping
    Replication
    Dataloss protection

3 comments: