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
V
Vietha
Community Contributor
Quizzes Created: 11 | Total Attempts: 9,911
| Attempts: 382 | Questions: 126
Please wait...
Question 1 / 126
0 %
0/100
Score 0/100
1. Web Service methods provide access to database objects

Explanation

Web Service methods provide access to database objects. This statement is true because web services are designed to provide a standardized way for different applications to communicate and exchange data over the internet. In many cases, these applications need to access and manipulate data stored in databases. Web service methods are used to expose functionalities that can retrieve, update, or delete data from the database. This allows clients to interact with the database objects through the web service, making it a convenient and efficient way to access and manage data remotely.

Submit
Please wait...
About This Quiz
Advanced Features Quizzes & Trivia

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

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

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.

Submit
3. SOAP encourages distributed computing

Explanation

SOAP (Simple Object Access Protocol) is a protocol that allows programs running on different operating systems to communicate with each other over the internet. It is commonly used in web services to enable distributed computing, where different components of an application can be located on different machines. SOAP provides a standardized way of exchanging structured information between systems, making it easier to integrate and interact with remote services. Therefore, the statement "SOAP encourages distributed computing" is true, as SOAP facilitates communication and interoperability between distributed systems.

Submit
4. SOAP message consists of an XML document with a header and a body

Explanation

The statement is true because a SOAP message is indeed composed of an XML document that includes a header and a body. The XML document format allows for the exchange of structured information between systems using SOAP, which is a protocol for communication between applications over a network. The header typically contains metadata and information about the message, while the body contains the actual data being transmitted. Thus, the given answer is correct.

Submit
5.    A class consisting of properties and methods is created for defining a UDT

Explanation

In object-oriented programming, a UDT (User-Defined Type) is defined by creating a class that consists of properties (attributes) and methods (functions) specific to that type. Therefore, the statement "A class consisting of properties and methods is created for defining a UDT" is true. A class serves as a blueprint for creating objects of that type, allowing the programmer to define the structure and behavior of the UDT.

Submit
6. Which statement of code is type xml data?

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.

Submit
7. Insert, append or delete XML document nodes.

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.

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

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.

Submit
9. Only an empty message body is acceptable

Explanation

not-available-via-ai

Submit
10. Notification Services delivers notifications to the delivery endpoint by the protocol specified by the delivery channel

Explanation

The statement is true because Notification Services is responsible for delivering notifications to the delivery endpoint. The delivery channel specifies the protocol to be used for delivering the notifications. Therefore, the notifications will be delivered using the protocol specified by the delivery channel.

Submit
11. CLR is a runtime environment that manages the execution of .NET code

Explanation

The correct answer is true because CLR (Common Language Runtime) is indeed a runtime environment that manages the execution of .NET code. It provides various services such as memory management, exception handling, and security. CLR is responsible for compiling the intermediate language code into machine code during runtime and also ensures that the code runs efficiently and securely. Therefore, it can be concluded that CLR is an essential component of the .NET framework for executing and managing .NET applications.

Submit
12. The existing components and libraries can be easily exposed as Web Services

Explanation

The statement is true because existing components and libraries can indeed be exposed as web services. Web services allow these components and libraries to be accessed and utilized by other applications or systems over the internet. This enables interoperability and reusability of existing resources, making it easier to integrate them into different platforms or environments.

Submit
13. Subscriptions define what notifications the subscriber wishes to retrieve

Explanation

This statement is true because subscriptions allow subscribers to specify the types of notifications they want to receive. By defining their subscriptions, subscribers can choose which specific notifications or updates they are interested in and want to retrieve. This allows them to tailor their notification preferences according to their needs and preferences.

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

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.

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

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.

Submit
16. Defines the type of message data

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.

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

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.

Submit
18. SOAP is a protocol for the exchange of information in decentralized and distributed environments

Explanation

SOAP (Simple Object Access Protocol) is indeed a protocol used for exchanging structured information in decentralized and distributed environments. It allows different systems to communicate with each other by sending XML-based messages over various protocols like HTTP, SMTP, etc. SOAP enables interoperability between different platforms and languages, making it suitable for distributed systems. Therefore, the given statement is true.

Submit
19.   CREATE LOGIN statement is used to add a user to the SQL Server 2005 security system.

Explanation

The CREATE LOGIN statement is indeed used to add a user to the SQL Server 2005 security system. This statement allows for the creation of a login account, which is necessary for a user to access the SQL Server. By using this statement, administrators can grant appropriate permissions and control access to the server. Therefore, the given answer, which is "True," is correct.

Submit
20. GRANT CONNECT ON ENDPOINT statement grants permission to the user to connect to the HTTP endpoint.

Explanation

The GRANT CONNECT ON ENDPOINT statement grants permission to the user to connect to the HTTP endpoint. This means that the user will have the necessary access and privileges to establish a connection with the HTTP endpoint and perform actions or retrieve information from it. Therefore, the given answer "True" is correct.

Submit
21.   CRL compiles the code into Microsoft Intermediate Language.

Explanation

CRL, which stands for Common Language Runtime, is a component of the .NET framework that compiles the code into Microsoft Intermediate Language (MSIL). MSIL is a low-level programming language that is executed by the .NET runtime environment. Therefore, the statement "CRL compiles the code into Microsoft Intermediate Language" is true.

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

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.

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

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.

Submit
24.   A UDT is used to define a column in a table.

Explanation

A UDT (User-Defined Type) is indeed used to define a column in a table. It allows users to create their own data types based on existing data types provided by the database management system. These custom data types can then be used to define columns in tables, providing more flexibility and customization in data storage and retrieval.

Submit
25. CLR forms the core of Microsoft .NET programming initiative.

Explanation

CLR, or Common Language Runtime, is a key component of the Microsoft .NET programming initiative. It provides various services such as memory management, exception handling, and security. CLR also allows different programming languages to be used within the .NET framework, facilitating interoperability. Therefore, it can be concluded that CLR forms the core of Microsoft .NET programming initiative.

Submit
26. All Service Broker applications use conversations for their reliable communication

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.

Submit
27.   Web Services are services available on the Web

Explanation

The statement "Web Services are services available on the Web" is true. Web services are software systems designed to support interoperable machine-to-machine interaction over a network. They are accessed through standard web protocols and can be used by different applications and platforms regardless of their programming languages. These services can provide functionalities like data exchange, communication, and integration between different systems or applications over the internet. Therefore, the statement is correct.

Submit
28.   The SqlUserDefinedAggregate attribute is used before using a CLR aggregate function.

Explanation

The SqlUserDefinedAggregate attribute is indeed used before using a CLR aggregate function. This attribute is applied to a class that implements a user-defined aggregate function in SQL Server. It is used to specify the properties and behavior of the aggregate function, such as the name, the type it operates on, and whether it is deterministic or not. By applying this attribute, the CLR aggregate function becomes accessible and usable in SQL Server.

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

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.

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

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.

Submit
31. ALTER ENDPOINT statement permits adding, removing and altering a WEBMETHOD from the endpoints

Explanation

The ALTER ENDPOINT statement allows for the addition, removal, and alteration of a WEBMETHOD from the endpoints. This means that with this statement, you can modify the web methods associated with the endpoints, giving you flexibility and control over the functionality and behavior of the endpoints. Therefore, the given statement is true.

Submit
32. Specifies a Notification Services instance.

Explanation

The correct answer is NSInstance. NSInstance is the option that best fits the given description of specifying a Notification Services instance. The other options do not directly relate to specifying an instance. SubscriberDevice refers to a device used by a subscriber, SubscriberLocale refers to the language or region of a subscriber, Subscription refers to a specific subscription for a service, and Subscriber refers to an individual who has subscribed to a service.

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

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.

Submit
34. Responsible for the communication in Service Broker

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.

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

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.

Submit
36. Function in which consumers communicate through contract

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.

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

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.

Submit
38. Only a message body with valid XML is acceptable.

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.

Submit
39. Specifies the serialization format.

Explanation

The given correct answer, "Format," specifies the serialization format. This means that it determines the way in which the data is converted into a format that can be stored or transmitted. The format could be a specific file type, such as JSON or XML, or it could be a custom format defined by the system or application. The format is crucial for ensuring that the data can be properly interpreted and used by the receiving party.

Submit
40. The Terminate () method terminates the aggregation process

Explanation

The Terminate() method is used to terminate the aggregation process. This means that when this method is called, the aggregation process will be stopped and any remaining calculations or operations related to the aggregation will be halted. Therefore, the correct answer is True, as the Terminate() method does indeed terminate the aggregation process.

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

Explanation

XML fragments refer to parts of XML documents that do not include the root element. They are self-contained portions of an XML document that can be used independently or combined with other fragments to form a complete XML document. XML fragments are useful when only certain parts of an XML document need to be processed or transmitted, rather than the entire document. They allow for more flexibility and efficiency in working with XML data.

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

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.

Submit
43. 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 ?

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.

Submit
44.    Which one of the following code snippets is a valid code snippet for creating HTTP endpoints?

Explanation

The correct answer is the first code snippet: CREATE ENDPOINT sqlEndpoint STATE = STARTED AS HTTP(PATH = ‘/sql’, AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR)). This code snippet correctly uses the CREATE ENDPOINT statement to create an HTTP endpoint named sqlEndpoint. It specifies the path as '/sql', sets authentication to INTEGRATED, and uses the CLEAR port.

Submit
45. Subscriber can be a person identified by subscriber identification

Explanation

The statement is true because a subscriber can indeed be a person who is identified by their subscriber identification. This identification can be in the form of a unique number or code assigned to the individual, allowing them to be recognized and differentiated from other subscribers. This identification is important for various purposes such as billing, account management, and providing personalized services to the subscriber.

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

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.

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

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.

Submit
48. The Init () method is used to initialize the aggregate computation.

Explanation

The Init() method is used to initialize the aggregate computation. This means that it is responsible for setting up any necessary variables or data structures before the computation begins. By initializing the computation, the Init() method ensures that the aggregate function starts with a clean slate and is ready to process the data. Therefore, the given answer "True" is correct.

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

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.

Submit
50.   Specified in bytes the maximum size allowed for storing the state of the aggregate.

Explanation

The correct answer is MaxByteSize. This property specifies the maximum size, in bytes, allowed for storing the state of the aggregate. It determines the maximum amount of data that can be stored in the aggregate's state.

Submit
51. Sends a single row of data

Explanation

The given correct answer, "SendResultsRow," is the most appropriate option because it specifically mentions sending a single row of data. The other options, such as "SendResultsStart," "ExecuteAndSend," "SendResultsEnd," and "Send," do not specify the action of sending a single row of data. Therefore, "SendResultsRow" is the most suitable choice based on the information provided.

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

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.

Submit
53. The HTTP request is forwarded to SQL Server.

Explanation

The given correct answer states that "Receiving requests" is the reason why the HTTP request is forwarded to SQL Server. This suggests that the SQL Server is responsible for handling and processing incoming requests from clients. It implies that the SQL Server receives the requests and then performs the necessary actions or operations on the database objects based on those requests.

Submit
54. Recreate xml fragments as specified by 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.

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

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.

Submit
56. Subscription management interface can be an ASP.NET Web application

Explanation

The statement is true because an ASP.NET Web application can be used as a subscription management interface. ASP.NET is a web development framework that allows developers to build dynamic websites and web applications. With ASP.NET, developers can create user-friendly interfaces for managing subscriptions, allowing users to easily subscribe, unsubscribe, or modify their subscription preferences. This makes it a suitable choice for building a subscription management interface.

Submit
57. An entity that is exchanged between Service Brokers

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.

Submit
58. The generator writes notification to internal notification table.

Explanation

The given statement is true. The generator writes notifications to an internal notification table. This suggests that there is a system or process in place that generates notifications and stores them in a table specifically designed for this purpose. This table could be used for various purposes such as tracking and managing notifications, sending them to users, or generating reports based on the notifications.

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

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.

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

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.

Submit
61. Holds messages as long as they do not expire

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."

Submit
62.   Any type of message body is acceptable.

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.

Submit
63. Requires installation of Windows 2003 to support native HTTP

Explanation

The given correct answer suggests that the installation of Windows 2003 is required in order to support native HTTP. This means that in order to have native HTTP functionality, the system needs to have Windows 2003 installed. Native HTTP requirements may include features like receiving requests, accessing database objects, generating WSDL documents, and using Http.sys.

Submit
64. Subscription management interface does not require subscriptions, and subscriber devices to create notification services

Explanation

The statement is false because a subscription management interface does require subscriptions and subscriber devices to create notification services. This interface is responsible for managing and organizing subscriptions, allowing subscribers to receive notifications or updates from various sources. Without subscriptions and subscriber devices, the interface would have no purpose or function. Therefore, the given statement is incorrect.

Submit
65.   Supports communication between two services and connection between two databases along with authentication

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.

Submit
66. Web Services are platform independent, but not language independent

Explanation

Web services are both platform independent and language independent. This means that they can be accessed and used by different platforms (such as Windows, Linux, or macOS) and can be implemented using different programming languages (such as Java, Python, or C#). The interoperability of web services allows for seamless communication and integration between different systems and technologies. Therefore, the given statement is incorrect.

Submit
67. CLR executes non-managed code.

Explanation

The statement "CLR executes non-managed code" is incorrect. The Common Language Runtime (CLR) is responsible for executing managed code, which is code that is written in languages such as C# or Visual Basic.NET. The CLR provides various services such as memory management, exception handling, and security for managed code. Non-managed code, on the other hand, is code that is written in languages such as C or C++ and is not executed by the CLR. Therefore, the correct answer is False.

Submit
68. XML data storage in relational databases makes data management impossible.

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.

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

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.

Submit
70. All Service Broker applications communicate using dialogs for reliable communication

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.

Submit
71.   Action that occurred affecting the specified data.

Explanation

The correct answer is "Event". In the context of the given question, an event refers to an action that occurred affecting the specified data. It could be any kind of occurrence or incident that triggers a response or change in the system. Events are often used in event-driven programming or systems to handle and respond to various actions or inputs.

Submit
72. Specifies a device that can receive notifications.

Explanation

The correct answer is "SubscriberDevice" because it is the only option that directly relates to a device that can receive notifications. NSInstance, SubscriberLocale, Subscription, and Subscriber do not specifically refer to a device, but rather to other aspects of a subscription or subscriber.

Submit
73.   Satisfied by COUNT function.

Explanation

The correct answer is "IsInvariantToNull." This means that the COUNT function is not affected by null values in the data. In other words, if there are null values in the dataset, the COUNT function will still return an accurate count of non-null values.

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

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.

Submit
75. A group sharing similar dialog conversations.

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.

Submit
76. Web Services fail to encourage reusability

Explanation

Web Services actually encourage reusability. They provide a standardized way for different applications to communicate and share data over the internet. By using Web Services, developers can create modular and reusable components that can be easily integrated into different systems. This promotes code reuse and reduces the need to reinvent the wheel for every new project. Therefore, the statement "Web Services fail to encourage reusability" is incorrect.

Submit
77.   An act by which subscriber describes when and what to be notified on.

Explanation

A subscription is an act by which a subscriber provides information about when and what they want to be notified about. This means that the subscriber is specifying their preferences for receiving notifications or updates on certain events or topics. The subscriber is essentially signing up or registering to receive specific information or updates based on their interests or needs.

Submit
78.    A CLR UDE can have only a single element.

Explanation

A CLR UDE (Common Language Runtime User-Defined Exception) can have multiple elements. This means that a single CLR UDE can have different properties, methods, or data associated with it. This allows for more flexibility and customization when creating and handling exceptions in a .NET application.

Submit
79. Two new database objects that expands the storage and querying capabilities of SQL Server

Explanation

The correct answer is UDT & Aggregate Functions. UDT stands for User-Defined Types, which allow users to create their own data types and use them in their database schema. This expands the storage capabilities of SQL Server by allowing for more customized and specialized data types. Aggregate functions, on the other hand, allow users to perform calculations on a set of values and return a single value. This expands the querying capabilities of SQL Server by providing more advanced and complex calculations. Overall, both UDT and Aggregate Functions enhance the functionality and versatility of SQL Server.

Submit
80.   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.

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)

Submit
81. Endpoints can be altered by any of the members.

Explanation

Endpoints cannot be altered by any of the members. In a network or system, endpoints are the specific devices or applications that initiate or receive communication. They are fixed and cannot be changed by individual members. Therefore, the correct answer is False.

Submit
82.   Which of the following actions for creating and configuring a Notification Services application are correct and which are incorrect?

Explanation

The correct action is to deploy the notification services application. Deploying the application is necessary to make it available for use. However, deploying the target device or unregistering the target device are not actions related to creating and configuring a Notification Services application.

Submit
83.   Marks the beginning of the result set from a stored procedure.

Explanation

The correct answer is "SendResultsStart". This option is the one that marks the beginning of the result set from a stored procedure. It indicates the start of sending the results back to the caller or client.

Submit
84. IIS needs to be installed to listen for the requests in SQL Server 2005

Explanation

not-available-via-ai

Submit
85.   Document that helps in creating a proxy class, understand methods and parameters passing.

Explanation

The given correct answer suggests that the document helps in generating WSDL (Web Services Description Language) documents. WSDL documents are used to describe the functionality of a web service and provide information about the methods and parameters that can be used to interact with the service. By generating WSDL documents, developers can easily understand the methods and parameters passing in the proxy class, which is a class that acts as an interface for accessing a remote service.

Submit
86. Which statement is used to grant permission for stored procedure or user-define function?

Explanation

The correct answer is "GRANT EXECUTE ON TO". This statement is used to grant permission for a stored procedure or user-defined function. The "GRANT" keyword is used to give permissions, "EXECUTE" specifies the type of permission being granted, and "ON" is used to specify the object (stored procedure or user-defined function) for which the permission is being granted. The "TO" keyword is used to specify the user or role to whom the permission is being granted.

Submit
87.   Which of the following tasks in Notification Services are correct and which are incorrect?
-2 choices

Explanation

The correct tasks in Notification Services are subscription data stored in the database and generator matches subscriptions and events. Subscription data needs to be stored in a database to keep track of the subscribers and their preferences. The generator is responsible for matching the subscriptions with the corresponding events and generating the appropriate notifications.

Submit
88.   You want to register the Email assembly in the AdventureWorks database. The assembly cannot access the external resources and it should present in D:\Project\EMail\Email\bin\Debug directory. Which one of the following codes will help you to achieve this?

Explanation

The correct answer is "USE AdventureWorks CREATE ASSEMBLY Email FROM 'D:\Project\EMail\EMail\bin\Debug\EMail.dll' WITH PERMISSION_SET = SAFE". This code will register the Email assembly in the AdventureWorks database. It specifies the correct file path for the Email.dll assembly and sets the permission level to SAFE, which means it cannot access external resources. The USE AdventureWorks statement ensures that the assembly is registered in the correct database.

Submit
89.   A conversation that takes place between two Service Brokers.

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.

Submit
90. Software entity that implements a service specification.

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.

Submit
91. CLR is also known as Virtual Runtime System.

Explanation

CLR stands for Common Language Runtime, not Virtual Runtime System. The Common Language Runtime is a component of the Microsoft .NET framework that provides various services, such as memory management, exception handling, and security, for applications running on the framework. It is responsible for executing and managing .NET programs. Therefore, the given statement is false.

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

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.

Submit
93.   Microsoft .NET Framework languages provide different programming constructs and capabilities.

Explanation

The correct answer is "Enhanced Programming Model". The Microsoft .NET Framework languages offer an improved programming model, which means that developers have access to a set of tools, libraries, and capabilities that make it easier to create applications. This enhanced programming model includes features such as simplified syntax, better support for object-oriented programming, and improved integration with other technologies. Overall, the enhanced programming model allows developers to write code more efficiently and effectively, resulting in faster development and better-quality applications.

Submit
94.   Subscriber device is not the endpoint for notification delivery.

Explanation

The given statement is false. Subscriber devices are indeed the endpoints for notification delivery. When a notification is sent, it is delivered to the subscriber device, which can be a smartphone, tablet, computer, or any other device that the subscriber has registered to receive notifications. The subscriber device receives the notification and displays it to the user. Therefore, the subscriber device plays a crucial role in the delivery of notifications.

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

Explanation

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

Submit
96. You want to configure an e-mail delivery channel for the instance of Notification Services. Which one of the following codes will help you to achieve this?

Explanation

The correct answer is "EmailChannel SMTP" because SMTP (Simple Mail Transfer Protocol) is the standard protocol used for sending emails. Therefore, configuring an email delivery channel for Notification Services would require using the EmailChannel with the SMTP protocol.

Submit
97. Enables to manipulate subscriber information in Notification Services instance

Explanation

The correct answer is "Subscriber" because a subscriber is a person or entity who has opted in to receive notifications from a Notification Services instance. The subscriber's information, such as their device, locale, and subscription details, can be manipulated within the Notification Services instance to customize the notifications they receive.

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

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.

Submit
99. Which of the following is the correct code to send the message from service consumer to service provider

Explanation

This code snippet correctly declares a variable @dialog_handle1 to initiate a conversation between the service consumer and service provider. It specifies the source and destination services using the FROM SERVICE and TO SERVICE statements respectively. It also defines the contract between the two services using the ON CONTRACT statement. The code then sets the message content using the @msgString variable. Finally, it uses the SEND ON CONVERSATION statement to send the message with the specified message type.

Submit
100. The generator does the notification formatting and distribution in Notification Services.

Explanation

The given statement is false. The generator does not handle the notification formatting and distribution in Notification Services. This task is typically performed by other components or services within the system.

Submit
101. GRANT ACCESS statement is used to grant permission to a user for stored procedures

Explanation

The GRANT ACCESS statement is not used to grant permission to a user for stored procedures. It is actually used to grant or revoke access privileges for database objects such as tables, views, and functions. To grant permission to a user for stored procedures, the GRANT EXECUTE statement is used. Therefore, the given statement is false.

Submit
102. Transpose XML values to relational database

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.

Submit
103. The Merge () method is used to merge an aggregate object with another object.

Explanation

The Merge() method is not used to merge an aggregate object with another object. It is used to merge the changes made to a detached object back into the persistence context and update the corresponding entity in the database.

