Advance Features Of Sqlserver 2005 For Aptech (Accp 20007)

Reviewed by Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By Vietha

Vietha

Community Contributor

Quizzes Created: 11 | Total Attempts: 9,883

| Attempts: 382

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

1/126 Questions

This refer to parts of XML documents. These parts need not include the root element.
- XML Views
- XML fragments
- Native XML storage

About This Quiz

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

Quiz Preview

2.

The XML data type can be used to define:- 3 choices.
- Rowa
- Columns
- Parameters
- Values
- Variables
Correct Answer(s)

A. Columns
A. Parameters
A. Variables

Explanation

The XML data type in programming can be used to define columns, parameters, and variables. It allows for storing and manipulating structured data in a hierarchical format. Columns refer to the fields or attributes of a table, parameters are variables that can be passed to a function or procedure, and variables are used to store data values that can be accessed and modified throughout the program. The XML data type provides flexibility and versatility in handling different types of data in a structured manner.

Rate this question:
3.

Until an xml data type variables. parameter, or column is not associated with an xml schema it is called:
- Typed XML data
- Untyped XML data
Correct Answer

A. Untyped XML data

Explanation

When an xml data type variable, parameter, or column is not linked to an xml schema, it is referred to as untyped XML data. This means that the data does not have any predefined structure or data types associated with it. Without an xml schema, the data is considered untyped and can be more flexible but also less structured compared to typed XML data.

Rate this question:
4.

Which statement of code is type xml data?
- CREATE TABLE student( ID varchar(20) not null, Address xml (CONTENT studentAddress) null, Class xml )
- CREATE TABLE student( ID varchar(20) not null, Address xml null, Class xml not null )
Correct Answer

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

Explanation

The correct answer is the first statement of code: CREATE TABLE student(
ID varchar(20) not null,
Address xml (CONTENT studentAddress) null,
Class xml
)
This is because in this statement, the "Address" column is defined as type xml with the optional "CONTENT studentAddress" specification, indicating that it will contain XML data. The second statement does not specify the "Address" column as xml data type.

Rate this question:
5.

The XML data type enable storage of xml data in their native form, xml
- True
- False
Correct Answer

A. True

Explanation

The XML data type allows for the storage of XML data in its original XML format. This means that the data can be stored and retrieved without any loss of information or structure. This is useful for applications that need to work with XML data directly, such as parsing and manipulating XML documents. By enabling storage in the native form, the XML data type ensures that the integrity and structure of the XML data is preserved. Therefore, the statement "The XML data type enables storage of XML data in their native form, xml" is true.

Rate this question:
6.

XML data type variables or columns can only store complete XML documents.
- True
- False
Correct Answer

A. False

Explanation

XML data type variables or columns can store both complete XML documents as well as fragments of XML data. This allows for more flexibility in storing and manipulating XML data within a database.

Rate this question:
7.

Native XML storage makes it easy to map XML data into relational databases
- True
- False
Correct Answer

A. False

Explanation

Native XML storage does not make it easy to map XML data into relational databases. In fact, native XML storage is designed to store and retrieve XML data without the need for mapping it into a relational database structure. Native XML databases are specifically built to handle XML data efficiently and provide functionalities like indexing, querying, and storing XML documents as a whole, rather than breaking them down into relational tables. Therefore, the statement is false.

Rate this question:
8.

XML data can provide a highly optimized querying environment by indexing.
- True
- False
Correct Answer

A. True

Explanation

XML data can provide a highly optimized querying environment by indexing. This is because XML data can be indexed using various techniques such as tree-based indexing or path-based indexing. By creating indexes on specific elements or attributes within the XML data, the querying process can be significantly sped up. Indexing allows for faster retrieval of data and improves the overall performance of XML queries. Therefore, the statement is true.

Rate this question:
9.

XML views work best when data in database needs to be converted to xml
- True
- False
Correct Answer

A. True

Explanation

XML views are a useful tool when there is a need to convert data from a database into XML format. XML views allow for the transformation of structured data into a hierarchical format, which is the basis of XML. This can be particularly helpful when integrating data from different sources or when sharing data with systems that require XML. By using XML views, the process of converting data from a database to XML becomes more efficient and manageable. Therefore, the statement that XML views work best when data in a database needs to be converted to XML is true.

Rate this question:
10.

XML data storage in relational databases makes data management impossible.
- True
- False
Correct Answer

A. False

Explanation

XML data storage in relational databases does not make data management impossible. In fact, XML data can be stored in relational databases using specific data types and structures. This allows for efficient querying, indexing, and manipulation of XML data within the relational database environment. Additionally, relational databases provide features like transactions, security, and data integrity constraints, which aid in effective data management. Therefore, the statement that XML data storage in relational databases makes data management impossible is false.

Rate this question:
11.

XML document can be validated against their schemas sincean xml schema defines an xml document's basic structure.
- True
- False
Correct Answer

A. True

Explanation

An XML schema is a set of rules and guidelines that define the structure, content, and data types of an XML document. It acts as a blueprint for validating an XML document to ensure it adheres to the specified structure. By validating an XML document against its schema, any errors or inconsistencies can be identified, allowing for data integrity and interoperability. Therefore, the given statement is true.

Rate this question:
12.

ALTER XML SCHEMA COLLECTION statement permits developers to modify existing schema elements and attributes.
- True
- False
Correct Answer

A. False

Explanation

The ALTER XML SCHEMA COLLECTION statement does not allow developers to modify existing schema elements and attributes. This statement is used to modify the properties of an existing XML schema collection, such as changing its name or owner. It does not provide the functionality to alter the schema elements or attributes within the collection. Therefore, the given answer is False.

Rate this question:
13.

This method is used to shred an xml document into relational data.
- Query();
- Value();
- Nodes();
- Modify();
Correct Answer

A. Nodes();

Explanation

The "nodes();" method is used to shred an XML document into relational data. It allows you to extract specific nodes from the XML document and convert them into a relational format. This method is commonly used in XML data processing to transform hierarchical data into tabular data that can be easily stored and manipulated in a relational database.

Rate this question:
14.

This method is used to retrieve fragments of an xml document.
- Value()
- Data()
- Query()
- Nodes()
Correct Answer

A. Query()

Explanation

The query() method is used to retrieve fragments of an XML document. It allows you to search for specific elements or attributes within the XML and return the matching results. This method is commonly used when you need to extract specific data from an XML document or perform complex searches.

Rate this question:
15.

Insert, append or delete XML document nodes.
- Modify
- Nodes
- Query
Correct Answer

A. Modify

Explanation

The correct answer is "modify". In XML, modifying refers to the action of changing or updating the content or structure of the document nodes. This can involve making changes to existing nodes, adding new nodes, or deleting existing nodes. The modify operation allows for the manipulation of XML documents to meet specific requirements or to update information as needed.

Rate this question:
16.

Recreate xml fragments as specified by query.
- Modify
- Exist
- Query
Correct Answer

A. Query

Explanation

The correct answer is "query" because the question asks for the term that specifies the action being performed. Out of the given options, "query" is the only term that directly relates to the task of recreating XML fragments as specified. The terms "modify" and "exist" do not accurately describe the action of recreating XML fragments.

Rate this question:
17.

Transpose XML values to relational database
- Value
- Exist
- Nodes
- Node
Correct Answer

A. Nodes

Explanation

The correct answer "nodes" suggests that the task is to transpose XML values to a relational database, specifically focusing on the nodes within the XML structure. This implies that the goal is to extract and convert the data contained within the XML nodes into a format that can be stored and queried in a relational database.

Rate this question:
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 ?
- CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails varchar NOT NULL, PassengerDetails varchar NOT NULL, ReservationDetails varchar NOT NULL)
- CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML, PassengerDetails XML (CONTENT Passenger) NOT NULL, ReservationDetails varchar NOT NULL)
- CRATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML, PassengerDetails XML, ReservationDetails XML)
- 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)
Correct Answer

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

Explanation

The correct answer is "CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML, PassengerDetails XML, ReservationDetails XML)". This code creates a table named "LongDistanceDetails" with four columns: TicketNumber (a non-null string), JourneyDetails (an XML data type), PassengerDetails (an XML data type), and ReservationDetails (an XML data type). This structure allows for storing long distance train travel details in the form of untyped XML data.

Rate this question:
19.

Which of these codes snippets about XML data type methods are true and which of these statements are false ?
- SELECT StudentID FROM Students WHERE @student.exist(‘(/Age)[.=”15”]’)=1
- SELECT @student.value( ‘(/Student/Age)[1]’, ‘int(2)’)
- SELECT StudentID FROM Students WHERE @student.exist(‘(/Age)[.=”15”]’)=0
- SET @student.modify( ‘insert Aaroninto Student[1]’)
- SELECT StudentID FROM Students WHERE @student.exist(‘(/Age’=”15”)
Correct Answer(s)

A. SELECT StudentID FROM Students WHERE @student.exist(‘(/Age)[.=”15”]’)=1
A. SELECT @student.value( ‘(/Student/Age)[1]’, ‘int(2)’)
A. SELECT StudentID FROM Students WHERE @student.exist(‘(/Age)[.=”15”]’)=0
A. SET @student.modify( ‘insert Aaroninto Student[1]’)

Explanation

The given answer includes four true statements about XML data type methods. The first statement is true because it selects the StudentID from the Students table where the XML data type @student exists and has an Age value of "15". The second statement is true because it uses the value() method to retrieve the first Age value from the XML data type @student and converts it to an integer with a length of 2. The third statement is true because it selects the StudentID from the Students table where the XML data type @student exists but does not have an Age value of "15". The fourth statement is true because it uses the modify() method to insert the value "Aaron" into the first Student element of the XML data type @student.

Rate this question:
20.

Software entity that implements a service specification.
- Service Consumer
- Service Locator
- Service Broker
- Services
- Service Provider
Correct Answer

A. Service Provider

Explanation

A software entity that implements a service specification is referred to as a service provider. This means that the service provider is responsible for creating and delivering the service as defined in the specification. The service provider is typically the entity that offers the service to service consumers, who can then use the service to fulfill their needs.

Rate this question:
21.

Service provider that can pass on service requests to one or more additional service providers.
- Service Consumer
- Service Locator
- Service Broker
- Services
- Service Provider
Correct Answer

A. Service Broker

Explanation

A service broker is a service provider that can pass on service requests to one or more additional service providers. It acts as an intermediary between the service consumer and the actual service provider, facilitating the connection and communication between them. The service broker helps in managing and coordinating the services, ensuring that the consumer's requests are fulfilled by the appropriate service providers.

Rate this question:
22.

Service provider that acts as a registry and allows for lookup of service provider interfaces and service location
- Service Consumer
- Service Locator
- Service Broker
- Services
- Service Provider
Correct Answer

A. Service Locator

Explanation

A service locator is a service provider that acts as a registry and allows for the lookup of service provider interfaces and service locations. It helps service consumers to locate and connect with the appropriate service providers by providing a centralized registry or directory. This allows for easier management and discovery of services in a distributed system.

Rate this question:
23.

Function in which consumers communicate through contract
- Service Consumer
- Service Locator
- Service Broker
- Services
- Service Provider
Correct Answer

A. Services

Explanation

The correct answer is "Services" because services are the functions or tasks that are provided by a service provider to service consumers. In this context, consumers communicate with the service provider through a contract, which outlines the terms and conditions of the service. The service provider then delivers the requested service to the consumer based on the agreed-upon contract.

Rate this question:
24.

SOA is an architecture that encourages tightly coupled communication between software services.
- True
- Fasle
Correct Answer

A. True

Explanation

SOA stands for Service-Oriented Architecture, which is an architectural approach that promotes the use of loosely coupled and independent software services. However, the given statement contradicts this definition by stating that SOA encourages tightly coupled communication between software services. Since this statement is incorrect, the correct answer is "True" as it accurately reflects the nature of SOA.

Rate this question:
25.

Service-Oriented architecture is essentially a collection of services that communicate with each other
- True
- False
Correct Answer

A. True

Explanation

Service-Oriented Architecture (SOA) is a design approach where software components are organized as services that can be independently deployed and accessed over a network. These services communicate with each other through well-defined interfaces, allowing them to collaborate and fulfill business processes. Therefore, the statement "Service-Oriented architecture is essentially a collection of services that communicate with each other" is true, as it accurately describes the fundamental concept of SOA.

Rate this question:
26.

Service consumer can be a client application, a server application such as a Web server, or any other kind of application.
- True
- False
Correct Answer

A. True

Explanation

The statement is true because a service consumer can indeed be any type of application, including client applications, server applications like web servers, or any other kind of application. This means that a service can be consumed by a wide range of applications, allowing for flexibility and interoperability in the system architecture.

Rate this question:
27.

Service is a function that directly depends on the state of other service.
- True
- False
Correct Answer

A. False

Explanation

The given statement is false. A service is a function that can be executed independently and does not directly depend on the state of other services. Services are designed to be modular and self-contained, allowing them to be easily reused and integrated into different systems without relying on the state of other services.

Rate this question:
28.

A group sharing similar dialog conversations.
- Endpoints
- Service Broker Security
- Conversation Groups
- Messages
- Dialogs
Correct Answer

A. Conversation Groups

Explanation

Conversation Groups refer to a group of related dialog conversations. It allows multiple conversations to be grouped together, enabling them to share common properties and behaviors. This grouping helps in managing and organizing conversations, making it easier to track and handle them as a unit. By using conversation groups, it becomes possible to perform actions on multiple conversations simultaneously, such as ending or deleting them.

Rate this question:
29.

A conversation that takes place between two Service Brokers.
- Endpoints
- Service Broker Security
- Conversation Groups
- Messages
- Dialogs
Correct Answer

A. Dialogs

Explanation

Dialogs are a key component in a conversation that takes place between two Service Brokers. Dialogs allow the Service Brokers to exchange messages and establish communication between the endpoints. They provide a way for the Service Brokers to maintain state and manage the flow of the conversation. Dialogs are essential for ensuring the reliability and integrity of the communication process.

Rate this question:
30.

An entity that is exchanged between Service Brokers
- Dialogs
- Endpoints
- Conversation Groups
- Service Broker Security
- Messages
Correct Answer

A. Messages

Explanation

Messages are the entities that are exchanged between Service Brokers. In the context of service-oriented architecture, messages are used to communicate and exchange information between different components or services. They contain the data and instructions that need to be transmitted from one service to another. Messages play a crucial role in enabling communication and coordination between different entities in a distributed system.

Rate this question:
31.

Supports communication between two services and connection between two databases along with authentication
- Endpoints
- Dialogs
- Service Broker Security
- Conversation Groups
- Message
Correct Answer

A. Service Broker Security

Explanation

Service Broker Security is the correct answer because it supports communication between two services and connection between two databases along with authentication. Service Broker Security provides a secure way to exchange messages between different services, ensuring that only authorized parties can access and interact with the data. It helps protect the integrity and confidentiality of the messages being transmitted, ensuring that sensitive information is not compromised during the communication process.

Rate this question:
32.

Responsible for the communication in Service Broker
- Conversation Groups
- Endpoints
- Service Broker Security
- Dialogs
- Messages
Correct Answer

A. Endpoints

Explanation

The correct answer is "Endpoints." In Service Broker, endpoints are responsible for the communication between the different components of the system. They define the network address and protocol for sending and receiving messages. Endpoints play a crucial role in establishing connections and facilitating the exchange of messages between the Service Broker components, such as conversation groups, dialogs, and messages. They ensure secure and reliable communication within the Service Broker system.

Rate this question:
33.

The messages are read one after another from the same queue by multiple programs
- True
- False
Correct Answer

A. False

Explanation

Multiple programs can read messages from the same queue one after another. Therefore, the given statement is true.

Rate this question:
34.

Service Broker handles ordering of messages, conversation identification, and unique delivery automatically.
- True
- False
Correct Answer

A. True

Explanation

Service Broker is a feature in SQL Server that allows different databases to communicate with each other asynchronously. It handles the ordering of messages, assigns a unique conversation ID to each message, and ensures reliable delivery of messages. These tasks are performed automatically by Service Broker, making it a convenient and efficient way to manage message-based communication between databases. Therefore, the statement that Service Broker handles ordering of messages, conversation identification, and unique delivery automatically is true.

Rate this question:
35.

Service Broker’s integrated design is beneficial for application performance and administration
- True
- Fasle
Correct Answer

A. True

Explanation

The integrated design of Service Broker is beneficial for application performance and administration because it allows for seamless communication between different components of an application. This integrated design eliminates the need for external messaging systems and simplifies the administration process. It also improves performance by reducing latency and increasing efficiency in message delivery. Overall, the integrated design of Service Broker enhances the overall performance and administration of applications.

Rate this question:
36.

Defines the type of message data
- Services
- Message Types
- Service Program
- Queues
- Contracts
Correct Answer

A. Message Types

Explanation

Message Types are used to define the structure and format of the data that can be exchanged between different components or systems in a messaging system. They specify the fields, data types, and any constraints or rules that need to be followed when sending or receiving messages. By defining the type of message data, message types ensure that the communication between different components is standardized and consistent, allowing for seamless integration and interoperability.

Rate this question:
37.

Agreement that specifies who sends the message and what message types are sent.
- Message Types
- Contracts
- Queues
- Services
- Service Type
Correct Answer

A. Contracts

Explanation

Contracts are agreements that specify who sends the message and what message types are sent. In the context of the given information, contracts define the terms and conditions between the parties involved in sending and receiving messages. They outline the responsibilities, expectations, and message types that will be exchanged. Contracts play a crucial role in ensuring that communication between different entities is clear, consistent, and mutually understood. They provide a framework for establishing and maintaining effective communication channels.

Rate this question:
38.

Holds messages as long as they do not expire
- Message Type
- Service Program
- Services
- Queues
- Contracts
Correct Answer

A. Queues

Explanation

Queues are a type of data structure that holds messages until they are processed or consumed. They are used to store and manage messages in a first-in, first-out (FIFO) manner. Messages in a queue can be held for as long as needed, until they are either processed or expire. Therefore, the correct answer to this question is "Queues."

Rate this question:
39.

Receives the messages from a queue and send the messages to services.
- Message Type
- Service Program
- Queues
- Services
- Contracts
Correct Answer

A. Service Program

Explanation

A service program receives the messages from a queue and sends them to services. This implies that the service program acts as an intermediary between the queue and the services. It is responsible for retrieving the messages from the queue and forwarding them to the appropriate services. This helps in ensuring efficient communication and coordination between different components of a system.

Rate this question:
40.

Handles and processes all the messages when they arrive at the server.
- Message Type
- Service Program
- Services
- Queues
- Contracts
Correct Answer

A. Services

Explanation

Services are responsible for handling and processing all the messages when they arrive at the server. This means that the services perform the necessary actions or tasks required for the messages, such as validating, transforming, storing, or forwarding them. Services play a crucial role in ensuring the smooth flow of messages within a server and are an essential component of the overall messaging system.

Rate this question:
41.

All Service Broker applications use conversations for their reliable communication
- True
- Fasle
Correct Answer

A. True

Explanation

Service Broker applications use conversations for their reliable communication. Conversations in Service Broker allow two or more applications to exchange messages in a reliable and ordered manner. Each conversation has a unique identifier and a sequence of messages. This ensures that messages are delivered in the correct order and that they are processed reliably. Therefore, it is true that all Service Broker applications use conversations for their reliable communication.

Rate this question:
42.

All Service Broker applications communicate using dialogs for reliable communication
- True
- False
Correct Answer

A. False

Explanation

Service Broker applications communicate using dialogs for reliable communication. This statement is false. Service Broker applications use message queues and conversations to communicate, not dialogs. Dialogs are a higher-level concept that builds on top of conversations. Conversations are used to exchange messages between services, while dialogs provide a way to group related conversations together. So, while dialogs are used for organizing conversations, they are not the means of communication themselves.

Rate this question:
43.

Service Broker delivers messages in an Exactly-Once-In-Order fashion
- True
- False
Correct Answer

A. True

Explanation

Service Broker delivers messages in an Exactly-Once-In-Order fashion, meaning that it ensures that messages are delivered exactly once and in the order in which they were sent. This ensures reliable and sequential processing of messages, which is important for maintaining data integrity and consistency in distributed systems. By guaranteeing that messages are delivered in the correct order, Service Broker helps to prevent data corruption and ensures that business processes can be executed correctly.

Rate this question:
44.

The first message dialog sent by the Service Broker has the message_sequence_number of one
- True
- False
Correct Answer

A. False

Explanation

The first message dialog sent by the Service Broker does not necessarily have the message_sequence_number of one. The message_sequence_number is assigned by the Service Broker and can vary depending on various factors such as the order in which messages are sent and received, the configuration settings, and any previous message dialogs that may have been established.

Rate this question:
45.

When conversations are going on between various SQL Server instances, Service Broker use the routes to direct the messages.
- True
- False
Correct Answer

A. True

Explanation

Service Broker is a messaging framework in SQL Server that allows communication between different instances. When conversations are happening between different instances, Service Broker uses routes to direct the messages. These routes define the path that messages should take to reach their destination. Therefore, the statement "When conversations are going on between various SQL Server instances, Service Broker uses the routes to direct the messages" is true.

Rate this question:
46.

Any type of message body is acceptable.
- NONE
- Well Formed xml
- Well Formed Xml Schema
- Empty
Correct Answer

A. NONE

Explanation

The correct answer is "NONE" because the question is asking for an explanation, not for a specific answer choice. The options provided are not relevant to the question and do not provide any information about the explanation. Therefore, the correct answer is "NONE" as there is no specific answer given in the question.

Rate this question:
47.

Only an empty message body is acceptable
- NONE
- Well Formed XML
- Well Form XML Schema
- EMPTY
Correct Answer

A. EMPTY
48.

Only a message body with valid XML is acceptable.
- NONE
- Well Formed XML
- Well Formed XML Schema
- EMPTY
Correct Answer

A. Well Formed XML

Explanation

The correct answer is "Well Formed XML" because well-formed XML refers to XML documents that adhere to the basic syntax rules of XML. These rules include having a root element, properly nested elements, and closing tags for all elements. Well-formed XML documents can be parsed and processed by XML parsers.

Rate this question:
49.

Arrange the following steps in sequence to create the service in Service Broker 1. Create a contract 2. Create an application that uses functions 3. Create a service 4. Create the message type 5. Create a queue.
- 1-3-2-4-5
- 4-1-2-5-3
- 4-1-5-3-2
- 2-3-4-1-5
Correct Answer

A. 4-1-2-5-3

Explanation

To create a service in Service Broker, the steps should be arranged in the following sequence:
1. Create the message type (4)
2. Create a contract (1)
3. Create an application that uses functions (2)
4. Create a queue (5)
5. Create a service (3)

Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 21, 2023

Quiz Edited by
ProProfs Editorial Team
Jun 13, 2009

Quiz Created by
Vietha

Advance Features Of Sqlserver 2005 For Aptech (Accp 20007)

This refer to parts of XML documents. These parts need not include the root element.

Quiz Preview

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

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

Which statement of code is type xml data?

The XML data type enable storage of xml data in their native form, xml

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

Native XML storage makes it easy to map XML data into relational databases

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

XML views work best when data in database needs to be converted to xml

XML data storage in relational databases makes data management impossible.

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

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

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

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

Insert, append or delete XML document nodes.

Recreate xml fragments as specified by query.

Transpose XML values to relational database

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 ?

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

Software entity that implements a service specification.

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

Service provider that acts as a registry and allows for lookup of service provider interfaces and service location

Function in which consumers communicate through contract

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

Service-Oriented architecture is essentially a collection of services that communicate with each other

Service consumer can be a client application, a server application such as a Web server, or any other kind of application.

Service is a function that directly depends on the state of other service.

A group sharing similar dialog conversations.

A conversation that takes place between two Service Brokers.

An entity that is exchanged between Service Brokers

Supports communication between two services and connection between two databases along with authentication

Responsible for the communication in Service Broker

The messages are read one after another from the same queue by multiple programs

Service Broker handles ordering of messages, conversation identification, and unique delivery automatically.

Service Broker’s integrated design is beneficial for application performance and administration

Defines the type of message data

Agreement that specifies who sends the message and what message types are sent.

Holds messages as long as they do not expire

Receives the messages from a queue and send the messages to services.

Handles and processes all the messages when they arrive at the server.

All Service Broker applications use conversations for their reliable communication

All Service Broker applications communicate using dialogs for reliable communication

Service Broker delivers messages in an Exactly-Once-In-Order fashion

The first message dialog sent by the Service Broker has the message_sequence_number of one

When conversations are going on between various SQL Server instances, Service Broker use the routes to direct the messages.

Any type of message body is acceptable.

Only an empty message body is acceptable

Only a message body with valid XML is acceptable.

Arrange the following steps in sequence to create the service in Service Broker 1. Create a contract 2. Create an application that uses functions 3. Create a service 4. Create the message type 5. Create a queue.