Menu
Home / CSE MCQs / SQL Server MCQs :: SQL Server Data Connectivity

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. Which is the most serious issue after migration of access database to SQL Server ?
    2. A.
    Auto-increment columns are not updated until the record is updated
    B.
    Slow performance with linked tables
    C.
    New records are not available
    D.
    You cannot modify a linked table schema with Access

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. Under the _______ recovery model, all bulk operations are fully logged
    3. A.
    Simple
    B.
    Partial
    C.
    Full
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. Which of the following command tells that all local users are logged in as "sa in the following code ?

    EXEC sp_addlinkedsrvlogin
    @rmtsrvname = "Northwinds",
    @useself = "false",
    @locallogin = "sa",
    @rmtuser = "Admin",
    @rmtpassword = NULL
    4. A.
    sp_addlinkedsrv
    B.
    sp_addlinkedserver
    C.
    sp_addlinkedsrvlogin
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. When you execute SQL statements within Integration Services, the following optimization can be made ?
    5. A.
    If Integration Services and SQL Server run on the different server, use the SQL Server destination instead of the OLE DB destination to improve performance
    B.
    In SQL Server 2008 Integration Services, there is a new feature of the shared lookup cache
    C.
    If you cannot use commit size 1, use the highest possible value of commit size to reduce the overhead of multiple-batch writing
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. Which of the following is the best practice related to SSIS ?
    6. A.
    Plan for capacity by understanding resource utilization.
    B.
    SSIS is an in-memory pipeline, so ensure that all transformations occur in memory
    C.
    Baseline source system extract speed
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. Point out the correct statement :
    7. A.
    LINQ supports flat outer joins
    B.
    LINQ's parameterization is inline, typesafe, and highly readable
    C.
    LINQ queries are composable
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. The ______ pre-compiler translates embedded SQL into calls to the Oracle runtime library.
    8. A.
    Pro*C
    B.
    ORM
    C.
    ApexSQL
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. Which of the following stored prcoedure provide replication support for AlwaysOn ?
    9. A.
    sp_validate_replica_publishers
    B.
    sp_validate_hosts_as_publishers
    C.
    sp_validate_replica_hosts_as_publishers
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Point out the wrong statement :
    10. A.
    The developers can design applications from independent components known as services"
    B.
    The maintenance of Service Broker is difficult
    C.
    Maintenance of Service Broker it is a part of the routine database
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers