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

CSE MCQs :: SQL Server MCQs

SQL Server MCQs - SQL Server Security
SQL Server MCQs - SQL Server Specifications
SQL Server MCQs - SQL Server Beyond Relational
SQL Server MCQs - SQL Server Data Connectivity
SQL Server MCQs - SQL Server Laying Foundation
SQL Server MCQs - SQL Server Manipulating Data
SQL Server MCQs - SQL Server Monitoring, Auditing
SQL Server MCQs - SQL Server Business Intelligence
SQL Server MCQs - SQL Server Developing with SQL Server
SQL Server MCQs - SQL Server Enterprise Data Management
SQL Server MCQs - SQL Server Performance Tuning,Optimization
  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

  2. The resources owned by WSFC node include:
    3. 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

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

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. Which of the following scenario prefers not to use database snapshots ?
    6. 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

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

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. Which of the following is policy based management tip related to administration ?
    9. 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

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

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers