| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
82. Entity interested in being notified when an event occurs.
A.Notification
B. Subscription
B. Subscription
C. Subscriber
D. Event
83. Channel of communication
A.Subscriber
B. Subscription
C. Event
D. Notification
84.Action that occurred affecting the specified data.
A.Notification
B. Event
C. Subscriber
D. Subscription
85. An act by which subscriber describes when and what to be notified on.
A.Subscription
B. Subscriber
C. Notification
D. Event
86.Which of the following tasks in Notification Services are correctand which are incorrect?
- 3 choices
- 3 choices
A.Events format notifications.
B. Distributor sends notification to subscribers
B. Distributor sends notification to subscribers
C. Event data stored in application database.
D. Generator runs every five seconds.
E. Subscriber data stored in database
87. Which of the following tasks in Notification Services are correctand which are incorrect?
-2 choices
-2 choices
A.Subscription data stored in database.
B. Generator collects event data.
C. Generator matches subscriptions and events.
88.Which of the following actions for creating and configuring a Notification Services application are correctand which are incorrect?
- 3 choices
- 3 choices
A.Create a stored procedure.
B.Create custom event providers.
B.Create custom event providers.
C. Create program definition file.
D. Create subscription management application.
E. Create instance configuration file.
89. Which of the following actions for creating and configuring a Notification Services application are correctand which are incorrect?
A.Deploy notification services application.
B.Deploy the target device.
C.Unregister the target device.
B.Deploy the target device.
C.Unregister the target device.
90. 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?
A.P0DT00H00M60S
PT4M
EventsQuery
SELECT StockID, StockPrice, StockName FROM
Stock
EventClassName
StockEvents
PT4M
EventsQuery
SELECT StockID, StockPrice, StockName FROM
Stock
EventClassName
StockEvents
B.SQLStockWatch
SQLProvider
SERVER304
P0DT00H00M60S
PT4M
EventClassName
StockEvents
SQLProvider
SERVER304
P0DT00H00M60S
PT4M
EventClassName
StockEvents
C.SQLStockWatch
SQLProvider
SERVER304
P0DT00H00M60S
PT4M
EventsQuery
SELECT StockID, StockPrice, StockName FROM
Stock
SQLProvider
SERVER304
P0DT00H00M60S
PT4M
EventsQuery
SELECT StockID, StockPrice, StockName FROM
Stock
D.SQLStockWatch
P0DT00H00M60S
PT4M
EventsQuery
SELECT StockID, StockPrice, StockName FROM
Stock
EventClassName
StockEvents
91.Specifies a device that can receive notifications.
A.NSInstance
B.SubscriberDevice
B.SubscriberDevice
C. SubscriberLocale
D.Subscription
D.Subscription
E. Subscriber
92. Specifies a geographic region for which a notification will be formatted
A.Subscriber
B. Subscription
C. SubscriberLocale
D. NSInstance
93.Specifies a Notification Services instance.
A.SubscriberDevice
B. NSInstance
C. SubscriberLocale
D. Subscription
E. Subscriber
94.Specifies a single subscription
A.Subscriber
B. Subscription
C. SubscriberLocale
D. NSInstance
E. SubscriberDevice
95.Enables to manipulate subscriber information in Notification Services instance
A.SubscriberDevice
B. NSInstance
C. SubscriberLocale
D. Subscription
E. Subscriber
96.Subscriptions define what notifications the subscriber wishes to retrieve
A.True
B. False
97.Subscriber can be a person identified by subscriber identification
A.True
B. False
98.Subscription management interface can be an ASP.NET Web application
A.True
B. False
99. Subscription management interface does not require subscriptions, and subscriber devices to create notification services
A.True
B. False
100.Subscriber device is not the endpoint for notification delivery.
A.True
B. False
101. 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?
A.FineChannel
C:File.xml
B. EmailChannel
SMTP
C:File.xml
B. EmailChannel
SMTP
C.EmailChannel
http://aptech-education.com
D. File or
EmailChannel
C:File1.xml
http://aptech-education.com
D. File or
EmailChannel
C:File1.xml
102. Notification Services uses internal channels for the final delivery of notification.
A.True
B. False
103. Notification Services delivers notifications to the delivery endpoint by the protocol specified by the delivery channel
A.True
B. False
104.The generator writes notification to internal notification table.
A.True
B. False
105.Custom control formatters can be developed to format notifications for the device and locale.
A.True
B. False
106. The generator does the notification formatting and distribution in Notification Services.
A.True
B. False
107. Delivery Channels of Notification are:
- 3 choices
- 3 choices
A.POP3 channel
B. SMTP channel
C. Email channel
D. HTTP channel
E. File channel
108. A class consisting of properties and methods is created for defining a UDT
A.True
B. False
109. A CLR UDE can have only a single element.
A. True
A. True
B. False
110. Complex UDT enhances the performance of the system.
A. True
B. False
111.A UDT is used to define a column in a table.
A.True
B. False
112. You want to register the Email assembly in the AdventureWorks database. The assembly cannot access the external resources and it should present in D:ProjectEMailEmailbinDebug directory. Which one of the following codes will help you to achieve this?
A.CREATE ASSEMBLY Email
FROM ‘EMailEMailbinDebugEmail.dll’
WITH PERMISSION_SET = SAFE
FROM ‘EMailEMailbinDebugEmail.dll’
WITH PERMISSION_SET = SAFE
B.USE AdventureWorks
CREATE ASSEMBLY Email
FROM
‘D:ProjectEMailEMailbinDebugEMail.dll’
WITH PERMISSION_SET = SAFE
CREATE ASSEMBLY Email
FROM
‘D:ProjectEMailEMailbinDebugEMail.dll’
WITH PERMISSION_SET = SAFE
C.CREATE ASSEMBLY EMail
FROM ‘D:ProjectEMailEMailbinDebugEMail.dll’
FROM ‘D:ProjectEMailEMailbinDebugEMail.dll’
D.USE AdventureWorks
CREATE ASSEMBLY EMail
FROM ‘D:ProjectEMailEMailbinDebugEMail.dll’
WITH PERMISSION_SET = UNSAFE
CREATE ASSEMBLY EMail
FROM ‘D:ProjectEMailEMailbinDebugEMail.dll’
WITH PERMISSION_SET = UNSAFE
113.Satisfied by MAX and MIN function
A.MaxByteSize
B. IsNullIfEmpty
C. Format
D. IsInvariantToNulls
E. IsInvariantToDuplicates
114. Specified in bytes the maximum size allowed for storing the state of the aggregate.
A.IsInvariantToDuplicates
B. IsInvariantToNulls
C. Format
D. IsNullIfEmpty
E. MaxByteSize
115.Specifies the serialization format.
A.MaxByteSize
B. IsNullIfEmpty
C. Format
D. IsInvariantToNulls
E. IsInvariantToDuplicates
116.Indicates if no value is returned then aggregate returns null.
A.IsInvariantToDuplicates
B. IsInvariantToNull
C. IsNullIfEmpty
D. MaxByteSize
E. Format
117. Satisfied by COUNT function
117. Satisfied by COUNT function
A.Format
B. IsInvariantToNull
C. IsInvariantToDuplicates
D. IsNullIfEmpty
E. MaxByteSize
118. The SqlUserDefinedAggregate attribute is used before using a CLR aggregate function.
A.True
B. False
119. The Init () method is used to initialize the aggregate computation.
A.True
B. False
120. The Merge () method is used to merge an aggregate object with another object.
A.True
B. False
121.The Accumulate () method is used to process the aggregate value into discrete value.
A.True
B. False
122. The Terminate () method terminates the aggregation process
A.True
B. False
123. 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?
A. public partial class UserDefinedFunctions
{
[SqlUserFunction]
public static SqlDecimal CurrencyConverter()
{
return new SqlDecimal(((Int16)value * 7.10);
}
};
{
[SqlUserFunction]
public static SqlDecimal CurrencyConverter()
{
return new SqlDecimal(((Int16)value * 7.10);
}
};
B.public partial class UserDefinedFunctions
{
[SqlUserFunction]
(DataAccess=DataAccessKind.None)]
public static SqlDecimal CurrencyConverter()
{
return new SqlDecimal(((Int16)value * 7.10);
}
};
{
[SqlUserFunction]
(DataAccess=DataAccessKind.None)]
public static SqlDecimal CurrencyConverter()
{
return new SqlDecimal(((Int16)value * 7.10);
}
};
C.public partial class UserDefinedFunctions
{
public static SqlDecimal
CurrencyConverter(SqlInt16 value)
{
Return new SqlDecimal(((Int16)value * 7.10);
}
};
{
public static SqlDecimal
CurrencyConverter(SqlInt16 value)
{
Return new SqlDecimal(((Int16)value * 7.10);
}
};
D.public partial class UserDefinedFunctions
{
[SqlFunction (DataAccess=DataAccessKind.None)]
public static SqlDecimal
CurrencyConverter(SqlInt16 value)
{
Return new SqlDecimal(((Int16)value * 7.10);
}
};
{
[SqlFunction (DataAccess=DataAccessKind.None)]
public static SqlDecimal
CurrencyConverter(SqlInt16 value)
{
Return new SqlDecimal(((Int16)value * 7.10);
}
};
124.CLR is a runtime environment that manages the execution of .NET code
A. True
B.False
125. CLR is also known as Virtual Runtime System.
A.True
B.False
126. CRL compiles the code into Microsoft Intermediate Language.
A. True
B. False
127. CLR forms the core of Microsoft .NET programming initiative.
A. True
B. False
128. CLR executes non-managed code.
A. True
B. False
129. Database engine hosting the CLR environment execute managed codes.
A. Streamlined Model
B. UDT & Aggregate Functions
C. Improved Safety & Security
D. Enhanced Programming Model
E. Improved Performance
130. Microsoft .NET Framework compilation and execution model improves the performance over T-SQL.
130. Microsoft .NET Framework compilation and execution model improves the performance over T-SQL.
A.Improved Performance
B. Enhanced Programming Model
C. Improved Safety & Security
D. UDT & Aggregate Functions
E. Streamlined Model
131. Developers develop and debug database objects and scripts from within the .NET development environment.
131. Developers develop and debug database objects and scripts from within the .NET development environment.
A. Improved Performance
B. Enhanced Programming Model
C. Improved Safety & Security
D. UDT & Aggregate Functions
E. Streamlined Model
132. Microsoft .NET Framework languages provide different programming constructs and capabilities.
A. Streamlined Model
B. UDT & Aggregate Functions
C. Enhanced Programming Model
D. Improved Safety & Security
E. Improved Performance
133. Two new database objects that expands the storage and querying capabilities of SQL Server
A. Improved Performance
B. Enhanced Programming Model
C. UDT & Aggregate Functions
D. Improved Safety & Security
E. Streamlined Model
134. Executes the command received as an argument and returns the result set.
A. Send
B.SendResultsEnd
C.SendResultsStart
D. ExecuteAndSend
E. SendResultsRow
135. Returns a string message or a single row result set to the client.
A. SendResultsRow
B. ExecuteAndSend
C. SendResultsStart
D. SendResultsEnd
E. Send
136. Sets the SqlPipe object to its original state.
A. Send
B. SendResultsEnd
C. ExecuteAndSend
D. SendResultsRow
E. SendResultsStart
137. Sends a single row of data
A. SendResultsStart
B. SendResultsRow
C. ExecuteAndSend
D. SendResultsEnd
E. Send
138. Marks the beginning of the result set from a stored procedure.
A. Send
B.SendResultsEnd
C. ExecuteAndSend
D.SendResultsRow
E. SendResultsStart
) Which of the following object froms the basic parts of the Service Broker System
(2-21)
a) Message Type
b) Stack
c) Queue
d) Contacts
2) Which of the following correctly describes the usage of the property IsInvariant Toduplicates?
(6-23)
a) it states whether the aggregate is invariant to duplicates such as Max and Min
b) it states whether the aggregate is invariant to nulls such as COUNT Which is not invariant to nulls
c) Is States whether aggregate is invariant to order
d) It states whether a null Value is Returned if no Values are accumulated
3) which of the following XQUERY expression supports the for,where,order by and ….clauses?
(1-24)
a) XML
b) Conditional
c) FLWOR statement and lteration
d) Arithmentic
4) which of the following methods of the XML data Type retrieves tragments of an XML document?
(1-25)
e) Query()
f) Value()
g) Get()
h) Nodes()
5)Which of the following fuctions in SOA does not depend on the state of other service ?
(2-3)
a) send()
b) Response
c) Request
d) Service
6)_________Is a service Provider that acts as a registry and allows for the lookup of send…provider interfaces and service location
(2-5)
a) Service
b) Service Provider
c) Service Broker
d) Service Location
7)____________ is a conversation that takes Place between one Service Broker and an…
(2-21)
a) Dialog
b) Messages
c) Conversation groups
d) Endpoint
8) You want to add a Microsoft user account named?Mark? of Windows domain Aptech to SQL Service and grant access right to a default database named AptechTraining .Which one of the following code will help you to achieve this task?
(3-28+3)
a) CREATE LOGIN[AptechMark] FROM WINDOWS WITH DATABASE =AptechTraining
b) CREATE USER [AptechMark]FROM WINDOWS WITH DATABASE= AptechTraining
c) CREATELOGIN [AptechMark] FROM WINDOWS WITH DATABASENAME = AptechTraining
d) CREATE LOGINNAME [AptechMark] FROM WINDOWS WITH DATABASENAME = AptechTraining
9)__________is an application that receives the messages from a queue and sends the messages to services.
(2-21)
a) Services
b) Queues
c) Dialogs
d) Service Program
10)Which of the following message type accepts any type of message body?
(2-29)
a) NONE
b) Empty
c) Well Formed XML
d) Well Formed XML with Schema collection
11)___________ converts the information in a Web Service request and response message prior to network transmission
(3-6+2)
a) UDDI
b) WSDL
c) XML
d) SOAP
12) which of the following tags specifles the name of the analysis Service database that the event provider will query?
(4-27+3)
a) <Name>AnalysisServiceInstances </Name>
<Value>%ASInstance</Value>
b) <Name> AnalysisServiceDatabase</Name>
<Value> AdventureWorks</Values>
c) <Name>EventQuery</Name>
<Value>SELECT BookID FROM BookTable</Value>
d) <Name>EventClassName</Name>
<Value>BookEvents</Value>
13) Which of the following entities are required to develop a Service Broker application…….
(2-22)
a) Dialog
b) Route
c) Service Object
d) Gateway
14)Which of the following classes specifies a notification Service application ?
(4-5)
a) NotificationService
b) NSApplication
c) Notifier
d) Subscription
15)_________Is the Process of converting the scource code into an application so that executed by the CLR
(5-5)
a) Compliation
b) Managed Debugging
c) Managed Execution
d) Execution
16)Which of the following features of CLR description describes that develop and debug datatbase objects and scripts from winthin the .Net development environment?
(5-8+3)
a) Enhanced Programming Model
b) UDT and Aggregate Functions
c) StreamLined Model
d) Improved Performance
17) the__________ option of the Server configuration specifies whether use be executed winthin SQL Server
(5-16)
a) clr_enabled
b) clr
c) enableclr
d) enables
18) which of the following methords of the SqlPipe class returns a single row reset the client?
a) void send(SqlDataRecord)
b) void send(SqlDataReader)
c) void sendresultsRow()
d) void sendSingleRow(SqlDataRecord)
19) which of the following namespace in the System.Data .dll consists of classes that comprise the ADO.Net architecture?
a) System.Data.ADO
b) Syste.Data.sql
c) System.Data.sqlClients
d) System.Data
20) which of the Native HTTP features helps in creating a proxy class,understand the method and parameter passing?
a) Native HTTP requirements
b) Receiving requests
c) WSDL document generation
d) Access to database objects
21) which one of the following codes declares a dialog handle variable named dialog_handle as a unique identifier?
a) DECLARE @dialog_handle uniqueidentifiler
b) DECLARE $dialog_handle uniqueidentifiler
c) DECLARE %dialog_handle uniqueidentifiler
d) DECLARE uniqueidentifiler @dialog_handle
22)which one of the following commands is used to grant permission to a user for stored procedures?
a) GRANT PERMISSION
b) GRANT EXECUTE
c) CREATE ACCESS
d) ALLOW
Q.1)
|
This refer to parts of XML documents. These parts need not include the root element.
| ||
A.
|
XML Views
| ||
B.
|
XML fragments ()
| ||
C.
|
Native XML storage
| ||
Correct
|
100%answered this correctly. 0% answered wrong
| ||
Q.2)
|
The XML data type can be used to define:
- 3 choices. | |
A.
|
rowa
| |
B.
|
columns ()
| |
C.
|
parameters ()
| |
D.
|
values
| |
E.
|
variables ()
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.3)
|
Until an xml data type variables. parameter, or column is not associated with an xml schema it is called:
| |
A.
|
Typed XML data
| |
B.
|
Untyped XML data ()
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.4)
|
Which statement of code is type xml data?
| |
A.
|
CREATE TABLE student(
ID varchar(20) not null, Address xml (CONTENT studentAddress) null, Class xml ) () | |
B.
|
CREATE TABLE student(
ID varchar(20) not null, Address xml null, Class xml not null ) | |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.5)
|
The XML data type enable storage of xml data in their native form, xml
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.6)
|
XML data type variables or columns can only store complete XML documents.
| |
A.
|
True
| |
B.
|
False ()
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.7)
|
Native XML storage makes it easy to map XML data into relational databases
| |
A.
|
True ()
| |
B.
|
False (correct answer)
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.8)
|
XML data can provide a highly optimized querying environment by indexing.
| |
A.
|
True ()
| |
B.
|
False
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.9)
|
XML views work best when data in database needs to be converted to xml
| |
A.
|
True (correct answer)
| |
B.
|
False ()
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.10)
|
XML data storage in relational databases makes data management impossible.
| |
A.
|
True
| |
B.
|
False ()
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.11)
|
XML document can be validated against their schemas sincean xml schema defines an xml document's basic structure.
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.12)
|
ALTER XML SCHEMA COLLECTION statement permits developers to modify existing schema elements and attributes.
| |
A.
|
True
| |
B.
|
False ()
| |
Correct
|
50%answered this correctly. 50% answered wrong
|
Q.13)
|
This method is used to shred an xml document into relational data.
| |
A.
|
query();
| |
B.
|
value();
| |
C.
|
nodes(); ()
| |
D.
|
modify();
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.14)
|
This method is used to retrieve fragments of an xml document.
| |
A.
|
value()
| |
B.
|
data()
| |
C.
|
query() ()
| |
D.
|
nodes()
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.15)
|
Insert, append or delete XML document nodes.
| |
A.
|
modify ()
| |
B.
|
nodes
| |
C.
|
query
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.16)
|
Recreate xml fragments as specified by query.
| |
A.
|
modify ()
| |
B.
|
exist
| |
C.
|
query (correct answer)
| |
Correct
|
50%answered this correctly. 50% answered wrong
|
Q.17)
|
Transpose XML values to relational database
| |
A.
|
value
| |
B.
|
exist
| |
C.
|
nodes ()
| |
D.
|
node
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.18)
|
You want to create a table store long distance train travel details. The table stores the journey, passenger and reservation details in the form of untyped XML data. Which one of the following codes will help you achieve this ?
| |
A.
|
CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails varchar NOT NULL, PassengerDetails varchar NOT NULL, ReservationDetails varchar NOT NULL)
| |
B.
|
CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML, PassengerDetails XML (CONTENT Passenger) NOT NULL, ReservationDetails varchar NOT NULL) ()
| |
C.
|
CRATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML, PassengerDetails XML, ReservationDetails XML) (correct answer)
| |
D.
|
CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML (CONTENT Journey) NOT NULL, PassengerDetails XML (CONTENT Passenger) NOT NULL, ReservationDetails XML (CONTENT Reservation) NOT NULL)
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.19)
|
Which of these codes snippets about XML data type methods are true and which of these statements are false ?
| |
A.
|
SELECT StudentID FROM Students
WHERE @student.exist(‘(/Age)[.=”15”]’)=1 (missed) | |
B.
|
SELECT @student.value(
‘(/Student/Age)[1]’, ‘int(2)’) (missed) | |
C.
|
SELECT StudentID FROM Students
WHERE @student.exist(‘(/Age)[.=”15”]’)=0 () | |
D.
|
SET @student.modify(
‘insert Aaroninto Student[1]’) (missed) | |
E.
|
SELECT StudentID FROM Students
WHERE @student.exist(‘(/Age’=”15”) | |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.20)
|
Software entity that calls a service provider
| |
A.
|
Service Consumer ()
| |
B.
|
Service Locator
| |
C.
|
Service Broker
| |
D.
|
Services
| |
E.
|
Service Provider
| |
Correct
|
50%answered this correctly. 50% answered wrong
|
Q.21)
|
Software entity that implements a service specification.
| |
A.
|
Service Consumer
| |
B.
|
Service Locator
| |
C.
|
Service Broker
| |
D.
|
Services
| |
E.
|
Service Provider ()
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.22)
|
Service provider that can pass on service requests to one or more additional service providers.
| |
A.
|
Service Consumer
| |
B.
|
Service Locator ()
| |
C.
|
Service Broker (correct answer)
| |
D.
|
Services
| |
E.
|
Service Provider
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.23)
|
Service provider that acts as a registry and allows for lookup of service provider interfaces and service location
| |
A.
|
Service Consumer
| |
B.
|
Service Locator ()
| |
C.
|
Service Broker
| |
D.
|
Services
| |
E.
|
Service Provider
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.24)
|
Function in which consumers communicate through contract
| |
A.
|
Service Consumer
| |
B.
|
Service Locator
| |
C.
|
Service Broker
| |
D.
|
Services ()
| |
E.
|
Service Provider
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.25)
|
SOA is an architecture that encourages tightly coupled communication between software services.
| |
A.
|
True (correct answer)
| |
B.
|
Fasle ()
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.26)
|
Service-Oriented architecture is essentially a collection of services that communicate with each other
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
50%answered this correctly. 50% answered wrong
|
Q.27)
|
Service-Oriented terminology provides patterns for design, development, deployment, and management of a loosely coupled business application infrastructure
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.28)
|
Service consumer can be a client application, a server application such as a Web server, or any other kind of application.
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.29)
|
Service is a function that directly depends on the state of other service.
| |
A.
|
True
| |
B.
|
False ()
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.30)
|
A group sharing similar dialog conversations.
| |
A.
|
Endpoints
| |
B.
|
Service Broker Security
| |
C.
|
Conversation Groups (correct answer)
| |
D.
|
Messages ()
| |
E.
|
Dialogs
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.31)
|
A conversation that takes place between two Service Brokers.
| |
A.
|
Endpoints
| |
B.
|
Service Broker Security
| |
C.
|
Conversation Groups
| |
D.
|
Messages
| |
E.
|
Dialogs ()
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.32)
|
An entity that is exchanged between Service Brokers
| |
A.
|
Dialogs
| |
B.
|
Endpoints
| |
C.
|
Conversation Groups
| |
D.
|
Service Broker Security
| |
E.
|
Messages ()
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.33)
|
Supports communication between two services and connection between two databases along with authentication
| |
A.
|
Endpoints
| |
B.
|
Dialogs ()
| |
C.
|
Service Broker Security (correct answer)
| |
D.
|
Conversation Groups
| |
E.
|
Message
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.34)
|
Responsible for the communication in Service Broker
| |
A.
|
Conversation Groups
| |
B.
|
Endpoints ()
| |
C.
|
Service Broker Security
| |
D.
|
Dialogs
| |
E.
|
Messages
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.35)
|
The messages are read one after another from the same queue by multiple programs
| |
A.
|
True ()
| |
B.
|
False (correct answer)
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.36)
|
Service Broker handles ordering of messages, conversation identification, and unique delivery automatically.
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.37)
|
Service Broker’s integrated design is beneficial for application performance and administration
| |
A.
|
True ()
| |
B.
|
Fasle
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.38)
|
Defines the type of message data
| |
A.
|
Services
| |
B.
|
Message Types ()
| |
C.
|
Service Program
| |
D.
|
Queues
| |
E.
|
Contracts
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.39)
|
Agreement that specifies who sends the message and what message types are sent.
| |
A.
|
Message Types
| |
B.
|
Contracts ()
| |
C.
|
Queues
| |
D.
|
Services
| |
E.
|
Service Type
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.40)
|
Holds messages as long as they do not expire
| |
A.
|
Message Type
| |
B.
|
Service Program
| |
C.
|
Services
| |
D.
|
Queues ()
| |
E.
|
Contracts
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.41)
|
Receives the messages from a queue and send the messages to services.
| |
A.
|
Message Type
| |
B.
|
Service Program (correct answer)
| |
C.
|
Queues
| |
D.
|
Services ()
| |
E.
|
Contracts
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.42)
|
Handles and processes all the messages when they arrive at the server.
| |
A.
|
Message Type
| |
B.
|
Service Program
| |
C.
|
Services (correct answer)
| |
D.
|
Queues
| |
E.
|
Contracts ()
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.43)
|
All Service Broker applications use conversations for their reliable communication
| |
A.
|
True ()
| |
B.
|
Fasle
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.44)
|
All Service Broker applications communicate using dialogs for reliable communication
| |
A.
|
True ()
| |
B.
|
False (correct answer)
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.45)
|
Service Broker delivers messages in an Exactly-Once-In-Order fashion
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
50%answered this correctly. 50% answered wrong
|
Q.46)
|
The first message dialog sent by the Service Broker has the message_sequence_number of one
| |
A.
|
True
| |
B.
|
False ()
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.47)
|
When conversations are going on between various SQL Server instances, Service Broker use the routes to direct the messages.
| |
A.
|
True (correct answer)
| |
B.
|
False ()
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.48)
|
Any type of message body is acceptable.
| |
A.
|
NONE ()
| |
B.
|
Well Formed xml
| |
C.
|
Well Formed Xml Schema
| |
D.
|
Empty
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.49)
|
Only an empty message body is acceptable
| |
A.
|
NONE ()
| |
B.
|
Well Formed XML
| |
C.
|
Well Form XML Schema
| |
D.
|
EMPTY (correct answer)
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.50)
|
Only a message body with valid XML is acceptable.
| |
A.
|
NONE
| |
B.
|
Well Formed XML (correct answer)
| |
C.
|
Well Formed XML Schema ()
| |
D.
|
EMPTY
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.51)
|
Only a message with valid XML and XML schema is acceptable
| |
A.
|
NONE
| |
B.
|
Well Formed XML
| |
C.
|
Well Formed XML Schema ()
| |
D.
|
EMPTY
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.52)
|
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.
| |
A.
|
1-3-2-4-5
| |
B.
|
4-1-2-5-3 ()
| |
C.
|
4-1-5-3-2
| |
D.
|
2-3-4-1-5
| |
Incorrect
|
0%answered this correctly. 100% answered wrong
|
Q.53)
|
Which of the following is the correct code to send the message from service consumer to service provider
| |
A.
|
DECLARE @dialog_handle1
FROM SERVICE [//Adventure-Service.com/Provider] TO SERVICE ‘//Adventure-Service.com/Consumer’ DECLARE @msgString NVARCHAR(MAX) SET @msgString = N’Welcome’; SEND ON CONVERSATION @dialog_handle1 MESSAGE TYPE [//Adventure-Service.com/Adventure/AdventureSales] (@msgString) () | |
B.
|
DECLARE @dialog_handle1
BEGIN DIALOG CONVERSATION @dialog_handle1 FROM SERVICE [//Adventure-Service.com/Provider] TO SERVICE ‘//Adventure-Service.com/Consumer’ ON CONTRACT [//Adventure-Service.com/Adventure/Contract] DECLARE @msgString NVARCHAR(MAX) SET @msgString = N’Welcome’; SEND ON CONVERSATION @dialog_handle1 | |
C.
|
DECLARE @dialog_handle1
BEGIN DIALOG CONVERSATION @dialog_handle1 FROM SERVICE [//Adventure-Service.com/Provider] TO SERVICE ‘//Adventure-Service.com/Consumer’ ON CONTRACT [//Adventure-Service.com/Adventure/Contract] DECLARE @msgString NVARCHAR(MAX) SET @msgString = N’Welcome’; SEND ON CONVERSATION @dialog_handle1 MESSAGE TYPE [//Adventure-Service.com/Adventure/AdventureSales] (@msgString) (correct answer) | |
D.
|
DECLARE @dialog_handle1
BEGIN DIALOG CONVERSATION @dialog_handle1 ON CONTRACT [//Adventure-Service.com/Adventure/Contract] DECLARE @msgString NVARCHAR(MAX) SET @msgString = N’Welcome’; SEND ON CONVERSATION @dialog_handle1 MESSAGE TYPE [//Adventure-Service.com/Adventure/AdventureSales] | |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.54)
|
Web Services are services available on the Web
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.55)
|
Web Services are platform independent, but not language independent
| |
A.
|
True
| |
B.
|
False ()
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.56)
|
Web Services fail to encourage reusability
| |
A.
|
True
| |
B.
|
False ()
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.57)
|
Web Services makes use of industry-supported standards
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.58)
|
The existing components and libraries can be easily exposed as Web Services
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.59)
|
SOAP is a protocol for the exchange of information in decentralized and distributed environments
| |
A.
|
True ()
| |
B.
|
False
| |
Incorrect
|
0%answered this correctly. 100% answered wrong
|
Q.60)
|
Exchanging SOAP messages leads to time consuming way for communicating with Web Services.
| |
A.
|
True ()
| |
B.
|
False (correct answer)
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.61)
|
SOAP encourages distributed computing
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
50%answered this correctly. 50% answered wrong
|
Q.62)
|
SOAP defines application semantics such as a programming model or implementation-specific details
| |
A.
|
True
| |
B.
|
False ()
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.63)
|
SOAP message consists of an XML document with a header and a body
| |
A.
|
True ()
| |
B.
|
Fasle
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.64)
|
Http.sys receives requests and forwards to SQL Server based on an HTTP endpoint.
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.65)
|
IIS needs to be installed to listen for the requests in SQL Server 2005
| |
A.
|
True
| |
B.
|
Fasle ()
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.66)
|
Native HTTP allows implementing a database as a service to be accessed on the Web
| |
A.
|
True ()
| |
B.
|
False (correct answer)
| |
Incorrect
|
0%answered this correctly. 100% answered wrong
|
Q.67)
|
WSDL document helps to create a proxy class to call a Web Service
| |
A.
|
True ()
| |
B.
|
Fasle (correct answer)
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.68)
|
Web Service methods provide access to database objects
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.69)
|
Document that helps in creating a proxy class, understand methods and parameters passing.
| |
A.
|
Http.sys
| |
B.
|
WSDL Document Generation ()
| |
C.
|
Access to database objects.
| |
D.
|
Native HTTP requirements.
| |
E.
|
Receiving requests.
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.70)
|
Requires installation of Windows 2003 to support native HTTP
| |
A.
|
Receiving requests.
| |
B.
|
Access to database objects.
| |
C.
|
WSDL Document Generation
| |
D.
|
Http.sys
| |
E.
|
Native HTTP requirements ()
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.71)
|
Combines a single method to an individual SQL Server object, to provide access to database objects.
| |
A.
|
WSDL Document Generation
| |
B.
|
Native HTTP requirements
| |
C.
|
Receiving requests
| |
D.
|
Access to database objects. (correct answer)
| |
E.
|
Http.sys ()
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.72)
|
Receives the HTTP request from the client
| |
A.
|
Native HTTP requirements
| |
B.
|
Http.sys ()
| |
C.
|
WSDL Document Generation
| |
D.
|
Receiving requests
| |
E.
|
Access to database objects.
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.73)
|
The HTTP request is forwarded to SQL Server.
| |
A.
|
Access to database objects.
| |
B.
|
Receiving requests ()
| |
C.
|
Http.sys
| |
D.
|
Native HTTP requirements
| |
E.
|
WSDL Document Generation
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.74)
|
Which one of the following code snippets is a valid code snippet for creating HTTP endpoints?
| |
A.
|
CREATE ENDPOINT sqlEndpoint
STATE = STARTED AS HTTP( PATH = ‘/sql’, AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR) ) () | |
B.
|
CREATE sqlEndpoint
STATE = STARTED AS HTTP( PATH = ‘/sql’, AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR) ) | |
C.
|
GRANTENDPOINT sqlEndpoint
STATE= STARTED AS HTTP( PATH = ‘/sql’, AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR) ) | |
D.
|
CREATE POINT sqlEndpoint
STATE = STARTED AS HTTP( PATH = ‘/sql’, AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR) ) | |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.75)
|
CREATE LOGIN statement is used to add a user to the SQL Server 2005 security system.
| |
A.
|
True (correct answer)
| |
B.
|
False ()
| |
Incorrect
|
50%answered this correctly. 50% answered wrong
|
Q.76)
|
GRANT ACCESS statement is used to grant permission to a user for stored procedures
| |
A.
|
True ()
| |
B.
|
False (correct answer)
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.77)
|
GRANT CONNECT ON ENDPOINT statement grants permission to the user to connect to the HTTP endpoint.
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.78)
|
Endpoints can be altered by any of the members.
| |
A.
|
True
| |
B.
|
False ()
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.79)
|
ALTER ENDPOINT statement permits adding, removing and altering a WEBMETHOD from the endpoints
| |
A.
|
True ()
| |
B.
|
False
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.80)
|
Which statement is used to grant permission for stored procedure or user-define function?
| |
A.
|
GRANT ACCESS TO
| |
B.
|
GRANT EXECUTE TO
| |
C.
|
GRANT EXECUTE ON TO ()
| |
D.
|
GRANT ACCESS ON TO
| |
Correct
|
100%answered this correctly. 0% answered wrong
|
Q.81)
|
Uses e-mail, SMS, data files for the channel of communication.
| |
A.
| Event | |
B.
|
Subscription
| |
C.
|
Subscriber
| |
D.
|
Notification ()
| |