Submit
104.   You want to create a scalar-valued function named CurrencyConverter, which converts US dollar to Chinese Yuan. Which one of following codes will help you to achieve this?

Explanation

The correct answer is the fourth option: public partial class UserDefinedFunctions
{
[SqlFunction (DataAccess=DataAccessKind.None)]
public static SqlDecimal CurrencyConverter(SqlInt16 value)
{
return new SqlDecimal(((Int16)value * 7.10);
}
};

This is the correct answer because it includes the necessary attributes and parameters for a scalar-valued function in SQL Server. The [SqlFunction] attribute specifies that this method is a user-defined scalar function, and the DataAccessKind.None attribute specifies that the function does not access any external data. The function takes a SqlInt16 parameter named "value" and returns a SqlDecimal value, which is the desired behavior for a currency converter function.

Submit
105. Microsoft .NET Framework compilation and execution model improves the performance over T-SQL.

Explanation

The Microsoft .NET Framework compilation and execution model improves performance over T-SQL. This means that executing code written in .NET Framework is faster and more efficient compared to executing T-SQL code. This improvement in performance can be attributed to various factors such as the optimized compilation process, efficient memory management, and the ability to leverage the power of the underlying hardware. Overall, the improved performance of the .NET Framework makes it a preferable choice for developers when compared to T-SQL.

Submit
106. Exchanging SOAP messages leads to time consuming way for communicating with Web Services.

Explanation

Exchanging SOAP messages does not necessarily lead to a time-consuming way of communicating with Web Services. SOAP (Simple Object Access Protocol) is a messaging protocol that allows programs running on different operating systems to communicate with each other. While SOAP messages can be more verbose and have more overhead compared to other communication protocols, such as REST (Representational State Transfer), the efficiency of communication depends on various factors like network speed, message size, and server processing capabilities. Therefore, it is incorrect to claim that exchanging SOAP messages always leads to a time-consuming way of communication.

Submit
107. Indicates if no value is returned then aggregate returns null.

Explanation

The correct answer is "IsNullIfEmpty." This property indicates that if no value is returned by the aggregate function, it will return null. In other words, if the input to the aggregate function is empty or has no valid values, the result will be null.

Submit
108.   Database engine hosting the CLR environment execute managed codes.

Explanation

The correct answer is "Improved Safety & Security." This is because the database engine hosting the CLR environment executes managed codes, which provides improved safety and security. By executing managed codes, the database engine can enforce stricter security measures and ensure that the code being executed is safe and reliable. This helps to prevent any potential security vulnerabilities or risks that could arise from executing untrusted or malicious code within the database environment.

Submit
109. Executes the command received as an argument and returns the result set.

Explanation

The correct answer is "ExecuteAndSend" because it is the command that executes the command received as an argument and returns the result set. The other options mentioned, such as SendResultsEnd, SendResultsStart, SendResultsRow, are not related to executing a command and returning a result set.

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

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.

Submit
111. Receives the HTTP request from the client

Explanation

Http.sys is responsible for receiving the HTTP request from the client. It is a kernel-mode driver that handles HTTP protocol processing and provides a high-performance HTTP server. Http.sys is part of the native HTTP requirements in Windows operating systems and allows for receiving requests and accessing database objects. It is also used for WSDL (Web Services Description Language) document generation.

Submit
112. Entity interested in being notified when an event occurs.

Explanation

A subscriber is an entity that is interested in being notified when an event occurs. Subscribers typically subscribe to a notification system or service in order to receive notifications about specific events or updates. They provide their contact information or preferences to the system, and when the event they are interested in occurs, they receive a notification through their preferred channel, such as email or mobile app. Subscribers can choose to subscribe or unsubscribe from different events based on their interests and needs.

Submit
113. Developers develop and debug database objects and scripts from within the .NET development environment.

Explanation

The given correct answer suggests that one of the benefits of developing and debugging database objects and scripts from within the .NET development environment is a streamlined model. This means that the process of developing and debugging is made more efficient and simplified, resulting in a smoother workflow. This can save time and effort for developers, allowing them to focus on other aspects of their work.

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

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.

Submit
115.   Which of the following tasks in Notification Services are correct and which are incorrect?
- 3 choices

Explanation

The correct tasks in Notification Services are: Distributor sends notification to subscribers, Event data stored in application database, and Subscriber data stored in database. These tasks are all part of the process in Notification Services. The distributor is responsible for sending notifications to the subscribers, the event data needs to be stored in the application database for future reference, and the subscriber data also needs to be stored in a database for managing the subscribers.

Submit
116. You want to define a SQL Server event provider named SQLStockWatch in the application definition file. Which one of the following codes will help you to achieve this?

Explanation

This code includes the necessary elements to define a SQL Server event provider named SQLStockWatch. The SQLStockWatch is the name of the event provider, SQLProvider is likely the name of the SQL Server provider being used, and SERVER304 could be the name of the server hosting the SQL Server. The P0DT00H00M60S and PT4M are likely time intervals or durations for the event provider. The EventsQuery is a SQL query that retrieves specific data from the Stock table, and the EventClassName is the name of the class that handles the stock events.

Submit
117. The Accumulate () method is used to process the aggregate value into discrete value.

Explanation

The statement is false because the Accumulate() method is used to perform a cumulative operation on a sequence of values, not to process the aggregate value into discrete values. It takes an initial seed value and an accumulator function, which is applied to each element in the sequence to produce a running total or result.

Submit
118.   Sets the SqlPipe object to its original state.

Explanation

This answer is correct because the explanation accurately describes the purpose of the "SendResultsEnd" method. It states that this method sets the SqlPipe object back to its original state. This suggests that the method is used to finalize and end the sending of results from a SQL query.

Submit
119.   Satisfied by MAX and MIN function

Explanation

The correct answer is "IsInvariantToDuplicates." This property indicates whether the function's output remains the same when duplicate values are present in the input. If a function is invariant to duplicates, it means that it will produce the same result regardless of how many duplicate values are present in the input.

Submit
120. WSDL document helps to create a proxy class to call a Web Service

Explanation

The given answer is incorrect. A WSDL (Web Services Description Language) document actually describes the interface and functionality of a web service, including the operations that can be performed and the data types used. It does not directly help in creating a proxy class to call a web service. To create a proxy class, a tool like WSDL.exe or svcutil.exe is typically used to generate the proxy class code based on the information provided in the WSDL document.

Submit
121. SOAP defines application semantics such as a programming model or implementation-specific details

Explanation

SOAP does not define application semantics such as a programming model or implementation-specific details. SOAP is a protocol that is used for exchanging structured information in web services. It is a platform-independent and language-independent protocol that allows different systems to communicate with each other. The application semantics, programming model, and implementation-specific details are defined by the web services themselves, not by SOAP. Therefore, the correct answer is False.

Submit
122.   Which of the following actions for creating and configuring a Notification Services application are correct and which are incorrect?
- 3 choices

Explanation

The correct actions for creating and configuring a Notification Services application are to create custom event providers, create a subscription management application, and create an instance configuration file. Creating custom event providers allows you to define the events that trigger notifications. Creating a subscription management application enables users to manage their subscriptions to receive notifications. Creating an instance configuration file allows you to configure the settings for a specific instance of the Notification Services application.

Submit
123. Returns a string message or a single row result set to the client.

Explanation

The method "Send" is used to return a string message or a single row result set to the client. It is likely a part of a larger function or program that involves sending data or results back to the client.

Submit
124. Delivery Channels of Notification are:
- 3 choices

Explanation

The delivery channels of notification are SMTP channel, HTTP channel, and File channel. SMTP (Simple Mail Transfer Protocol) is commonly used for sending emails. HTTP (Hypertext Transfer Protocol) is used for communication between web servers and clients. File channel refers to the delivery of notifications through files. POP3 (Post Office Protocol 3), which is mentioned in the question, is not a valid delivery channel for notifications.

Submit
125.   Channel of communication.

Explanation

A notification is a message or alert that is sent to inform someone about a specific event or update. It serves as a channel of communication between the sender and the recipient, providing important information or updates. Unlike a subscriber or subscription, which refers to someone who has opted to receive certain content or services, a notification is the actual message or alert that is delivered to the subscriber. Similarly, an event is the occurrence or happening that triggers the notification to be sent. Therefore, notification is the correct answer in this context.

Submit
126. Complex UDT enhances the performance of the system.

Explanation

The statement that "Complex UDT enhances the performance of the system" is false. Complex UDT (User-Defined Types) typically introduce additional complexity and overhead to a system, which can negatively impact its performance. Complex UDTs may require more memory, processing power, and storage, leading to slower performance. Therefore, the correct answer is false, as complex UDTs do not enhance but rather hinder the performance of a system.

Submit
View My Results

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
Cancel
  • All
    All (126)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Web Service methods provide access to database objects
The XML data type enable storage of xml data in their native form, xml
SOAP encourages distributed computing
SOAP message consists of an XML document with a header and a body
   ...
Which statement of code is type xml data?
Insert, append or delete XML document nodes.
When conversations are going on between various ...
Only an empty message body is acceptable
Notification Services delivers notifications to the ...
CLR is a runtime environment that manages the execution of .NET code
The existing components and libraries can be ...
Subscriptions define what notifications the ...
XML data can provide a highly optimized querying environment by...
XML document can be validated against their schemas sincean xml schema...
Defines the type of message data
Service Broker delivers messages in an Exactly-Once-In-Order fashion
SOAP is a protocol for the exchange of ...
  ...
GRANT CONNECT ON ENDPOINT statement grants ...
  CRL compiles the code into Microsoft Intermediate Language.
This method is used to retrieve fragments of an xml document.
Service-Oriented architecture is essentially a ...
  A UDT is used to define a column in a table.
CLR forms the core of Microsoft .NET programming initiative.
All Service Broker applications use ...
  Web Services are services available on the Web
  ...
XML views work best when data in database needs to be converted to xml
Service Broker’s integrated design is beneficial ...
ALTER ENDPOINT statement permits adding, ...
Specifies a Notification Services instance.
Service provider that acts as a registry and ...
Responsible for the communication in Service Broker
Handles and processes all the messages when they ...
Function in which consumers communicate through contract
Service Broker handles ordering of messages, ...
Only a message body with valid XML is acceptable.
Specifies the serialization format.
The Terminate () method terminates the aggregation process
This refer to parts of XML documents. These parts need not include the...
XML data type variables or columns can only store complete XML...
You want to create a table store long distance ...
   ...
Subscriber can be a person identified by subscriber identification
Until an xml data type variables. parameter, or column is not...
Agreement that specifies who sends the message and ...
The Init () method is used to initialize the aggregate computation.
Service consumer can be a client application, a ...
  ...
Sends a single row of data
The XML data type can be used to define:- 3 choices.
The HTTP request is forwarded to SQL Server.
Recreate xml fragments as specified by query.
SOA is an architecture that encourages tightly ...
Subscription management interface can be an ASP.NET Web application
An entity that is exchanged between Service Brokers
The generator writes notification to internal notification table.
This method is used to shred an xml document into relational data.
Service provider that can pass on service ...
Holds messages as long as they do not expire
  Any type of message body is acceptable.
Requires installation of Windows 2003 to support native HTTP
Subscription management interface does not ...
  ...
Web Services are platform independent, but not language independent
CLR executes non-managed code.
XML data storage in relational databases makes data management...
Receives the messages from a queue and send the messages to services.
All Service Broker applications communicate ...
  Action that occurred affecting the specified data.
Specifies a device that can receive notifications.
  Satisfied by COUNT function.
Service is a function that directly depends on the ...
A group sharing similar dialog conversations.
Web Services fail to encourage reusability
  ...
   A CLR UDE can have only a single element.
Two new database objects that expands the ...
  ...
Endpoints can be altered by any of the members.
  ...
  ...
IIS needs to be installed to listen for the ...
  ...
Which statement is used to grant permission for stored procedure or...
  ...
  ...
  A conversation that takes place between two Service Brokers.
Software entity that implements a service specification.
CLR is also known as Virtual Runtime System.
The first message dialog sent by the Service Broker ...
  ...
  ...
The messages are read one after another from the ...
You want to configure an e-mail delivery channel ...
Enables to manipulate subscriber information in ...
ALTER XML SCHEMA COLLECTION statement permits developers to modify...
Which of the following is the correct code to send ...
The generator does the notification formatting and ...
GRANT ACCESS statement is used to grant ...
Transpose XML values to relational database
The Merge () method is used to merge an aggregate ...
  ...
Microsoft .NET Framework compilation and execution ...
Exchanging SOAP messages leads to time consuming way ...
Indicates if no value is returned then aggregate returns null.
  ...
Executes the command received as an argument and ...
Native XML storage makes it easy to map XML data into relational...
Receives the HTTP request from the client
Entity interested in being notified when an event occurs.
Developers develop and debug database objects and ...
Which of these codes snippets about XML data type ...
  ...
You want to define a SQL Server event provider ...
The Accumulate () method is used to process the ...
  Sets the SqlPipe object to its original state.
  Satisfied by MAX and MIN function
WSDL document helps to create a proxy class to call a Web Service
SOAP defines application semantics such as a ...
  ...
Returns a string message or a single row result set to the client.
Delivery Channels of Notification are:- 3 choices
  Channel of communication.
Complex UDT enhances the performance of the system.
Alert!

Advertisement