Menu
Home / CSE MCQs / SQL Server MCQs :: SQL Server Developing with SQL Server

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 stored procedures are present in SQL Server ?
    2. A.
    3
    B.
    4
    C.
    5
    D.
    8

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. How many type of cursor is present in SQL Server ?
    3. A.
    3
    B.
    4
    C.
    5
    D.
    6

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. Point out the correct statement :
    4. A.
    Logon triggers are special type of trigger that fire when LOGON event of Sql Server is raised
    B.
    DDL triggers are special type of trigger that fire when LOGON event of Sql Server is raised
    C.
    DML triggers are special type of trigger that fire when LOGON event of Sql Server is raised
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. DML triggers in SQL Server is applicable to :
    5. A.
    Insert
    B.
    Update
    C.
    Delete
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. Point out the wrong statement :
    6. A.
    The @stmt parameter in sp_executesql is a Unicode string containing valid SQL commands
    B.
    The input type @Type is passed as the first parameter to sp_executesql
    C.
    We can specify the parameters for both input and output in sp_executesql
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. Which of the following statements can be checked for Errors ?
    7. A.
    CREATE
    B.
    DROP
    C.
    DELETE
    D.
    INSERT

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. Which of the following is a control flow keyword ?
    8. A.
    IF
    B.
    GO
    C.
    GOTO
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. Which of the following script is example of SQL injection attack ?
    9. A.

    var Shipcity;

    ShipCity = Request.form ("ShipCity");

    var SQL = "select * from OrdersTable where ShipCity = '" + ShipCity + "'";
    B.

    var Shipcity;

    ShipCity = Request.form ("ShipCity");
    C.

    var Shipcity;

    var SQL = "select * from OrdersTable where ShipCity = '" + ShipCity + "'";
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Data return using output parameter is :
    10. A.
    Return codes, which are always an integer value
    B.
    A global cursor that can be referenced outside the stored procedure
    C.
    A single cursor that can be referenced inside the stored procedure
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. Which of the following has support for transaction ?
    11. A.
    sp_monitor
    B.
    sp_bindsession
    C.
    sp_status
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers