Menu
Home / CSE MCQs / SQL Server MCQs :: SQL Server Security

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. Point out the correct statement :
    2. A.
    SQL Server 2008 offers three authentication mode options
    B.
    Microsoft's best practice recommendation is that you use Windows authentication mode whenever possible
    C.
    If you use mixed authentication mode, you should enable the DBA's Windows account
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. Which of the following feature prefers SQL Server authentication mode over winbdows authentication ?
    3. A.
    Backward compatibility
    B.
    Forward compatibility
    C.
    Security
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. Point out the wrong statement :
    4. A.
    EncryptByKey uses a symmetric key
    B.
    EncryptByKey returns NULL if the key is not open
    C.
    You can use encryption in SQL Server for connections, data, and stored procedures
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. Point out the wrong statement :
    5. A.
    Encryption should be considered for all data or connections
    B.
    Any use of encryption should also include a maintenance strategy for passwords, keys, and certificates
    C.
    TDE is essentially an enterprise-oriented feature and is available only in the following editions of SQL Server
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. Like data compression, TDE database encryption is performed at the ______ level.
    6. A.
    Page
    B.
    Domain
    C.
    Column
    D.
    Row

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. View that contains the list of all the security labels present in the database:
    7. A.
    vwVisibleLabels
    B.
    VisibleLabels
    C.
    vwVisibleLabel
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. _________ returns a list of the permissions effectively granted to the principal on a securable.
    8. A.
    HAS_PERMS_BY_NAME
    B.
    sys.fn_my_permissions
    C.
    sys.fn_permissions
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. Point out the wrong statement :
    9. A.
    The entity that receives permission to a securable is called a principal
    B.
    The SCHEMA securable scope contains the USER securables
    C.
    A table is a securable
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Any SQL Server authentication login can see ________ login name.
    10. A.
    Own and sa
    B.
    sa
    C.
    Own
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers