Advance Features Of Sqlserver 2005 For Aptech (Accp 20007)

126 Questions | Total Attempts: 351

SettingsSettingsSettings
Please wait...
SQL Server Quizzes & Trivia

This is theory test for advance sql server 2005. It is good for you and I.


Related Topics
Questions and Answers
  • 1. 
    This refer to parts of XML documents. These parts need not include the root element.
    • A. 

      XML Views

    • B. 

      XML fragments

    • C. 

      Native XML storage

  • 2. 
    The XML data type can be used to define:- 3 choices.
    • A. 

      Rowa

    • B. 

      Columns

    • C. 

      Parameters

    • D. 

      Values

    • E. 

      Variables

  • 3. 
    Until an xml data type variables. parameter, or column is not associated with an xml schema it is called:
    • A. 

      Typed XML data

    • B. 

      Untyped XML data

  • 4. 
    Which statement of code is type xml data?
    • A. 

      CREATE TABLE student( ID varchar(20) not null, Address xml (CONTENT studentAddress) null, Class xml )

    • B. 

      CREATE TABLE student( ID varchar(20) not null, Address xml null, Class xml not null )

  • 5. 
    The XML data type enable storage of xml data in their native form, xml
    • A. 

      True

    • B. 

      False

  • 6. 
    XML data type variables or columns can only store complete XML documents.
    • A. 

      True

    • B. 

      False

  • 7. 
    Native XML storage makes it easy to map XML data into relational databases
    • A. 

      True

    • B. 

      False

  • 8. 
    XML data can provide a highly optimized querying environment by indexing.
    • A. 

      True

    • B. 

      False

  • 9. 
    XML views work best when data in database needs to be converted to xml
    • A. 

      True

    • B. 

      False

  • 10. 
    XML data storage in relational databases makes data management impossible.
    • A. 

      True

    • B. 

      False

  • 11. 
    XML document can be validated against their schemas sincean xml schema defines an xml document's basic structure.
    • A. 

      True

    • B. 

      False

  • 12. 
    ALTER XML SCHEMA COLLECTION statement permits developers to modify existing schema elements and attributes.
    • A. 

      True

    • B. 

      False

  • 13. 
    This method is used to shred an xml document into relational data.
    • A. 

      Query();

    • B. 

      Value();

    • C. 

      Nodes();

    • D. 

      Modify();

  • 14. 
    This method is used to retrieve fragments of an xml document.
    • A. 

      Value()

    • B. 

      Data()

    • C. 

      Query()

    • D. 

      Nodes()

  • 15. 
    Insert, append or delete XML document nodes.
    • A. 

      Modify

    • B. 

      Nodes

    • C. 

      Query

  • 16. 
    Recreate xml fragments as specified by query.
    • A. 

      Modify

    • B. 

      Exist

    • C. 

      Query

  • 17. 
    Transpose XML values to relational database
    • A. 

      Value

    • B. 

      Exist

    • C. 

      Nodes

    • D. 

      Node

  • 18. 
    You want to create a table store long distance train travel details. The table stores the journey, passenger and reservation details in the form of untyped XML data. Which one of the following codes will help you achieve this ?
    • A. 

      CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails varchar NOT NULL, PassengerDetails varchar NOT NULL, ReservationDetails varchar NOT NULL)

    • B. 

      CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML, PassengerDetails XML (CONTENT Passenger) NOT NULL, ReservationDetails varchar NOT NULL)

    • C. 

      CRATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML, PassengerDetails XML, ReservationDetails XML)

    • D. 

      CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML (CONTENT Journey) NOT NULL, PassengerDetails XML (CONTENT Passenger) NOT NULL, ReservationDetails XML (CONTENT Reservation) NOT NULL)

  • 19. 
    Which of these codes snippets about XML data type methods are true and which of these statements are false ?
    • A. 

      SELECT StudentID FROM Students WHERE @student.exist(‘(/Age)[.=”15”]’)=1

    • B. 

      SELECT @student.value( ‘(/Student/Age)[1]’, ‘int(2)’)

    • C. 

      SELECT StudentID FROM Students WHERE @student.exist(‘(/Age)[.=”15”]’)=0

    • D. 

      SET @student.modify( ‘insert Aaroninto Student[1]’)

    • E. 

      SELECT StudentID FROM Students WHERE @student.exist(‘(/Age’=”15”)

  • 20. 
    Software entity that implements a service specification.
    • A. 

      Service Consumer

    • B. 

      Service Locator

    • C. 

      Service Broker

    • D. 

      Services

    • E. 

      Service Provider

  • 21. 
    Service provider that can pass on service requests to one or more additional service providers.
    • A. 

      Service Consumer

    • B. 

      Service Locator

    • C. 

      Service Broker

    • D. 

      Services

    • E. 

      Service Provider

  • 22. 
    Service provider that acts as a registry and allows for lookup of service provider interfaces and service location
    • A. 

      Service Consumer

    • B. 

      Service Locator

    • C. 

      Service Broker

    • D. 

      Services

    • E. 

      Service Provider

  • 23. 
    Function in which consumers communicate through contract
    • A. 

      Service Consumer

    • B. 

      Service Locator

    • C. 

      Service Broker

    • D. 

      Services

    • E. 

      Service Provider

  • 24. 
    SOA is an architecture that encourages tightly coupled communication between software services.
    • A. 

      True

    • B. 

      Fasle

  • 25. 
    Service-Oriented architecture is essentially a collection of services that communicate with each other
    • A. 

      True

    • B. 

      False