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

CSE MCQs :: SQL Server MCQs

  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

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

  5. 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
  6. A.
    sp_addlinkedsrv
    B.
    sp_addlinkedserver
    C.
    sp_addlinkedsrvlogin
    D.
    None of the mentioned

  7. When you execute SQL statements within Integration Services, the following optimization can be made ?
  8. 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

  9. Which of the following is the best practice related to SSIS ?
  10. 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

  11. Point out the correct statement :
  12. 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

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

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

  17. Point out the wrong statement :
  18. 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