1)
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?
(5-20)
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?
(6-6)
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?
(2-19+3)
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?
(2-36+2)
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?
(3-28+5)
a)
GRANT PERMISSION
b)
GRANT EXECUTE
c)
CREATE ACCESS
d)
ALLOW
1.XML Data Type and Xquery(38)
XML
in SQL Server 2005 – 4/38
Native XML storage
XML Views
XML
Data Type – 6/38
Columns
Parameters
Variables
Types
of XML Data – 7/38
Untyped
Typed
Xquery
queries – 23/38
Prolog
body
Methods
of XML Data Type – 25/38
Query()
Value()
Exist()
Nodes()
Modify()
2.Exploring Service Broker(51)
Service-Oriented
Terminologies – 5/51
Services
Service Provider
Service Consumer
Service Locator
Service Broker
Service
Broker Feature – 10/51
Related messages are gathered in Service Broker
Scheduling can be done in case of delivery of message.
Message delivery can be performed asynchronously
Message delivery activates service program.
Messages are received in a proper order and they are recevied
Asyschronous
Message Communication – 11/51
Message Ordering
Transactions
Recoverability
scalability
Service
Broker Concepts – 12/51
Message
Dialog
Conversation groups
Endpoint
Service Broker Security
Service
Broker Advance – 14/51
Ordering of Messages
Locking of Related Messages
Database Integrantion
Loose coupling and flexibility in workload
Automatic Activation
Service
Broker Advance – 15/51
Reliable Query processing
Efficient data collection
Triggers working asynchronously
Consolidation of data
Batch processing on a large scale
Distributed processing
Service
Broker Architecture – 20/51
Conversation Components
Service definition components
Routing and security components
Working
of Service Broker System – 21/51
Message Types
Contracts
Queues
Service program
Services
Dialogs
Service
Broker Conversation Architecture – 22/51
Service Object
Dialog
Route
Remote service binding
Messages
– 29/51
None
Empty
Well formed XML
Well formed XML with Schema Collection
3.Exploring Native HTTP Support and Web Services(37)
Features
of Native HTTP – 19/37
Native HTTP requirements
Receiving requests
Genneration of WSDL document
Access to database objects
==================================================================
6)
Which of the following object froms the basic parts of the Service Broker System
e)
Message Type
f)
Stack
g)
Queue
h)
Contacts
7)
Which of the following correctly describes the usage of the property
IsInvariant Toduplicates?
e)
it states whether the aggregate is
invariant to duplicates such as Max and Min
f)
it
states whether the aggregate is invariant to nulls such as COUNT Which is not
invariant to nulls
g)
Is States whether aggregate is invariant to
order
h)
It states whether a null Value is Returned
if no Values are accumulated
9)
which of the following XQUERY expression
supports the for,where,order by and ….clauses?
a)
XML
b)
Conditional
c)
FLWOR statement and lteration
d)
Arithmentic
10) which of
the following methods of the XML data Type retrieves tragments of an XML
document?
a)
Query()
b)
Value()
c)
Get()
d)
Nodes()
10)Which
of the following fuctions in SOA does not depend on the state of other service
?
e)
send()
f)
Response
g)
Request
h)
Service
11)_________Is
a service Provider that acts as a registry and allows for the lookup of
send…provider interfaces and service location
e)
Service
f)
Service Provider
g)
Service Broker
h)
Service Location
12)____________
is a conversation that takes Place between one Service Broker and an…
e)
Dialog
f)
Messages
g)
Conversation groups
h)
Endpoint
14)
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?
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
13)__________is
an application that receives the messages from a queue and sends the messages
to services.
e)
Services
(True)
f)
Queues
g)
Dialogs
h)
Service Program
14)Which
of the following message type accepts any type of message body?
a)NONE
b) Empty
c) Well Formed XML
d) Well Formed XML with
Schema collection
15)___________
converts the information in a Web Service request and response message prior to
network transmission
e)
UDDI
f)
WSDL
g)
XML
h)
SOAP
16)
which of the following tags specifles
the name of the analysis Service database that the event provider will query?
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>
(khoang vao cac chu cai ben
duoi)
A
B
C
D
17)
Which of the following entities are
required to develop a Service Broker application…….
e)
Dialog
f)
Route
g)
Service Object
h)
Gateway
19)
Which of the following classes specifies a
notification Service application ?
a)
NotificationService
b)
NSApplication
c)
Notifier
d)
Subscription
19)_________Is
the Process of converting the scource code into an application so that executed by the CLR
a) Compliation (True)
b) Managed Debugging
c)
Managed Execution
d) Execution
20)Which
of the following features of CLR description describes that develop and debug
datatbase objects and scripts from winthin the
.Net development environment?
e)
Enhanced Programming Model
f)
UDT and Aggregate Functions
g)
StreamLined Model
h)
Improved Performance
21)
the__________ option of the Server configuration specifies whether use be
executed winthin SQL Server
e)
clr_enabled (true)
f)
clr
g)
enableclr
h)
enables
22)
which of the following methords of the SqlPipe class returns a single row reset
the client?
e)
void send(SqlDataRecord)
f)
void send(SqlDataReader)
g)
void sendresultsRow()
h)
void sendSingleRow(SqlDataRecord)
23)
whichh of the following namespace in the System.Data .dll consists of classes
that comprise the ADO.Net architecture?
e)
System.Data.ADO
f)
Syste.Data.sql
g)
System.Data.sqlClients
h)
System.Data
24)
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
25)
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
26)which
one of the following commands is used to grant permission to a user for stored
procedures?
e)
GRANT PERMISSION
f)
GRANT EXECUTE
g)
CREATE ACCESS
h)
ALLOW
==================================================================
1. Which
of the XQuery expression supports the for, where, order by and return clauses?
o XML
o Conditional
o FLOWOR statement
and iteration
o Arithmetic
2. Which
of the following methods of the XML data type retrieves fragments of an XML
document ?
o Query()
o Value()
o Get()
o Nodes()
3. Which
of the following functions in SOA does not depend on the state of other
services?
o Send
o Response
o Request
o Service
4. ----------is
a service provider that acts as a registry and allows for the lookup of service
provider interfaces and service location.
o Service
o Service
Provider
o Service
Broker
o Service Locator
5. -----------is
a conversation that takes place between one Service Broker and another.
o Dialog
o Messages
o Conversation
group
o Endpoint
6. You
want to add a Microsoft user account named ?Mark? of Windows domain Aptech to
SQL Server and grant access right to a default database named Aptech Training.
Which one of the following code will help you to achieve this task?
o CREATE LOGIN
[AptechMark] FROM WINDOWS WITH DATABASE = AptechTraining
o CREATE
USER [AptechMark] FROM WINDOWS WITH DATABASE= AptechTranining.
o CREATE
LOGIN [AptechMark]FROM WINDOWS WITH DATABASENAME= AptechTraining
o CREATE
LOGINNAME[AptechMark]FROM WINDOWS WITH DATABASENAME = AptechTraining
7. _______is
an application that receives the messages from a queue and sends the messages
to services.
o Services
o Queues
o Dialogs
o Service Program
8. Which
of the following message type accepts any type of message body?
o NONE
o EMPTY
o Well
Formed XML
o Well
Formed XML with Schema Collection
9. ______converts
the information in a Web Service request and response message prior to network
transmission.
o UDDI
o WSDL
o XML
o SOAP
10. Which
one of the following codes declares a dialog handle variable named
dialog_handle as a unique identifier?
o DECLARE
@dialog_handle uniqueidentifier
o DECLARE
$dialog_handle uniqueidentifier
o DECLARE
%dialog_handle uniqueidentifier
o DECLARE
uniqueidentifier @dialog_handle
11. Which
of the Native HTTP features helps in creating a proxy class, understand the
method and parameter passing?
o Native
HTTP requirements
o Receiving
requests
o WSDL document
generation
o Access
to database objects
12. Which
one of the following commands is used to grant permission to a user for stored
procedures?
o GRANT
PERMISSION
o GRANT EXECUTE
o CREATE
ACCESS
o ALLOW
13. Which
of the following features of SQL Server 2005 provides a platform for generating
and sending messages to the subscriber?
o Web
Services
o Notification
Services
o Endpoints
o Messages
14. _____is
an application or user that requests and receives notification
o Notification
o Event
o Subscription
o Subscriber
15. The
_____ option of the server configuration specifies whether user assemblies can
be executed within SQL Server
o Clr_enabled
o Clr
o Enableclr
o Enabled
16. Which
of the following methods of the SqlPipe class returns a single row result-set
to the client?
o Void send
(SqlDataRecord)
o Void
send (SqlDataReader)
o Void
sendresultRow()
o Void
sendSingleRow(SqlDataRecord)
17. Which
of the following namespaces in the System.Data.dll consists of classes that
comprise the ADO.NET architecture?
o System.Data.ADO
o Syste.Data.Sql
o System.Data.SqlClient
o System.Data
18. Which
of the following objects forms the basic part of the Service Broker System?
ü Message Types
ü Stack
ü Queue
ü Contracts
19. Which
of the following correctly describes the usage of the property
isInvariantToDuplicates?
o It states whether
the aggregate is invariant to duplicates such as MAX and MIN.
o It
states whether the aggregate is Invariant to Null such as COUNT which is not
invariant to nulls
o It
states whether aggregate is invariant to order.
o It
states whether a null value is returned if no values are accumulated.
20. Which
of the following correctly describes the usage of the method merge()?
o It
accumulates the aggregate values by the processor
o It merges an
aggregate class object with the current object
o It
returns the aggregated result and terminates the aggregation process.
o It
initializes the aggregate computation
21. Which
of the following tags specify that 10 attempts are to be made to access a
locked file before removing the file from the queue?
A. <Name>RetryPeriod</Name>
<Value>10</Value>
B. <Name>RetryQueueOccupancy</Name>
<Value>10</Value>
C.
<Name>RetryAttempts</Name>
<Value>10</Value>
D. <Name>RetryWorkload</Name>
<Value>10</Value>
o A
o B
o C
o D
22. Which
of the following tags specifies the name of the Analysis Services database that
the event provider will query? (chưa chắc)
A. <Name>AnalysisServicesInstances</Name>
<Value>%ASInstance</Value>
B.
<Name>AnalysisServicesDatabase</Name>
<Value>AdventureWorks</Value>
C. <Name>EventQuery</Name>
<Value>SELECT BookID FROM BookTable</Value>
E. <Name>EventClassName</Name>
<Value>BookEvents</Value>
o A
o B
o C
o D
23. ____
is an act by which subscriber describes when and what to be notified on.
o Event Collection
o Notification
Generation
o Subscription
o Notification
Formatting
24. _____is
an XML file that describes a Notification Service instance and stores its data
in an SQL Server database
o XML
o Instance
Configuration File
o Object
Configuration File
o Stored
procedure
25. Which
of the following event providers of SQL Server Notification Services monitors a
directory for new event files ?
o SQL
Server
o Analysis
Services
o File System
Watcher
o Web
Services
==================================================================
- Mà các biểu
hiện XQuery hỗ trợ cho, ở đâu, tự do và các khoản trả lại?
- XML XML
- Conditional Có
điều kiện
- FLOWOR statement and
iteration FLOWOR câu
và lặp lại
- Arithmetic Số
học
- Which of the following methods of the XML data type
retrieves fragments of an XML document ? Mà các phương
pháp sau đây của kiểu dữ liệu XML lấy mảnh vỡ của một tài liệu XML?
- Query() Truy vấn ()
- Value() Giá trị ()
- Get() Get ()
- Nodes() Các nút ()
- Which of the following functions in SOA does not
depend on the state of other services? Mà các chức
năng sau trong SOA không phụ thuộc vào nhà nước các dịch vụ khác không?
- Send Gửi
- Response
Đáp ứng
- Request Yêu cầu
- Service Dịch vụ
- ----------is a service provider that acts as a
registry and allows for the lookup of service provider interfaces and
service location. ---------- Là nhà cung cấp dịch vụ
đăng ký hoạt động như một và cho phép tra cứu các giao diện cung cấp dịch
vụ và địa điểm dịch vụ.
- Service Dịch vụ
- Service Provider
Cung cấp dịch vụ
- Service Broker
Dịch vụ môi giới
- Service Locator Dịch vụ Đại lý
- -----------is a conversation that takes place
between one Service Broker and another. ----------- Là
một cuộc trò chuyện diễn ra giữa một trong những dịch vụ môi giới và khác.
- Dialog Dialog
- Messages
Thông điệp
- Conversation group
Đam nhóm
- Endpoint
Endpoint
- You want to add a Microsoft user account named
?Mark? Bạn muốn thêm một người dùng tài khoản tên là
Microsoft? Mark? of Windows domain Aptech to
SQL Server and grant access right to a default database named Aptech
Training. Which one of the following code will help you to achieve this
task? của Aptech miền Windows để SQL Server và quyền truy cập cấp
cho một cơ sở dữ liệu mặc định được đặt tên Aptech Đào tạo. Mà một trong
những mã sau đây sẽ giúp bạn đạt được nhiệm vụ này?
- CREATE LOGIN [AptechMark]
FROM WINDOWS WITH DATABASE = AptechTraining CREATE LOGIN [AptechMark] TỪ VỚI WINDOWS DATABASE =
AptechTraining
- CREATE USER [AptechMark] FROM WINDOWS
WITH DATABASE= AptechTranining. CREATE USER
AptechMark] [TỪ VỚI WINDOWS DATABASE = AptechTranining.
- CREATE LOGIN [AptechMark]FROM WINDOWS
WITH DATABASENAME= AptechTraining CREATE LOGIN
[AptechMark] TỪ VỚI WINDOWS = AptechTraining DATABASENAME
- CREATE LOGINNAME[AptechMark]FROM
WINDOWS WITH DATABASENAME = AptechTraining CREATE
LOGINNAME [] AptechMark TỪ VỚI WINDOWS = AptechTraining DATABASENAME
- _______is an application that receives the messages
from a queue and sends the messages to services.
_______is một ứng dụng nhận được tin nhắn từ một hàng đợi và gửi các tin
nhắn với các dịch vụ.
- Services
Dịch vụ
- Queues Hàng đợi
- Dialogs Hộp thoại
- Service Program Chương trình dịch vụ
- Which of the following message type accepts any
type of message body? Mà các loại thông báo sau chấp nhận
bất kỳ loại hình cơ thể tin?
- NONE NONE
- EMPTY EMPTY
- Well Formed XML
Thành lập cũng XML
- Well Formed XML with Schema Collection
Thành lập cũng XML với Schema Bộ sưu tập
- ______converts the information in a Web Service
request and response message prior to network transmission.
______converts thông tin trong một dịch vụ web yêu cầu và thông điệp phản
ứng trước khi mạng lưới truyền tải điện.
- UDDI UDDI
- WSDL WSDL
- XML XML
- SOAP SOAP
- Which one of the following codes declares a dialog
handle variable named dialog_handle as a unique identifier? Mà
một trong các mã sau đây tuyên bố một hộp thoại xử lý các biến
dialog_handle được đặt tên như một định danh duy nhất?
- DECLARE @dialog_handle
uniqueidentifier DECLARE @
dialog_handle uniqueidentifier
- DECLARE $dialog_handle
uniqueidentifier DECLARE $ dialog_handle
uniqueidentifier
- DECLARE %dialog_handle
uniqueidentifier DECLARE% dialog_handle
uniqueidentifier
- DECLARE uniqueidentifier
@dialog_handle DECLARE @ dialog_handle
uniqueidentifier
- Which of the Native HTTP features helps in creating
a proxy class, understand the method and parameter passing? Mà
các HTTP bản tính năng giúp trong việc tạo ra một lớp proxy, hiểu được
phương pháp và qua tham số?
- Native HTTP requirements
Người bản yêu cầu HTTP
- Receiving requests
Nhận được yêu cầu
- WSDL document generation WSDL tài liệu thế hệ
- Access to database objects
Truy cập vào các đối tượng cơ sở dữ liệu
- Which one of the following commands is used to grant
permission to a user for stored procedures? Mà một trong
những lệnh sau được dùng để cấp phép cho một người sử dụng cho thủ tục
được lưu giữ?
- GRANT PERMISSION
GRANT PHEÙP
- GRANT EXECUTE GRANT thực hiện
- CREATE ACCESS
TẠO ACCESS
- ALLOW CHO PHÉP
- Which of the following features of SQL Server 2005
provides a platform for generating and sending messages to the subscriber? Mà
các tính năng sau đây của SQL Server 2005 cung cấp một nền tảng để tạo ra
và gửi tin nhắn cho các thuê bao?
- Web Services
Dịch vụ Web
- Notification Services Dịch vụ thông báo
- Endpoints
Thiết bị đầu cuối
- Messages
Thông điệp
- _____is an application or user that requests and
receives notification _____is một ứng dụng hoặc người sử
dụng rằng các yêu cầu và nhận được thông báo
- Notification
Thông báo
- Event Sự kiện
- Subscription
Đăng ký
- Subscriber Thuê bao
- The _____ option of the server configuration
specifies whether user assemblies can be executed within SQL Server Các
tùy chọn _____ của cấu hình máy chủ xác định liệu người dùng có thể lắp
ráp được thực hiện trong SQL Server
- Clr_enabled Clr_enabled
- Clr CLR
- Enableclr
Enableclr
- Enabled Bật
- Which of the following methods of the SqlPipe class
returns a single row result-set to the client? Mà
các phương pháp sau đây của lớp SqlPipe trả về kết quả đơn đặt hàng cho
khách hàng?
- Void send (SqlDataRecord) Void send (SqlDataRecord)
- Void send (SqlDataReader)
Void send (SqlDataReader)
- Void sendresultRow()
Void sendresultRow ()
- Void sendSingleRow(SqlDataRecord)
Void sendSingleRow (SqlDataRecord)
- Which of the following namespaces in the
System.Data.dll consists of classes that comprise the ADO.NET
architecture? Phát biểu nào sau đây trong không gian
tên System.Data.dll bao gồm các lớp học đó bao gồm các kiến trúc ADO.NET?
- System.Data.ADO
System.Data.ADO
- Syste.Data.Sql
Syste.Data.Sql
- System.Data.SqlClient
System.Data.SqlClient
- System.Data System.Data
- Which of the following objects forms the basic part
of the Service Broker System? Mà các đối
tượng sau đây tạo thành một phần cơ bản của Hệ thống dịch vụ môi giới?
- Message Types Loại tin nhắn
- Stack Cây rơm
- Queue Xếp hàng
- Contracts Hợp đồng
- Which of the following correctly describes the
usage of the property isInvariantToDuplicates? Nào
dưới đây mô tả đúng cách sử dụng của tài sản isInvariantToDuplicates?
- It states whether the
aggregate is invariant to duplicates such as MAX and MIN. Nó nói liệu tổng hợp là bất biến để bản sao như MAX và
MIN.
- It states whether the aggregate is
Invariant to Null such as COUNT which is not invariant to nulls Nó
nói liệu tổng hợp là bất biến để Null như COUNT mà không phải là bất biến
để null
- It states whether aggregate is
invariant to order. Nó nói cho dù là bất biến tổng hợp để
đặt hàng.
- It states whether a null value is
returned if no values are accumulated. Nó nói cho dù
một giá trị null được trả về nếu không có giá trị được tích lũy.
- Which of the following correctly describes the
usage of the method merge()? Nào dưới đây
mô tả đúng cách sử dụng phương pháp hợp nhất ()?
- It accumulates the aggregate values by
the processor Nó tích lũy các giá trị tổng hợp của
bộ vi xử lý
- It merges an aggregate class
object with the current object Nó sáp nhập một đối tượng lớp học tổng hợp với đối
tượng hiện hành
- It returns the aggregated result and
terminates the aggregation process. Nó trả về kết
quả tổng hợp và chấm dứt quá trình tập hợp.
- It initializes the aggregate
computation Nó khởi sự tính toán tổng hợp
- Which of the following tags specify that 10 attempts
are to be made to access a locked file before removing the file from the
queue? Mà các thẻ sau đây xác định rằng 10 nỗ lực sẽ được
thực hiện để truy cập một tập tin đã bị khóa trước khi gỡ bỏ các tập tin
từ hàng đợi?
- <Name>RetryPeriod</Name>
<name> RetryPeriod <> Tên /
<Value>10</Value>
<value> 10 </ Giá trị>
- <Name>RetryQueueOccupancy</Name>
<name> RetryQueueOccupancy </ Name>
<Value>10</Value>
<value> 10 </ Giá trị>
- <Name>RetryAttempts</Name> <name> RetryAttempts </> Tên
<Value>10</Value> <value> 10 </ Giá trị>
- <Name>RetryWorkload</Name>
<name> RetryWorkload </> Tên
<Value>10</Value>
<value> 10 </ Giá trị>
- A A
- B B
- C C
- D D
- Which of the following tags specifies the name of
the Analysis Services database that the event provider will query? (chưa chắc) Mà các thẻ sau
đây xác định tên của các cơ sở dữ liệu Dịch vụ phân tích rằng các nhà cung
cấp sự kiện sẽ truy vấn? (Chưa Chắc)
- <Name>AnalysisServicesInstances</Name>
<name> AnalysisServicesInstances </ Name>
<Value>%ASInstance</Value>
<value>% ASInstance </ Giá trị>
- <Name>AnalysisServicesDatabase</Name> <name>
AnalysisServicesDatabase </ Name>
<Value>AdventureWorks</Value> <value>
AdventureWorks </ Giá trị>
- <Name>EventQuery</Name> <name> EventQuery </ Name>
<Value>SELECT
BookID FROM BookTable</Value> <value> BookID FROM SELECT <BookTable /> giá trị
gia tăng
- <Name>EventClassName</Name>
<name> EventClassName </ Name>
<Value>BookEvents</Value>
<value> BookEvents </> giá trị gia tăng
- A A
- B B
- C C
- D D
- ____ is an act by which subscriber describes when
and what to be notified on. ____ Là một
hành động mà theo đó các thuê bao mô tả khi nào và những gì được thông báo
trên.
- Event Collection Sự kiện Bộ sưu tập
- Notification Generation
Thông báo thế hệ
- Subscription
Đăng ký
- Notification Formatting
Thông báo định dạng
- _____is an XML file that describes a Notification
Service instance and stores its data in an SQL Server database
_____is một file XML mô tả một Dịch vụ Thông báo sơ thẩm và lưu trữ dữ
liệu của nó trong một cơ sở dữ liệu SQL Server
- XML XML
- Instance Configuration File Ví dụ: File cấu hình
- Object Configuration File
Cấu hình Object File
- Stored procedure
Thủ tục lưu trữ
- Which of the following event providers of SQL
Server Notification Services monitors a directory for new event files ? Mà
các nhà cung cấp sự kiện sau đây của SQL Server Dịch vụ thông báo theo dõi
một thư mục cho các tập tin sự kiện mới?
- SQL Server SQL
Server
- Analysis Services
Dịch vụ Phân tích
- File System Watcher File System Watcher
- Web Services
Dịch vụ Web
==================================================================
1. Which
of the following Xquery expression supports the for, where, order by and return
clause?
a.
XML
b. Conditional
c. FLWOR
statement and Iteration
d. Arithmetic
2. Which
of the following methods of the XML data type retrieves fragments of an XML
document?
a.
Query()
b. Value()
c. Get()
d. Nodes()
3. Which
of the following functions in SOA does not depend on the state of other
services?
a. Send
b. Response
c. Request
d.
Service
4. _______
is a service provider that acts as a registry and allows for the lookup of
service provider interfaces and service location
a. Service
b. Service
Provider
c. Service
Broker
d.
Service
Locatior
5. ______is
a conversation that takes places between one Service Broker and another
a.
Dialog
b. Messages
c. Conversation
groups
d. Endpoint
6.
You want to add a Microsoft user account named ?Mark? of
Windows domain Aptech to SQL Server and grant access right to a default database
named Aptech Training. Which one of the following code will help you to achieve
this task?
a.
Create Login [AptechMark] From Windows With Database =
AptechTraining
b.
Create User [AptechMark] From Windows With Database =
AptechTraining
c.
Create Login [AptechMark] From Windows With
DatabaseName=AptechTraining
d. Create LoginName [AptechMark] From
Windows With DatabaseName= AptechTraining
7. ____is
an application that receives the messages from a queue and sends the messages
to services.
a. Services
b. Queues
c. Dialogs
d.
Service
Program
8. Which
of the message type accepts any type of message body?
a.
NONE
b. Empty
c. Well
Formed XML
d. Well
Formed XML with Schema Collection
9. ___converts
the information in a Web Service request and response message prior to network
transmission
a. UDDI
b. WSDL
c. XML
d.
SOAP
10. Which
one of the following codes declares a dialog handle variable named
dialog_handle as a unique identifier?
a.
Declare
@dialog_handle uniqueidentifier
b. Declare
$dialog_handle uniqueidentifier
c. Declare
%dialog_handle uniqueidentifier
d. Declare
uniqueidentifier @dialog_handle
11. 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
12. 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
13. Which
of the following features of SQL Server 2005 provides a platform for generating
and sending messages to the subscriber?
a. Web
Services
b.
Notification
Services
c. Endpoints
d. Messages
14. ____is
an application or user that requests and receives notification
a. Notification
b. Event
c. Subscription
d.
Subscriber
15. The
____ option of the server configuration specifies whether user assemblies can
be executed within SQL Server
a.
Clr_enabled
b. Clr
c. Enableclr
d. Enabled
16. Which
of the following methods of the SqlPipe class returns a single row result-set
to the client?
a. Void
send(SqlDataRecord)
b.
Void
send(SqlDataReader)
c. Void
sendresultsRow()
d. Void
sendSingleRow(SqlDataRecord)
17. Which
of the following namspaces 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.SqlClient
d.
System.Data
18. Which
of the following objects forms the basic part of the Service Broker System?
a.
Message
Types
b. Stack
c.
Queue
d.
Contract
19. Which of the following correctly
describes the usage of the property IsInvariantToDuplicates?
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 as
COUNT which is not invariant to nulls
c.
It states whether aggregate is invariant to order
d.
It states whether a null value is returned if no values
are accumulated
20. Which of the following correctly
describes the usage of the method merge()?
a.
It accumulates the aggregate values by the query
processor.
b.
It merges an aggregate class object with the current
object.
c.
It returns the aggregated result and terminates the
aggregation process.
d.
It initializes the aggregate computation.
21. _____is an act by which subscriber
describes when and what to be notified on.
a.
Event Collection
b.
Notification Generation
c.
Subscription
d.
Notification Formatting
22. _____is a process where a distributor
edits the new notification and delivers it through an channel
a.
Event Collection
b.
Notification Generation
c.
Subscription
d.
Notification Formatting
23. ____
is an XML file that describes a Notification Service instance and stores its
data in an SQL Server database.
a. XML
b.
Instance
Configuration File
c. Object
Configuration File
d. Stored
procedure
24. Which
of the following event providers of SQL Server Notification Services monitors a
directory for new event files?
a. SQL
server
b. Analysis
Service
c.
File
System Watcher
d. Web
services
25. Which
of the following tags specify that 10 attempts are to be made to access a locked
file before removing the file from the queue?
a. <Name>
RetryPeriod </Name>
<Value>10</Value>
b. <Name>
RetryQueueOccupancy </Name>
<Value>10</Value>
c.
<Name>
RetryAttempts </Name>
<Value>10</Value>
d. <Name>
RetryWorkload</Name>
<Value>10</Value>
26. Which
of the following tags specifies the name of the Analysis Services database that
the event provider will query?
a. <Name>
AnalysisServicesInstances</Name>
<Value>%ASInstance</Value>
b.
<Name>
AnalysisServicesDatabase</Name>
<Value>AdventureWorks</Value>
c. <Name>
EventQuery</Name>
<Value>SELECT BookID FROM BookTable</Value>
d.
<Name>
EventClassName</Name>
<Value>BookEvent</Value>
==================================================================
26. Which
of the XQuery expression supports the for, where, order by and return clauses?
o XML
o Conditional
o FLOWOR statement
and iteration
o Arithmetic
27. Which
of the following methods of the XML data type retrieves fragments of an XML
document ?
o Query()
o Value()
o Get()
o Nodes()
28. Which
of the following functions in SOA does not depend on the state of other
services?
o Send
o Response
o Request
o Service
29. ----------is
a service provider that acts as a registry and allows for the lookup of service
provider interfaces and service location.
o Service
o Service
Provider
o Service
Broker
o Service Locator
30. -----------is
a conversation that takes place between one Service Broker and another.
o Dialog
o Messages
o Conversation
group
o Endpoint
31. You
want to add a Microsoft user account named ?Mark? of Windows domain Aptech to
SQL Server and grant access right to a default database named Aptech Training.
Which one of the following code will help you to achieve this task?
o CREATE LOGIN
[AptechMark] FROM WINDOWS WITH DATABASE = AptechTraining
o CREATE
USER [AptechMark] FROM WINDOWS WITH DATABASE= AptechTranining.
o CREATE
LOGIN [AptechMark]FROM WINDOWS WITH DATABASENAME= AptechTraining
o CREATE
LOGINNAME[AptechMark]FROM WINDOWS WITH DATABASENAME = AptechTraining
32. _______is
an application that receives the messages from a queue and sends the messages
to services.
o Services
o Queues
o Dialogs
o Service Program
33. Which
of the following message type accepts any type of message body?
o NONE
o EMPTY
o Well
Formed XML
o Well
Formed XML with Schema Collection
34. ______converts
the information in a Web Service request and response message prior to network transmission.
o UDDI
o WSDL
o XML
o SOAP
35. Which
one of the following codes declares a dialog handle variable named
dialog_handle as a unique identifier?
o DECLARE
@dialog_handle uniqueidentifier
o DECLARE
$dialog_handle uniqueidentifier
o DECLARE
%dialog_handle uniqueidentifier
o DECLARE
uniqueidentifier @dialog_handle
36. Which
of the Native HTTP features helps in creating a proxy class, understand the
method and parameter passing?
o Native
HTTP requirements
o Receiving
requests
o WSDL document
generation
o Access
to database objects
37. Which
one of the following commands is used to grant permission to a user for stored
procedures?
o GRANT
PERMISSION
o GRANT EXECUTE
o CREATE
ACCESS
o ALLOW
38. Which
of the following features of SQL Server 2005 provides a platform for generating
and sending messages to the subscriber?
o Web
Services
o Notification
Services
o Endpoints
o Messages
39. _____is
an application or user that requests and receives notification
o Notification
o Event
o Subscription
o Subscriber
40. The
_____ option of the server configuration specifies whether user assemblies can
be executed within SQL Server
o Clr_enabled
o Clr
o Enableclr
o Enabled
41. Which
of the following methods of the SqlPipe class returns a single row result-set
to the client?
o Void send
(SqlDataRecord)
o Void
send (SqlDataReader)
o Void
sendresultRow()
o Void
sendSingleRow(SqlDataRecord)
42. Which
of the following namespaces in the System.Data.dll consists of classes that
comprise the ADO.NET architecture?
o System.Data.ADO
o Syste.Data.Sql
o System.Data.SqlClient
o System.Data
43. Which
of the following objects forms the basic part of the Service Broker System?
ü Message Types
ü Stack
ü Queue
ü Contracts
44. Which
of the following correctly describes the usage of the property
isInvariantToDuplicates?
o It states whether
the aggregate is invariant to duplicates such as MAX and MIN.
o It
states whether the aggregate is Invariant to Null such as COUNT which is not
invariant to nulls
o It
states whether aggregate is invariant to order.
o It
states whether a null value is returned if no values are accumulated.
45. Which of
the following correctly describes the usage of the method merge()?
o It
accumulates the aggregate values by the processor
o It merges an
aggregate class object with the current object
o It
returns the aggregated result and terminates the aggregation process.
o It
initializes the aggregate computation
46. Which
of the following tags specify that 10 attempts are to be made to access a
locked file before removing the file from the queue?
F. <Name>RetryPeriod</Name>
<Value>10</Value>
G. <Name>RetryQueueOccupancy</Name>
<Value>10</Value>
H.
<Name>RetryAttempts</Name>
<Value>10</Value>
I. <Name>RetryWorkload</Name>
<Value>10</Value>
o A
o B
o C
o D
47. Which
of the following tags specifies the name of the Analysis Services database that
the event provider will query? (chưa chắc)
D. <Name>AnalysisServicesInstances</Name>
<Value>%ASInstance</Value>
E.
<Name>AnalysisServicesDatabase</Name>
<Value>AdventureWorks</Value>
F. <Name>EventQuery</Name>
<Value>SELECT BookID FROM BookTable</Value>
J. <Name>EventClassName</Name>
<Value>BookEvents</Value>
o A
o B
o C
o D
48. ____
is an act by which subscriber describes when and
what to be notified on.
o Event Collection
o Notification
Generation
o Subscription
o Notification
Formatting
49. _____is an XML file that
describes a Notification Service instance and stores its data in an SQL Server
database
o XML
o Instance Configuration
File
o Object
Configuration File
o Stored
procedure
50. Which
of the following event providers of SQL Server Notification Services monitors a
directory for new event files ?
o SQL
Server
o Analysis
Services
o File System
Watcher
o Web
Services
==================================================================
1)
---------- is an application that receives
the messages from a queue and sends the messages to services.
A Services
B Queues
C Dialogs
D Service Program
2)
which of the following message type accepts
any type of message body?
A None
B Empty
C Well Formed XML
D Well Formed XML With Schema Collection
3)
---------- Converts the information in a web
servicee request and response message prior to network transmission.
A UDDI
B WSDL
C XML
D SOAP
4)
Which one of the following codes declares a
dialog handle variable named dialog_handle as a unique identifier?
A Declare @dialog_handle
uniqueidentifier
B Declare $dialog_handle
uniqueidentifier
C Declare %dialog_handle
uniqueidentifier
D Declare uniqueidentifier
@dialog_handle
5)
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
6)
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
7)
---------- is an application or user that
requests and receives notification.
A Notification
B Event
C Subscription
D Subscriber
8)
---------- is and act by which subscriber describes when and what to be
notified on.
A Event Collection
B Notification Generation
C Subscription
D Notification Formatting
9)
---------- is a process where a distributor edits the new notification
and delivers it through a channel.
A Event Collection
B Notification Generation
C Subscription
D Notification Formatting
10)
---------- is an XML file that describes a
notification service instance and stores its data in an sql server database.
A XML
B Instance Configuration File
C Object Configuration File
D Stored Procedure
11) Which of
the following event providers of sql server notification services monitors
a directory for new event files?
A SQL Server
B Analysis Services
C File System
Watcher
D Web Services
12)
Which of the following tags specify that 10
attempts are to be made to access a locked file before removing the file from
the queue?
A <name>retryperied</name>
<value>10</value>
B <name>retryqueueoccup</name>
<value>10</value>
C <name>retryattempts</name>
<value>10</value>
D <name>retryWorld</name>
<value>10</value>
13)
Which of the following tags specifies the
name of the analysis services database that the event provider will query?
A <name>AnalysisServicesInstances</name>
<value>%ASInstance</value>
B <name>AnalysisServicesDatabase</name>
<value>AdventureWorks</value>
C <name>EventQuery</name>
<value>%Select
BookID From BookTable</value>
D <name>EventClassName</name>
<value>BookEvents</value>
14)
which of the foffowing entities are required
to develop a service broker application? Choose 3
A Dialog
B Route
C Service Object
D Gateway
15)
which of the following classes specifies a notification service
application?
A NotificationService
B NSApplication
C Notifier
D Subscription
16)
which of the following function in SOA does not depend on the state of other
services?
A Send
B Response
C Request
D Service
17)
------------ is a service provider that acts
as a registry and allows for the lookup of service provider intertaces and
service location
A Service
B Service Provider
C Service Broker
D Service locator
18)
---------- is a conversation that takes
place between one service broker and another.
A Dialog
B Messages
C Conversation Groups
D Endpoint
19)
You
want to add a microsoft user account name ? mark? of windows domain aptech to
sql server and grant access right to a default database named aptech Training .
which one of the following code will help you to achieve this task?
A CREATE LOGIN [AptechMark] FROM WINDOWS
WITH DATABASE = Aptech Training
B CREATE URER [AptechMark] FROM WINDOWS
WITH DATABASE = Aptech Training
C CREATE LOGIN [AptechMark] FROM WINDOWS
WITH DATABASENAME = Aptech Training
D CREATE LOGIN NAME[AptechMark] FROM
WINDOWS WITH DATABASE = Aptech Training
===================================================================================
|
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.
|
GRANT ENDPOINT 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 ()
|
============================================================================================================================
1.
________ is an application that receives the messages from a queue and sends
the messages to services.
Services Program
2.
Which of the following message type accepts any typeof message body?
NONE
3.
_______ converts the information in a Web Service request and response message
prior to network transmission
SOAP
4.
Which one of the following codes declares a dialog handle variable named
dialog_handle as a unique identifier?
DECLARE
@dialog_handle uniqueindentifier
5.
Which of the Native HTTP features helps in creating a proxy class, understand
the method and parameter passing?
WSDL document
generation
6.
Which one of the following commands is used to grant permission to a user for
stored procedures?
GRANT PERMISSION
8.
______ is an application or user that requests and receives notification.
Subscriber
9. ______ is an act
by which subscriber describes when and what to be notified on.
Subscription
10.
______ is a process where a distributor edits the new notification and delivers
it through a channel.
Notification
Formatting
11.
______ is an XML file that describes a Notification Service instance and store
its data in an SQL Server database.
Instance
Configuration File
12.
Which of the following eventproviders of SQL Server Nitification Services
monitors a directory for new event files?
File System Watcher
13.
Which of the following tags specify that 10 attempts are to be made to access a
locked file before removing the file from the queue?
<Name>
RetryAttempts</Name>
<Value>
10 </Value>
14.
Which of the following tags specifies the name of the Analysis Services
database that the event provider will query?
<Name>
AnalysusServicesInstances </Name>
<Value>
%ASInstance </Value>
15.
Which of the following entities are required to develop a Service Broker
application?
Dialog + Route +
Service Object
16.
Which of the following classes specifies a Notification Service application?
NSApplication
17.
Which of the following functions in SOA does not depend on thestate of other
services?
Service
18.
____ is a service provider that acts as a registry and allows for the lookup of
service provider interfaces and service location.
Service Broker
19.
____ is a conversation that takes place between one Service Broker and another.
Dialog
20.
You want to add a Microsoft user account named?Mark? of windows domain Aptech
to SQL Server and grant access right to a default database named Aptech Training.
Which one of the following code will help you to achieve this task?
CREATE LOGIN
[AptechMark] FROM WINDOWS WITH DATABASE = AptechTraining
