Home / CSE MCQs / SQL Server MCQs :: SQL Server Enterprise Data Management

CSE MCQs :: SQL Server MCQs

  1. How many types of backups are provided by SQL Server ?
  2. A.
    5
    B.
    6
    C.
    7
    D.
    8

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. The resources owned by WSFC node include:
  4. A.
    Destination address
    B.
    SQL Server Browser
    C.
    One file share resource, if the FILESTREAM feature is installed
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. Which of the following is used to determine the fragmentation for tables and indexes ?
  6. A.
    DBCC SHOWCONTIG
    B.
    DBCC CHECKDB
    C.
    DBCC CHECKCATALOG
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. Database mirroring operates in how many modes ?
  8. A.
    2
    B.
    3
    C.
    4
    D.
    5

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. Which of the following scenario prefers not to use database snapshots ?
  10. A.
    Database Snapshots should be seen as high availability option
    B.
    Database Snapshots should not be seen as an alternative to regular backups of your data
    C.
    Snapshots can be created very quickly
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Which of the following SQL Server tools is used to enhance data management and governance
  12. A.
    SSIT
    B.
    SSDT
    C.
    OBEII
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. In which of the following modes, the database is read-only ?
  14. A.
    Stand by
    B.
    Read only
    C.
    Restore mode
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. Which of the following is policy based management tip related to administration ?
  16. A.
    Evaluate and Implement Policies in Multiple SQL Server Instances
    B.
    Identify SQL Server Databases Not in Full Recovery Model
    C.
    SQL Server Policy Base Management Has Clustered Index Condition
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. How many types of recovery model is provided by SQL Server ?
  18. A.
    2
    B.
    3
    C.
    4
    D.
    5

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. SQL Agent Job definitions are specified in which database ?
  20. A.
    msdb
    B.
    master
    C.
    tempdb
    D.
    all of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum