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

5 comments:

  1. Suba1 February 2019 at 22:10

    Thanks for the update admin, eagerly waiting for the next session of your blog.


    Hadoop Training in Chennai
    Android Training in Chennai
    Selenium Training in Chennai
    Digital Marketing Course in Chennai
    JAVA Training in Chennai
    German Classes in chennai
    Big Data Training in Chennai
    Big Data Hadoop Training in Chennai

    ReplyDelete
  2. Balaji27 June 2019 at 01:15

    This comment has been removed by the author.

    ReplyDelete
  3. https://www.nakivo.com/incremental-backup/26 December 2019 at 01:58

    Passed, thanks :)

    ReplyDelete
  4. saran12 June 2020 at 18:26

    "It is actually a great and helpful piece of information. I am satisfied that you simply shared this helpful information with us. Please stay us informed like this. Thanks for sharing.
    Digital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery "

    ReplyDelete
  5. saran16 June 2020 at 23:47

    Thanks for sharing the information. It is very useful for my future. keep sharing.
    Digital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery

    ReplyDelete